DBA > Job Interview Questions > Microsoft SQL Server FAQs

You want to release some memory and reduce SQL S

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

You want to release some memory and reduce SQL Server to 3GB or RAM. How can you do this?

You have enabled AWE for your SQL Server 2005 server and allocated 4GB or RAM on one of your servers. An ASP.NET application on the same server is feeling memory pressure and you want to release some memory and reduce SQL Server to 3GB or RAM. How can you do this?

Answer
Change the max amount of memory allocated and shut down and restart SQL Server to have it take affect.
Explanation
Once memory is allocated through AWE, it cannot be released unless the SQL Server is restarted.

(Continued on next question...)

Other Job Interview Questions