Sybase 12.5.1, Руководство пользователя

Страница: 122 / 210

Table of data items and definitions
108
Historical Server
Current Stmt Locks
Granted After Wait
Version: 11.5 and later
Number of lock requests by the currently executing SQL statement that were granted
after waiting.
Type: Result
Current Stmt Locks
Granted Immediately
Version: 11.5 and later
Number of lock requests by the currently executing SQL statement that were granted
immediately or were not needed (because sufficient locking was already held by the
requestor).
Type: Result
Current Stmt Locks Not
Granted
Version: 11.5 and later
Number of lock requests by the currently executing SQL statement that were denied.
Type: Result
Current Stmt Logical
Reads
Version: 11.5 and later
Number of data page reads satisfied from cache or from device reads by the currently
executing SQL statement.
Type: Result
Current Stmt Number
Version: 11.5 and later
The number of the statement (appearing in a query batch or stored procedure) that is
the currently executing SQL statement for a particular process. The currently
executing SQL statement is in the query batch if both Current Stmt Procedure Database
ID is equal to 0 and Current Stmt Procedure ID is equal 0.
Otherwise, the currently executing SQL statement is in the stored procedure uniquely
identified by these two IDs.
A value of 0 indicates partial result data for the currently executing SQL statement. In
other words, this SQL statement began executing before monitoring began.
Performance metrics are available but numbers reflect only the time period since the
start of monitoring.
Type: Result
Current Stmt Page I/O
Version: 11.5 and later
Number of combined logical page reads and page writes by the currently executing
SQL statement.
Type: Result
Current Stmt Physical
Reads
Version: 11.5 and later
Number of data page reads by the currently executing SQL statement that could not be
satisfied from the data cache.
Type: Result
Current Stmt Procedure
Database ID
Version: 11.5 and later
The database ID of the stored procedure (including triggers, a special kind of stored
procedure) that contains the currently executing SQL statement for a particular
process. If the currently executing SQL statement is not contained in a stored
procedure, this ID is 0.
Type: Result
Data item Description