 Re: SQL 2005 SP2 Memory -
11-19-2008
, 08:28 AM
Are you using AWE? What does Total Server Memory say for each of the
instances in Perf Mon?
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"dfeldman" <dfeldman (AT) discussions (DOT) microsoft.com> wrote
I have a two server cluster with 32GB mem. I have six SQL instances running
with the default memory settings. Min mem 0 Max all.
When I look at Taskmanager process tab I see the six sqlserver.exe's and the
most any are using is 250mb. Butr when i look at the perfromance tab it
tells
me that only 400mb of 32gb are free.
Where is all the mem being used.
Page file was originally set to 4gb. Reset to min 25gb max 60gb
One strange thing is that after reboot for the pagefile change I cannot
delete the old page file because it says it is in use but I verified the
settings and there is not page file set for C. I moved to B and that partion
shows a page file.
 |
Linear Mode
