Solved

SQL Server 2005 Performance on Virtual Machine

Posted on 2011-03-23
2
424 Views
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.
0
Comment
Question by:Beratung
2 Comments
 
LVL 5

Expert Comment

by:tsmgeek
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,
0
 
LVL 23

Accepted Solution

by:
Racim BOUDJAKDJI earned 500 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...
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Join & Write a Comment

Suggested Solutions

HOW TO: Connect to the VMware vSphere Hypervisor 6.5 (ESXi 6.5) using the vSphere (HTML5 Web) Host Client 6.5, and perform a simple configuration task of adding a new VMFS 6 datastore.
HOW TO: Upload an ISO image to a VMware datastore for use with VMware vSphere Hypervisor 6.5 (ESXi 6.5) using the vSphere Host Client, and checking its MD5 checksum signature is correct.  It's a good idea to compare checksums, because many installat…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

758 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now