SQL SERVER – 2008 – Location of Activity Monitor – Where is SQL Serve Activity Monitor Located

I received question from Aloke Sinha after reading my article SQL SERVER – 2008 – Activity Monitor is Empty – Fix Activity Monitor for All Users.

Hello Pinalbhai,

Thank you for your post about activity monitor, but I can not find activity monitor under Menu — Tools. How to activate it?

[Other unrelated information removed]

Take care,
Aloke Sinha

The reason I decided to write about this subject is because I totally understand why Aloke is confused here. Activity Monitor can not be activated from any menu from top menu bar. There are two different methods to activate Activity Monitors.

From Standard Toolbar (Standard Toolbar can be made visible from here : Menu >> View >> Toolbar >> Standard) and from “Right Click” of SQL Server Node.

Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL Activity Monitor, SQL Utility
Previous Post
SQL SERVER – 2008 – Activity Monitor is Empty – Fix Activity Monitor for All Users
Next Post
SQL SERVER – 2008 – SCOPE_IDENTITY Bug with Multi Processor Parallel Plan and Solution

Related Posts

5 Comments. Leave new

  • Thank you for this posting.

    The SQL 2008 BOL states Activity Monitor is in the Management section of Object Explorer, which is of course wrong.

    Quite a nice tool – now I can actually find it!

  • Sumit Jolly
    June 27, 2014 8:45 am

    Hi Pinal, is it same like sp_who

  • Activity Monitor do not open. Error: Could not load file or assembly ‘Microsoft.SqlServer.Management.ResourceMonitoring…


Leave a Reply

Exit mobile version