Posts Tagged ‘SQL Server’

Hyper-V Dynamic Memory Help SQL Server Workload

August 3, 2011 Leave a comment

One of the most important system resources for SQL Server is memory.

Lack of memory resources for the database engine results in increased I/O that is orders of magnitude slower than accessing memory.

One of the key benefits of leveraging dynamic memory is the flexibility to respond to the needs of a particular workload that would benefit from additional memory resources and make the most use out of all physical memory resources on a system.

VERY IMPORTANT : The benefit of additional memory depends on your workload.

The main highlights of using DM are:

– Without Hyper-V Dynamic Memory the virtual machines would have to be sized with a specific amount of static memory to ensure that all virtual machines could run on a single node in the case of a failover.

– The additional memory provides significant reduction in the number of I/O operations needed to support the same workload throughput.

– It should be noted that the benefit depends on your workload.

To read the complete review: :Running SQL Server with Hyper-V Dynamic Memory – Best Practices and Considerations

MS Support policy for SQL Server in a virtualization environment

February 19, 2011 Leave a comment

SQL Server 2005/ 2008 / 2008 R2 are supported in the following virtualization environments:

  • Windows Server 2008 /R2 with Hyper-V
  • Microsoft Hyper-V Server 2008 / R2
  • Configurations that are validated through the Server Virtualization Validation Program (SVVP), which includes VmWare and Citrix.
    Note The SVVP solution must be running on hardware that is certified for Windows Server 2008 to be considered a valid SVVP configuration.

Restrictions and Limitations

  • Guest Failover Clustering is supported for SQL Server 2005 / 2008 / 2008 R2 in a virtual machine provided all of the following requirements are met:
    • The OS running in the virtual machine (the “Guest Operating System”) is Windows Server 2008 or higher
    • The virtualization environment meets the requirements of Windows 2008 Failover Clustering, as documented in the following Microsoft Knowledge Base article:
      943984  ( ) The Microsoft Support Policy for Windows Server 2008 Failover Clusters
  • Virtualization Snapshots for Hyper-V or any virtualization vendor are not supported to use with SQL Server in a virtual machine. It is possible that you may not encounter any problems when using snapshots and SQL Server, but Microsoft will not provide technical support to SQL Server customers for a virtual machine that was restored from a snapshot.

Is Quick and Live Migration with Windows Server 2008 R2 Hyper-V supported with SQL Server?

Yes, Live Migration is supported for SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2 when using Windows Server 2008 R2 with Hyper-V or Hyper-V Server 2008 R2.Quick Migration, which was introduced with Windows Server 2008 with Hyper-V and Hyper-V Server 2008, is also supported for SQL Server 2005, 2008, and 2008 R2 for Windows Server 2008 with Hyper-V, Windows Server 2008 R2 with Hyper-V, Hyper-V Server 2008, and Hyper-V Server 2008 R2.

For more information :

New security baselines for SQL Server

October 28, 2010 Leave a comment

 New security baselines for SQL Server 2008 and SQL Server 2008 R2 now available for beta download.

The latest security baselines in this beta review program are designed to help you plan, deploy, and monitor the security of Microsoft SQL Server 2008 and SQL Server 2008 R2.

The baselines are formatted for import using the Security Compliance Manager, which provides guidance and tools to help you balance your organization’s needs for security and functionality.