You can monitor individual user activity to pinpoint transactions that may be blocking other transactions or causing the performance of Microsoft® SQL Server™ to be slower than expected.
Monitoring user activity helps identify trends such as the types of transactions run by certain users, if any users are executing inefficient ad hoc queries, and the types of transactions that require the most resources.
To collect statistical information about users, use either SQL Server Profiler or Windows NT Performance Monitor. Use the SQL Server Enterprise Manager Current Activity window to perform ad hoc monitoring of SQL Server, which allows you to determine user activity on the system.
Monitoring with SQL Server Enterprise Manager | SQL Server: General Statistics Object |
Sessions Event Category |