[dba-SQLServer] Performance of a SP

Bobby Heid bheid at sc.rr.com
Thu Dec 11 20:38:09 CST 2008


And, if using Hyper-V on Server 2008, check to see if he set up disk
pass-through (or something like that).  The disk pass-through gives almost
the same performance as a native disk out of a VM.

Bobby

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Francisco
Tapia
Sent: Thursday, December 11, 2008 9:09 AM
To: Discussion concerning MS SQL Server
Cc: Discussion concerning MS SQL Server
Subject: Re: [dba-SQLServer] Performance of a SP

Steve,
   I am a big fan of VM's but even I will admit that there are  
limitations. SQL requires fast I/o access. So even though the host is  
a honking machine, how much CPU/ memory is alocated to you SQL vm?   
Are there any other vm's on the same disk with your VM? Because of the  
way VM's work, what VM technology did he implement? By that I ask who  
is the host? Is it esx or is it windows.


Sent from my mobile





More information about the dba-SQLServer mailing list