- 论坛徽章:
- 0
|
sybase数据库出现SQL Server CPU占用过高,常常达到49%(一个引擎)。但实际业务不是很忙。
目前操作系统为Solaris 8,两个CPU。磁盘采用SDS做RAID-1.
下面是sysmon 的输出。发现IO比较忙,很奇怪,是不是参数设置有问题。多谢帮忙.
1>; sp_sysmon "00:15:00"
2>; go
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/P/SWR 8774 ESD 1/Sun_svr
Server Name: Server is Unnamed
Run Date: Mar 02, 2004
Statistics Cleared at: 13:34:28
Statistics Sampled at: 13:49:28
Sample Interval: 00:15:00
===============================================================================
Kernel Utilization
------------------
Engine Busy Utilization
Engine 0 35.8 %
CPU Yields by Engine per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total CPU Yields 0.0 0.0 0 n/a
Network Checks
Non-Blocking 57216.7 4893.1 51495032 100.0 %
Blocking 14.7 1.3 13270 0.0 %
------------------------- ------------ ------------ ----------
Total Network I/O Checks 57231.4 4894.4 51508302
Avg Net I/Os per Check n/a n/a 0.00042 n/a
Disk I/O Checks
Total Disk I/O Checks 57231.4 4894.4 51508302 n/a
Checks Returning I/O 50527.6 4321.1 45474802 88.3 %
Avg Disk I/Os Returned n/a n/a 0.00033 n/a
===============================================================================
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 1 n/a
Task Context Switches by Engine
Engine 0 75.1 6.4 67557 100.0 %
Task Context Switches Due To:
Voluntary Yields 10.0 0.9 9007 13.3 %
Cache Search Misses 2.9 0.3 2643 3.9 %
System Disk Writes 0.1 0.0 105 0.2 %
I/O Pacing 2.3 0.2 2067 3.1 %
Logical Lock Contention 0.1 0.0 71 0.1 %
Address Lock Contention 0.0 0.0 0 0.0 %
Latch Contention 0.0 0.0 5 0.0 %
Log Semaphore Contention 1.0 0.1 865 1.3 %
PLC Lock Contention 0.0 0.0 14 0.0 %
Group Commit Sleeps 1.7 0.1 1540 2.3 %
Last Log Page Writes 8.6 0.7 7699 11.4 %
Modify Conflicts 1.2 0.1 1077 1.6 %
I/O Device Contention 0.0 0.0 0 0.0 %
Network Packet Received 9.8 0.8 8823 13.1 %
Network Packet Sent 14.1 1.2 12653 18.7 %
Other Causes 23.3 2.0 20988 31.1 %
===============================================================================
Application Management
----------------------
Application Statistics Summary (All Applications)
-------------------------------------------------
Priority Changes per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
To High Priority 1.0 0.1 943 18.8 %
To Medium Priority 2.8 0.2 2508 50.0 %
To Low Priority 1.7 0.1 1564 31.2 %
------------------------- ------------ ------------ ----------
Total Priority Changes 5.6 0.5 5015
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 %
Low Priority 0.0 0.0 0 0.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 9.0 0.8 8087 89.9 %
Dirty 1.0 0.1 913 10.1 %
------------ ------------ ----------
Total Washes 10.0 0.9 9000
Garbage Collections 1.2 0.1 1095 n/a
Pages Processed in GC 0.0 0.0 44 n/a
Statistics Updates 1.2 0.1 1095 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 11.7 n/a 10524 n/a
Transaction Detail per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Inserts
APL Heap Table 0.1 0.0 97 4.2 %
APL Clustered Table 0.0 0.0 8 0.3 %
Data Only Lock Table 2.4 0.2 2187 95.4 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Inserted 2.5 0.2 2292 19.9 %
Updates
APL Deferred 0.0 0.0 0 0.0 %
APL Direct In-place 3.3 0.3 2988 37.7 %
APL Direct Cheap 0.0 0.0 0 0.0 %
APL Direct Expensive 0.0 0.0 0 0.0 %
DOL Deferred 0.6 0.0 510 6.4 %
DOL Direct 4.9 0.4 4437 55.9 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Updated 8.8 0.8 7935 69.0 %
Data Only Locked Updates
DOL Replace 4.6 0.4 4143 83.7 %
DOL Shrink 0.0 0.0 0 0.0 %
DOL Cheap Expand 0.1 0.0 93 1.9 %
DOL Expensive Expand 0.8 0.1 711 14.4 %
DOL Expand & Forward 0.0 0.0 0 0.0 %
DOL Fwd Row Returned 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total DOL Rows Updated 5.5 0.5 4947 43.0 %
Deletes
APL Deferred 0.0 0.0 0 0.0 %
APL Direct 0.0 0.0 2 0.2 %
DOL 1.4 0.1 1268 99.8 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Deleted 1.4 0.1 1270 11.0 %
========================= ============ ============ ==========
Total Rows Affected 12.8 1.1 11497
===============================================================================
Transaction Management
----------------------
ULC Flushes to Xact Log per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
by Full ULC 0.0 0.0 1 0.0 %
by End Transaction 9.7 0.8 8768 71.9 %
by Change of Database 0.0 0.0 15 0.1 %
by System Log Record 0.1 0.0 91 0.7 %
by Other 3.7 0.3 3314 27.2 %
------------------------- ------------ ------------ ----------
Total ULC Flushes 13.5 1.2 12189
ULC Log Records 41.3 3.5 37144 n/a
Max ULC Size During Sample n/a n/a 2004 n/a
ULC Semaphore Requests
Granted 103.1 8.8 92756 100.0 %
Waited 0.0 0.0 14 0.0 %
------------------------- ------------ ------------ ----------
Total ULC Semaphore Req 103.1 8.8 92770
Log Semaphore Requests
Granted 14.3 1.2 12896 93.7 %
Waited 1.0 0.1 865 6.3 %
------------------------- ------------ ------------ ----------
Total Log Semaphore Req 15.3 1.3 13761
Transaction Log Writes 10.3 0.9 9273 n/a
Transaction Log Alloc 1.7 0.1 1559 n/a
Avg # Writes per Log Page n/a n/a 5.94804 n/a
===============================================================================
Index Management
----------------
Nonclustered Maintenance per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Ins/Upd Requiring Maint 0.0 0.0 0 n/a
# of NC Ndx Maint 0.0 0.0 0 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 6.9 0.6 6215 n/a
# of DOL Ndx Maint 2.0 0.2 1806 n/a
Avg DOL Ndx Maint / Op n/a n/a 0.29059 n/a
Page Splits 0.0 0.0 15 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 8 n/a
Index Scans per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Ascending Scans 9.9 0.8 8931 34.4 %
DOL Ascending Scans 18.9 1.6 17004 65.4 %
Descending Scans 0.1 0.0 61 0.2 %
DOL Descending Scans 0.0 0.0 0 0.0 %
------------ ------------ ----------
Total Scans 28.9 2.5 25996
===============================================================================
Metadata Cache Management
-------------------------
Metadata Cache Summary per sec per xact count % of total
------------------------ ------------ ------------ ---------- ----------
Open Object Usage
Active 0.4 0.0 375 n/a
Max Ever Used Since Boot 0.4 0.0 381 n/a
Free 0.1 0.0 125 n/a
Reuse Requests
Succeeded 0.0 0.0 0 n/a
Failed 0.0 0.0 0 n/a
Open Index Usage
Active 0.1 0.0 92 n/a
Max Ever Used Since Boot 0.1 0.0 98 n/a
Free 0.5 0.0 408 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.0 0.0 9 n/a
Max Ever Used Since Boot 0.0 0.0 9 n/a
Free 0.0 0.0 3 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 63.9 5.5 57542 n/a
Avg Lock Contention 0.1 0.0 71 0.1 %
Deadlock Percentage 0.0 0.0 0 0.0 %
Lock Hashtable Lookups 66.7 5.7 60055 n/a
Avg Hash Chain Length n/a n/a 0.00043 n/a
Lock Detail per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Exclusive Table
Total EX-Table Requests 0.0 0.0 0 n/a
Shared Table
Granted 0.0 0.0 6 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Table Requests 0.0 0.0 6 0.0 %
Exclusive Intent
Granted 16.8 1.4 15097 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Intent Requests 16.8 1.4 15097 26.2 %
Shared Intent
Granted 17.3 1.5 15546 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Intent Requests 17.3 1.5 15546 27.0 %
Exclusive Page
Granted 3.4 0.3 3102 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Page Requests 3.4 0.3 3102 5.4 %
Update Page
Granted 3.3 0.3 2945 98.3 %
Waited 0.1 0.0 50 1.7 %
------------------------- ------------ ------------ ---------- ----------
Total UP-Page Requests 3.3 0.3 2995 5.2 %
Shared Page
Granted 4.3 0.4 3865 99.7 %
Waited 0.0 0.0 10 0.3 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Page Requests 4.3 0.4 3875 6.7 %
Exclusive Row
Granted 10.1 0.9 9099 99.9 %
Waited 0.0 0.0 6 0.1 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Row Requests 10.1 0.9 9105 15.8 %
Update Row
Granted 3.3 0.3 2984 99.9 %
Waited 0.0 0.0 4 0.1 %
------------------------- ------------ ------------ ---------- ----------
Total UP-Row Requests 3.3 0.3 2988 5.2 %
Shared Row
Granted 0.8 0.1 736 99.9 %
Waited 0.0 0.0 1 0.1 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Row Requests 0.8 0.1 737 1.3 %
Next-Key
Total Next-Key Requests 0.0 0.0 0 n/a
Exclusive Address
Granted 0.2 0.0 196 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Address Requests 0.2 0.0 196 0.3 %
Shared Address
Granted 4.3 0.4 3895 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Address Requests 4.3 0.4 3895 6.8 %
Last Page Locks on Heaps
Granted 0.1 0.0 97 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total Last Pg Locks 0.1 0.0 97 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 2 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
===============================================================================
Data Cache Management
---------------------
Cache Statistics Summary (All Caches)
-------------------------------------
per sec per xact count % of total
------------ ------------ ---------- ----------
Cache Search Summary
Total Cache Hits 5328.3 455.7 4795514 99.8 %
Total Cache Misses 10.6 0.9 9583 0.2 %
------------------------- ------------ ------------ ----------
Total Cache Searches 5339.0 456.6 4805097
Cache Turnover
Buffers Grabbed 3.9 0.3 3489 n/a
Buffers Grabbed Dirty 0.0 0.0 0 0.0 %
Cache Strategy Summary
Cached (LRU) Buffers 5322.5 455.2 4790272 100.0 %
Discarded (MRU) Buffers 0.0 0.0 0 0.0 %
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 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 1433.1 122.6 1289796 100.0 %
------------------------- ------------ ------------ ----------
Total APFs Requested 1433.1 122.6 1289796
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 0.0 %
Utilization n/a n/a n/a 100.0 %
Cache Searches
Cache Hits 5328.3 455.7 4795514 99.8 %
Found in Wash 8.8 0.8 7927 0.2 %
Cache Misses 10.6 0.9 9583 0.2 %
------------------------- ------------ ------------ ----------
Total Cache Searches 5339.0 456.6 4805097
Pool Turnover
2 Kb Pool
LRU Buffer Grab 3.9 0.3 3489 100.0 %
Grabbed Dirty 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Cache Turnover 3.9 0.3 3489
Buffer Wash Behavior
Statistics Not Available - No Buffers Entered Wash Section Yet
Cache Strategy
Cached (LRU) Buffers 5322.5 455.2 4790272 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
===============================================================================
Procedure Cache Management per sec per xact count % of total
--------------------------- ------------ ------------ ---------- ----------
Procedure Requests 20.7 1.8 18639 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 0.0 91 n/a
Pages Released 0.1 0.0 91 n/a
===============================================================================
Recovery Management
-------------------
Checkpoints per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
# of Normal Checkpoints 0.0 0.0 15 100.0 %
# of Free Checkpoints 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Checkpoints 0.0 0.0 15
Avg Time per Normal Chkpt 4.53333 seconds
===============================================================================
Disk I/O Management
-------------------
Max Outstanding I/Os per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Server n/a n/a 18 n/a
Engine 0 n/a n/a 18 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 16.8 1.4 15130
Completed Disk I/O's
Engine 0 16.8 1.4 15130 100.0 %
------------------------- ------------ ------------ ----------
Total Completed I/Os 16.8 1.4 15130
Device Activity Detail
----------------------
Device:
/opt/sybase/database/sybproc.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/datafile/vol11
devdata_s3 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 2.9 0.3 2643 45.8 %
Writes 3.5 0.3 3129 54.2 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 6.4 0.5 5772 38.1 %
Device Semaphore Granted 6.4 0.5 5772 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/opt/sybase/datafile/vol13
devlog_s7 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 10.3 0.9 9301 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 10.3 0.9 9301 61.5 %
Device Semaphore Granted 10.3 0.9 9301 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/opt/sybase/datafile/vol14
devdata_s4 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/datafile/vol15
tempdevdata_s12 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 21 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 21 0.1 %
Device Semaphore Granted 0.0 0.0 21 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/opt/sybase/datafile/vol16
tempdevlog_s13 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 1 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 1 0.0 %
Device Semaphore Granted 0.0 0.0 1 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/opt/sybase/datafile/vol17
devlog_s8 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/datafile/vol18
devdata_s5 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/datafile/vol19
devlog_s9 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/datafile/vol20
devdata_s6 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:
/users/sybase/datafile/vol21
vasdevlog_s10 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:
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.0 0.0 35 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 35 0.2 %
Device Semaphore Granted 0.0 0.0 35 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
===============================================================================
Network I/O Management
----------------------
Total Network I/O Requests 23.9 2.0 21476 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 9.8 0.8 8823 100.0 %
------------------------- ------------ ------------ ----------
Total TDS Packets Rec'd 9.8 0.8 8823
Total Bytes Received per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 954.6 81.6 859164 100.0 %
------------------------- ------------ ------------ ----------
Total Bytes Rec'd 954.6 81.6 859164
Avg Bytes Rec'd per Packet n/a n/a 97 n/a
-----------------------------------------------------------------------------
Total TDS Packets Sent per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 14.1 1.2 12653 100.0 %
------------------------- ------------ ------------ ----------
Total TDS Packets Sent 14.1 1.2 12653
Total Bytes Sent per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 3616.1 309.2 3254449 100.0 %
------------------------- ------------ ------------ ----------
Total Bytes Sent 3616.1 309.2 3254449
Avg Bytes Sent per Packet n/a n/a 257 n/a
=============================== End of Report =================================
(return status = 0) |
|