January 18, 2008 at 4:00 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
January 18, 2008 at 9:05 am
I can't advise you on what you need to do to benchmark this setup in a forum posting (this would be at least a week-long consulting project to do it right from start to finish) but I can definitely say that the given setup will be a VERY poor performer if you have any reasonable amount of data on the systems. 3 drives in a RAID5 for those VMs will be a total dog from an I/O perspective. If your SQL databases have more than a few tens of GB of data I would want at least 10 active spindles serving up the data.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply