Gary Gwyn (2/19/2014)
If no maximum is set, then SQL uses as much RAM as it needs. You can set a maximum, say 44,032 MB -- allows 4GB for OS operations. One catch - you must restart the SQL service before the changes take effect. You will have to schedule a momentary outage.
No. The change is immediate and no need to restart SQL Server.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events