• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 435
  • Last Modified:

SQL Server 2005 Performance on Virtual Machine

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.
0
Beratung
Asked:
Beratung
1 Solution
 
tsmgeekCommented:
you need to see if ESX is paging out your memory to disk, are you sure you have not overcommited your ram between multiple virtual machines,
0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
The problem with VM's is that they have low IO bandwidth : at most 75MB/s with best possible tuning.  When an application request more than 75MB/s, the IO hypervizor becomes a serious bottleneck and no matter how fast are your spindles (or SAN throughput) or how large is your RAM, your hypervizor will stop.  The best you can do is make sure that you have multiple vfiles no larger than 150GB and that each file has its own quota in the buffer pool...
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now