Monitoring with SQL Server Enterprise Manager

Using SQL Server Enterprise Manager, you can view the following information about current Microsoft® SQL Server™ activity:

• Current user connections and locks.
• Process number, status, locks, and commands that the 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 that is currently connected to a computer running SQL Server, or terminate a selected process.

Use the current activity window in SQL Server Enterprise Manager to perform ad hoc monitoring of a computer running 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 SQL Server and the last statement executed.
• Locks that are in effect.

SQL Server activity can also be monitored using the sp_who and sp_lock system stored procedures.

To view current server activity

To view the last command batch for a connection

To view the current locks

To send a message to a currently connected user

To kill a process