Memory counters in system monitor

  • Hi ,

    I have 2 instances of SQL server and how can i check the memory "currently" being used by my each instance ,i find so many counters in perfmon but can any body direct me to the correct counters to check how much memory is being consumed by my SQL instances.

    Thanks

  • In SQL 2005 I use this....

    SELECT

    object_name, counter_name, cntr_value/1024 as 'MBs used'

    from

    sys.dm_os_performance_counters

    where

    object_name = 'SQLServer:Memory Manager'

    and

    (counter_name = 'Total Server Memory (KB)' or counter_name = 'Target Server Memory (KB)')

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply