How can I view activity monitor on multiple SQL Server instances???

• WWDMark

  Hall of Fame

  Points: 3157

  More actions

  February 9, 2012 at 3:30 am

  #252695

  Hi there, wondering if someone could point me in the right direction - I'm responsible for maintaining 4 instances of SQL Server 2008 R2, each instance has it's own seperate server that I access via Remote Desktop on Windows 7. I'd like to be able to view the activity monitor on all the servers and display a 'collective' view on one PC screen. Does anyone know if this is possible and if so how could I implement it?

  Thanks in advance.

  ---

  MCITP
  MCTS - E-Business Card
  Twitter: WWDMark

  ---

  
  Try not! Do or do not, there is no try

  email: info@weekendwebdesign.co.uk
  Personal Website: http://markallen.co.uk/
  Business Website: https://www.weekendwebdesign.co.uk

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  February 9, 2012 at 7:57 am

  #1445086

  You could grab the query run by activity monitor and run it against a server group.

  How to: Execute Statements Against Multiple Servers Simultaneously

  Activity Monitor and Profiler[/url]

  -- Gianluca Sartori