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

  • 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

  • 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

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

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