SQLAuthority News – Running SQL Server 2008 in a Hyper-V Environment Best Practices and Performance Considerations

Hyper-V in Windows Server 2008 is a powerful virtualization technology that can be used by corporate IT to consolidate under-utilized servers, lowering TCO and maintaining or improving Quality of Service. Through a series of test scenarios that are representative of SQL Server application fundamentals, this document provides best practice recommendations on running SQL Server in Windows Hyper-V environment.

White paper talks about many subjects and various topics. I enjoyed reading following sections.

Setup and Configuration of Hyper-V Configurations

Hyper-V Preinstall Checklist and Considerations

Storage Configuration Recommendations

Monitoring SQL Server on Hyper-V Configurations

Test Methodology, Workloads Results, Observations, and Recommendations

Different kind of Performance Overhead of Running SQL Server in Hyper-V

SQL Server Consolidation Scenarios Using Hyper-V

Virtual Instance Scalability

Comparing Consolidation Options

Hyper-V Architecture

Hardware requirements

Hardware Configuration

Download White Paper

Reference : Pinal Dave (https://blog.sqlauthority.com)

Exit mobile version