Determining User Activity
You can monitor individual user activity to pinpoint the type and location of blocking transactions or slowed performance of Microsoft SQL Server.
Monitoring user activity helps identify trends such as the types of transactions run by users, the number of inefficient ad hoc queries being run, and the types of transactions requiring the most resources. To collect statistical information about users, use either SQL Server Profiler or System Monitor. Use the SQL Server Management Studio Activity Monitor to perform ad hoc monitoring of SQL Server, which allows you to determine user activity on the system.
See Also