Server performance summary

This view represents overall Adaptive Server performance. It shows the number of lock requests per second, the percentage of the sample interval when the Adaptive Server was busy, the number of transactions processed per second, and the number of times the Adaptive Server detected a deadlock during the most recent sample interval.

hs_create_view server_perf_sum,
"Lock Count", "Rate for Sample",
"CPU Busy Percent", "Value for Sample",
"Transactions", "Rate for Sample",
"Deadlock Count", "Value for Sample"