Share via


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

Tasks

How to: Open the Activity Monitor (SQL Server Management Studio)

Reference

SQL Server, General Statistics Object

Concepts

Sessions Event Category

Help and Information

Getting SQL Server 2005 Assistance