The Free Pages on our SQL server is consistently at 84 which I've read is
low. Any suggestions on how to improve this number?This is related to the memory allocated to SQL Server. If only SQL Server is
running in that machine, try to increase the "min server memory" occupied by
SQL Server.
for this, use sp_configure.. the syntax, you can check from BOL.
The other ways of increasing memory is by reducing the prcedure cache.
For more info, check this link
http://www.windowsitlibrary.com/Content/77/15/3.html
hope this helps
"Shane C" wrote:
> The Free Pages on our SQL server is consistently at 84 which I've read is
> low. Any suggestions on how to improve this number?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment