|
1> sp_sysmon '00:01:00'
===============================================================================
Sybase Adaptive Server Enterprise System Performance Report
===============================================================================
Server Version: Adaptive Server Enterprise/15.0.2/EBF 15965 ESD#6/P/ia64
Server Name: SHD_SPMS_SRV
Run Date: Mar 23, 2011
Sampling Started at: Mar 23, 2011 10:09:18
Sampling Ended at: Mar 23, 2011 10:10:31
Sample Interval: 00:01:13
Sample Mode: No Clear
Counters Last Cleared: Feb 26, 2011 23:09:33
===============================================================================
Kernel Utilization
------------------
Your Runnable Process Search Count is set to 10
and I/O Polling Process Count is set to 50
Engine Busy Utilization CPU Busy I/O Busy Idle
------------------------ -------- -------- --------
Engine 0 100.0 % 0.0 % 0.0 %
Engine 1 100.0 % 0.0 % 0.0 %
Engine 2 100.0 % 0.0 % 0.0 %
Engine 3 100.0 % 0.0 % 0.0 %
------------------------ -------- -------- --------
Summary Total 400.0 % 0.0 % 0.0 %
Average 100.0 % 0.0 % 0.0 %
CPU Yields by Engine per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 0.0 0.0 0 0.0 %
Engine 1 0.0 0.0 0 0.0 %
Engine 2 0.0 0.0 0 0.0 %
Engine 3 0.1 0.0 5 100.0 %
------------------------- ------------ ------------ ----------
Total CPU Yields 0.1 0.0 5
Network Checks
Non-Blocking 30.2 1.3 2208 99.8 %
Blocking 0.1 0.0 5 0.2 %
------------------------- ------------ ------------ ----------
Total Network I/O Checks 30.3 1.3 2213
Avg Net I/Os per Check n/a n/a 3.79349 n/a
Disk I/O Checks
Total Disk I/O Checks 34.7 1.4 2533 n/a
Checks Returning I/O 12.1 0.5 882 34.8 %
Avg Disk I/Os Returned n/a n/a 0.55102 n/a
Tuning Recommendations for Kernel Utilization
---------------------------------------------
- Consider bringing more engines online |
|