Sybase 12.5.1, User Manual

Page: 6 / 210

Contents
vi
Historical Server
Using “Timestamp”, “Timestamp Datim”, and “Elapsed Time” 170
A P P E N D I X D
Examples of Recording Session Views..................................... 173
Cache performance summary ...................................................... 174
Database object lock status ......................................................... 175
Database object page I/O ............................................................ 175
Data cache activity for individual caches ..................................... 176
Data cache statistics for recording session.................................. 177
Data cache statistics for sample interval ...................................... 177
Device I/O for recording session .................................................. 178
Device I/O for sample interval ...................................................... 178
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
Index ........................................................................................................................................... 191