jitendra.padhiyar (1/9/2013)
GilaMonster (12/24/2012)
If it's using too much, lower max server memoryIs it dynamic change ? I mean if I will lower down the max memory, Will SQL server will release memory OR I need sql services restart?
You can adjust that setting without a restart. The memory use will start to cycle down as queries complete and memory can be freed.
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