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

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

Server performance summary
188
Historical Server
"Physical Page Reads", "Value for Sample",
"Page Writes", "Value for Sample"
Server performance summary
This view represents overall Adaptive Server performance. It shows the
number of lock requests per second, the percentage of the sample interval when
the Adaptive Server was busy, the number of transactions processed per
second, and the number of times the Adaptive Server detected a deadlock
during the most recent sample interval.
hs_create_view server_perf_sum,
"Lock Count", "Rate for Sample",
"CPU Busy Percent", "Value for Sample",
"Transactions", "Rate for Sample",
"Deadlock Count", "Value for Sample"
Stored procedure activity
This view shows stored procedure activity at the level of procedure statement.
Each statement of any stored procedure that was executed during the most
recent sample interval is identified by the name and ID of the database that
contains the procedure, the name and ID of the procedure, the relative number
of the statement within the procedure, and the line of the procedure’s text on
which the statement begins.
The view includes the number of times each statement was executed, both
during the most recent sample interval and since the start of the recording
session. It also contains the average elapsed time needed to execute the
statement, both for the sample interval and for the recording session so far.
hs_create_view procedure_activity,
"Procedure Database ID", "Value for Sample",
"Procedure Database Name", "Value for Sample",
"Procedure ID", "Value for Sample",
"Procedure Name", "Value for Sample",
"Procedure Line Number", "Value for Sample",
"Procedure Statement Number", "Value for Sample",
"Procedure Execution Count", "Value for Sample",