The following sample shows sp_sysmon output for “Kernel Utilization” in an environment with one thread pool, syb_default_pool, and three Adaptive Server engines.
Kernel Utilization ------------------ Engine Utilization (Tick %) User Busy System Busy I/O Busy Idle ----------------------- ------------ ------------ ---------- -------- ThreadPool : syb_default_pool Engine 0 8.7 % 0.8 % 31.1 % 59.5 % Engine 1 8.0 % 0.1 % 33.2 % 58.7 % Engine 2 8.8 % 0.3 % 32.7 % 58.2 % Engine 3 15.0 % 0.3 % 32.6 % 52.0 % ------------------------- ------------ ------------ ---------- ------- Server Summary Total 40.4 % 1.6 % 129.6 % 228.4 % Average 10.1 % 0.4 % 32.4 % 57.1 % Average Runnable Tasks 1 min 5 min 15 min % of total ------------------------- ---------- ---------- ------- -------- ThreadPool : syb_default_pool Global Queue 0.0 0.0 0.0 0.0 % Engine 0 0.3 0.2 0.1 61.7 % Engine 1 0.0 0.0 0.0 0.7 % Engine 2 0.1 0.1 0.0 17.3 % ------------------------- ------------ ------------ --------- Pool Summary Total 0.5 0.3 0.1 Average 0.1 0.1 0.0 ------------------------- ------------ ------------ --------- Server Summary Total 0.5 0.3 0.1 Average 0.1 0.1 0.0 CPU Yields by Engine per sec per xact count % of total ------------------------- -------- ---------- -------- -------- ThreadPool : syb_default_pool Engine 0 Full Sleeps 20.4 13.8 2442 4.2 % Interrupted Sleeps 81.7 55.4 9800 16.7 % Engine 1 Full Sleeps 22.8 15.5 2740 4.7 % Interrupted Sleeps 89.1 60.4 10697 18.3 % Engine 2 Full Sleeps 19.9 13.5 2390 4.1 % Interrupted Sleeps 93.4 63.3 11202 19.1 % Engine 3 Full Sleeps 17.8 12.1 2133 3.6 % Interrupted Sleeps 142.6 96.7 17113 29.2 % ------------------------- ------------ ------------ ---------- Pool Summary 487.6 330.6 58517 ------------------------- ------------ ------------ ---------- Total CPU Yields 487.6 330.6 58517 Thread Utilization (OS %) User Busy System Busy Idle ------------------------- ------------ ------------ ---------- ThreadPool : syb_blocking_pool : no activity during sample ThreadPool : syb_default_pool Thread 6 (Engine 0) 0.0 % 0.0 % 100.0 % Thread 7 (Engine 1) 0.2 % 0.0 % 99.8 % Thread 8 (Engine 2) 0.0 % 0.0 % 100.0 % ------------------------- ------------ ------------ ---------- Pool Summary Total 0.2 % 0.0 % 299.9 % Average 0.1 % 0.0 % 99.9 % ThreadPool : syb_system_pool Thread 10 (NetController) 0.1 % 0.0 % 99.9 % ------------------------- ------------ ------------ ---------- Pool Summary Total 1.1 % 0.0 % 400.0 % Average 0.0 % 0.0 % 100.0 % ------------------------- ------------ ------------ ---------- Server Summary Total 0.2 % 0.0 % 1099.8 % Average 0.0 % 0.0 % 100.0 % Adaptive Server threads are consuming 0.0 CPU units. Throughput (committed xacts per CPU unit) : 275.0 Page Faults at OS per sec per xact count % of total ------------------------- -------- ---------- -------- -------- Minor Faults 0.6 0.4 69 100.0 % Major Faults 0.0 0.0 0 0.0 % ------------------------- -------- ---------- -------- -------- Total Page Faults 0.6 0.4 69 100.0 % Context Switches at OS per sec per xact count % of total ------------------------- -------- ---------- -------- -------- ThreadPool : syb_blocking_pool Voluntary 0.0 0.0 0 0.0 % Non-Voluntary 0.0 0.0 0 0.0 % ThreadPool : syb_default_pool Voluntary 43.6 130.7 1307 56.3 % Non-Voluntary 0.2 0.6 6 0.3 % ThreadPool : syb_system_pool Voluntary 33.7 101.0 1010 43.5 % Non-Voluntary 0.0 0.0 0 0.0 % ------------------------- ----------- ------------ ---------- --------- Total Context Switches 77.4 232.3 2323 100.0 % CtlibController Activity per sec per xact count % of total ------------------------- -------- ---------- -------- -------- Polls 1.0 0.7 120 n/a Polls Returning Events 0.0 0.0 0 0.0 % DiskController Activity per sec per xact count % of total ------------------------- -------- ---------- -------- -------- Polls 35019.1 23741.8 4202292 n/a Polls Returning Events 351.2 238.1 42145 1.0 % Polls Returning Max Events 0.0 0.0 0 0.0 % Total Events 374.9 254.1 44984 n/a Events Per Poll n/a n/a 0.011 n/a NetController Activity per sec per xact count % of total ------------------------- -------- ---------- -------- -------- Polls 7919.5 5369.1 950338 n/a Polls Returning Events 2537.8 1720.5 304536 32.0 % Polls Returning Max Events 0.0 0.0 0 0.0 % Total Events 2537.8 1720.5 304536 n/a Events Per Poll n/a n/a 0.320 n/a Blocking Call Activity per sec per xact count % of total ------------------------- -------- ---------- -------- -------- Total Requests 0.0 0.0 0 n/a