SQL Server 2005 Performance on Virtual Machine
Posted on 2011-03-23
We have a large database applicaiton on SQL 2005 Standard that is in a DEV environment both on VMWare and Virutal Server 2005. Both SQL Servers come to a crawl after heaving deletes and inserts. The rememdy to speed it back up is to restart SQL Services. There is plenty of free memory, plenty of processor resources and disk space. The throughput report in vSpere for the drives ranges from 150 when slow and 12000 when running optimally for both reads and writes. The VM disks are on a Raid 1 for logs and Raid 5 for MDF's.
Is there an issue with SQL 2005 in virutal environments or is there best practices that we need to know about when working with large datasets and large deletes and inserts on VM environments.