locked
SQL Server 2012 Standard and Hyper-V Dynamic Memory RRS feed

 > 

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Anton,

    All versions of SQL Server support Hyper-V Dynamic Memory. However, only certain editions of SQL Server are aware of dynamically changing system memory. To have a truly dynamic environment for SQL Server VMs make sure that you are running the SQL Server Enterprise editions .

    By the way, SQL 2005 and later Enterprise and Datacenter editions are required to take advantage of Dynamic Memory in SQL VMs.  This is because the lower editions (Express, Standard, Web and Workgroup) don’t support hot-add memory.

    For more information about SQL Server and Hyper-V Dynamic Memory, you can review the following blog.
    ttp://www.aidanfinn.com/?p=11139

    Thanks,
    Sofiya Li

    If you have any feedback on our support, please click here.

    Sofiya Li
    TechNet Community Support

    • Marked as answer by Sofiya Li Monday, November 25, 2013 3:47 AM
    Tuesday, November 19, 2013 7:01 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    This link is about SQL Server 2008 R2. I asked about SQL Server 2012

    I did propose the whitepaper "Running SQL Server with Hyper-V Dynamic Memory" as an answer because it explains how Hyper-V in general implements dynamic memory.

    Quote:

    • "...Hyper-V Dynamic Memory uses Enlightened Memory Addition functionality of Windows when it adds memory to a virtual machine. This technique is the virtual equivalent of the Hot Add Memory functionality of Windows Server. But compared to it; this technique is lighter weight and faster because it does not require any hardware emulation inside the virtual machine..."
    • "...at startup time, SQL Server detects that Hot Add Memory is supported..."


    So this does indeed give the answer:
    it's just the same as Hot Add Memory and therefore the same rules apply: not in Standard Edition

    Andreas Wolter | Microsoft Certified Master SQL Server

    Blog: www.insidesql.org/blogs/andreaswolter
    Web: www.andreas-wolter.com | www.SarpedonQualityLab.com

    • Marked as answer by Sofiya Li Monday, November 25, 2013 3:47 AM
    Tuesday, November 19, 2013 10:26 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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 that support Hot Add Memory (Enterprise and Datacenter) can see memory that is added by using Hyper-V Dynamic Memory. SQL Server 2012 Standard edition also recognizes Hot Add memory when running in a virtual enviroment.  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:

    http://support.microsoft.com/kb/956893/en-au

    • Proposed as answer by TechHead110 Wednesday, November 20, 2013 12:31 AM
    • Marked as answer by Sofiya Li Monday, November 25, 2013 3:47 AM
    Wednesday, November 20, 2013 12:22 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello! See the link below:

    http://msdn.microsoft.com/en-us/library/hh372970.aspx

    Regards,

    André César Rodrigues

    Please click the Mark as answer button and vote as helpful if this reply solves your problem. Thanks!

    Blog: http://sqlmagu.blogspot.com.br  LinkedIn:   

    Monday, November 18, 2013 3:05 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    This link is about SQL Server 2008 R2. I asked about SQL Server 2012
    Tuesday, November 19, 2013 3:13 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Anton,

    All versions of SQL Server support Hyper-V Dynamic Memory. However, only certain editions of SQL Server are aware of dynamically changing system memory. To have a truly dynamic environment for SQL Server VMs make sure that you are running the SQL Server Enterprise editions .

    By the way, SQL 2005 and later Enterprise and Datacenter editions are required to take advantage of Dynamic Memory in SQL VMs.  This is because the lower editions (Express, Standard, Web and Workgroup) don’t support hot-add memory.

    For more information about SQL Server and Hyper-V Dynamic Memory, you can review the following blog.
    ttp://www.aidanfinn.com/?p=11139

    Thanks,
    Sofiya Li

    If you have any feedback on our support, please click here.

    Sofiya Li
    TechNet Community Support

    • Marked as answer by Sofiya Li Monday, November 25, 2013 3:47 AM
    Tuesday, November 19, 2013 7:01 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    This link is about SQL Server 2008 R2. I asked about SQL Server 2012

    I did propose the whitepaper "Running SQL Server with Hyper-V Dynamic Memory" as an answer because it explains how Hyper-V in general implements dynamic memory.

    Quote:

    • "...Hyper-V Dynamic Memory uses Enlightened Memory Addition functionality of Windows when it adds memory to a virtual machine. This technique is the virtual equivalent of the Hot Add Memory functionality of Windows Server. But compared to it; this technique is lighter weight and faster because it does not require any hardware emulation inside the virtual machine..."
    • "...at startup time, SQL Server detects that Hot Add Memory is supported..."


    So this does indeed give the answer:
    it's just the same as Hot Add Memory and therefore the same rules apply: not in Standard Edition

    Andreas Wolter | Microsoft Certified Master SQL Server

    Blog: www.insidesql.org/blogs/andreaswolter
    Web: www.andreas-wolter.com | www.SarpedonQualityLab.com

    • Marked as answer by Sofiya Li Monday, November 25, 2013 3:47 AM
    Tuesday, November 19, 2013 10:26 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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 that support Hot Add Memory (Enterprise and Datacenter) can see memory that is added by using Hyper-V Dynamic Memory. SQL Server 2012 Standard edition also recognizes Hot Add memory when running in a virtual enviroment.  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:

    http://support.microsoft.com/kb/956893/en-au

    • Proposed as answer by TechHead110 Wednesday, November 20, 2013 12:31 AM
    • Marked as answer by Sofiya Li Monday, November 25, 2013 3:47 AM
    Wednesday, November 20, 2013 12:22 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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 that support Hot Add Memory (Enterprise and Datacenter) can see memory that is added by using Hyper-V Dynamic Memory. SQL Server 2012 Standard edition also recognizes Hot Add memory when running in a virtual enviroment.  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:

    http://support.microsoft.com/kb/956893/en-au

    extremely confusing wording

    but in the end it states the same as above: it doesn't work as one might expect

    it's "just supported" to be there

    Andreas Wolter | Microsoft Certified Master SQL Server

    Blog: www.insidesql.org/blogs/andreaswolter
    Web: www.andreas-wolter.com | www.SarpedonQualityLab.com

    Wednesday, November 20, 2013 12:30 AM