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)
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?