How do I view the open connections in a SQL Server 2008 R2 Database Instance

• maas149848

  Old Hand

  Points: 336

  More actions

  April 11, 2011 at 4:13 pm

  #248701

  In SQL Server 2005, I could view existing connections by viewing Connection under the management folder.

  How do I do this in 2008 R2?

  Thanks!

  Michael

• Grant Fritchey

  SSC Guru

  Points: 399061

  More actions

  April 12, 2011 at 6:46 am

  #1310332

  You've got a couple of options. My favorite is to use Dynamic Management Objects such as sys.dm_exec_requests or sys.dm_exec_sessions to see what's happening on the server. You can combine these with other DMOs to get excellent information.

  You can also use the Activity Monitor inside SSMS to see what's happening on the server. Right click on the server in the Object Explorer and you'll see the Activity Monitor as a menu choice.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning