SQL Server Virtualization
Sensory Computer Systems can not be responsible for potential performance issues with your organization's virtual machine guest hosting the SQL service. Please contact your IT support staff. There are many aspects of virtualization configurations that can cause performance issues. Virtualization should work fine with proper planning, configuration, resource allocation, real-world testing and fine-tuning.
For more information, please refer to the Microsoft whitepapers:
Running SQL Server 2008 in a Hyper-V Environment - Best Practices and Performance Recommendations.
http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/SQL2008inHyperV2008.docx
Planning, Implementing and Supporting SQL Server Virtualization with Windows Server 2008 R2 Hyper-V
http://technet.microsoft.com/en-us/library/ff898403.aspx
Some common VM guest SQL server issues may include:
- Insufficient memory allocated to VM guest.
- Insufficient cpu processors allocated to VM guest.
- Improper I/O configuration for virtual hard disks.
- Improper I/O configuration for virtual network cards.
- Contention with other virtualized servers on the physical host box.
- And more.
The newest available Microsoft software releases include improved support for virtualiztion.
- Microsoft Windows 2008 Server R2 64-bit operating system
- Microsoft SQL Server 2008 R2 64-bit.
- Microsoft Windows 2012 Server 64-bit operating system
- Microsoft SQL Server 2012 64-bit.