- 论坛徽章:
- 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.5/SWR 9790 ESD 2/P/RS6000/
Server Name: izumi
Run Date: Mar 22, 2006
Statistics Cleared at: 08:35:26
Statistics Sampled at: 11:36:26
Sample Interval: 03:00:00
===============================================================================
Kernel Utilization
------------------
Engine Busy Utilization
Engine 0 99.6 %
CPU Yields by Engine per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 0.0 11.8 365 100.0 %
Network Checks
Non-Blocking 0.0 3.4 105 29.0 %
Blocking 0.0 8.3 257 71.0 %
------------------------- ------------ ------------ ----------
Total Network I/O Checks 0.0 11.7 362
Avg Net I/Os per Check n/a n/a 0.27348 n/a
Disk I/O Checks
Total Disk I/O Checks 0.2 66.8 2070 n/a
Checks Returning I/O 0.1 25.1 778 37.6 %
Avg Disk I/Os Returned n/a n/a 0.48586 n/a
===============================================================================
Worker Process Management
-------------------------
per sec per xact count % of total
------------ ------------ ---------- ----------
Worker Process Requests
Requests Granted 0.0 0.0 1 100.0 %
Requests Denied 0.0 0.0 0 0.0 %
-------------------------- ------------ ------------ ----------
Total Requests 0.0 0.0 1
Requests Terminated 0.0 0.0 0 0.0 %
Worker Process Usage
Total Used 0.0 0.1 3 n/a
Max Ever Used During Sample 0.0 0.3 9 n/a
Memory Requests for Worker Processes
Succeeded 0.0 1.0 30 100.0 %
Failed 0.0 0.0 0 0.0 %
-------------------------- ------------ ------------ ----------
Total Requests 0.0 1.0 30
Avg Mem Ever Used by a WP (in bytes) n/a n/a 1025.8 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 0 0.0 %
Merge Lock Requests per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Network Buffer Merge Locks
Granted with no wait 0.0 0.1 3 100.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 0 0.0 %
Granted after wait 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total # of Requests 0.0 0.1 3
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.0 0 n/a
Task Context Switches by Engine
Engine 0 0.0 12.2 377 100.0 %
Task Context Switches Due To:
Voluntary Yields 0.0 2.7 83 22.0 %
Cache Search Misses 0.0 0.0 0 0.0 %
System Disk Writes 0.0 0.3 8 2.1 %
I/O Pacing 0.0 0.3 9 2.4 %
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 0 0.0 %
Last Log Page Writes 0.0 1.2 36 9.5 %
Modify Conflicts 0.0 0.0 0 0.0 %
I/O Device Contention 0.0 0.0 0 0.0 %
Network Packet Received 0.0 1.2 37 9.8 %
Network Packet Sent 0.0 2.0 62 16.4 %
Other Causes 0.0 4.6 142 37.7 %
===============================================================================
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 0.0 6.5 202 50.0 %
To Low Priority 0.0 6.5 202 50.0 %
------------------------- ------------ ------------ ----------
Total Priority Changes 0.0 13.0 404
Allotted Slices Exhausted per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total Slices Exhausted 0.0 0.0 0 n/a
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 0.2 67.1 2079 85.1 %
Dirty 0.0 11.8 365 14.9 %
------------ ------------ ----------
Total Washes 0.2 78.8 2444
Garbage Collections 0.0 1.4 43 n/a
Pages Processed in GC 0.0 0.0 0 n/a
Statistics Updates 0.0 1.4 43 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.0 n/a 31 n/a
Transaction Detail per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Inserts
APL Heap Table 0.1 51.9 1609 88.0 %
APL Clustered Table 0.0 1.2 37 2.0 %
Data Only Lock Table 0.0 5.9 182 10.0 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Inserted 0.2 59.0 1828 97.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.4 12 100.0 %
DOL Direct 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Updated 0.0 0.4 12 0.6 %
Data Only Locked Updates
DOL Replace 0.0 0.4 12 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.4 12 0.6 %
Deletes
APL Deferred 0.0 1.0 32 76.2 %
APL Direct 0.0 0.2 5 11.9 %
DOL 0.0 0.2 5 11.9 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Deleted 0.0 1.4 42 2.2 %
========================= ============ ============ ==========
Total Rows Affected 0.2 60.7 1882
===============================================================================
Transaction Management
----------------------
ULC Flushes to Xact Log per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
by Full ULC 0.0 0.0 1 0.8 %
by End Transaction 0.0 0.9 28 23.1 %
by Change of Database 0.0 0.0 0 0.0 %
by System Log Record 0.0 1.0 30 24.8 %
by Other 0.0 2.0 62 51.2 %
------------------------- ------------ ------------ ----------
Total ULC Flushes 0.0 3.9 121
ULC Log Records 0.0 12.3 380 n/a
Max ULC Size During Sample n/a n/a 4096 n/a
ULC Semaphore Requests
Granted 0.1 32.8 1018 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total ULC Semaphore Req 0.1 32.8 1018
Log Semaphore Requests
Granted 0.0 2.6 81 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Log Semaphore Req 0.0 2.6 81
Transaction Log Writes 0.0 1.4 44 n/a
Transaction Log Alloc 0.0 0.3 8 n/a
Avg # Writes per Log Page n/a n/a 5.50000 n/a
===============================================================================
Index Management
----------------
Nonclustered Maintenance per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Ins/Upd Requiring Maint 0.0 0.2 5 n/a
# of NC Ndx Maint 0.0 0.2 5 n/a
Avg NC Ndx Maint / Op n/a n/a 1.00000 n/a
Deletes Requiring Maint 0.0 0.2 5 n/a
# of NC Ndx Maint 0.0 0.2 5 n/a
Avg NC Ndx Maint / Op n/a n/a 1.00000 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.5 17 n/a
# of DOL Ndx Maint 0.0 0.2 5 n/a
Avg DOL Ndx Maint / Op n/a n/a 0.29412 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 0.1 26.8 831 91.0 %
DOL Ascending Scans 0.0 2.3 72 7.9 %
Descending Scans 0.0 0.3 10 1.1 %
DOL Descending Scans 0.0 0.0 0 0.0 %
------------ ------------ ----------
Total Scans 0.1 29.5 913
=============================================================================== |
|
免费注册
发表于 2006-03-21 19:43
发表于 2006-03-21 20:54
