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.

To create a non-raw playback view that shows per-process data, the recording session view and the playback view must include both the Process ID and Kernel Process ID data items. If playback is raw, using only Process ID is allowed.

Views that include Process ID return rows as follows:

These views return rows for all server processes included in any of the input samples. However, since process IDs are not guaranteed to be unique, the Kernel Process ID data item must also be included to ensure uniqueness of the key. Otherwise, the view could erroneously summarize two different processes.