As Joey explains, Activity Monitor consumes a lot of resources and yields little usable data. Here are some third-party alternatives. I get to work with a lot of customers, so I get to see a lot of ...

Redgate Software is releasing SQL Monitor v7, adding a reporting suite to the SQL Server monitoring tool. The new feature can instantly generate accurate, informative reports on the performance of SQL ...