- 论坛徽章:
- 0
|
下面是sybase10分钟的报告,平台hp9000,sybase12.5.2,请大家帮忙分析一下
===============================================================================
Sybase Adaptive Server Enterprise System Performance Report
===============================================================================
Server Version: Adaptive Server Enterprise/12.5.2/EBF 11795/P/HP9000-879
Server Name: pjyyb
Run Date: Aug 04, 2005
Statistics Cleared at: Aug 04, 2005 14:47:57
Statistics Sampled at: Aug 04, 2005 14:57:57
Sample Interval: 00:10:00
===============================================================================
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 6.9 % 0.0 % 93.1 %
Engine 1 5.4 % 0.0 % 94.6 %
Engine 2 15.7 % 0.0 % 84.3 %
Engine 3 9.0 % 0.0 % 91.0 %
------------------------ -------- -------- --------
Summary Total 37.1 % 0.0 % 362.9 %
Average 9.3 % 0.0 % 90.7 %
CPU Yields by Engine per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 49.0 177.2 29409 26.4 %
Engine 1 46.9 169.4 28113 25.2 %
Engine 2 43.4 156.8 26021 23.4 %
Engine 3 46.5 167.9 27874 25.0 %
------------------------- ------------ ------------ ----------
Total CPU Yields 185.7 671.2 111417
Network Checks
Non-Blocking 22158.6 80091.3 13295155 99.2 %
Blocking 185.7 671.2 111417 0.8 %
------------------------- ------------ ------------ ----------
Total Network I/O Checks 22344.3 80762.5 13406572
Avg Net I/Os per Check n/a n/a 0.00460 n/a
Disk I/O Checks
Total Disk I/O Checks 22403.9 80977.8 13442314 n/a
Checks Returning I/O 0.0 0.0 0 0.0 %
===============================================================================
Worker Process Management
-------------------------
per sec per xact count % of total
------------ ------------ ---------- ----------
Worker Process 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
===============================================================================
Parallel Query Management
-------------------------
Parallel Query Usage per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total 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
===============================================================================
Task Management per sec per xact count % of total
--------------------------- ------------ ------------ ---------- ----------
Connections Opened 0.0 0.1 12 n/a
Task Context Switches by Engine
Engine 0 15.1 54.6 9056 20.2 %
Engine 1 17.3 62.5 10374 23.1 %
Engine 2 25.9 93.8 15563 34.7 %
Engine 3 16.5 59.5 9872 22.0 %
------------------------- ------------ ------------ ----------
Total Task Switches: 74.8 270.3 44865
Task Context Switches Due To:
Voluntary Yields 2.6 9.4 1554 3.5 %
Cache Search Misses 0.1 0.3 58 0.1 %
System Disk Writes 0.3 1.0 163 0.4 %
I/O Pacing 2.4 8.7 1446 3.2 %
Logical Lock Contention 0.0 0.0 0 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.3 1.1 177 0.4 %
Modify Conflicts 0.0 0.0 1 0.0 %
I/O Device Contention 0.0 0.0 0 0.0 %
Network Packet Received 11.7 42.2 7001 15.6 %
Network Packet Sent 19.3 69.8 11591 25.8 %
Other Causes 38.1 137.8 22870 51.0 %
===============================================================================
Application Management
----------------------
Application Statistics Summary (All Applications)
-------------------------------------------------
Priority Changes per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
To High Priority 0.0 0.0 0 0.0 %
To Medium Priority 5.1 18.4 3048 50.1 %
To Low Priority 5.1 18.3 3036 49.9 %
------------------------- ------------ ------------ ----------
Total Priority Changes 10.1 36.7 6084
Allotted Slices Exhausted per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
High Priority 0.0 0.0 0 0.0 %
Medium Priority 0.4 1.3 219 100.0 %
Low Priority 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Slices Exhausted 0.4 1.3 219
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
------------ ------------ ----------
Buffer Cache Washes
Clean 104.7 378.3 62790 83.8 %
Dirty 20.3 73.2 12154 16.2 %
------------ ------------ ----------
Total Washes 124.9 451.5 74944
Garbage Collections 0.8 2.9 476 n/a
Pages Processed in GC 0.0 0.0 0 n/a
Statistics Updates 0.2 0.7 124 n/a
Tuning Recommendations for Housekeeper
--------------------------------------
- Consider increasing the 'housekeeper free write percent'
configuration parameter.
===============================================================================
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.3 n/a 166 n/a
Transaction Detail per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Inserts
APL Heap Table 845.1 3054.7 507077 99.9 %
APL Clustered Table 1.1 4.1 673 0.1 %
Data Only Lock Table 0.0 0.1 14 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Inserted 846.3 3058.8 507764 100.0 %
Updates
APL Deferred 0.0 0.0 0 0.0 %
APL Direct In-place 0.1 0.2 31 47.0 %
APL Direct Cheap 0.1 0.2 34 51.5 %
APL Direct Expensive 0.0 0.0 1 1.5 %
DOL Deferred 0.0 0.0 0 0.0 %
DOL Direct 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Updated 0.1 0.4 66 0.0 %
Data Only Locked Updates
Total Rows Updated 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total DOL Rows Updated 0.0 0.0 0 0.0 %
Deletes
APL Deferred 0.2 0.9 144 83.2 %
APL Direct 0.0 0.1 15 8.7 %
DOL 0.0 0.1 14 8.1 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Deleted 0.3 1.0 173 0.0 %
========================= ============ ============ ==========
Total Rows Affected 846.7 3060.3 508003
===============================================================================
Transaction Management
----------------------
ULC Flushes to Xact Log per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
by Full ULC 0.0 0.0 3 0.1 %
by End Transaction 0.3 1.2 200 7.7 %
by Change of Database 0.0 0.1 20 0.8 %
by Single Log Record 3.8 13.6 2265 87.5 %
by Unpin 0.0 0.2 29 1.1 %
by Other 0.1 0.4 71 2.7 %
------------------------- ------------ ------------ ----------
Total ULC Flushes 4.3 15.6 2588
ULC Log Records 8.8 31.9 5302 n/a
Max ULC Size During Sample n/a n/a 2032 n/a
ULC Semaphore Requests
Granted 12.3 44.6 7405 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total ULC Semaphore Req 12.3 44.6 7405
Log Semaphore Requests
Granted 4.5 16.1 2675 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Log Semaphore Req 4.5 16.1 2675
Transaction Log Writes 0.5 1.8 295 n/a
Transaction Log Alloc 0.3 1.1 190 n/a
Avg # Writes per Log Page n/a n/a 1.55263 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.
===============================================================================
Index Management
----------------
Nonclustered Maintenance per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Ins/Upd Requiring Maint 0.1 0.3 43 n/a
# of NC Ndx Maint 0.0 0.1 15 n/a
Avg NC Ndx Maint / Op n/a n/a 0.34884 n/a
Deletes Requiring Maint 0.1 0.3 42 n/a
# of NC Ndx Maint 0.0 0.1 14 n/a
Avg NC Ndx Maint / Op n/a n/a 0.33333 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.0 0.1 14 n/a
# of DOL Ndx Maint 0.0 0.1 14 n/a
Avg DOL Ndx Maint / Op n/a n/a 1.00000 n/a
Page Splits 0.0 0.0 0 n/a
Page Shrinks 0.0 0.0 0 n/a
Index Scans per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Ascending Scans 577.6 2087.7 346550 97.1 %
DOL Ascending Scans 17.3 62.5 10380 2.9 %
Descending Scans 0.1 0.4 74 0.0 %
DOL Descending Scans 0.0 0.0 0 0.0 %
------------ ------------ ----------
Total Scans 595.0 2150.6 357004
===============================================================================
Metadata Cache Management
-------------------------
Metadata Cache Summary per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Open Object Usage
Active n/a n/a 376 n/a
Max Ever Used Since Boot n/a n/a 376 n/a
Free n/a n/a 10000 n/a
Reuse Requests
Succeeded n/a n/a 0 n/a
Failed n/a n/a 0 n/a
Open Index Usage
Active n/a n/a 399 n/a
Max Ever Used Since Boot n/a n/a 399 n/a
Free n/a n/a 10000 n/a
Reuse Requests
Succeeded n/a n/a 0 n/a
Failed n/a n/a 0 n/a
Open Database Usage
Active n/a n/a 8 n/a
Max Ever Used Since Boot n/a n/a 8 n/a
Free n/a n/a 12 n/a
Reuse Requests
Succeeded n/a n/a 0 n/a
Failed n/a n/a 0 n/a
Object Manager Spinlock Contention n/a n/a n/a 0.0 %
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 1989.5 7191.1 1193721 n/a
Avg Lock Contention 0.0 0.0 0 0.0 %
Deadlock Percentage 0.0 0.0 0 0.0 %
Lock Detail per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Table Lock Hashtable
Lookups 53.3 192.5 31956 n/a
Avg Chain Length n/a n/a 0.01170 n/a
Spinlock Contention n/a n/a n/a 0.0 %
Exclusive Table
Granted 0.4 1.3 210 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Table Requests 0.4 1.3 210 0.0 %
Shared Table
Granted 0.0 0.1 14 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Table Requests 0.0 0.1 14 0.0 %
Exclusive Intent
Granted 0.3 1.0 170 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Intent Requests 0.3 1.0 170 0.0 %
Shared Intent
Granted 52.6 190.0 31534 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Intent Requests 52.6 190.0 31534 2.6 %
Page & Row Lock HashTable
Lookups 1105.6 3996.1 663352 n/a
Avg Chain Length n/a n/a 0.00058 n/a
Spinlock Contention n/a n/a n/a 0.0 %
Exclusive Page
Granted 0.3 1.3 209 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Page Requests 0.3 1.3 209 0.0 %
Update Page
Granted 0.2 0.8 136 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total UP-Page Requests 0.2 0.8 136 0.0 %
Shared Page
Granted 1082.8 3913.9 649701 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Page Requests 1082.8 3913.9 649701 54.4 %
Exclusive Row
Granted 0.1 0.4 66 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Row Requests 0.1 0.4 66 0.0 %
Update Row
Granted 0.0 0.1 14 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total UP-Row Requests 0.0 0.1 14 0.0 %
Shared Row
Granted 21.4 77.2 12818 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Row Requests 21.4 77.2 12818 1.1 %
Next-Key
Total Next-Key Requests 0.0 0.0 0 n/a
Address Lock Hashtable
Lookups 831.4 3005.1 498849 n/a
Avg Chain Length n/a n/a 0.00000 n/a
Spinlock Contention n/a n/a n/a 0.0 %
Exclusive Address
Granted 0.4 1.5 245 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Address Requests 0.4 1.5 245 0.0 %
Shared Address
Granted 831.0 3003.6 498604 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Address Requests 831.0 3003.6 498604 41.8 %
Last Page Locks on Heaps
Granted 845.1 3054.7 507077 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total Last Pg Locks 845.1 3054.7 507077 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 0 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 6133.2 22168.4 3679949 98.8 %
Total Cache Misses 73.0 263.8 43784 1.2 %
------------------------- ------------ ------------ ----------
Total Cache Searches 6206.2 22432.1 3723733
Cache Turnover
Buffers Grabbed 10.4 37.4 6210 n/a
Buffers Grabbed Dirty 0.0 0.0 0 0.0 %
Cache Strategy Summary
Cached (LRU) Buffers 6248.2 22583.9 3748927 100.0 %
Discarded (MRU) Buffers 0.0 0.1 9 0.0 %
Large I/O Usage
Large I/Os Performed 10.1 36.5 6059 99.2 %
Large I/Os Denied due to
Pool < Prefetch Size 0.1 0.3 47 0.8 %
------------------------- ------------ ------------ ----------
Total Large I/O Requests 10.2 36.8 6106
Large I/O Effectiveness
Pages by Lrg I/O Cached 79.9 288.6 47914 n/a
Pages by Lrg I/O Used 6.4 23.0 3816 8.0 %
Asynchronous Prefetch Activity
APFs Issued 0.8 2.9 480 5.7 %
APFs Denied Due To
APF I/O Overloads 0.0 0.0 0 0.0 %
APF Limit Overloads 0.0 0.0 0 0.0 %
APF Reused Overloads 0.0 0.0 0 0.0 %
APF Buffers Found in Cache
With Spinlock Held 0.0 0.0 0 0.0 %
W/o Spinlock Held 13.2 47.6 7900 94.3 %
------------------------- ------------ ------------ ----------
Total APFs Requested 14.0 50.5 8380
Other Asynchronous Prefetch Statistics
APFs Used 0.9 3.1 520 n/a
APF Waits for I/O 0.6 2.3 381 n/a
APF Discards 0.0 0.0 0 n/a
Dirty Read Behavior
Page Requests 0.0 0.0 0 n/a
-------------------------------------------------------------------------------
Cache: data_cache
per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Spinlock Contention n/a n/a n/a 0.0 %
Utilization n/a n/a n/a 22.1 %
Cache Searches
Cache Hits 1370.5 4953.4 822270 100.0 %
Found in Wash 85.0 307.1 50973 6.2 %
Cache Misses 0.1 0.3 58 0.0 %
------------------------- ------------ ------------ ----------
Total Cache Searches 1370.5 4953.8 822328
Pool Turnover
2 Kb Pool
LRU Buffer Grab 0.1 0.4 61 11.2 %
Grabbed Dirty 0.0 0.0 0 0.0 %
4 Kb Pool
LRU Buffer Grab 0.0 0.0 8 1.5 %
Grabbed Dirty 0.0 0.0 0 0.0 %
16 Kb Pool & |
|
免费注册
发表于 2005-08-04 15:51
