SQL Server 2008 Activity Monitor

The Activity Monitor node is no longer under the Management Folder in SSMS,” Ramos explained. “Instead, we’ve added a new icon on the main toolbar at the far right side. We also added the Activity Monitor command to the Server context menu as well. Although I don’t show it, you can also configure SSMS to […]

The Activity Monitor node is no longer under the Management Folder in SSMS,” Ramos explained. “Instead, we’ve added a new icon on the main toolbar at the far right side. We also added the Activity Monitor command to the Server context menu as well. Although I don’t show it, you can also configure SSMS to start-up with Activity Monitor using the Tools | Options command.

Unlike the previous version of the Activity Monitor (AM), the new AM starts up with a 10 second refresh interval. That doesn’t necessarily mean that each of the four panes: Overview, Processes, Resource Waits, Data File I/O, and Recent Expensive Queries all refresh at the specified interval, Ramos stated.

Source:→ Softpedia