November 14, 2011 at 10:46 am
Hi,
I new to sql server.
Very frequently there are High Memory utilization issues like (97% ., 98 % ....... )
read couple of articles but didn't really understand the final solution ...
My knowledge , no AWE -- SQL server will occupy windows memory.
my question -- how to release the memory usage by sql server
is it possible to release or should i propose to increase windows memory .
some people suggest to enable AWE or set max memory so wont eat windows memory.IN what scenarios I should make such decisions.
HOW TO MAKE FINAL DECESION WITH BEST SOLUTION.
Thank you in advance.
November 14, 2011 at 11:01 am
Set max memory for sql server and make sure to leave 1-2 GB for the OS.
Aside from that, % of memory used is insignificant as a perf metric.
November 14, 2011 at 11:46 am
www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/
Chapter 4.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply