Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a dev computer running Windows Server 2008 R2 Enterprise and SQL Server 2008 R2 Enterprise, with 8GB of RAM. As I write code and use the database, SQL Server will use more-and-more RAM (which is fine!).

If I run Hyper-V Manager and start a virtual machine, then SQL Server will release all the RAM it can. It runs in this minimal memory mode mode even after all Virtual Machines are shut down. The only way to get SQL Server to run normally again is to restart the MSSQLServer service, or reboot the computer -- both of which are sometimes very inconvenient.

Does anyone know of another way to get SQL Server 2008 R2 to use RAM normally again (not in minimal memory mode), without restarting SQL Server or rebooting?

share|improve this question

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.