Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

memory issue: manual memory settings Expand / Collapse
Author
Message
Posted Friday, February 7, 2014 10:38 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 4:50 PM
Points: 45,339, Visits: 43,574
JudithK (2/7/2014)
Just in case the obvious has been missed... The max server memory setting won't take effect until you restart the sql server instance.


The Max server memory setting takes effect immediately, no restart is necessary.



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

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

Post #1539292
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse