Blog

SQL Server 2008 Active Connections

June 17, 2009

Went digging around for ways to view the active connections in Microsoft SQL 2008. To my surprise Microsoft moved the Activity Monitor. Apparently they did this way back in SQL 2005. I skipped 2005 so I missed that. To view the open connection:

  1. Open Management Studio.
  2. On the standard toolbar is a little graph icon. That is the Activity Monitor (CTRL + ALT + A).
  3. Click on Processes

Simple as that!

2 Comments

Mary
MaryJune 18, 2012 at 6:27:17 pm

I was in the same position today, having skipped over SQL Server 2005, so I missed the memo where they revamped this. Thank you for this gem... it really was as simple as that!

wendy yan
wendy yanOctober 19, 2015 at 2:06:13 pm

I have tried to find this for many years. Thank you for sharing this!

Wendy

Leave Your Comment

Your email address will not be published. Required fields are marked *


about me

An information technology professional with twenty five years experience in systems administration, computer programming, requirements gathering, customer service, and technical support.