7

In this support article:

https://support.microsoft.com/en-us/kb/956893

The answer to Q7 says:

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 environment.

The two sentences seem contradictory. Can anyone confirm if SQL Server Standard supports hot add memory when running on a Hyper-V guest?

4

The phrasing might be confusing, however it means exactly what it says.

The Hot memory adding is a feature. Not a subject of limitations of the environment.

So what the article actually says is:

  • You can only use the Hot add Memory feature in SQL Server Enterprise and Datacenter
  • Standard version of SQL Server 2012 could detect memory being added to the system, however it does not allow for hot add memory to the SQL Server so the feature is turned off

In other words, no it doesn't work.
I guess somewhere in the Microsoft office there is a dev who really really wanted people to know it wasn't his fault that the feature is limited to Enterprise and Datacenter editions. But rather a part of the licensing.

  • Ok thanks so it doesn't work in Standard. That's the main question. I still don't understand the meaning of the highlighted sentence. Does 2012 Standard "recognize" hot add memory in some way that web edition doesn't? – richb Oct 13 '15 at 4:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.