- 论坛徽章:
- 0
|
请教对数据库优化的建议
jazy兄我按照您的建议作了一些优化已有很大成效但是我发现在同等测试条件下
网络的I/O与磁盘I/O增加了很多请问是什么原因?一下时改动后进行sp_sysmon的结果
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.1/EBF 10431 ESD#2/P/Li
Server Name: omc
Run Date: Jan 23, 2003
Statistics Cleared at: 17:44:28
Statistics Sampled at: 17:54:26
Sample Interval: 00:10:00
===============================================================================
Kernel Utilization
------------------
Engine Busy Utilization
Engine 0 16.0 %
CPU Yields by Engine per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 79.7 6.7 47793 100.0 %
Network Checks
Non-Blocking 7631.3 638.6 4578806 99.4 %
Blocking 45.9 3.8 27526 0.6 %
------------------------- ------------ ------------ ----------
Total Network I/O Checks 7677.2 642.4 4606332
Avg Net I/Os per Check n/a n/a 0.00940 n/a
Disk I/O Checks
Total Disk I/O Checks 23147.5 1937.0 13888516 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.0 6 n/a
Task Context Switches by Engine
Engine 0 222.9 18.7 133723 100.0 %
Task Context Switches Due To:
Voluntary Yields 11.9 1.0 7169 5.4 %
Cache Search Misses 53.7 4.5 32201 24.1 %
System Disk Writes 0.5 0.0 328 0.2 %
I/O Pacing 2.9 0.2 1756 1.3 %
Logical Lock Contention 0.2 0.0 90 0.1 %
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 2 0.0 %
Last Log Page Writes 11.7 1.0 7032 5.3 %
Modify Conflicts 0.0 0.0 4 0.0 %
I/O Device Contention 0.0 0.0 0 0.0 %
Network Packet Received 43.1 3.6 25831 19.3 %
Network Packet Sent 29.1 2.4 17487 13.1 %
Other Causes 69.7 5.8 41823 31.3 %
===============================================================================
Application Management
----------------------
Application Statistics Summary (All Applications)
-------------------------------------------------
Priority Changes per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
To High Priority 0.2 0.0 149 7.5 %
To Medium Priority 1.7 0.1 993 50.2 %
To Low Priority 1.4 0.1 838 42.3 %
------------------------- ------------ ------------ ----------
Total Priority Changes 3.3 0.3 1980
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 23.5 2.0 14086 92.7 %
Dirty 1.8 0.2 1104 7.3 %
------------ ------------ ----------
Total Washes 25.3 2.1 15190
Garbage Collections 1.3 0.1 808 n/a
Pages Processed in GC 0.0 0.0 0 n/a
Statistics Updates 1.3 0.1 808 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)
Tuning Recommendations for Monitor Access to Executing SQL
----------------------------------------------------------
- Consider decreasing the 'max SQL text monitored' parameter
to 512 (i.e., half way from its current value to Maximum
SQL Text Requested).
===============================================================================
Transaction Profile
-------------------
Transaction Summary per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Committed Xacts 12.0 n/a 7170 n/a
Transaction Detail per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Inserts
APL Heap Table 0.0 0.0 2 0.0 %
APL Clustered Table 7.1 0.6 4232 100.0 %
Data Only Lock Table 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Inserted 7.1 0.6 4234 64.0 %
Updates
APL Deferred 0.0 0.0 0 0.0 %
APL Direct In-place 0.0 0.0 17 100.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.0 0 0.0 %
DOL Direct 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Updated 0.0 0.0 17 0.3 %
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.0 0.0 0 0.0 %
APL Direct 3.9 0.3 2367 100.0 %
DOL 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Deleted 3.9 0.3 2367 35.8 %
========================= ============ ============ ==========
Total Rows Affected 11.0 0.9 6618
===============================================================================
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 11.3 0.9 6766 87.7 %
by Change of Database 0.0 0.0 12 0.2 %
by Single Log Record 0.1 0.0 49 0.6 %
by Other 1.5 0.1 891 11.5 %
------------------------- ------------ ------------ ----------
Total ULC Flushes 12.9 1.1 7718
ULC Log Records 64.8 5.4 38893 n/a
Max ULC Size During Sample n/a n/a 3348 n/a
ULC Semaphore Requests
Granted 136.7 11.4 82001 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total ULC Semaphore Req 136.7 11.4 82001
Log Semaphore Requests
Granted 11.9 1.0 7159 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Log Semaphore Req 11.9 1.0 7159
Transaction Log Writes 14.5 1.2 8698 n/a
Transaction Log Alloc 2.8 0.2 1655 n/a
Avg # Writes per Log Page n/a n/a 5.25559 n/a
===============================================================================
Index Management
----------------
Nonclustered Maintenance per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Ins/Upd Requiring Maint 7.0 0.6 4188 n/a
# of NC Ndx Maint 13.9 1.2 8341 n/a
Avg NC Ndx Maint / Op n/a n/a 1.99164 n/a
Deletes Requiring Maint 4.0 0.3 2384 n/a
# of NC Ndx Maint 7.9 0.7 4737 n/a
Avg NC Ndx Maint / Op n/a n/a 1.98700 n/a
RID Upd from Clust Split 0.2 0.0 149 n/a
# of NC Ndx Maint 4.2 0.3 2492 n/a
Avg NC Ndx Maint / Op n/a n/a 16.72483 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.1 0.0 89 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 4 n/a
Deadlocks %
Deadlock Retries Exceeded 0.0 0.0 0 0.0 %
Index Scans per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Ascending Scans 307.8 25.8 184687 91.6 %
DOL Ascending Scans 28.0 2.3 16814 8.3 %
Descending Scans 0.1 0.0 50 0.0 %
DOL Descending Scans 0.0 0.0 0 0.0 %
------------ ------------ ----------
Total Scans 335.9 28.1 201551
===============================================================================
Lock Management
---------------
Lock Summary per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total Lock Requests 1350.2 113.0 810145 n/a
Avg Lock Contention 0.2 0.0 90 0.0 %
Deadlock Percentage 0.0 0.0 0 0.0 %
Lock Detail per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Table Lock Hashtable
Lookups 98.0 8.2 58815 n/a
Avg Chain Length n/a n/a 0.00000 n/a
Spinlock Contention n/a n/a n/a 0.0 %
Exclusive Table
Granted 0.0 0.0 12 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Table Requests 0.0 0.0 12 0.0 %
Shared Table
Granted 0.1 0.0 61 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Table Requests 0.1 0.0 61 0.0 %
Exclusive Intent
Granted 12.2 1.0 7301 99.2 %
Waited 0.1 0.0 58 0.8 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Intent Requests 12.3 1.0 7359 0.9 %
Shared Intent
Granted 85.6 7.2 51383 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Intent Requests 85.6 7.2 51383 6.3 %
Page & Row Lock HashTable
Lookups 827.2 69.2 496292 n/a
Avg Chain Length n/a n/a 0.00432 n/a
Spinlock Contention n/a n/a n/a 0.0 %
Exclusive Page
Granted 35.5 3.0 21296 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Page Requests 35.5 3.0 21296 2.6 %
Update Page
Granted 8.9 0.7 5342 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total UP-Page Requests 8.9 0.7 5342 0.7 %
Shared Page
Granted 557.7 46.7 334591 100.0 %
Waited 0.1 0.0 32 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Page Requests 557.7 46.7 334623 41.3 %
Exclusive Row
Granted 0.8 0.1 503 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Row Requests 0.8 0.1 503 0.1 %
Update Row
Total UP-Row Requests 0.0 0.0 0 n/a
Shared Row
Granted 215.0 18.0 128974 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Row Requests 215.0 18.0 128974 15.9 %
Next-Key
Total Next-Key Requests 0.0 0.0 0 n/a
Address Lock Hashtable
Lookups 434.3 36.3 260592 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 87.2 7.3 52302 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Address Requests 87.2 7.3 52302 6.5 %
Shared Address
Granted 347.2 29.1 208290 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Address Requests 347.2 29.1 208290 25.7 %
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.1 0.0 59 n/a
Searches Skipped 0.0 0.0 0 0.0 %
Avg Deadlocks per Search n/a n/a 0.00000 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
Tuning Recommendations for Lock Management
------------------------------------------
- Consider increasing the 'deadlock checking period' parameter
by 50 ms.
===============================================================================
Data Cache Management
---------------------
Cache Statistics Summary (All Caches)
-------------------------------------
per sec per xact count % of total
------------ ------------ ---------- ----------
Cache Search Summary
Total Cache Hits 3406.9 285.1 2044118 84.4 %
Total Cache Misses 628.7 52.6 377243 15.6 %
------------------------- ------------ ------------ ----------
Total Cache Searches 4035.6 337.7 2421361
Cache Turnover
Buffers Grabbed 2964.2 248.0 1778491 n/a
Buffers Grabbed Dirty 0.0 0.0 0 0.0 %
Cache Strategy Summary
Cached (LRU) Buffers 4026.5 336.9 2415899 100.0 %
Discarded (MRU) Buffers 0.0 0.0 0 0.0 %
Large I/O Usage
Large I/Os Performed 245.5 20.5 147297 81.6 %
Large I/Os Denied due to
Pool < Prefetch Size 55.4 4.6 33252 18.4 %
------------------------- ------------ ------------ ----------
Total Large I/O Requests 300.9 25.2 180549
Large I/O Effectiveness
Pages by Lrg I/O Cached 1964.0 164.3 1178376 n/a
Pages by Lrg I/O Used 1961.0 164.1 1176605 99.8 %
Asynchronous Prefetch Activity
APFs Issued 571.8 47.8 343054 76.0 %
APFs Denied Due To
APF I/O Overloads 0.0 0.0 0 0.0 %
APF Limit Overloads 11.4 1.0 6849 1.5 %
APF Reused Overloads 0.0 0.0 0 0.0 %
APF Buffers Found in Cache
With Spinlock Held 3.5 0.3 2127 0.5 %
W/o Spinlock Held 165.3 13.8 99175 22.0 %
------------------------- ------------ ------------ ----------
Total APFs Requested 752.0 62.9 451205
Other Asynchronous Prefetch Statistics
APFs Used 571.8 47.8 343051 n/a
APF Waits for I/O 56.1 4.7 33678 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: ccb_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 74.8 %
Cache Searches
Cache Hits 2400.8 200.9 1440472 79.5 %
Found in Wash 4.0 0.3 2385 0.2 %
Cache Misses 618.7 51.8 371226 20.5 %
------------------------- ------------ ------------ ----------
Total Cache Searches 3019.5 252.7 1811698
Pool Turnover
2 Kb Pool
LRU Buffer Grab 372.8 31.2 223688 12.6 %
Grabbed Dirty 0.0 0.0 0 0.0 %
16 Kb Pool
LRU Buffer Grab 245.5 20.5 147297 8.3 %
Grabbed Dirty 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Cache Turnover 2952.1 247.0 1771267
Buffer Wash Behavior
Buffers Passed Clean 619.1 51.8 371440 100.0 %
Buffers Already in I/O 0.0 0.0 0 0.0 %
Buffers Washed Dirty 0.1 0.0 87 0.0 %
Cache Strategy
Cached (LRU) Buffers 3017.2 252.5 1810337 100.0 %
Discarded (MRU) Buffers 0.0 0.0 0 0.0 %
Large I/O Usage
Large I/Os Performed 245.5 20.5 147297 81.6 %
Large I/Os Denied due to
Pool < Prefetch Size 55.4 4.6 33252 18.4 %
------------------------- ------------ ------------ ----------
Total Large I/O Requests 300.9 25.2 180549
Large I/O Detail
16 Kb Pool
Pages Cached 1964.0 164.3 1178376 n/a
Pages Used 1961.0 164.1 1176605 99.8 %
Dirty Read Behavior
Page Requests 0.0 0.0 0 n/a
Tuning Recommendations for Data cache : ccb_cache
-------------------------------------
- Consider increasing the 'wash size' of the 2k pool for this cache.
- Consider adding a large I/O pool for this cache.
-------------------------------------------------------------------------------
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 25.2 %
Cache Searches
Cache Hits 1006.1 84.2 603646 99.0 %
Found in Wash 2.0 0.2 1205 0.2 %
Cache Misses 10.0 0.8 6017 1.0 %
------------------------- ------------ ------------ ----------
Total Cache Searches 1016.1 85.0 609663
Pool Turnover
2 Kb Pool
LRU Buffer Grab 7.1 0.6 4270 59.1 %
Grabbed Dirty 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Cache Turnover 12.0 1.0 7224
Buffer Wash Behavior
Statistics Not Available - No Buffers Entered Wash Section Yet
Cache Strategy
Cached (LRU) Buffers 1009.3 84.5 605562 100.0 %
Discarded (MRU) Buffers 0.0 0.0 0 0.0 %
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.0 0.0 0 n/a
===============================================================================
Memory Management per sec per xact count % of total
--------------------------- ------------ ------------ ---------- ----------
Pages Allocated 0.1 0.0 64 n/a
Pages Released 0.1 0.0 64 n/a
===============================================================================
Recovery Management
-------------------
Checkpoints per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
# of Normal Checkpoints 0.0 0.0 12 100.0 %
# of Free Checkpoints 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Checkpoints 0.0 0.0 12
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 644.0 53.9 386374
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:
/opt/sybase-12.5/devs/omcdata1.dev
omcdata1 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 571.8 47.8 343054 90.8 %
Non-APF 53.7 4.5 32194 8.5 %
Writes 3.9 0.3 2369 0.6 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 629.4 52.7 377617 97.7 %
Device Semaphore Granted 629.4 52.7 377617 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/opt/sybase-12.5/devs/omcdata10.dev
omcdata10 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:
/opt/sybase-12.5/devs/omcdata11.dev
omcdata11 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:
/opt/sybase-12.5/devs/omcdata12.dev
omcdata12 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:
/opt/sybase-12.5/devs/omcdata13.dev
omcdata13 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:
/opt/sybase-12.5/devs/omcdata14.dev
omcdata14 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:
/opt/sybase-12.5/devs/omcdata15.dev
omcdata15 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:
/opt/sybase-12.5/devs/omcdata16.dev
omcdata16 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:
/opt/sybase-12.5/devs/omcdata17.dev
omcdata17 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:
/opt/sybase-12.5/devs/omcdata18.dev
omcdata18 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:
/opt/sybase-12.5/devs/omcdata19.dev
omcdata19 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:
/opt/sybase-12.5/devs/omcdata2.dev
omcdata2 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:
/opt/sybase-12.5/devs/omcdata20.dev
omcdata20 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:
/opt/sybase-12.5/devs/omcdata21.dev
omcdata21 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:
/opt/sybase-12.5/devs/omcdata22.dev
omcdata22 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:
/opt/sybase-12.5/devs/omcdata23.dev
omcdata23 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:
/opt/sybase-12.5/devs/omcdata24.dev
omcdata24 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:
/opt/sybase-12.5/devs/omcdata25.dev
omcdata25 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:
/opt/sybase-12.5/devs/omcdata3.dev
omcdata3 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:
/opt/sybase-12.5/devs/omcdata4.dev
omcdata4 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:
/opt/sybase-12.5/devs/omcdata5.dev
omcdata5 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:
/opt/sybase-12.5/devs/omcdata6.dev
omcdata6 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:
/opt/sybase-12.5/devs/omcdata7.dev
omcdata7 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:
/opt/sybase-12.5/devs/omcdata8.dev
omcdata8 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:
/opt/sybase-12.5/devs/omcdata9.dev
omcdata9 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:
/opt/sybase-12.5/devs/omclog1.dev
omclog1 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 7 0.1 %
Writes 14.5 1.2 8726 99.9 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 14.6 1.2 8733 2.3 %
Device Semaphore Granted 14.6 1.2 8733 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/opt/sybase-12.5/devs/omclog2.dev
omclog2 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:
/opt/sybase-12.5/devs/omclog3.dev
omclog3 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:
/opt/sybase-12.5/devs/omclog4.dev
omclog4 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:
/opt/sybase-12.5/devs/omclog5.dev
omclog5 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:
/opt/sybase-12.5/devs/omclog6.dev
omclog6 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:
/opt/sybase-12.5/devs/omclog7.dev
omclog7 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:
/opt/sybase-12.5/devs/omclog8.dev
omclog8 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:
/opt/sybase-12.5/sys_devs/master.dat
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.0 0.0 24 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 24 0.0 %
Device Semaphore Granted 0.0 0.0 24 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/opt/sybase-12.5/sys_devs/sybsystemdb.dat
systemdbdev 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:
/opt/sybase-12.5/sys_devs/sybsystemprocs.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:
/opt/sybase-12.5/temp.dev
tempdev 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 %
-----------------------------------------------------------------------------
===============================================================================
Network I/O Management
----------------------
Total Network I/O Requests 43.2 3.6 25911 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 43.1 3.6 25831 100.0 %
------------------------- ------------ ------------ ----------
Total TDS Packets Rec'd 43.1 3.6 25831
Total Bytes Received per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 11288.4 944.6 6773050 100.0 %
------------------------- ------------ ------------ ----------
Total Bytes Rec'd 11288.4 944.6 6773050
Avg Bytes Rec'd per Packet n/a n/a 262 n/a
-----------------------------------------------------------------------------
Total TDS Packets Sent per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 29.1 2.4 17487 100.0 %
------------------------- ------------ ------------ ----------
Total TDS Packets Sent 29.1 2.4 17487
Total Bytes Sent per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 1534.8 128.4 920878 100.0 %
------------------------- ------------ ------------ ----------
Total Bytes Sent 1534.8 128.4 920878
Avg Bytes Sent per Packet n/a n/a 52 n/a
=============================== End of Report =================================
(return status = 0) |
|