Share via

Where is that darn Activity Monitor in SQL Server 2008?

  • Article

Technorati Tags: SQL Server 2008,Activity Monitor,SSMS

You may have heard – we rewrote the Activity Monitor from the ground up. However, I’ve seen feedback on the Connect site and from others looking at SQL Server 2008 who claim they can’t find the Activity Monitor. Well – I guess I learned a lesson – don’t willy-nilly move UI components without making it obvious where it moved to.

From the image below – you’ll notice that the Activity Monitor node is no longer under the Management Folder in SSMS.

SSMS 2008 Activity Monitor Launch Points

Instead, we’ve added a new icon on the main toolbar at the far right side. In this example, I customized the toolbar button to show both the icon and the command text to make it more obvious. We also added the Activity Monitor command to the Server context menu as well.  Although I don’t show it, you can also configure SSMS to start-up with Activity Monitor using the Tools | Options command.

There you go – maybe we'll need to consider moving it back – naw :-)

Comments

  • Anonymous
    December 28, 2008
      Now that you know where to find the Activity Monitor in SQL Server 2008 Management Studio, here
  • Anonymous
    July 26, 2010
    Thanks a lot<a hreef='http://www.videozcorner.com' > sql server videos </a>
  • Anonymous
    May 27, 2015
    Hi, Thanks, I really thought it was gone. It will take a while to get used to the layout... I do like the Recent Expensive Queries.