April 11, 2013 at 11:56 am
In one of the server we have defined 'max server memory'
below is the server configuration
OS = windows server 2003 enterprise edition 32 bit
SQL = sql server 2005 standard edition 32 bit
total RAM = 64 GB
Max server memory = 48 GB
AWE = enabled
please let me know how can check if max server memory should increase for 2 or 4 GB more?
please reply
April 11, 2013 at 12:46 pm
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
April 15, 2013 at 1:05 pm
Hi
Another help could be found here
http://www.idera.com/Downloads/WhitePapers/Top10SQLPerf.pdf
The SQL service account must be granted the "Lock pages in memory" user right.
Regards
IgorMi
Igor Micev,My blog: www.igormicev.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply