SQL Server 2008 Memory Question?
We wanted to change the memory setting for a SQL Server Instance on a particular server. The settings for the way our SQL Server 2008 Instance uses memory was set to minimum 0 to maximum 10GB so we changed it to minimum 5GB to maximum 10GB. When the Sys Admin monitored this server after making the change it was not using minimum 5GB. We did not restart the SQL Server 2008 services or reboot the server after making the SQL Server 2008 memory change. Why isn't grabbing and holding the minimum of 5GB?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
So is that a good practice to have SQL grab that amount of memory whenever it is reached and never release until memory setting is reduced from a performance point of view? Would it be best to just have minimum as 0 and max as 10GB?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
no but we also notice that when we changed the memory settings, SQL Server is using all the memory so why is that occurring?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
did you run the first query? what is the value you got?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER