SQL Server 2005 Performance on Virtual Machine

Posted on 2011-03-23
Medium Priority
Last Modified: 2012-05-11
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.
Question by:Beratung

Expert Comment

ID: 35203746
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,
LVL 23

Accepted Solution

Racim BOUDJAKDJI earned 2000 total points
ID: 35379194
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...

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
In this article will go through how to backup a vPostgres DB from a broken vCenter Appliance and restore to a new vCenter Appliance.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

588 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question