Connection Issues

• TST1

  SSCommitted

  Points: 1798

  More actions

  December 1, 2011 at 2:40 am

  #263916

  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

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  December 1, 2011 at 3:10 am

  #1415104

  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