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

March 23, 2009

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

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.

SQL SERVER - 2008 - Location of Activity Monitor - Where is SQL Serve Activity Monitor Located avmonact

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

SQL Activity Monitor, SQL Utility

SQL SERVER – 2008 – Activity Monitor is Empty – Fix Activity Monitor for All Users

SQL SERVER – 2008 – SCOPE_IDENTITY Bug with Multi Processor Parallel Plan and Solution

5 Comments. Leave new

Sharon Smith
November 5, 2009 8:30 pm
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!
Reply
Sumit Jolly
June 27, 2014 8:45 am
Hi Pinal, is it same like sp_who
Reply
Terezinha
June 3, 2015 11:38 pm
Activity Monitor do not open. Error: Could not load file or assembly ‘Microsoft.SqlServer.Management.ResourceMonitoring…
Reply