Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Memory utilization by a single sqlserver instance alone. Expand / Collapse
Author
Message
Posted Friday, November 30, 2012 3:24 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, August 16, 2014 12:36 PM
Points: 31, Visits: 378
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.
Post #1391575
Posted Saturday, December 1, 2012 1:00 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, November 28, 2013 10:20 PM
Points: 45, Visits: 309
Did you check the perfmon counter total server memory?
Post #1391631
Posted Monday, December 3, 2012 3:27 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 12:26 AM
Points: 2,840, Visits: 3,963
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
Post #1391830
Posted Monday, December 3, 2012 4:25 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 9:44 AM
Points: 1,320, Visits: 2,551
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:


SELECT CASE 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
FROM sys.dm_os_performance_counters
WHERE counter_name IN ('Target Server Memory (KB)','Total Server Memory (KB)')


Hope this helps.



Sujeet Singh
Post #1391844
Posted Monday, December 3, 2012 7:04 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:28 PM
Points: 43,028, Visits: 36,193
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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1391924
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse