Table 21-1 describes updates to monitoring tables.
Column name |
Monitoring table |
Description |
|---|---|---|
RowsAffected |
monSysStatement |
Indicates the number of rows affected by the current statement. Queries using an inefficient query plan probably show a high number of logical I/Os per returned row. |
ErrorStatus |
monSysStatement |
The error return status of the statement. |
RowsAffected |
monProcessStatement |
Indicates the number of rows affected by the current statement. Queries using an inefficient query plan probably show a high number of logical I/Os per returned row. |
BlockedBy |
monLocks |
Identifies the lock ID blocking this lock request. Zero indicates no block. |
BlockedState |
monLocks |
Identifies lock status. |
