Need to open Activity Monitor but can’t find it in SQL Server Management Studio for 2008 R2? Here’s how to open Activity Monitor in SQL Server 2008 R2:
Open SQL Server Management Studio 2008 R2
Connect to the SQL server
On the tool bar, click on the icon that looks like a little graph. Alternatively, press Ctrl + Alt + A to open Activity Monitor.