|
蓝森林 http://www.lslnet.com 2006年7月08日 11:08
 有谁能帮我分析一下这个sysmon report，系统应该怎样优化？
tru64 unix sybase 12.0
DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role
===============================================================================
Sybase Adaptive Server Enterprise System Performance Report
===============================================================================
Server Version: Adaptive Server Enterprise/12.0.0.1/P/SWR 9270 ESD 3/Dig
Server Name: Server is Unnamed
Run Date: Oct 23, 2004
Statistics Cleared at: 08:55:03
Statistics Sampled at: 09:05:03
Sample Interval: 00:10:00
===============================================================================
Kernel Utilization
------------------
Engine Busy Utilization
Engine 0 92.1 %
Engine 1 99.9 %
----------- --------------- ----------------
Summary Total 191.9 % Average 96.0 %
CPU Yields by Engine per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 0.1 0.2 79 73.1 %
Engine 1 0.0 0.1 29 26.9 %
------------------------- ------------ ------------ ----------
Total CPU Yields 0.2 0.3 108
Network Checks
Non-Blocking 213367.6 352673.7 128020539 100.0 %
Blocking 0.1 0.2 61 0.0 %
------------------------- ------------ ------------ ----------
Total Network I/O Checks 213367.7 352673.8 128020600
Avg Net I/Os per Check n/a n/a 0.00017 n/a
Disk I/O Checks
Total Disk I/O Checks 640184.4 1058156.1 384110663 n/a
Checks Returning I/O 625986.8 1034688.9 375592052 97.8 %
Avg Disk I/Os Returned n/a n/a 0.00076 n/a
===============================================================================
Worker Process Management
-------------------------
per sec per xact count % of total
------------ ------------ ---------- ----------
Worker Process Requests
Requests Granted 0.0 0.0 1 50.0 %
Requests Denied 0.0 0.0 1 50.0 %
-------------------------- ------------ ------------ ----------
Total Requests 0.0 0.0 2
Requests Terminated 0.0 0.0 0 0.0 %
Worker Process Usage
Total Used 0.0 0.1 19 n/a
Max Ever Used During Sample 0.0 0.0 11 n/a
Memory Requests for Worker Processes
Succeeded 0.0 0.1 22 100.0 %
Failed 0.0 0.0 0 0.0 %
-------------------------- ------------ ------------ ----------
Total Requests 0.0 0.1 22
Avg Mem Ever Used by a WP (in bytes) n/a n/a 817.5 n/a
===============================================================================
Parallel Query Management
-------------------------
Parallel Query Usage per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total Parallel Queries 0.0 0.0 1 n/a
WP Adjustments Made
Due to WP Limit 0.0 0.0 0 0.0 %
Due to No WPs 0.0 0.0 1 100.0 %
Merge Lock Requests per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Network Buffer Merge Locks
Granted with no wait 0.0 0.0 0 0.0 %
Granted after wait 0.0 0.0 0 0.0 %
Result Buffer Merge Locks
Granted with no wait 0.0 0.0 0 0.0 %
Granted after wait 0.0 0.0 0 0.0 %
Work Table Merge Locks
Granted with no wait 0.0 0.0 4 100.0 %
Granted after wait 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total # of Requests 0.0 0.0 4
Sort Buffer Waits per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total # of Waits 0.0 0.0 0 n/a
===============================================================================
Task Management per sec per xact count % of total
--------------------------- ------------ ------------ ---------- ----------
Connections Opened 0.2 0.3 105 n/a
Task Context Switches by Engine
Engine 0 9720.8 16067.4 5832471 96.9 %
Engine 1 311.6 515.1 186974 3.1 %
------------------------- ------------ ------------ ----------
Total Task Switches: 10032.4 16582.5 6019445
Task Context Switches Due To:
Voluntary Yields 1.5 2.5 920 0.0 %
Cache Search Misses 331.9 548.7 199168 3.3 %
System Disk Writes 0.2 0.4 145 0.0 %
I/O Pacing 0.5 0.8 297 0.0 %
Logical Lock Contention 0.0 0.0 18 0.0 %
Address Lock Contention 0.0 0.0 0 0.0 %
Latch Contention 0.0 0.0 0 0.0 %
Log Semaphore Contention 0.0 0.0 0 0.0 %
PLC Lock Contention 0.0 0.0 0 0.0 %
Group Commit Sleeps 0.0 0.0 4 0.0 %
Last Log Page Writes 0.7 1.2 447 0.0 %
Modify Conflicts 0.2 0.3 114 0.0 %
I/O Device Contention 3.7 6.1 2228 0.0 %
Network Packet Received 11.1 18.4 6679 0.1 %
Network Packet Sent 25.1 41.5 15069 0.3 %
Other Causes 9657.3 15962.4 5794356 96.3 %
===============================================================================
Application Management
----------------------
Application Statistics Summary (All Applications)
-------------------------------------------------
Priority Changes per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
To High Priority 0.0 0.1 25 4.3 %
To Medium Priority 0.6 1.0 345 58.8 %
To Low Priority 0.4 0.6 217 37.0 %
------------------------- ------------ ------------ ----------
Total Priority Changes 1.0 1.6 587
Allotted Slices Exhausted per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
High Priority 0.0 0.0 0 0.0 %
Medium Priority 0.6 1.0 353 100.0 %
Low Priority 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Slices Exhausted 0.6 1.0 353
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 0 n/a
===============================================================================
ESP Management per sec per xact count % of total
--------------------------- ------------ ------------ ---------- ----------
ESP Requests 0.0 0.0 0 n/a
===============================================================================
Housekeeper Task Activity
-------------------------
per sec per xact count % of total
------------ ------------ ----------
Garbage Collections 0.3 0.6 200 n/a
Pages Processed in GC 0.0 0.0 0 n/a
Statistics Updates 0.3 0.6 200 n/a
===============================================================================
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)
===============================================================================
Transaction Profile
-------------------
Transaction Summary per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Committed Xacts 0.6 n/a 363 n/a
Transaction Detail per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Inserts
APL Heap Table 31.4 51.9 18850 9.0 %
APL Clustered Table 319.3 527.7 191552 91.0 %
Data Only Lock Table 0.1 0.1 30 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Inserted 350.7 579.7 210432 98.8 %
Updates
APL Deferred 0.0 0.0 10 0.8 %
APL Direct In-place 1.1 1.9 687 56.9 %
APL Direct Cheap 0.4 0.6 212 17.5 %
APL Direct Expensive 0.0 0.0 9 0.7 %
DOL Deferred 0.0 0.0 0 0.0 %
DOL Direct 0.5 0.8 290 24.0 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Updated 2.0 3.3 1208 0.6 %
Data Only Locked Updates
DOL Replace 0.5 0.8 290 100.0 %
DOL Shrink 0.0 0.0 0 0.0 %
DOL Cheap Expand 0.0 0.0 0 0.0 %
DOL Expensive Expand 0.0 0.0 0 0.0 %
DOL Expand & Forward 0.0 0.0 0 0.0 %
DOL Fwd Row Returned 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total DOL Rows Updated 0.5 0.8 290 0.1 %
Deletes
APL Deferred 0.5 0.8 285 22.1 %
APL Direct 1.7 2.7 994 76.9 %
DOL 0.0 0.0 13 1.0 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Deleted 2.2 3.6 1292 0.6 %
========================= ============ ============ ==========
Total Rows Affected 354.9 586.6 212932
===============================================================================
Transaction Management
----------------------
ULC Flushes to Xact Log per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
by Full ULC 0.3 0.5 193 15.6 %
by End Transaction 0.5 0.9 318 25.7 %
by Change of Database 0.0 0.0 14 1.1 %
by System Log Record 0.3 0.5 186 15.0 %
by Other 0.9 1.4 526 42.5 %
------------------------- ------------ ------------ ----------
Total ULC Flushes 2.1 3.4 1237
ULC Log Records 16.9 27.9 10119 n/a
Max ULC Size During Sample n/a n/a 4096 n/a
ULC Semaphore Requests
Granted 35.6 58.8 21340 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total ULC Semaphore Req 35.6 58.8 21340
Log Semaphore Requests
Granted 2.2 3.6 1311 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Log Semaphore Req 2.2 3.6 1311
Transaction Log Writes 1.6 2.6 939 n/a
Transaction Log Alloc 0.8 1.3 485 n/a
Avg # Writes per Log Page n/a n/a 1.93608 n/a
===============================================================================
Index Management
----------------
Nonclustered Maintenance per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Ins/Upd Requiring Maint 3.6 6.0 2161 n/a
# of NC Ndx Maint 3.5 5.8 2097 n/a
Avg NC Ndx Maint / Op n/a n/a 0.97038 n/a
Deletes Requiring Maint 3.2 5.2 1900 n/a
# of NC Ndx Maint 2.7 4.5 1620 n/a
Avg NC Ndx Maint / Op n/a n/a 0.85263 n/a
RID Upd from Clust Split 0.0 0.0 0 n/a
# of NC Ndx Maint 0.0 0.0 0 n/a
Upd/Del DOL Req Maint 0.5 0.8 303 n/a
# of DOL Ndx Maint 0.0 0.0 13 n/a
Avg DOL Ndx Maint / Op n/a n/a 0.04290 n/a
Page Splits 0.2 0.4 138 n/a
Retries 0.0 0.0 0 0.0 %
Deadlocks 0.0 0.0 0 0.0 %
Add Index Level 0.0 0.0 0 0.0 %
Page Shrinks 0.0 0.1 20 n/a
Index Scans per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Ascending Scans 1965.8 3249.2 1179450 61.7 %
DOL Ascending Scans 1221.5 2019.0 732895 38.3 %
Descending Scans 0.1 0.2 61 0.0 %
DOL Descending Scans 0.0 0.0 0 0.0 %
------------ ------------ ----------
Total Scans 3187.3 5268.3 1912406
===============================================================================
Metadata Cache Management
-------------------------
Metadata Cache Summary per sec per xact count % of total
------------------------ ------------ ------------ ---------- ----------
Open Object Usage
Active 0.5 0.8 303 n/a
Max Ever Used Since Boot 0.5 0.8 304 n/a
Free 0.3 0.5 197 n/a
Reuse Requests
Succeeded 0.0 0.0 0 n/a
Failed 0.0 0.0 0 n/a
Open Index Usage
Active 0.8 1.4 499 n/a
Max Ever Used Since Boot 0.8 1.4 500 n/a
Free 0.0 0.0 1 n/a
Reuse Requests
Succeeded 0.0 0.0 0 n/a
Failed 0.0 0.0 0 n/a
Open Database Usage
Active 0.0 0.0 7 n/a
Max Ever Used Since Boot 0.0 0.0 7 n/a
Free 0.0 0.0 5 n/a
Reuse Requests
Succeeded 0.0 0.0 0 n/a
Failed 0.0 0.0 0 n/a
Object Spinlock Contention n/a n/a n/a 0.0 %
Index Spinlock Contention n/a n/a n/a 0.0 %
Hash Spinlock Contention n/a n/a n/a 0.0 %
===============================================================================
Lock Management
---------------
Lock Summary per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total Lock Requests 11357.4 18772.6 6814453 n/a
Avg Lock Contention 0.0 0.0 18 0.0 %
Deadlock Percentage 0.0 0.0 0 0.0 %
Lock Hashtable Lookups 11369.3 18792.2 6821557 n/a
Avg Hash Chain Length n/a n/a 0.00258 n/a
Lock Detail per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Exclusive Table
Granted 0.3 0.5 186 99.5 %
Waited 0.0 0.0 1 0.5 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Table Requests 0.3 0.5 187 0.0 %
Shared Table
Granted 0.0 0.0 14 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Table Requests 0.0 0.0 14 0.0 %
Exclusive Intent
Granted 0.9 1.4 524 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Intent Requests 0.9 1.4 524 0.0 %
Shared Intent
Granted 34.9 57.7 20954 100.0 %
Waited 0.0 0.0 4 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Intent Requests 34.9 57.7 20958 0.3 %
Exclusive Page
Granted 2.9 4.8 1756 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Page Requests 2.9 4.8 1756 0.0 %
Update Page
Granted 356.8 589.8 214085 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total UP-Page Requests 356.8 589.8 214085 3.1 %
Shared Page
Granted 5858.2 9682.9 3514908 100.0 %
Waited 0.0 0.0 3 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Page Requests 5858.2 9683.0 3514911 51.6 %
Exclusive Row
Granted 0.5 0.8 307 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Row Requests 0.5 0.8 307 0.0 %
Update Row
Granted 0.0 0.0 13 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total UP-Row Requests 0.0 0.0 13 0.0 %
Shared Row
Granted 100.9 166.7 60518 100.0 %
Waited 0.0 0.0 10 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Row Requests 100.9 166.7 60528 0.9 %
Next-Key
Total Next-Key Requests 0.0 0.0 0 n/a
Exclusive Address
Granted 20.2 33.4 12138 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Address Requests 20.2 33.4 12138 0.2 %
Shared Address
Granted 4981.7 8234.2 2989032 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Address Requests 4981.7 8234.2 2989032 43.9 %
Last Page Locks on Heaps
Granted 31.4 51.9 18850 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total Last Pg Locks 31.4 51.9 18850 100.0 %
Deadlocks by Lock Type per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total Deadlocks 0.0 0.0 0 n/a
Deadlock Detection
Deadlock Searches 0.0 0.0 6 n/a
Searches Skipped 0.0 0.0 0 0.0 %
Avg Deadlocks per Search n/a n/a 0.00000 n/a
Lock Promotions
Total Lock Promotions 0.0 0.0 0 n/a
Lock Timeouts by Lock Type per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total Timeouts 0.0 0.0 0 n/a
===============================================================================
Data Cache Management
---------------------
Cache Statistics Summary (All Caches)
-------------------------------------
per sec per xact count % of total
------------ ------------ ---------- ----------
Cache Search Summary
Total Cache Hits 12607.1 20838.2 7564261 96.3 %
Total Cache Misses 484.8 801.3 290854 3.7 %
------------------------- ------------ ------------ ----------
Total Cache Searches 13091.9 21639.4 7855115
Cache Turnover
Buffers Grabbed 473.6 782.9 284186 n/a
Buffers Grabbed Dirty 0.0 0.0 0 0.0 %
Cache Strategy Summary
Cached (LRU) Buffers 12925.1 21363.8 7755045 99.8 %
Discarded (MRU) Buffers 28.3 46.8 16977 0.2 %
Large I/O Usage
0.0 0.0 0 n/a
Large I/O Effectiveness
Pages by Lrg I/O Cached 0.0 0.0 0 n/a
Asynchronous Prefetch Activity
APFs Issued 129.5 214.0 77672 23.3 %
APFs Denied Due To
APF I/O Overloads 3.9 6.5 2349 0.7 %
APF Limit Overloads 0.0 0.0 0 0.0 %
APF Reused Overloads 7.2 11.9 4332 1.3 %
APF Buffers Found in Cache
With Spinlock Held 0.1 0.1 48 0.0 %
W/o Spinlock Held 415.2 686.3 249126 74.7 %
------------------------- ------------ ------------ ----------
Total APFs Requested 555.9 918.8 333527
Other Asynchronous Prefetch Statistics
APFs Used 121.4 200.7 72856 n/a
APF Waits for I/O 77.0 127.2 46170 n/a
APF Discards 0.0 0.0 0 n/a
Dirty Read Behavior
Page Requests 0.0 0.0 0 n/a
-------------------------------------------------------------------------------
Cache: default data cache
per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Spinlock Contention n/a n/a n/a 2.0 %
Utilization n/a n/a n/a 100.0 %
Cache Searches
Cache Hits 12607.1 20838.2 7564261 96.3 %
Found in Wash 10.3 17.0 6162 0.1 %
Cache Misses 484.8 801.3 290854 3.7 %
------------------------- ------------ ------------ ----------
Total Cache Searches 13091.9 21639.4 7855115
Pool Turnover
2 Kb Pool
LRU Buffer Grab 473.6 782.9 284186 100.0 %
Grabbed Dirty 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Cache Turnover 473.6 782.9 284186
Buffer Wash Behavior
Buffers Passed Clean 474.5 784.2 284671 98.1 %
Buffers Already in I/O 0.0 0.0 1 0.0 %
Buffers Washed Dirty 9.0 14.8 5371 1.9 %
Cache Strategy
Cached (LRU) Buffers 12925.1 21363.8 7755045 99.8 %
Discarded (MRU) Buffers 28.3 46.8 16977 0.2 %
Large I/O Usage
Total Large I/O Requests 0.0 0.0 0 n/a
Large I/O Detail
No Large Pool(s) In This Cache
Dirty Read Behavior
Page Requests 0.0 0.0 0 n/a
===============================================================================
Procedure Cache Management per sec per xact count % of total
--------------------------- ------------ ------------ ---------- ----------
Procedure Requests 0.2 0.4 141 n/a
Procedure Reads from Disk 0.0 0.0 0 0.0 %
Procedure Writes to Disk 0.0 0.0 0 0.0 %
Procedure Removals 0.0 0.0 0 n/a
===============================================================================
Memory Management per sec per xact count % of total
--------------------------- ------------ ------------ ---------- ----------
Pages Allocated 0.1 0.1 53 n/a
Pages Released 0.1 0.2 55 n/a
===============================================================================
Recovery Management
-------------------
Checkpoints per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
# of Normal Checkpoints 0.0 0.0 8 100.0 %
# of Free Checkpoints 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Checkpoints 0.0 0.0 8
Avg Time per Normal Chkpt 0.00000 seconds
===============================================================================
Disk I/O Management
-------------------
Max Outstanding I/Os per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Server n/a n/a 254 n/a
Engine 0 n/a n/a 220 n/a
Engine 1 n/a n/a 217 n/a
I/Os Delayed by
Disk I/O Structures n/a n/a 0 n/a
Server Config Limit n/a n/a 0 n/a
Engine Config Limit n/a n/a 0 n/a
Operating System Limit n/a n/a 0 n/a
Total Requested Disk I/Os 476.7 787.9 285997
Completed Disk I/O's
Engine 0 198.0 327.3 118799 41.9 %
Engine 1 274.8 454.2 164867 58.1 %
------------------------- ------------ ------------ ----------
Total Completed I/Os 472.8 781.4 283666
Device Activity Detail
----------------------
Device:
/dev/rrz80d
sysprocsdev per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 1 100.0 %
Writes 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 1 0.0 %
Device Semaphore Granted 0.0 0.0 1 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/rrz80e
tempdbdev1 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.1 0.1 45 5.5 %
Writes 1.3 2.1 772 94.5 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 1.4 2.3 817 0.3 %
Device Semaphore Granted 1.4 2.2 815 99.5 %
Device Semaphore Waited 0.0 0.0 4 0.5 %
-----------------------------------------------------------------------------
Device:
/dev/rrz80f
ytposdblog1 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/rrz80g
lspsdblog1 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 2 0.3 %
Writes 1.3 2.1 769 99.7 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 1.3 2.1 771 0.3 %
Device Semaphore Granted 1.3 2.1 771 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/rrzb80b
lspsdbdev1 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 74.3 122.8 44585 68.4 %
Non-APF 33.3 55.1 20005 30.7 %
Writes 1.0 1.6 572 0.9 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 108.6 179.5 65162 23.0 %
Device Semaphore Granted 108.6 179.5 65147 99.9 %
Device Semaphore Waited 0.1 0.1 44 0.1 %
-----------------------------------------------------------------------------
Device:
/dev/rrzb80d
lspsdbdev2 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 4.5 7.4 2676 36.5 %
Non-APF 0.6 1.1 384 5.2 %
Writes 7.1 11.8 4279 58.3 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 12.2 20.2 7339 2.6 %
Device Semaphore Granted 12.2 20.2 7339 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/rrzb80e
lspsdbdev3 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 3.9 6.4 2321 78.6 %
Non-APF 1.0 1.6 594 20.1 %
Writes 0.1 0.1 39 1.3 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 4.9 8.1 2954 1.0 %
Device Semaphore Granted 4.9 8.1 2954 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/rrzb80f
lspsdbdev4 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 3.5 5.8 2103 76.0 %
Non-APF 0.9 1.4 511 18.5 %
Writes 0.3 0.4 154 5.6 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 4.6 7.6 2768 1.0 %
Device Semaphore Granted 4.6 7.6 2768 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/rrzb80g
lspsdev1 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 5.8 9.5 3453 7.5 %
Non-APF 70.8 117.0 42479 92.5 %
Writes 0.0 0.0 2 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 76.6 126.5 45934 16.2 %
Device Semaphore Granted 76.5 126.4 45887 98.8 %
Device Semaphore Waited 0.9 1.6 567 1.2 %
-----------------------------------------------------------------------------
Device:
/dev/rrzc80b
ytposdbdev1 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/rrzc80d
ytposdbdev2 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/rrzc80e
lspsdbdev5 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 4.0 6.6 2384 67.8 %
Non-APF 1.7 2.8 1021 29.1 %
Writes 0.2 0.3 109 3.1 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 5.9 9.7 3514 1.2 %
Device Semaphore Granted 5.9 9.7 3514 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/rrzc80f
lspsdev2 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 14.1 23.4 8482 13.2 %
Non-APF 92.6 153.0 55532 86.7 %
Writes 0.0 0.0 4 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 106.7 176.4 64018 22.6 %
Device Semaphore Granted 106.6 176.2 63969 99.2 %
Device Semaphore Waited 0.9 1.4 516 0.8 %
-----------------------------------------------------------------------------
Device:
/dev/rrzc80g
lspsdev3 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 14.7 24.3 8823 14.0 %
Non-APF 90.5 149.6 54311 86.0 %
Writes 0.0 0.0 3 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 105.2 173.9 63137 22.3 %
Device Semaphore Granted 105.1 173.8 63080 99.2 %
Device Semaphore Waited 0.8 1.4 500 0.8 %
-----------------------------------------------------------------------------
Device:
/dev/rrzd80d
lspsdev4 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 1.9 3.1 1143 12.9 %
Non-APF 12.8 21.2 7695 87.0 %
Writes 0.0 0.0 4 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 14.7 24.4 8842 3.1 %
Device Semaphore Granted 14.7 24.4 8840 100.0 %
Device Semaphore Waited 0.0 0.0 2 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/rrzd80e
lspsdev5 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 2.8 4.7 1702 9.3 %
Non-APF 27.6 45.6 16555 90.7 %
Writes 0.0 0.0 2 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 30.4 50.3 18259 6.4 %
Device Semaphore Granted 30.4 50.3 18251 96.8 %
Device Semaphore Waited 1.0 1.6 595 3.2 %
-----------------------------------------------------------------------------
Device:
d_master
master per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.1 0.1 33 25.2 %
Writes 0.2 0.3 98 74.8 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.2 0.4 131 0.0 %
Device Semaphore Granted 0.2 0.4 131 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
===============================================================================
Network I/O Management
----------------------
Total Network I/O Requests 35.3 58.3 21167 n/a
Network I/Os Delayed 0.0 0.0 0 0.0 %
Total TDS Packets Received per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 6.9 11.4 4147 62.1 %
Engine 1 4.2 7.0 2532 37.9 %
------------------------- ------------ ------------ ----------
Total TDS Packets Rec'd 11.1 18.4 6679
Total Bytes Received per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 1109.4 1833.7 665627 63.0 %
Engine 1 652.6 1078.6 391543 37.0 %
------------------------- ------------ ------------ ----------
Total Bytes Rec'd 1762.0 2912.3 1057170
Avg Bytes Rec'd per Packet n/a n/a 158 n/a
-----------------------------------------------------------------------------
Total TDS Packets Sent per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 13.5 22.3 8103 53.8 %
Engine 1 11.6 19.2 6966 46.2 %
------------------------- ------------ ------------ ----------
Total TDS Packets Sent 25.1 41.5 15069
Total Bytes Sent per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 3946.9 6523.8 2368130 49.6 %
Engine 1 4007.1 6623.4 2404285 50.4 %
------------------------- ------------ ------------ ----------
Total Bytes Sent 7954.0 13147.1 4772415
Avg Bytes Sent per Packet n/a n/a 316 n/a
=============================== End of Report ================================= |
有谁能帮我分析一下这个sysmon report，系统应该怎样优化？
开一个large i/O先看看，另最好能使用并行，数据库设备是建立在文件系统上还是裸设备上？ |
有谁能帮我分析一下这个sysmon report，系统应该怎样优化？
10170f正解。
采样期间是大量插入，什么操作。对文件系统（rawor fs）进行调整得到的回报可能更大 |
有谁能帮我分析一下这个sysmon report，系统应该怎样优化？
大概看了一下,你的数据库的问题可能是CPU数量太少,建议增加CPU
第二、并发性有问题，需要增加number of worker processes
其他的没有仔细看 |
| |
