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

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

APPENDIX A Data Items
User’s Guide
119
Select Statements
Version: 11.0 and later
Number of SELECT or OPEN CURSOR statements.
Type: Result
Server Structures Size
Version: 11.0 and later
Amount of memory in bytes allocated for the Adaptive Server structures.
Type: Result
SQL Server Name
Version: 11.0 and later Name of the Adaptive Server that is being monitored as specified by the -S parameter
in the start-up command for the Monitor Server being used.
Type: Result
SQL Server Version
Version: 11.0 and later
Version of the Adaptive Server that is being monitored. For more information, see the
global @@version variable in the Transact-SQL User’s Guide.
Type: Result
Thread Exceeded Max
Version: 11.5 and later
The number of times a query plan was adjusted at runtime because of attempting to
exceed the configured limit of threads in the server-wide worker thread pool in
Adaptive Server version 11.5 and later.
Type: Result
Thread Exceeded Max
Percent
Version: 11.5 and later
The percentage of time a query plan was adjusted at runtime because of attempting to
exceed the configured limit of threads in the server-wide worker thread pool in
Adaptive Server version 11.5 and later.
Type: Result
Thread Max Used
Version: 11.5 and later
The maximum number of threads from the server-wide worker thread pool that were
concurrently in use on the server.
Type: Result
Time Waited on Lock
Version: 11.0 and later
Amount of time (in seconds) that a lock request has been waiting.
Type: Result
Timestamp
Version: 11.0 and later
In recording session views and in playback views when summarization_level is raw,
the date and time on the Adaptive Server when the recording session data was
gathered.
In playback views, when summarization_level is actual , entire , or a user-defined
interval, the time is converted to the time zone of Historical Server.
For more information, see the
getdate()
function in the Transact-SQL User’s Guide.
Type: Result
Timestamp Datim
Version: 11.0 and later
In recording session views and in playback views when summarization_level is
raw,
the date and time on the Adaptive Server when the recording session data was
gathered, returned in a CS_DATETIME structure. For more information, see the
getdate()
function in the Transact-SQL User’s Guide.
In playback views, when summarization_level is
actual
,
entire
, or a user-defined
interval, the time is converted to the time zone on Historical Server.
Type: Result
Data item Description