I received question from Aloke Sinha after reading my article SQL SERVER – 2008 – Activity Monitor is Empty – Fix Activity Monitor for All Users.
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]
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)
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!
Hi Pinal, is it same like sp_who
Activity Monitor do not open. Error: Could not load file or assembly ‘Microsoft.SqlServer.Management.ResourceMonitoring…