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)

, , ,
Previous Post
SQL SERVER – Fix : Error : Incorrect syntax near. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel
Next Post
Author Visit – MVP Open Day 2008 – Goa – November 15-17

Related Posts

1 Comment. Leave new

  • Sir, I’m a regular reader of your blog. Currently I was searching for a good article regarding the difference between VARCHAR and NVARCHAR data types in SQL Server. But din’t find one. Can you please put light on that?

    Reply

Leave a Reply

Menu