Sample output

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