Home Forums SQL Server 2008 SQL Server 2008 Administration Memory utilization by a single sqlserver instance alone. RE: Memory utilization by a single sqlserver instance alone.

  • December 3, 2012 at 4:25 am

    #1564796

    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.

    Sujeet Singh