Cisco Cisco Process Orchestrator 3.0
4-53
Cisco TEO Adapter Guide for Microsoft SQL Server Database
OL-24576-02
Chapter 4 Using Microsoft SQL Server Database Activities
Viewing Activity Instance Information
Figure 4-37
Check SQL Server Locks Properties—Results Tab
The following information is displayed:
Column
Description
Database name
Name of the database currently being used by the process
Blocked PID
Process ID (spid) of a blocking process
Blocked Host Process
Process ID number of workstation that is blocked by the
process
process
Blocker PID
Process ID of the item blocked
Blocker Host Process
Process ID number of workstation that is blocking the
process
process
Wait time (seconds)
Current wait time in milliseconds. Is 0 when the process is
not waiting
not waiting
Last Wait Type
String indicating the name of the last or current wait type
Wait resource
Textual representation of a lock resource
Blocked Status
Process ID status of the item blocked
Blocker Status
Process ID status of the blocking resource
Blocked Program Name
Name of the application program blocked by the process
Blocker Program Name
Name of the application program that is blocking the
process
process