August 21, 2008 at 11:02 am
Hi All,
I have a development server with 4 instances of SQL Server, and I have the maximum memory option set to 850MB on all instances to keep some order.
In task manager, one of the instances shows that it has almost 950MB allocated to it - is there something up with this instance, or are the task manager values not always in sync with the SQL Server settings?
Sp_configure shows my 850 max, and shows an 850 run value.
Thanks in advance,
Rob
August 21, 2008 at 2:17 pm
Task manager never accurately reports memory usage for SQL.
August 21, 2008 at 2:49 pm
try running dbcc memorystatus to see how much is actually consumed
August 21, 2008 at 4:22 pm
what is min memory set to on the instances?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply