January 18, 2008 at 4:01 am
Hi,
I am running VMWARE ESX 3 on 4 dual-core Intel Xeon 3.40GHz with 24 GB RAM
Disk Layout
PHYSICAL DISK 0 and 1 --> RAID 1 --> for LINUX and VMWARE
PHYSICAL DISK 2,3 and 4 ---> Raid 5 --> All three images are sitting on this
I have 3 VM images running
Image 1
--------
Windows 2000 Standard ,SQL 2000 SP4 with 4 GB RAM
Image 2
--------
Windows 2000 Standard with 4 GB RAM
Image 3
--------
Windows 2005 Enterprise,SQL 2005 Enterprise SP1 with 8 GB RAM
I wish to generate matrix for
1) Load on the system generated by that application(s) running on the image ONLY (should eliminate the load created by another image(s) on DISK and CPU)
2) Overall load on the BOX (load of image 1 , 2 and 3)
Which all counters should I monitor? Is there any whiter paper or article which I can refer?
Cheers
Deepak
March 26, 2008 at 8:06 am
Hi Deepak
There are several articles avaliable on VMWare website, hope this might be usefull, i will look into this and let you know if i find any articles
Cheers
Suji
March 26, 2008 at 8:41 am
I have heard that the counters under Windows are not accurate with using VMs. You might want to check with VMware about that.
Also, keep in mind that the load is primarily IO bound and that might skew the performance of SQL Server. To make it run well, you really need disks/spindles, dedicated to SQL Server.
April 29, 2010 at 2:01 pm
I know this thread is a bit old but when you say "you really need disks/spindles, dedicated to SQL Server." do you mean have physical disks that the SQL VM uses?
For example, if we have a pillar box with 24 disks (12 with failover), we should have 2-4 of those disks only be used for that SQL VM?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply