Thursday, July 7, 2011

Max Server Memory in SQL 2008

Yagnesh Shah (blog) does a nice job of giving an easy to follow formula for determining the max server memory advanced options setting for SQL 2008 in his post here.  I have always added a little more memory than what was required of the OS and other apps running on the server.  Yagnesh's formula allows for additional memory space for worker threads - something I had not considered.

No comments:

Post a Comment