kshaileshbca (3/15/2014)
Fist you have to check fragmentation level
What's that got to do with memory?
add lock pages in memory
Um, no. That's not going to reduce memory usage, do you know what it actually does?
last one is if you are using SQL Enterprise Edition , you can enable resource governor .
To do what exactly? Just enable, no setting up groups and pools or any configuration at all?
i sure that it will help you .
Not.
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