Is Hyper-V Dynamic Memory supported for SQL Server?

Simply YES

Q7: Is Hyper-V Dynamic Memory supported for SQL Server?

A7: Hyper-V Dynamic Memory is fully supported with SQL Server. Only SQL Server versions and editions (Enterprise and Datacenter) that support Hot Add Memory can see memory that is added by using Hyper-V Dynamic Memory. SQL Server versions that do not support Hot Add Memory are still supported. But these versions will detect only the memory that is present in the operating system when SQL Server starts. Before you deploy Hyper-V Dynamic Memory, please read the following resources when you use Hyper-V Dynamic Memory with SQL Server:

Hyper-V Dynamic Memory Evaluation Guide (http://technet.microsoft.com/en-us/library/ff817651(WS.10).aspx)
SQLOS Team Blog – Hyper-V Dynamic Memory (http://blogs.msdn.com/b/sqlosteam/archive/tags/hyper_2d00_v+dynamic+memory/)
Windows Virtualization Team Blog – Dynamic Memory (http://blogs.technet.com/b/virtualization/archive/tags/dynamic+memory/)

Source http://support.microsoft.com/kb/956893

SCVMM reports error 10637 when Red Hat Linux selected as the Operating System

Source

A new KB article regarding Red Hat is being posted on Microsoft Support any day now. For those of you who do not need the official KB, here’s the content. This is a relatively minor fix. If you are not a SQL expert, find one, or just follow the simple instructions for the free SQL Studio Express Edition. Thanks!

URL when published http://support.microsoft.com/kb/2022557.

Symptoms

On System Center Virtual Machine Manager 2008 R2, it is possible to select Red Hat as the virtual machine ‘Operating System’ property for a virtual machine hosted by Hyper-V. The job, however, will show as failed with Error 10637. This can occur when creating a new virtual machine or changing this property on an existing VM. This does not affect the function or stability of the virtual machine itself. This property is found on the General tab of the virtual machine properties dialog.

Error (10637)

The virtualization software on host server.contoso.com does not support the Red Hat Enterprise Linux 5 operating system.

Recommended Action

Specify a host with different virtualization software and then try the operation again.

Cause

A database entry that identifies the list of supported virtual machine operating systems per hypervisor requires an update. The following actions will remain unavailable for Red Hat virtual machines in SCVMM following this update:

• Shut down of the guest operating system from the SCVMM Administrator Console
• Detection and display of the VM Additions version for a virtual machine in the SCVMM Administrator Console and with Windows PowerShell
• Display of the computer name of the guest operating system

Resolution

Using SQL Server Management Studio Express, or a full SQL installation, make a full backup of the SCVMM database. Next, connect to the SCVMM database (VirtualManagerDB by default). Open a new query and enter the commands below. The number of affected columns will be returned in the ‘Messages’ window if present.

update tbl_IL_OS

set OSFlags=0×14

where Name like ‘Red Hat Enterprise Linux 5%’

Microsoft SQL Server 2008 RTM

Microsoft Corp. today announced the release to manufacturing of Microsoft SQL Server 2008, the new version of the company’s acclaimed data management and business intelligence platform. This version of SQL Server provides powerful new capabilities such as support for policy-based management, auditing, large-scale data warehousing, geospatial data, and advanced reporting and analysis services. SQL Server 2008 provides the trusted, productive and intelligent platform necessary for business-critical applications.

 

With more than 450,000 customer and partner downloads of SQL Server 2008’s community technology previews (CTPs), more than 75 large-scale applications already in production and more than 1,350 applications being developed by nearly 1,000 independent software vendors (ISVs) on SQL Server 2008, it’s clear that customers and partners are excited about the capabilities now available in SQL Server 2008.

 

For more information please check out the Press Release and Virtual Press Room.