mattwilson247
Old Hand
Points: 308
More actions
November 22, 2011 at 10:41 am
#246647
sqlservr.exe in Task Manager used to show the max amount of memory assigned to it (16 gigs) but now it never goes above 175 mb. Any reason why this would change?
November 22, 2011 at 10:59 am
#1411703
Disregard. I believe I found the answer in this post. http://www.sqlservercentral.com/Forums/Topic995089-146-1.aspx. We recently turned on a trace.
viiki.seth
Ten Centuries
Points: 1127
November 22, 2011 at 12:04 pm
#1411740
You can find the actual memory usage by below query.
SELECT cntr_value AS 'Total SQL Server Memory'
FROM sys.dm_os_performance_counters
WHERE object_name = 'MSSQL$INSTANCENAME:Memory Manager'
and counter_name = 'Total Server Memory (KB)'
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply