Sample output

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