Sybase 12.5.1, User Manual

Page: 188 / 210

Cache performance summary
174
Historical Server
Cache performance summary
This view represents the overall effectiveness of Adaptive Server caches
during the most recent sample interval. It shows the percentage of data page
reads that are satisfied from the Adaptive Server data caches, as well as the
percentage of requests for procedure executions that are satisfied from the
Adaptive Server procedure cache.
hs_create_view cache_perf_sum,
"Page Hit Percent", "Value for Sample",
"Procedure Hit Percent", "Value for Sample"
Device I/O performance summary 179
Engine activity 179
Lock performance summary 179
Network activity for recording session 180
Network activity for sample interval 180
Network performance summary 181
Page I/O 181
Procedure cache statistics for recording session 182
Procedure cache statistics for sample interval 182
Procedure page I/O 183
Process activity 183
Process database object page I/O 184
Process detail for locks 185
Process detail page I/O 185
Process locks 186
Process page I/O 186
Process state summary 187
Process stored procedure page I/O 187
Server performance summary 188
Stored procedure activity 188
Transaction activity 189
Topic Page