Location: Performance of SQL Server 2005 on ESX Server 3.5

Discussion: Web Chat on Virtualizing SQL Server


Watch
todd_muirhead
todd_muirhead
Web Chat on Virtualizing SQL Server
Apr 2 2008, 12:33 PM EDT
I hosted yesterday's Tech Tuesday chat which was about virtualizing SQL Server 2005. A lot of the time was spent discussing this whitepaper - so you may want to check out the transcript:

http://www.delltechcenter.com/page/04-01-2008+Chat+Log

Todd
1  out of 1 found this valuable. Do you?    
anthony_fernandez
anthony_fernandez
RE: Web Chat on Virtualizing SQL Server
Apr 17 2008, 11:29 AM EDT
Two thumbs up!
Curious to know how many threads you used to get to 80% CPU util?
Also, I wonder what was your limiting factor, RAM or I/O?
Do you find this valuable?    
todd_muirhead
todd_muirhead
RE: Web Chat on Virtualizing SQL Server
Apr 17 2008, 2:58 PM EDT
In order to drive the VMs to 80% I used 9, 14, and 30 threads for the 1vCPU, 2vCPU, and 4vCPU tests respectively. This is threads from the DVD Store driver program for sql server.

The limiting factor was CPU. Disk I/O would continue to scale as CPU utilization went over 80% - producing more orders per minute.

These were good questions. Anybody have more?

Todd
Do you find this valuable?    
Top Contributors
Browse by Keywords
Loading...