virtual machine performance

General
Enthusiast

virtual machine performance

Hi, I am new to teradata learning, I have download vm Express edition for testing purpose, but this is a very limited in performance, i want to test a machine have a little bit big data, ALL i have to face that, when ever i run a query especially with aggregation, i takes lots of mins to perform the result having 0.5 millions of rows

What i found right now, that i could not add amps in current configuration, which is the responsible in terms of performance.

Can i get vm having more powerfull configuration, in terms of amps or any other solution.

Any help will be appreciated...

6 REPLIES
Teradata Employee

Re: virtual machine performance

How much physical memory do you have on the host machine, and how much have you dedicated to the VM? How many virtual "CPUs"?

And which version of TD Express?

Enthusiast

Re: virtual machine performance

There is 8GB total physical memory on the machine, and at first , assigned 2gb to vm and after that i increase it to 4GB and then 6GB

There is 8 Core CPUs machine, and assigen 4 core to the vm , 

I got folloing results by running this Query

select count(t1.ProcId) Nodes, sum(t1.AmpCount) Amps, sum(t1.PECount) PEs

from table (MonitorPhysicalResource()) as t1

where t1.Status = 'U'

Result:

Nodes   AMPs      PEs

1 2 1

  I wonder, why this is not giving me the performance , i could know , how to increase AMPs , Either , i have try to do that by begin config command to set the APMs by using following command

bc add amps 4 -7, cn =3, but it display the messge that i have trail version, and could not fullfill this command such like message, 

So , there is any way , by which i could get performace to compare with other database ...

Note: Please ignore, if i am asking some stupid question, because i do not have much experience in dba , but in development..

Thanks in advance: 

Enthusiast

Re: virtual machine performance

Sorry, i forget to mention the TD Version

Teradata version is 14.10

Enthusiast

Re: virtual machine performance

Try to attach vm configuration 

Junior Contributor

Re: virtual machine performance

Adding AMPs would not help, as you still got the same CPU/IO/RAM, just divide it by more AMPs.

I assume you're limited by IO, does Explain show "not be cached in memory"?

Do you run the VM on a harddisk or a SSD? I never had problems with VMs on SSD.

Years ago I've seen very bad performance because the VM was running on a compressed harddrive.

Btw, based on the screenshot you're running a TD14 with only 4GB, if this is true you might run into MiniCylPacks when available space gets low.

You should go for the 40GB version.

Enthusiast

Re: virtual machine performance

Hi Dieter,

         Thank you for your response, Yes, vm is running on sata drive not on SSD.  I got 40GB version and still no luck. I believe , this is some what configuration issue as you explained.

Dieter, i could not understand what you said "just divide it by more AMPs."  how can i do that ? moreover ,  show "not be cached in memory"? ... can you please explain it

following is the new cofiguartion with 40GB version

I just want to know, where i am going wrong.

Is there a huge difference in performance btw ssd and hard drive.. there are other databases running on harddisk giving good performane, as what i am looking to execute a query giving results in 5-10 seconds, but here on td in 4-5 min

ahmad