Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Max server memory setting Expand / Collapse
Author
Message
Posted Thursday, April 11, 2013 11:56 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 3:30 AM
Points: 208, Visits: 1,028
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
Post #1441404
Posted Thursday, April 11, 2013 12:46 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 1:30 AM
Points: 39,977, Visits: 36,341
Chapter 4: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1441432
Posted Monday, April 15, 2013 1:05 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:33 PM
Points: 2,980, Visits: 3,013
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,
SQL Server developer at Seavus
www.seavus.com
Post #1442465
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse