Use SQL Server Enterprise Manager to view the following information about current
Microsoft SQL Server activity:
- Current user connections and locks.
- Process number, status, locks, and commands that active users are running.
- Objects that are locked, and the kinds of locks that are present.
If you are a system administrator, you can view additional information about a selected process,
send a message to a user who is connected currently to an instance of SQL Server, or terminate a selected process.
Use the current activity window in SQL Server Enterprise Manager to perform ad hoc monitoring of an instance of SQL Server.
This allows you to determine, at a glance, the volume and general types of activity on the system, for example:
- Current blocked and blocking transactions.
- Currently connected users on an instance of SQL Server and the last statement executed.
- Locks that are in effect.
SQL Server activity can be monitored using the sp_who and sp_lock system stored procedures.