- 论坛徽章:
- 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.0.3/EBF 10977 ESD#1/P/HP
Server Name: tjsyb
Run Date: Mar 04, 2004
Statistics Cleared at: 11:22:02
Statistics Sampled at: 10:21:38
Sample Interval: 00:10:00
===============================================================================
Kernel Utilization
------------------
Engine Busy Utilization
Engine 0 100.0 %
CPU Yields by Engine per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Network Checks
Non-Blocking 10.0 112.9 5982 100.0 %
Blocking 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Network I/O Checks 10.0 112.9 5982
Avg Net I/Os per Check n/a n/a 0.29505 n/a
Disk I/O Checks
Total Disk I/O Checks 590.3 6682.5 354175 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
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.1 1.2 65 n/a
Task Context Switches by Engine
Engine 0 1199.9 13584.1 719955 100.0 %
Task Context Switches Due To:
Voluntary Yields 0.6 6.8 361 0.1 %
Cache Search Misses 184.8 2092.5 110903 15.4 %
System Disk Writes 0.0 0.3 14 0.0 %
I/O Pacing 0.0 0.1 3 0.0 %
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 0.3 16 0.0 %
Modify Conflicts 0.0 0.0 0 0.0 %
I/O Device Contention 0.0 0.0 0 0.0 %
Network Packet Sent 1.4 15.3 812 0.1 %
Other Causes 1011.5 11450.8 606893 84.3 %
===============================================================================
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.5 5.5 289 56.3 %
To Low Priority 0.4 4.2 224 43.7 %
------------------------- ------------ ------------ ----------
Total Priority Changes 0.9 9.7 513
Allotted Slices Exhausted per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
High Priority 0.0 0.0 0 0.0 %
Medium Priority 0.0 0.0 1 100.0 %
------------------------- ------------ ------------ ----------
Total Slices Exhausted 0.0 0.0 1
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 13.3 150.9 8000 100.0 %
Dirty 0.0 0.0 0 0.0 %
Total Washes 13.3 150.9 8000
Garbage Collections 0.2 2.3 120 n/a
Pages Processed in GC 0.0 0.0 0 n/a
Statistics Updates 0.0 0.4 22 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.1 n/a 53 n/a
Transaction Detail per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Inserts
APL Heap Table 0.0 0.0 2 14.3 %
APL Clustered Table 0.0 0.2 12 85.7 %
Data Only Lock Table 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Inserted 0.0 0.3 14 100.0 %
Updates
Total Rows Updated 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total Rows Updated 0.0 0.0 0 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 %
Total Rows Deleted 0.0 0.0 0 n/a
========================= ============ ============ ==========
Total Rows Affected 0.0 0.3 14
===============================================================================
Transaction Management
----------------------
ULC Flushes to Xact Log per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
by Full ULC 0.0 0.0 0 0.0 %
by End Transaction 0.0 0.2 13 18.8 %
by Change of Database 0.0 0.0 2 2.9 %
by Single Log Record 0.0 0.1 6 8.7 %
by Other 0.1 0.9 48 69.6 %
------------------------- ------------ ------------ ----------
Total ULC Flushes 0.1 1.3 69
ULC Log Records 0.1 1.2 63 n/a
Max ULC Size During Sample n/a n/a 1056 n/a
ULC Semaphore Requests
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total ULC Semaphore Req 0.5 6.2 326
Log Semaphore Requests
Granted 0.1 1.2 65 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Log Semaphore Req 0.1 1.2 65
Transaction Log Writes 0.0 0.4 21 n/a
Transaction Log Alloc 0.0 0.1 3 n/a
Avg # Writes per Log Page n/a n/a 7.00000 n/a
===============================================================================
Index Management
----------------
Nonclustered Maintenance per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Ins/Upd Requiring Maint 0.0 0.1 4 n/a
# of NC Ndx Maint 0.0 0.2 8 n/a
Deletes Requiring Maint 0.0 0.0 0 n/a
# of NC Ndx Maint 0.0 0.0 0 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.0 0 n/a
# of DOL Ndx Maint 0.0 0.0 0 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 4239.7 47996.3 2543804 100.0 %
DOL Ascending Scans 0.7 8.0 424 0.0 %
Descending Scans 0.0 0.0 2 0.0 %
DOL Descending Scans 0.0 0.0 0 0.0 %
------------ ------------ ----------
Total Scans 4240.4 48004.3 2544230
Metadata Cache Management
-------------------------
Metadata Cache Summary per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Open Object Usage
Active n/a n/a 343 n/a
Max Ever Used Since Boot n/a n/a 343 n/a
Free n/a n/a 3657 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 242 n/a
Max Ever Used Since Boot n/a n/a 242 n/a
Free n/a n/a 3558 n/a
Reuse Requests
Succeeded n/a n/a 0 n/a
Failed n/a n/a 0 n/a
Active n/a n/a 7 n/a
Max Ever Used Since Boot n/a n/a 7 n/a
Free n/a n/a 5 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 18382.8 208107.5 11029697 n/a
Deadlock Percentage 0.0 0.0 0 0.0 %
Lock Detail per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Table Lock Hashtable
Lookups 2.0 22.5 1195 n/a
Avg Chain Length n/a n/a 0.00418 n/a
Spinlock Contention n/a n/a n/a 0.0 %
Exclusive Table
Total EX-Table Requests 0.0 0.0 0 n/a
Shared Table
Granted 0.0 0.0 1 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Table Requests 0.0 0.0 1 0.0 %
Exclusive Intent
Granted 0.0 0.3 17 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Shared Intent
Granted 2.0 22.2 1177 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Intent Requests 2.0 22.2 1177 0.0 %
Page & Row Lock HashTable
Lookups 5667.4 64158.8 3400414 n/a
Avg Chain Length n/a n/a 0.00094 n/a
Spinlock Contention n/a n/a n/a 0.0 %
Exclusive Page
Granted 0.0 0.4 19 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Page Requests 0.0 0.4 19 0.0 %
Update Page
Granted 323.2 3659.1 193930 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total UP-Page Requests 323.2 3659.1 193930 1.8 %
Shared Page
Granted 5341.8 60473.5 3205098 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Page Requests 5341.8 60473.5 3205098 29.1 %
Exclusive Row
Granted 0.0 0.2 8 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Row Requests 0.0 0.2 8 0.0 %
Update Row
Total UP-Row Requests 0.0 0.0 0 n/a
Shared Row
Granted 2.3 25.6 1358 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Row Requests 2.3 25.6 1358 0.0 %
Total Next-Key Requests 0.0 0.0 0 n/a
Address Lock Hashtable
Lookups 12713.5 143926.2 7628089 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.1 1.3 70 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Address Requests 0.1 1.3 70 0.0 %
Shared Address
Granted 12713.4 143924.9 7628019 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Address Requests 12713.4 143924.9 7628019 69.2 %
Last Page Locks on Heaps
Granted 0.0 0.0 2 100.0 %
Waited 0.0 0.0 0 0.0 %
Total Last Pg Locks 0.0 0.0 2 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
===============================================================================
---------------------
Cache Statistics Summary (All Caches)
-------------------------------------
per sec per xact count % of total
------------ ------------ ---------- ----------
Cache Search Summary
Total Cache Hits 13970.6 158157.9 8382368 90.7 %
Total Cache Misses 1438.2 16281.2 862905 9.3 %
------------------------- ------------ ------------ ----------
Total Cache Searches 15408.8 174439.1 9245273
Cache Turnover
Buffers Grabbed 1412.0 15984.7 847188 n/a
Buffers Grabbed Dirty 0.0 0.0 0 0.0 %
Cache Strategy Summary
Cached (LRU) Buffers 15007.4 169894.5 9004411 97.6 %
Discarded (MRU) Buffers 375.1 4245.9 225032 2.4 %
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 1227.1 13892.2 736285 92.9
APFs Denied Due To
APF I/O Overloads 0.0 0.0 0 0.0
APF Limit Overloads 5.9 66.3 3513 0.4
APF Reused Overloads 26.1 295.2 15648 2.0
APF Buffers Found in Cache
With Spinlock Held 0.0 0.0 0 0.0
W/o Spinlock Held 62.3 704.8 37354 4.7
------------------------- ------------ ------------ ----------
Total APFs Requested 1321.3 14958.5 792800
Other Asynchronous Prefetch Statistics
APFs Used 1200.9 13594.9 720532 n/a
APF Waits for I/O 1010.5 11439.6 606299 n/a
APF Discards 0.0 0.0 0 n/a
Dirty Read Behavior
Page Requests 0.0 0.0 0 n/a
Tuning Recommendations for All Caches
-------------------------------------
- Consider increasing the 'global asynchronous prefetch limit' parameter
(and the 'local asynchronous prefetch limit' parameter for each pool
for which this was overidden) by 10%.
-------------------------------------------------------------------------------
Cache: default 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 100.0 %
Cache Searches
Cache Hits 13970.6 158157.9 8382368 90.7 %
Found in Wash 0.5 5.5 290 0.0 %
Cache Misses 1438.2 16281.2 862905 9.3 %
------------------------- ------------ ------------ ----------
Total Cache Searches 15408.8 174439.1 9245273
Pool Turnover
2 Kb Pool
LRU Buffer Grab 1412.0 15984.7 847188 100.0 %
Grabbed Dirty 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Cache Turnover 1412.0 15984.7 847188
Buffer Wash Behavior
Buffers Passed Clean 1399.0 15837.7 839400 100.0 %
Buffers Already in I/O 0.0 0.0 0 0.0 %
Buffers Washed Dirty 0.1 1.6 85 0.0 %
Cache Strategy
Cached (LRU) Buffers 15007.4 169894.5 9004411 97.6 %
Discarded (MRU) Buffers 375.1 4245.9 225032 2.4 %
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
Tuning Recommendations for Data cache : default data cache
-------------------------------------
- Consider adding a large I/O pool for this cache.
===============================================================================
Procedure Cache Management per sec per xact count % of total
--------------------------- ------------ ------------ ---------- ----------
Procedure Requests 0.3 2.9 155 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 1.0 54 n/a
Pages Released 0.1 1.0 54 n/a
===============================================================================
Recovery Management
-------------------
Checkpoints per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
# of Normal Checkpoints 0.0 0.0 2 100.0 %
# of Free Checkpoints 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Checkpoints 0.0 0.0 2
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 0 n/a
Engine 0 n/a n/a 0 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 1412.2 15986.9 847306
Completed Disk I/O's
Total Completed I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ----------
Total Completed I/Os 0.0 0.0 0
Device Activity Detail
----------------------
Device:
/dev/vgdata/rdata1
data1 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 502.1 5684.4 301272 82.1 %
Non-APF 109.1 1235.1 65459 17.8 %
Writes 0.0 0.4 20 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 611.3 6919.8 366751 43.3 %
-----------------------------------------------------------------------------
Device:
/dev/vgdata/rdata10
data10 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/vgdata/rdata11
data11 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/vgdata/rdata12
data12 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/vgdata/rdata13
data13 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/vgdata/rdata14
data14 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/vgdata/rdata15
data15 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/vgdata/rdata16
data16 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/vgdata/rdata17
data17 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/vgdata/rdata18
data18 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/vgdata/rdata19
data19 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/vgdata/rdata2
data2 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 725.0 8207.8 435013 90.7 %
Non-APF 74.7 845.6 44816 9.3 %
Writes 0.0 0.1 7 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 799.7 9053.5 479836 56.6 %
-----------------------------------------------------------------------------
Device:
/dev/vgdata/rdata20
data20 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/vgdata/rdata21
data21 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/vgdata/rdata22
data22 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/vgdata/rdata23
data23 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/vgdata/rdata24
data24 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/vgdata/rdata25
data25 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/vgdata/rdata26
data26 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/vgdata/rdata27
data27 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/vgdata/rdata28
data28 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/vgdata/rdata29
data29 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/vgdata/rdata3
data3 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/vgdata/rdata30
data30 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/vgdata/rdata4
data4 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/vgdata/rdata5
data5 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/vgdata/rdata6
data6 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/vgdata/rdata7
data7 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/vgdata/rdata8
data8 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/vgdata/rdata9
data9 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/vglog/rlog1
log1 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/vglog/rlog2
log2 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 2 10.0 %
Writes 0.0 0.3 18 90.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.4 20 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/vglog/rlog3
log3 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/vgsys/rmaster
master per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 1.0 11.4 602 93.6 %
Writes 0.1 0.8 41 6.4 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 1.1 12.1 643 0.1 %
-----------------------------------------------------------------------------
Device:
/dev/vgsys/rsysproc
sysprocsdev 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/vgsys/rtempdb1
tempdb1 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.5 24 42.9 %
Writes 0.1 0.6 32 57.1 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.1 1.1 56 0.0 %
-----------------------------------------------------------------------------
===============================================================================
Network I/O Management
----------------------
Total Network I/O Requests 1.6 17.9 951 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 1.6 18.0 953 100.0 %
------------------------- ------------ ------------ ----------
Total TDS Packets Rec'd 1.6 18.0 953
Total Bytes Received per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 147.6 1671.4 88582 100.0 %
------------------------- ------------ ------------ ----------
Total Bytes Rec'd 147.6 1671.4 88582
Avg Bytes Rec'd per Packet n/a n/a 92 n/a
-----------------------------------------------------------------------------
Total TDS Packets Sent per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Avg Bytes Rec'd per Packet n/a n/a 92 n/a
-----------------------------------------------------------------------------
Total TDS Packets Sent per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 1.4 15.3 812 100.0 %
------------------------- ------------ ------------ ----------
Total TDS Packets Sent 1.4 15.3 812
Total Bytes Sent per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 107.9 1221.3 64728 100.0 %
------------------------- ------------ ------------ ----------
Total Bytes Sent 107.9 1221.3 64728
Avg Bytes Sent per Packet n/a n/a 79 n/a
=============================== End of Report =================================
(return status = 0) |
|
免费注册
发表于 2004-03-04 11:15
没有人知道吗？
