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 ««12

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



Group: General Forum Members
Last Login: Today @ 4:05 AM
Points: 43,450, Visits: 40,590
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
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