November 30, 2012 at 3:24 pm
Team,
Is there any way to find how much how much memory the single sqlserver instance is actually using in the node? I can see the max memory allocated is 50MB for my instance.But here i want to know hw much actually the instance is using.Can anyone help me on this.
Thank you,
Mithra.
December 1, 2012 at 1:00 am
Did you check the perfmon counter total server memory?
December 3, 2012 at 3:28 am
Mithra (11/30/2012)
I can see the max memory allocated is 50MB for my instance.
are you sure for this no ? and task manager can give you estimated value for sqlserver.exe
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 3, 2012 at 4:25 am
Mithra (11/30/2012)
Team,Is there any way to find how much how much memory the single sqlserver instance is actually using in the node? I can see the max memory allocated is 50MB for my instance.But here i want to know hw much actually the instance is using.Can anyone help me on this.
Thank you,
Mithra.
Execute below query on your SQL Server instance:
SELECTCASE counter_name
WHEN 'Target Server Memory (KB)' THEN 'MemoryAssignedToSQLServer'
WHEN 'Total Server Memory (KB)' THEN 'MemoryUsedBySQLServer'
END AS Property,
(cntr_value/1024) AS Value_MB
FROMsys.dm_os_performance_counters
WHEREcounter_name IN ('Target Server Memory (KB)','Total Server Memory (KB)')
Hope this helps.
December 3, 2012 at 7:04 am
Bhuvnesh (12/3/2012)
and task manager can give you estimated value for sqlserver.exe
No, Task manager gives exact values, not estimated. It can be wrong because it doesn't count memory allocated via the AWE mechanism which is used when SQL has the locked pages in memory privilege.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply