Okay, where has the Activity Monitor gone in Microsoft SQL Server Management Studio 2008?

1. Open Microsoft SQL Server Management Studio.  
2. In Object Explorer, right click on the server and select Activity Monitor.  Please note that the Activity Monitor is not available in the context menu unless you select the server.  You cannot launch the Activity Monitor when you select a database, another folder, etc.