SQL Profiler

Running under a different domain… To filter to only Stored Procedures… Events -> Check “RPC:Completed” To filter to a specific database… Trace Properties -> “Events Selection” tab -> Click on “Column Filters” Select “DatabaseName” -> LIKE “Datbase01”

SQL Server Activity Monitor

The SQL Server Activity Monitor gathers information about the monitored instance and displays the data in a series of collapsible panes.  Right Click Server -> Activity Monitor The Activity Monitor is split up into a couple of different panes. Overview Processes Resource Waits data file input output Recent expensive queries Active expensive queries