Connection Issues

  • Hi,

    One of my users was having problems connecting to one of the instances on our consolidated server. This server holds several instances of both 2005 and 2008. I found out that the memory was being used by one instance alone. Is there a dmv that could have told me this and also what is the best way to monitor which instance/s is using most of the memory.

    Thanks

  • select *

    from sys.dm_os_performance_counters

    where counter_name = 'Total Server Memory (KB)'

    Run this on all the instances and you'll get the whole picture.

    -- Gianluca Sartori

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

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