| |
Process Blocking
Real-time shows the information of blocking activity. You can forcible kill connection or view the Last SQL code executed of a process.
Display
- Process ID SQL Server process ID (SPID).
- Host Name of the workstation.
- Blocked Process ID (SPID) of a blocking process.
- Duration Number of microseconds between the time the block request was issued and the current time.
- CPU Cumulative CPU time for the process.
- Physical I/O Cumulative disk reads and writes for the process.
- Memory Number of pages in the procedure cache that are currently allocated to this process. A negative number indicates that the process is freeing memory allocated by another process.
- Login name The login name associated with the particular process.
- Login Time Time at which a client process logged into the server.
- Last Batch Last time a client process executed a remote stored procedure call or an EXECUTE statement.
- Program Name of the application program.
- Status The process status.
- Database The database used by the process.
- Command Command currently being executed.
- SQL Last SQL code executed that caused the block.
Interaction
To forcible kill a connection, right-click the process and click Kill Process.
To view Last SQL code executed of process, right-click the process and click Details.
|
