ZB 04 sysmon报告解读V01.docx

1、ZB 04 sysmon报告解读V01= Sybase Adaptive Server Enterprise System Performance Report= Server Version: Adaptive Server Enterprise/12.5.4/EBF 14921 ESD#7/P/RS60 Server Name: tst_par2 Run Date: Oct 23, 2014 Sampling Started at: Oct 23, 2014 11:41:16 Sampling Ended at: Oct 23, 2014 12:31:16 Sample Interval:

2、 00:50:00 Sample Mode: Reset Counters = 1. 内核使用率：Kernel Utilization- Your Runnable Process Search Count is set to 200 and I/O Polling Process Count is set to 10 1.1. Engine Busy Utilization Engine Busy Utilization CPU Busy I/O Busy Idle - - - - Engine 0 59.6 % 0.3 % 40.1 % “Engine Busy Utilization”报

3、告 Adaptive Server 内核在每个 Adaptive Server引擎上忙于执行任务的时间（而非空闲时间）的百分比。摘要行给出所有组合引擎的总活动时间和平均活动时间.1.2. CPU Yields by Engine CPU Yields by Engine per sec per xact count % of total - - - - - Engine 0 24.7 1.5 73998 100.0 %“CPU Yields by Engine”报告每个 Adaptive Server 引擎让位于操作系统的次数。“% of total”数据是一个引擎的放弃次数占所有引擎的组合放

4、弃次数的百分比。 1.3. Network Checks Non-Blocking 336.2 19.9 1008633 93.3 % Blocking 24.1 1.4 72248 6.7 % - - - - Total Network I/O Checks 360.3 21.3 1080881 Avg Net I/Os per Check n/a n/a 0.20608 n/a “Network Checks”包括以下相关信息：阻塞和非阻塞网络 I/O 检查、间隔期间进行的 I/O 检查的总数以及每次网络检查的网络 I/O 的平均数。Adaptive Server 具有两种检查网络 I/O

5、 的方法：阻塞模式和非阻塞模式。 1.4. Disk I/O Checks Total Disk I/O Checks 370.3 21.9 1110778 n/a Checks Returning I/O 186.2 11.0 558474 50.3 % Avg Disk I/Os Returned n/a n/a 0.12350 n/a 此部分报告磁盘 I/O 检查的总数，以及返回 I/O 的检查数量。 = 2. 工作进程管理：Worker Process Management- per sec per xact count % of total - - - - Worker Proces

6、s Requests Total Requests 0.0 0.0 0 n/a Worker Process Usage Total Used 0.0 0.0 0 n/a Max Ever Used During Sample 0.0 0.0 0 n/a Memory Requests for Worker Processes Total Requests 0.0 0.0 0 n/a = 3. 并行查询管理：Parallel Query Management- Parallel Query Usage per sec per xact count % of total - - - - - To

7、tal Parallel Queries 0.0 0.0 0 n/a Merge Lock Requests per sec per xact count % of total - - - - - Total # of Requests 0.0 0.0 0 n/a Sort Buffer Waits per sec per xact count % of total - - - - - Total # of Waits 0.0 0.0 0 n/a = 4. 任务管理：Task ManagementTask Management per sec per xact count % of total

8、- - - - - Connections Opened 0.0 0.0 7 n/a Task Context Switches by Engine Engine 0 45.1 2.7 135404 100.0 % Task Context Switches Due To: Voluntary Yields 9.4 0.6 28097 20.8 % Cache Search Misses 1.0 0.1 2886 2.1 % System Disk Writes 0.1 0.0 294 0.2 % I/O Pacing 7.6 0.5 22843 16.9 % Logical Lock Con

9、tention 1.1 0.1 3432 2.5 % Address Lock Contention 0.7 0.0 2089 1.5 % Latch Contention 0.5 0.0 1448 1.1 % Log Semaphore Contention 1.2 0.1 3745 2.8 % PLC Lock Contention 0.3 0.0 765 0.6 % Group Commit Sleeps 11.2 0.7 33572 24.8 % Last Log Page Writes 3.8 0.2 11497 8.5 % Modify Conflicts 0.6 0.0 1829

10、 1.4 % I/O Device Contention 0.0 0.0 0 0.0 % Network Packet Received 3.4 0.2 10171 7.5 % Network Packet Sent 0.8 0.0 2322 1.7 % Other Causes 3.5 0.2 10414 7.7 % = 5. 应用程序管理：Application Management- Application Statistics Summary (All Applications) - Priority Changes per sec per xact count % of total

11、- - - - - To High Priority 3.8 0.2 11331 38.4 % To Medium Priority 4.9 0.3 14774 50.0 % To Low Priority 1.1 0.1 3436 11.6 % - - - - Total Priority Changes 9.8 0.6 29541 Allotted Slices Exhausted per sec per xact count % of total - - - - - High Priority 0.0 0.0 0 0.0 % Medium Priority 2.4 0.1 7307 10

12、0.0 % Low Priority 0.0 0.0 0 0.0 % - - - - Total Slices Exhausted 2.4 0.1 7307 Skipped Tasks By Engine per sec per xact count % of total - - - - - Total Engine Skips 0.0 0.0 0 n/a Engine Scope Changes 0.0 0.0 7 n/a = 6. ESP管理：ESP ManagementESP Management per sec per xact count % of total- - - - - ES

13、P Requests 0.0 0.0 0 n/a = 7. 管家任务管理：Housekeeper Task Activity- per sec per xact count % of total - - - Buffer Cache Washes Clean 20.0 1.2 60098 98.4 % Dirty 0.3 0.0 1006 1.6 % - - - Total Washes 20.4 1.2 61104 Garbage Collections 0.5 0.0 1366 n/a Pages Processed in GC 0.2 0.0 560 n/a Statistics Upd

14、ates 0.5 0.0 1362 n/a = 8. 对执行SQL的监控访问：Monitor Access to Executing SQL- per sec per xact count % of total - - - - Waits on Execution Plans 0.0 0.0 0 n/a Number of SQL Text Overflows 0.0 0.0 0 n/a Maximum SQL Text Requested n/a n/a 0 n/a (since beginning of sample) = 9. 事务配置文件：Transaction Profile- Tr

15、ansaction Summary per sec per xact count % of total - - - - - Committed Xacts 16.9 n/a 50646 n/a Transaction Detail per sec per xact count % of total - - - - - Inserts APL Heap Table 5.5 0.3 16428 13.0 % APL Clustered Table 21.6 1.3 64712 51.2 % Data Only Lock Table 15.1 0.9 45261 35.8 % - - - - - T

16、otal Rows Inserted 42.1 2.5 126401 57.1 % Updates APL Deferred 0.0 0.0 0 0.0 % APL Direct In-place 0.0 0.0 0 0.0 % APL Direct Cheap 0.0 0.0 0 0.0 % APL Direct Expensive 0.0 0.0 0 0.0 % DOL Deferred 0.0 0.0 0 0.0 % DOL Direct 11.4 0.7 34216 100.0 % - - - - - Total Rows Updated 11.4 0.7 34216 15.5 % D

17、ata Only Locked Updates DOL Replace 5.4 0.3 16278 47.6 % DOL Shrink 0.1 0.0 252 0.7 % DOL Cheap Expand 1.1 0.1 3153 9.2 % DOL Expensive Expand 4.6 0.3 13749 40.2 % DOL Expand & Forward 0.3 0.0 784 2.3 % DOL Fwd Row Returned 0.0 0.0 0 0.0 % - - - - - Total DOL Rows Updated 11.4 0.7 34216 15.5 % Delet

18、es APL Deferred 18.5 1.1 55638 91.7 % APL Direct 0.8 0.0 2529 4.2 % DOL 0.8 0.0 2529 4.2 % - - - - - Total Rows Deleted 20.2 1.2 60696 27.4 % = = = = Total Rows Affected 73.8 4.4 221313 = 10. 事务管理：Transaction Management- ULC Flushes to Xact Log per sec per xact count % of total - - - - - by Full ULC

19、 2.7 0.2 8179 7.6 % by End Transaction 17.7 1.0 52980 49.1 % by Change of Database 0.9 0.1 2558 2.4 % by Single Log Record 9.1 0.5 27195 25.2 % by Unpin 4.3 0.3 13043 12.1 % by Other 1.3 0.1 3884 3.6 % - - - - Total ULC Flushes 35.9 2.1 107839 ULC Log Records 185.4 11.0 556284 n/a Max ULC Size Durin

20、g Sample n/a n/a 2048 n/a ULC Semaphore Requests Granted 375.6 22.2 1126656 99.9 % Waited 0.3 0.0 765 0.1 % - - - - Total ULC Semaphore Req 375.8 22.3 1127421 Log Semaphore Requests Granted 32.0 1.9 95878 96.2 % Waited 1.2 0.1 3745 3.8 % - - - - Total Log Semaphore Req 33.2 2.0 99623 Transaction Log

21、 Writes 14.9 0.9 44766 n/a Transaction Log Alloc 11.0 0.7 33112 n/a Avg # Writes per Log Page n/a n/a 1.35196 n/a Tuning Recommendations for Transaction Management - - Consider decreasing the user log cache size configuration parameter if it is greater than the logical database page size. = 11. 索引管理：Index Management- Nonclustered Maintenance per sec per xact count % of total - - - - - Ins/Upd Requ