March 15, 2009 at 2:09 pm
I have 32 GB physical memory on my production SQL Server and allocated 28 GB for SQL instance. when i run task manager - i see SQL Server consuming all 28 GB. but when i run perfmon and capture the counters like - Process working set and Total server memory. here's what i see:
Process working set is 200 MB
Total Server memory is like 180 MB.
Is there a way i could tell at any given moment - the memory in use by SQL Server? i thought Process working set could tell me. but may be i am wrong.
Appreciated any input on this.
March 15, 2009 at 5:19 pm
i guess that your using 32 bit sql server with awe enabled?
If so task manager will not accurately refelect the amount of memory being used by sql sever, as memory is not allocated dymaically with awe
Taken from a Technet article
Use the SQL Server Performance Monitor Total Server Memory (KB) counter to determine how much memory is allocated by the instance of SQL Server running in AWE mode, or select memory usage from sysperfinfo.
http://technet.microsoft.com/en-us/library/ms190673.aspx
this article has some useful tips for monitoring memoery usage
http://technet.microsoft.com/en-us/library/ms176018.aspx
Gethyn Elliswww.gethynellis.com
March 16, 2009 at 4:10 pm
Sorry should have mentioned earlier. i am using 64-bit SQL 2005.
March 16, 2009 at 4:28 pm
Have you set the max and min server memory to be the same value?
if not what are these values?
Gethyn Elliswww.gethynellis.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply