Post reply

Memory counters in system monitor

  • May 7, 2007 at 8:20 pm

    #117090

    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

  • May 9, 2007 at 11:22 am

    #705319

    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 2 (of 2 total)

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