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

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

Designing recording session views
122
Historical Server
Table B-1: View examples using various key combinations
Designing recording session views
To define a view:
• Choose valid combinations of key and result data items using Table B-2
on page 124.
• Choose valid statistic types for each of the data items using Table B-3 on
page 148.
Using the Process ID
When a server process terminates, Adaptive Server can reuse its Process ID for
a new process. Therefore, the Process ID data item is not guaranteed to
uniquely identify a process. The Kernel Process ID data item, however,
uniquely identifies a process.
View definition Results
Page I/O Since there are no keys in the view, the result is page I/O for the whole
server. For example:
Page I/O
--------
145
Process ID (key), Login
Name, Page I/O The result is page I/O per process. For example:
Process ID Login Name Page I/O
--------------------------------------
1 sa 45
5 joe 100
Process ID (key),
Database ID (key),
Object ID (key),
Database Name, Object
Name, Page I/O The result is page I/O per database table per process. For example:
Process Database Object Databse Object Page
ID ID ID Name Name I/O
---------------------------------------------
1 5 208003772 pubs2 authors 10
1 5 336004228 pubs2 titles 35
5 5 208003772 pubs2 authors 100