The Activity Monitor in SQL Server Management Studio is a great tool which can be used by DBA’s and database developers to get a quick overview of SQL Server system performance and connections. The Activity Monitor tool in SQL Server older versions than 2008 used to display information related to Processes, Lock by Objects and Locks by Process. There are many enhancements in Activity Monitor in SQL Server 2008 onwards like graphical display of Processor Time, Processes, Waiting Tasks, Database I/O’s, Data File I/O’s,Batch Requests, Resource Waits and also information on most expensive queries.
It is Best SQL server Monitoring software / Application which ships free with SSMS (SQL Server Management Studio). It is widely used for Performance monitoring in SQL Server by analyzing SQL Performance monitor metrics for individual SQL database performance monitoring like number of connections , Top processor utilization etc..
2 Different Ways to Open up Activity Monitor in SQL Server 2008 are mentioned below:
Open up Activity Monitor Using Object Explorer
In Object Explorer, right click the SQL Server 2008 Instance and click on Activity Monitor.
Also can be opened from SQL Server 2008 Management Studio’s toolbar, by clicking Activity Monitor
It shows the graphical display of Processor Time (%), Number of Waiting Tasks, Database I/O (MB/Sec) and the Number of Batch Requests/second.
Red Gate SQL Monitor is a paid version of SQL Monitoring tool / Application which can be used for monitoring multiple SQL Servers without connecting to each one. It is useful both for Monitoring Performance tuning.