The following sample shows sp_sysmon output for “Kernel Utilization” in an environment with eight Adaptive Server engines.
Kernel Utilization ------------------ Your Runnable Process Search Count is set to 2000 and I/O Polling Process Count is set to 10 Engine Busy Utilization CPU Busy I/O Busy Idle ------------------------ -------- -------- -------- Engine 0 3.3 % 13.7 % 83.0 % Engine 1 2.4 % 9.2 % 88.4 % Engine 2 4.9 % 19.9 % 75.2 % Engine 3 .8 % 19.1 % 76.1 % Engine 4 2.8 % 7.0 % 90.2 % Engine 5 1.9 % 7.3 % 90.8 % Engine 6 2.5 % 7.6 % 89.9 % Engine 7 2.0 % 8.1 % 89.9 % ------------------------ -------- -------- -------- Summary Total 24.6 % 91.9 % 683.5 % Average 3.1 % 11.5 % 85.4 % CPU Yields by Engine per sec per xact count % of total ------------------------- ----------- ----------- --------- --------- Engine 0 31.5 0.0 2802 11.6 % Engine 1 38.1 0.0 3388 14.0 % Engine 2 21.8 0.0 1936 8.0 % Engine 3 30.2 0.0 2689 11.1 % Engine 4 37.9 0.0 3372 13.9 % Engine 5 38.4 0.0 3421 14.1 % Engine 6 36.1 0.0 3217 13.3 % Engine 7 38.4 0.0 3420 14.1 % ------------------------- ---------- ----------- -------- Total CPU Yields 272.4 0.2 24245 Network Checks Non-Blocking 434722.4 366.8 38690292 99.9 % Blocking 272.4 0.2 24247 0.1 % ------------------------- ---------- ----------- -------- Total Network I/O Checks 434994.8 367.1 38714539 Avg Net I/Os per Check n/a n/a 0.00003 n/a Disk I/O Checks Total Disk I/O Checks 435855.6 367.8 38791149 n/a Checks Returning I/O 125358.1 105.8 11156875 28.8 % Avg Disk I/Os Returned n/a n/a 0.00313 n/a