- 论坛徽章:
- 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.6/P/EBF 10394 ROLLUP/D
Server Name: SYB12
Run Date: Sep 17, 2004
Statistics Cleared at: 13:52:43
Statistics Sampled at: 13:53:43
Sample Interval: 00:01:00
===============================================================================
Kernel Utilization
------------------
Engine Busy Utilization
Engine 0 22.2 %
Engine 1 30.5 %
----------- --------------- ----------------
Summary Total 52.7 % Average 26.3 %
CPU Yields by Engine per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 22.5 5.2 1350 52.7 %
Engine 1 20.2 4.6 1210 47.3 %
------------------------- ------------ ------------ ----------
Total CPU Yields 42.7 9.8 2560
Network Checks
Non-Blocking 11460.1 2624.4 687603 99.8 %
Blocking 24.4 5.6 1466 0.2 %
------------------------- ------------ ------------ ----------
Total Network I/O Checks 11484.5 2630.0 689069
Avg Net I/Os per Check n/a n/a 0.01388 n/a
Disk I/O Checks
Total Disk I/O Checks 34472.0 7894.4 2068320 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.2 0.0 9 n/a
Task Context Switches by Engine
Engine 0 192.3 44.0 11535 53.1 %
Engine 1 169.6 38.8 10176 46.9 %
------------------------- ------------ ------------ ----------
Total Task Switches: 361.9 82.9 21711
Task Context Switches Due To:
Voluntary Yields 9.4 2.2 564 2.6 %
Cache Search Misses 4.8 1.1 289 1.3 %
System Disk Writes 0.4 0.1 23 0.1 %
I/O Pacing 10.6 2.4 633 2.9 %
Logical Lock Contention 0.0 0.0 1 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 1 0.0 %
PLC Lock Contention 0.0 0.0 0 0.0 %
Group Commit Sleeps 0.2 0.0 12 0.1 %
Last Log Page Writes 8.4 1.9 503 2.3 %
Modify Conflicts 0.2 0.0 12 0.1 %
I/O Device Contention 2.5 0.6 147 0.7 %
Network Packet Received 65.6 15.0 3933 18.1 %
Network Packet Sent 93.9 21.5 5632 25.9 %
Other Causes 166.0 38.0 9961 45.9 %
===============================================================================
Application Management
----------------------
Application Statistics Summary (All Applications)
-------------------------------------------------
Priority Changes per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
To High Priority 0.0 0.0 2 1.5 %
To Medium Priority 1.2 0.3 73 53.3 %
To Low Priority 1.0 0.2 62 45.3 %
------------------------- ------------ ------------ ----------
Total Priority Changes 2.3 0.5 137
Allotted Slices Exhausted per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
High Priority 0.0 0.0 0 0.0 %
Medium Priority 0.2 0.0 13 100.0 %
Low Priority 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Slices Exhausted 0.2 0.0 13
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 4.4 1.0 266 93.3 %
Dirty 0.3 0.1 19 6.7 %
------------ ------------ ----------
Total Washes 4.8 1.1 285
Garbage Collections 0.6 0.1 33 n/a
Pages Processed in GC 0.0 0.0 0 n/a
Statistics Updates 0.6 0.1 33 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 4.4 n/a 262 n/a
Transaction Detail per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Inserts
APL Heap Table 337.2 77.2 20231 84.7 %
APL Clustered Table 58.9 13.5 3535 14.8 %
Data Only Lock Table 2.0 0.5 120 0.5 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Inserted 398.1 91.2 23886 98.6 %
Updates
APL Deferred 0.1 0.0 6 2.6 %
APL Direct In-place 0.2 0.0 12 5.3 %
APL Direct Cheap 0.2 0.0 10 4.4 %
APL Direct Expensive 0.0 0.0 2 0.9 %
DOL Deferred 0.0 0.0 0 0.0 %
DOL Direct 3.3 0.8 197 86.8 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Updated 3.8 0.9 227 0.9 %
Data Only Locked Updates
DOL Replace 2.7 0.6 164 83.2 %
DOL Shrink 0.0 0.0 1 0.5 %
DOL Cheap Expand 0.2 0.0 13 6.6 %
DOL Expensive Expand 0.3 0.1 18 9.1 %
DOL Expand & Forward 0.0 0.0 1 0.5 %
DOL Fwd Row Returned 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total DOL Rows Updated 3.3 0.8 197 0.8 %
Deletes
APL Deferred 1.7 0.4 102 82.3 %
APL Direct 0.3 0.1 15 12.1 %
DOL 0.1 0.0 7 5.6 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Deleted 2.1 0.5 124 0.5 %
========================= ============ ============ ==========
Total Rows Affected 404.0 92.5 24237
===============================================================================
Transaction Management
----------------------
ULC Flushes to Xact Log per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
by Full ULC 0.5 0.1 31 2.0 %
by End Transaction 8.4 1.9 503 32.8 %
by Change of Database 0.3 0.1 15 1.0 %
by System Log Record 15.0 3.4 902 58.9 %
by Other 1.4 0.3 81 5.3 %
------------------------- ------------ ------------ ----------
Total ULC Flushes 25.5 5.8 1532
ULC Log Records 69.7 16.0 4179 n/a
Max ULC Size During Sample n/a n/a 4072 n/a
ULC Semaphore Requests
Granted 154.7 35.4 9279 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total ULC Semaphore Req 154.7 35.4 9279
Log Semaphore Requests
Granted 30.6 7.0 1836 99.9 %
Waited 0.0 0.0 1 0.1 %
------------------------- ------------ ------------ ----------
Total Log Semaphore Req 30.6 7.0 1837
Transaction Log Writes 13.1 3.0 788 n/a
Transaction Log Alloc 4.7 1.1 283 n/a
Avg # Writes per Log Page n/a n/a 2.78445 n/a
===============================================================================
Index Management
----------------
Nonclustered Maintenance per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Ins/Upd Requiring Maint 0.4 0.1 22 n/a
# of NC Ndx Maint 0.4 0.1 22 n/a
Avg NC Ndx Maint / Op n/a n/a 1.00000 n/a
Deletes Requiring Maint 0.3 0.1 18 n/a
# of NC Ndx Maint 0.2 0.0 12 n/a
Avg NC Ndx Maint / Op n/a n/a 0.66667 n/a
RID Upd from Clust Split 0.0 0.0 2 n/a
# of NC Ndx Maint 1.2 0.3 73 n/a
Avg NC Ndx Maint / Op n/a n/a 36.50000 n/a
Upd/Del DOL Req Maint 3.4 0.8 204 n/a
# of DOL Ndx Maint 0.8 0.2 47 n/a
Avg DOL Ndx Maint / Op n/a n/a 0.23039 n/a
Page Splits 1.1 0.2 63 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.0 0 n/a
Index Scans per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Ascending Scans 276.2 63.2 16570 46.2 %
DOL Ascending Scans 321.2 73.6 19271 53.7 %
Descending Scans 0.3 0.1 15 0.0 %
DOL Descending Scans 0.0 0.0 0 0.0 %
------------ ------------ ----------
Total Scans 597.6 136.9 35856
===============================================================================
Metadata Cache Management
-------------------------
Metadata Cache Summary per sec per xact count % of total
------------------------ ------------ ------------ ---------- ----------
Open Object Usage
Active 8.3 1.9 500 n/a
Max Ever Used Since Boot 8.3 1.9 500 n/a
Free 0.0 0.0 0 n/a
Reuse Requests
Succeeded 88962.3 20373.0 5337739 n/a
Failed 0.0 0.0 0 n/a
Open Index Usage
Active 20.0 4.6 1202 n/a
Max Ever Used Since Boot 20.6 4.7 1234 n/a
Free 20.0 4.6 1198 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.1 0.0 8 n/a
Max Ever Used Since Boot 0.1 0.0 8 n/a
Free 0.1 0.0 4 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 2994.6 685.8 179675 n/a
Avg Lock Contention 0.0 0.0 1 0.0 %
Deadlock Percentage 0.0 0.0 0 0.0 %
Lock Hashtable Lookups 3012.9 690.0 180772 n/a
Avg Hash Chain Length n/a n/a 0.00154 n/a
Lock Detail per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Exclusive Table
Granted 1.8 0.4 106 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Table Requests 1.8 0.4 106 0.1 %
Shared Table
Granted 18.4 4.2 1101 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Table Requests 18.4 4.2 1101 0.6 %
Exclusive Intent
Granted 6.3 1.4 375 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Intent Requests 6.3 1.4 375 0.2 %
Shared Intent
Granted 234.5 53.7 14072 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Intent Requests 234.5 53.7 14072 7.8 %
Exclusive Page
Granted 3.1 0.7 184 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Page Requests 3.1 0.7 184 0.1 %
Update Page
Granted 1.4 0.3 81 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total UP-Page Requests 1.4 0.3 81 0.0 %
Shared Page
Granted 1255.4 287.5 75325 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Page Requests 1255.4 287.5 75325 41.9 %
Exclusive Row
Granted 5.4 1.2 322 99.7 %
Waited 0.0 0.0 1 0.3 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Row Requests 5.4 1.2 323 0.2 %
Update Row
Granted 1.9 0.4 112 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total UP-Row Requests 1.9 0.4 112 0.1 %
Shared Row
Granted 875.5 200.5 52530 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Row Requests 875.5 200.5 52530 29.2 %
Next-Key
Total Next-Key Requests 0.0 0.0 0 n/a
Exclusive Address
Granted 38.4 8.8 2302 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Address Requests 38.4 8.8 2302 1.3 %
Shared Address
Granted 552.7 126.6 33164 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Address Requests 552.7 126.6 33164 18.5 %
Last Page Locks on Heaps
Granted 337.2 77.2 20231 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total Last Pg Locks 337.2 77.2 20231 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 18711.6 4285.1 1122694 99.5 %
Total Cache Misses 91.3 20.9 5480 0.5 %
------------------------- ------------ ------------ ----------
Total Cache Searches 18802.9 4306.0 1128174
Cache Turnover
Buffers Grabbed 18.1 4.1 1085 n/a
Buffers Grabbed Dirty 0.0 0.0 0 0.0 %
Cache Strategy Summary
Cached (LRU) Buffers 18577.0 4254.3 1114619 99.8 %
Discarded (MRU) Buffers 42.9 9.8 2573 0.2 %
Large I/O Usage
Large I/Os Performed 4.7 1.1 279 98.9 %
Large I/Os Denied 0.1 0.0 3 1.1 %
------------------------- ------------ ------------ ----------
Total Large I/O Requests 4.7 1.1 282
Large I/O Effectiveness
Pages by Lrg I/O Cached 37.2 8.5 2232 n/a
Pages by Lrg I/O Used 0.7 0.2 40 1.8 %
Asynchronous Prefetch Activity
APFs Issued 0.0 0.0 0 0.0 %
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 174.0 39.8 10437 100.0 %
------------------------- ------------ ------------ ----------
Total APFs Requested 174.0 39.8 10437
Other Asynchronous Prefetch Statistics
APFs Used 0.0 0.0 0 n/a
APF Waits for I/O 0.0 0.0 0 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 18711.6 4285.1 1122694 99.5 %
Found in Wash 9.4 2.2 565 0.1 %
Cache Misses 91.3 20.9 5480 0.5 %
------------------------- ------------ ------------ ----------
Total Cache Searches 18802.9 4306.0 1128174
Pool Turnover
2 Kb Pool
LRU Buffer Grab 13.4 3.1 806 74.3 %
Grabbed Dirty 0.0 0.0 0 0.0 %
16 Kb Pool
LRU Buffer Grab 4.7 1.1 279 25.7 %
Grabbed Dirty 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Cache Turnover 18.1 4.1 1085
Buffer Wash Behavior
Statistics Not Available - No Buffers Entered Wash Section Yet
Cache Strategy
Cached (LRU) Buffers 18577.0 4254.3 1114619 99.8 %
Discarded (MRU) Buffers 42.9 9.8 2573 0.2 %
Large I/O Usage
Large I/Os Performed 4.6 1.0 274 97.2 %
Large I/Os Denied 0.1 0.0 8 2.8 %
------------------------- ------------ ------------ ----------
Total Large I/O Requests 4.7 1.1 282
Large I/O Detail
16 Kb Pool
Pages Cached 37.2 8.5 2232 n/a
Pages Used 0.7 0.2 40 1.8 %
Dirty Read Behavior
Page Requests 0.0 0.0 0 n/a
===============================================================================
Procedure Cache Management per sec per xact count % of total
--------------------------- ------------ ------------ ---------- ----------
Procedure Requests 9.7 2.2 580 n/a
Procedure Reads from Disk 4.6 1.1 276 47.6 %
Procedure Writes to Disk 0.0 0.0 0 0.0 %
Procedure Removals 1.6 0.4 95 n/a
===============================================================================
Memory Management per sec per xact count % of total
--------------------------- ------------ ------------ ---------- ----------
Pages Allocated 4.7 1.1 282 n/a
Pages Released 4.7 1.1 282 n/a
===============================================================================
Recovery Management
-------------------
Checkpoints per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
# of Normal Checkpoints 0.1 0.0 3 100.0 %
# of Free Checkpoints 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Checkpoints 0.1 0.0 3
Avg Time per Normal Chkpt 2.33333 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
Engine 1 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 50.8 11.6 3049
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:
/DATA/bsrun.dat
bsrun per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 2.5 0.6 149 22.1 %
Writes 8.8 2.0 525 77.9 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 11.2 2.6 674 22.1 %
Device Semaphore Granted 10.8 2.5 650 94.1 %
Device Semaphore Waited 0.7 0.2 41 5.9 %
-----------------------------------------------------------------------------
Device:
/DATA/bsrun1.dat
bsrun1 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.3 0.1 20 27.0 %
Writes 0.9 0.2 54 73.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 1.2 0.3 74 2.4 %
Device Semaphore Granted 1.2 0.3 74 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/DATA/bsrun2.dat
bsrun2 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.3 0.1 20 20.0 %
Writes 1.3 0.3 80 80.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 1.7 0.4 100 3.3 %
Device Semaphore Granted 1.7 0.4 100 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/DATA/bsrun4.dat
bsrun4 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.5 0.1 27 13.4 %
Writes 2.9 0.7 175 86.6 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 3.4 0.8 202 6.6 %
Device Semaphore Granted 3.4 0.8 202 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/DATA/bsrun_log.dat
bsrun_log per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.2 0.0 12 66.7 %
Writes 0.1 0.0 6 33.3 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.3 0.1 18 0.6 %
Device Semaphore Granted 0.3 0.1 18 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/DATA2/bsrun5.dat
bsrun5 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.6 0.1 33 25.2 %
Writes 1.6 0.4 98 74.8 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 2.2 0.5 131 4.3 %
Device Semaphore Granted 2.2 0.5 131 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/DATA2/bstest.dat
bstest 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:
/DATA2/bstest1.dat
bstest1 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:
/DATA2/bstest_log.dat
bstest_log 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:
/DATA2/bstest_log2.dat
bstest_log2 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:
/DATA5/bsrun6.dat
bsrun6 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.4 0.1 25 14.6 %
Writes 2.4 0.6 146 85.4 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 2.9 0.7 171 5.6 %
Device Semaphore Granted 2.9 0.7 171 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/usr/SYBASE/RSSD.dat
RSSD per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 0 0.0 %
Writes 0.4 0.1 23 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.4 0.1 23 0.8 %
Device Semaphore Granted 0.4 0.1 23 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/usr/SYBASE/systemprocs.dat
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:
/usr/SYBASE/tempdb2.dat
tempdb2 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.1 0.0 3 0.2 %
Writes 27.2 6.2 1632 99.8 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 27.3 6.2 1635 53.6 %
Device Semaphore Granted 26.4 6.0 1582 93.7 %
Device Semaphore Waited 1.8 0.4 106 6.3 %
-----------------------------------------------------------------------------
Device:
d_master
master per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 0 0.0 %
Writes 0.4 0.1 21 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.4 0.1 21 0.7 %
Device Semaphore Granted 0.4 0.1 21 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
===============================================================================
Network I/O Management
----------------------
Total Network I/O Requests 158.8 36.4 9528 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 33.8 7.7 2025 51.5 %
Engine 1 31.8 7.3 1908 48.5 %
------------------------- ------------ ------------ ----------
Total TDS Packets Rec'd 65.6 15.0 3933
Total Bytes Received per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 3759.9 861.0 225592 48.6 %
Engine 1 3984.0 912.4 239042 51.4 %
------------------------- ------------ ------------ ----------
Total Bytes Rec'd 7743.9 1773.4 464634
Avg Bytes Rec'd per Packet n/a n/a 118 n/a
-----------------------------------------------------------------------------
Total TDS Packets Sent per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 47.0 10.8 2821 50.1 %
Engine 1 46.9 10.7 2811 49.9 %
------------------------- ------------ ------------ ----------
Total TDS Packets Sent 93.9 21.5 5632
Total Bytes Sent per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 9251.0 2118.6 555061 45.3 %
Engine 1 11167.0 2557.3 670019 54.7 %
------------------------- ------------ ------------ ----------
Total Bytes Sent 20418.0 4675.9 1225080
Avg Bytes Sent per Packet n/a n/a 217 n/a
=============================== End of Report =================================
(return status = 0) |
|
免费注册
发表于 2004-09-17 15:12
