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 (http://blog.sqlauthority.com)