sp_whopro lets you monitor the current activity of a SQL Server Instance and at the same time allows you to save the activity to database for later analysis. You can collect data related to CPU, IO, MEMORY, NETWORK, WAIT, BLOCKING, LOCK, TRANSACTION,..
Relevance: 15.466485