- 论坛徽章:
- 0
|
1> sp_sysmon "00:10:00"
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.5/SWR 9610 GA/P/Sun_svr4/O
Server Name: SYBASE
Run Date: Jan 14, 2011
Statistics Cleared at: 14:22:04
Statistics Sampled at: 14:32:04
Sample Interval: 00:10:00
===============================================================================
Kernel Utilization
------------------
Engine Busy Utilization
Engine 0 2.8 %
Engine 1 0.8 %
Engine 2 1.1 %
Engine 3 0.3 %
Engine 4 1.2 %
Engine 5 2.8 %
Engine 6 2.2 %
----------- --------------- ----------------
Summary Total 11.3 % Average 1.6 %
CPU Yields by Engine per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 14.7 16.9 8815 14.1 %
Engine 1 15.1 17.3 9072 14.6 %
Engine 2 15.0 17.2 8989 14.4 %
Engine 3 15.1 17.4 9081 14.6 %
Engine 4 15.0 17.2 9015 14.5 %
Engine 5 14.2 16.3 8529 13.7 %
Engine 6 14.7 16.9 8822 14.2 %
------------------------- ------------ ------------ ----------
Total CPU Yields 103.9 119.2 62323
Network Checks
Non-Blocking 13371.9 15340.7 8023164 99.8 %
Blocking 29.9 34.3 17918 0.2 %
------------------------- ------------ ------------ ----------
Total Network I/O Checks 13401.8 15374.9 8041082
Avg Net I/Os per Check n/a n/a 0.00546 n/a
Disk I/O Checks
Total Disk I/O Checks 67069.8 76944.3 40241856 n/a
Checks Returning I/O 1919.9 2202.6 1151959 2.9 %
Avg Disk I/Os Returned n/a n/a 0.00958 n/a
===============================================================================
Worker Process Management
-------------------------
per sec per xact count % of total
------------ ------------ ---------- ----------
Worker Process Requests
Requests Granted 2.5 2.9 1498 100.0 %
Requests Denied 0.0 0.0 0 0.0 %
-------------------------- ------------ ------------ ----------
Total Requests 2.5 2.9 1498
Requests Terminated 0.0 0.0 0 0.0 %
Worker Process Usage
Total Used 22.5 25.8 13482 n/a
Max Ever Used During Sample 1.9 2.1 1116 n/a
Memory Requests for Worker Processes
Succeeded 232.4 266.6 139425 100.0 %
Failed 0.0 0.0 0 0.0 %
-------------------------- ------------ ------------ ----------
Total Requests 232.4 266.6 139425
Avg Mem Ever Used by a WP (in bytes) n/a n/a 77.3 n/a
===============================================================================
Parallel Query Management
-------------------------
Parallel Query Usage per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total Parallel Queries 2.5 2.9 1498 n/a
WP Adjustments Made
Due to WP Limit 0.0 0.0 0 0.0 %
Due to No WPs 0.0 0.0 0 0.0 %
Merge Lock Requests per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Network Buffer Merge Locks
Granted with no wait 4.8 5.5 2878 81.8 %
Granted after wait 0.2 0.2 101 2.9 %
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.9 1.0 520 14.8 %
Granted after wait 0.0 0.0 21 0.6 %
------------------------- ------------ ------------ ----------
Total # of Requests 5.9 6.7 3520
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.1 0.1 32 n/a
Task Context Switches by Engine
Engine 0 25.2 28.9 15136 12.2 %
Engine 1 16.3 18.7 9800 7.9 %
Engine 2 24.0 27.5 14373 11.6 %
Engine 3 23.9 27.5 14369 11.6 %
Engine 4 12.5 14.4 7506 6.0 %
Engine 5 71.9 82.5 43161 34.8 %
Engine 6 32.9 37.8 19760 15.9 %
------------------------- ------------ ------------ ----------
Total Task Switches: 206.8 237.3 124105
Task Context Switches Due To:
Voluntary Yields 11.2 12.8 6691 5.4 %
Cache Search Misses 0.1 0.1 50 0.0 %
System Disk Writes 2.7 3.1 1599 1.3 %
I/O Pacing 3.5 4.0 2077 1.7 %
Logical Lock Contention 0.0 0.0 15 0.0 %
Address Lock Contention 0.2 0.2 122 0.1 %
Latch Contention 0.0 0.0 0 0.0 %
Log Semaphore Contention 0.0 0.0 2 0.0 %
PLC Lock Contention 0.0 0.0 0 0.0 %
Group Commit Sleeps 0.0 0.0 12 0.0 %
Last Log Page Writes 3.2 3.7 1921 1.5 %
Modify Conflicts 0.5 0.6 308 0.2 %
I/O Device Contention 0.0 0.0 0 0.0 %
Network Packet Received 30.9 35.5 18562 15.0 %
Network Packet Sent 42.2 48.4 25309 20.4 %
Other Causes 112.4 128.9 67437 54.3 %
===============================================================================
Application Management
----------------------
Application Statistics Summary (All Applications)
-------------------------------------------------
Priority Changes per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
To High Priority 0.2 0.3 143 18.5 %
To Medium Priority 0.7 0.8 403 52.1 %
To Low Priority 0.4 0.4 228 29.5 %
------------------------- ------------ ------------ ----------
Total Priority Changes 1.3 1.5 774
Allotted Slices Exhausted per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
High Priority 0.0 0.0 1 0.5 %
Medium Priority 0.3 0.4 186 99.5 %
Low Priority 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Slices Exhausted 0.3 0.4 187
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 11.9 13.7 7140 87.8 %
Dirty 1.7 1.9 990 12.2 %
------------ ------------ ----------
Total Washes 13.6 15.5 8130
Garbage Collections 1.3 1.5 809 n/a
Pages Processed in GC 0.0 0.0 0 n/a
Statistics Updates 1.3 1.5 809 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.9 n/a 523 n/a
Transaction Detail per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Inserts
APL Heap Table 70.9 81.3 42535 59.9 %
APL Clustered Table 47.3 54.3 28389 40.0 %
Data Only Lock Table 0.2 0.2 105 0.1 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Inserted 118.4 135.8 71029 70.1 %
Updates
APL Deferred 0.2 0.3 132 0.7 %
APL Direct In-place 25.9 29.7 15521 81.1 %
APL Direct Cheap 5.8 6.7 3487 18.2 %
APL Direct Expensive 0.0 0.0 0 0.0 %
DOL Deferred 0.0 0.0 0 0.0 %
DOL Direct 0.0 0.0 6 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Updated 31.9 36.6 19146 18.9 %
Data Only Locked Updates
DOL Replace 0.0 0.0 6 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.0 0.0 6 0.0 %
Deletes
APL Deferred 13.7 15.8 8249 74.3 %
APL Direct 4.6 5.3 2768 24.9 %
DOL 0.2 0.2 92 0.8 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Deleted 18.5 21.2 11109 11.0 %
========================= ============ ============ ==========
Total Rows Affected 168.8 193.7 101284
===============================================================================
Transaction Management
----------------------
ULC Flushes to Xact Log per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
by Full ULC 6.3 7.2 3786 39.9 %
by End Transaction 0.7 0.8 440 4.6 %
by Change of Database 0.0 0.0 25 0.3 %
by System Log Record 8.2 9.4 4920 51.8 %
by Other 0.5 0.6 327 3.4 %
------------------------- ------------ ------------ ----------
Total ULC Flushes 15.8 18.2 9498
ULC Log Records 107.3 123.1 64373 n/a
Max ULC Size During Sample n/a n/a 14232 n/a
ULC Semaphore Requests
Granted 203.6 233.6 122156 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total ULC Semaphore Req 203.6 233.6 122156
Log Semaphore Requests
Granted 18.2 20.8 10904 100.0 %
Waited 0.0 0.0 2 0.0 %
------------------------- ------------ ------------ ----------
Total Log Semaphore Req 18.2 20.9 10906
Transaction Log Writes 13.3 15.3 8007 n/a
Transaction Log Alloc 10.1 11.6 6063 n/a
Avg # Writes per Log Page n/a n/a 1.32063 n/a
===============================================================================
Index Management
----------------
Nonclustered Maintenance per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Ins/Upd Requiring Maint 1.1 1.2 644 n/a
# of NC Ndx Maint 1.4 1.6 862 n/a
Avg NC Ndx Maint / Op n/a n/a 1.33851 n/a
Deletes Requiring Maint 1.2 1.3 699 n/a
# of NC Ndx Maint 2.4 2.8 1441 n/a
Avg NC Ndx Maint / Op n/a n/a 2.06152 n/a
RID Upd from Clust Split 0.0 0.0 11 n/a
# of NC Ndx Maint 0.2 0.2 98 n/a
Avg NC Ndx Maint / Op n/a n/a 8.90909 n/a
Upd/Del DOL Req Maint 0.2 0.2 98 n/a
# of DOL Ndx Maint 0.2 0.2 92 n/a
Avg DOL Ndx Maint / Op n/a n/a 0.93878 n/a
Page Splits 0.1 0.1 78 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.1 0.1 41 n/a
Index Scans per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Ascending Scans 567.2 650.8 340345 89.6 %
DOL Ascending Scans 65.3 74.9 39174 10.3 %
Descending Scans 0.2 0.3 135 0.0 %
DOL Descending Scans 0.0 0.0 0 0.0 %
------------ ------------ ----------
Total Scans 632.8 725.9 379654 |
|