Engine activity

This view shows the level of activity for each active Adaptive Server engine during the most recent sample interval. For each engine, the percentage of the sample interval, when that engine used the CPU, is presented.

Also shown are the number of logical page reads, physical page reads, and page writes that were generated by that engine during the sample interval.

hs_create_view engine_activity,
"Engine Number", "Value for Sample",
"CPU Busy Percent", "Value for Sample",
"Logical Page Reads", "Value for Sample",
"Physical Page Reads", "Value for Sample",
"Page Writes", "Value for Sample"