- 论坛徽章:
- 0
|
換了新的sybase server并將sybase11.92升到12.5,速度沒有提高卻反而下降了﹐到底是哪個參數沒調好﹐大家看下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.2/EBF 10752 ESD#1/P/NT
Server Name: Server is Unnamed
Run Date: Mar 16, 2004
Statistics Cleared at: 14:13:45
Statistics Sampled at: 14:23:45
Sample Interval: 00:10:00
===============================================================================
Kernel Utilization
------------------
Engine Busy Utilization
Engine 0 91.9 %
Engine 1 91.6 %
Engine 2 97.5 %
Engine 3 95.2 %
Engine 4 97.4 %
Engine 5 93.9 %
Engine 6 95.3 %
Engine 7 93.0 %
----------- --------------- ----------------
Summary Total 756.0 % Average 94.5 %
CPU Yields by Engine per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 20.7 4.0 12417 20.1 %
Engine 1 20.2 3.9 12128 19.6 %
Engine 2 5.9 1.1 3527 5.7 %
Engine 3 10.1 2.0 6058 9.8 %
Engine 4 5.1 1.0 3076 5.0 %
Engine 5 14.9 2.9 8964 14.5 %
Engine 6 10.9 2.1 6527 10.6 %
Engine 7 15.1 2.9 9074 14.7 %
------------------------- ------------ ------------ ----------
Total CPU Yields 103.0 20.0 61771
Network Checks
Non-Blocking 75962.8 14783.6 45577698 99.7 %
Blocking 205.7 40.0 123444 0.3 %
------------------------- ------------ ------------ ----------
Total Network I/O Checks 76168.6 14823.6 45701142
Avg Net I/Os per Check n/a n/a 0.00610 n/a
Disk I/O Checks
Total Disk I/O Checks 49800.8 9692.0 29880482 n/a
Checks Returning I/O 27027.6 5260.0 16216580 54.3 %
Avg Disk I/Os Returned n/a n/a 0.01081 n/a
Tuning Recommendations for Kernel Utilization
---------------------------------------------
- Consider bringing more engines online
===============================================================================
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
Tuning Recommendations for Worker Processes
-------------------------------------------
- Consider decreasing the 'number of worker processes'
configuration parameter.
===============================================================================
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.6 0.1 342 n/a
Task Context Switches by Engine
Engine 0 80.9 15.7 48549 13.0 %
Engine 1 72.9 14.2 43750 11.7 %
Engine 2 78.2 15.2 46923 12.6 %
Engine 3 70.6 13.7 42389 11.4 %
Engine 4 86.8 16.9 52055 13.9 %
Engine 5 73.0 14.2 43819 11.7 %
Engine 6 72.6 14.1 43575 11.7 %
Engine 7 86.9 16.9 52150 14.0 %
------------------------- ------------ ------------ ----------
Total Task Switches: 622.0 121.1 373210
Task Context Switches Due To:
Voluntary Yields 36.8 7.2 22074 5.9 %
Cache Search Misses 127.2 24.8 76313 20.4 %
System Disk Writes 0.2 0.0 142 0.0 %
I/O Pacing 16.6 3.2 9948 2.7 %
Logical Lock Contention 0.1 0.0 87 0.0 %
Address Lock Contention 0.0 0.0 0 0.0 %
Latch Contention 0.0 0.0 23 0.0 %
Log Semaphore Contention 0.1 0.0 84 0.0 %
PLC Lock Contention 0.0 0.0 0 0.0 %
Group Commit Sleeps 0.4 0.1 235 0.1 %
Last Log Page Writes 3.6 0.7 2173 0.6 %
Modify Conflicts 3.8 0.7 2297 0.6 %
I/O Device Contention 5.0 1.0 3010 0.8 %
Network Packet Received 206.9 40.3 124110 33.3 %
Network Packet Sent 257.4 50.1 154461 41.4 %
Other Causes -36.2 -7.1 -21747 -5.8 %
===============================================================================
Application Management
----------------------
Application Statistics Summary (All Applications)
-------------------------------------------------
Priority Changes per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
To High Priority 0.3 0.1 197 1.9 %
To Medium Priority 8.8 1.7 5266 51.7 %
To Low Priority 7.9 1.5 4727 46.4 %
------------------------- ------------ ------------ ----------
Total Priority Changes 17.0 3.3 10190
Allotted Slices Exhausted per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
High Priority 0.0 0.0 0 0.0 %
Medium Priority 38.7 7.5 23230 100.0 %
Low Priority 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Slices Exhausted 38.7 7.5 23230
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 21.5 4.2 12894 63.3 %
Dirty 12.5 2.4 7481 36.7 %
------------ ------------ ----------
Total Washes 34.0 6.6 20375
Garbage Collections 2.1 0.4 1263 n/a
Pages Processed in GC 0.0 0.0 2 n/a
Statistics Updates 2.1 0.4 1263 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 5.1 n/a 3083 n/a
Transaction Detail per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Inserts
APL Heap Table 2692.5 524.0 1615487 94.7 %
APL Clustered Table 149.0 29.0 89371 5.2 %
Data Only Lock Table 2.5 0.5 1491 0.1 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Inserted 2843.9 553.5 1706349 96.4 %
Updates
APL Deferred 8.6 1.7 5147 9.4 %
APL Direct In-place 36.2 7.1 21739 39.8 %
APL Direct Cheap 43.8 8.5 26291 48.1 %
APL Direct Expensive 0.0 0.0 20 0.0 %
DOL Deferred 0.2 0.0 114 0.2 %
DOL Direct 2.2 0.4 1293 2.4 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Updated 91.0 17.7 54604 3.1 %
Data Only Locked Updates
DOL Replace 1.9 0.4 1135 80.7 %
DOL Shrink 0.0 0.0 6 0.4 %
DOL Cheap Expand 0.1 0.0 38 2.7 %
DOL Expensive Expand 0.3 0.1 207 14.7 %
DOL Expand & Forward 0.0 0.0 21 1.5 %
DOL Fwd Row Returned 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total DOL Rows Updated 2.3 0.5 1407 0.1 %
Deletes
APL Deferred 5.7 1.1 3397 39.6 %
APL Direct 7.3 1.4 4351 50.7 %
DOL 1.4 0.3 831 9.7 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Deleted 14.3 2.8 8579 0.5 %
========================= ============ ============ ==========
Total Rows Affected 2949.2 574.0 1769532
===============================================================================
Transaction Management
----------------------
ULC Flushes to Xact Log per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
by Full ULC 5.0 1.0 2984 20.5 %
by End Transaction 3.9 0.8 2337 16.1 %
by Change of Database 0.1 0.0 36 0.2 %
by Single Log Record 11.4 2.2 6853 47.1 %
by Other 3.9 0.8 2349 16.1 %
------------------------- ------------ ------------ ----------
Total ULC Flushes 24.3 4.7 14559
ULC Log Records 207.3 40.4 124400 n/a
Max ULC Size During Sample n/a n/a 4096 n/a
ULC Semaphore Requests
Granted 410.9 80.0 246566 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total ULC Semaphore Req 410.9 80.0 246566
Log Semaphore Requests
Granted 27.0 5.2 16178 99.5 %
Waited 0.1 0.0 84 0.5 %
------------------------- ------------ ------------ ----------
Total Log Semaphore Req 27.1 5.3 16262
Transaction Log Writes 22.4 4.4 13412 n/a
Transaction Log Alloc 18.7 3.6 11224 n/a
Avg # Writes per Log Page n/a n/a 1.19494 n/a
===============================================================================
Index Management
----------------
Nonclustered Maintenance per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Ins/Upd Requiring Maint 1.1 0.2 659 n/a
# of NC Ndx Maint 0.9 0.2 533 n/a
Avg NC Ndx Maint / Op n/a n/a 0.80880 n/a
Deletes Requiring Maint 0.6 0.1 368 n/a
# of NC Ndx Maint 0.4 0.1 220 n/a
Avg NC Ndx Maint / Op n/a n/a 0.59783 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 3.7 0.7 2238 n/a
# of DOL Ndx Maint 3.6 0.7 2177 n/a
Avg DOL Ndx Maint / Op n/a n/a 0.97274 n/a
Page Splits 0.2 0.0 103 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 24 n/a
Deadlocks %
Deadlock Retries Exceeded 0.0 0.0 0 0.0 %
Index Scans per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Ascending Scans 6621.4 1288.6 3972827 93.2 %
DOL Ascending Scans 481.1 93.6 288645 6.8 %
Descending Scans 0.8 0.2 497 0.0 %
DOL Descending Scans 0.0 0.0 3 0.0 %
------------ ------------ ----------
Total Scans 7103.3 1382.4 4261972
===============================================================================
Metadata Cache Management
-------------------------
Metadata Cache Summary per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Open Object Usage
Active n/a n/a 2256 n/a
Max Ever Used Since Boot n/a n/a 2260 n/a
Free n/a n/a 7744 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 4881 n/a
Max Ever Used Since Boot n/a n/a 4903 n/a
Free n/a n/a 10119 n/a
Reuse Requests
Succeeded n/a n/a 0 n/a
Failed n/a n/a 0 n/a
Open Database Usage
Active n/a n/a 6 n/a
Max Ever Used Since Boot n/a n/a 6 n/a
Free n/a n/a 6 n/a
Reuse Requests
Succeeded n/a n/a 0 n/a
Failed n/a n/a 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 13384.1 2604.8 8030447 n/a
Avg Lock Contention 0.1 0.0 87 0.0 %
Deadlock Percentage 0.0 0.0 0 0.0 %
Lock Detail per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Table Lock Hashtable
Lookups 569.8 110.9 341886 n/a
Avg Chain Length n/a n/a 0.03087 n/a
Spinlock Contention n/a n/a n/a 0.0 %
Exclusive Table
Granted 5.5 1.1 3301 99.1 %
Waited 0.0 0.0 29 0.9 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Table Requests 5.6 1.1 3330 0.0 %
Shared Table
Granted 3.0 0.6 1780 99.3 %
Waited 0.0 0.0 13 0.7 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Table Requests 3.0 0.6 1793 0.0 %
Exclusive Intent
Granted 5.6 1.1 3336 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Intent Requests 5.6 1.1 3336 0.0 %
Shared Intent
Granted 552.6 107.5 331545 100.0 %
Waited 0.0 0.0 20 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Intent Requests 552.6 107.5 331565 4.1 %
Page & Row Lock HashTable
Lookups 9682.8 1884.4 5809659 n/a
Avg Chain Length n/a n/a 0.00923 n/a
Spinlock Contention n/a n/a n/a 0.0 %
Exclusive Page
Granted 4.2 0.8 2512 99.6 %
Waited 0.0 0.0 11 0.4 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Page Requests 4.2 0.8 2523 0.0 %
Update Page
Granted 5.4 1.0 3226 99.7 %
Waited 0.0 0.0 9 0.3 %
------------------------- ------------ ------------ ---------- ----------
Total UP-Page Requests 5.4 1.0 3235 0.0 %
Shared Page
Granted 1184.9 230.6 710943 100.0 %
Waited 0.0 0.0 5 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Page Requests 1184.9 230.6 710948 8.9 %
Exclusive Row
Granted 5.5 1.1 3316 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Row Requests 5.5 1.1 3316 0.0 %
Update Row
Granted 1.5 0.3 899 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total UP-Row Requests 1.5 0.3 899 0.0 %
Shared Row
Granted 8457.3 1645.9 5074392 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Row Requests 8457.3 1645.9 5074392 63.2 %
Next-Key
Total Next-Key Requests 0.0 0.0 0 n/a
Address Lock Hashtable
Lookups 3158.5 614.7 1895105 n/a
Avg Chain Length n/a n/a 0.00002 n/a
Spinlock Contention n/a n/a n/a 0.0 %
Exclusive Address
Granted 13.4 2.6 8060 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Address Requests 13.4 2.6 8060 0.1 %
Shared Address
Granted 3145.1 612.1 1887050 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Address Requests 3145.1 612.1 1887050 23.5 %
Last Page Locks on Heaps
Granted 2692.5 524.0 1615512 100.0 %
Waited 0.0 0.0 11 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total Last Pg Locks 2692.5 524.0 1615523 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 3 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 93491.8 18195.0 56095056 99.6 %
Total Cache Misses 370.4 72.1 222229 0.4 %
------------------------- ------------ ------------ ----------
Total Cache Searches 93862.1 18267.0 56317285
Cache Turnover
Buffers Grabbed 382.7 74.5 229600 n/a
Buffers Grabbed Dirty 0.0 0.0 0 0.0 %
Cache Strategy Summary
Cached (LRU) Buffers 81525.9 15866.2 48915554 87.1 %
Discarded (MRU) Buffers 12025.0 2340.2 7214990 12.9 %
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 3.9 0.8 2335 0.1 %
APFs Denied Due To
APF I/O Overloads 0.0 0.0 10 0.0 %
APF Limit Overloads 65.6 12.8 39338 1.9 %
APF Reused Overloads 0.1 0.0 41 0.0 %
APF Buffers Found in Cache
With Spinlock Held 0.0 0.0 0 0.0 %
W/o Spinlock Held 3351.1 652.2 2010654 98.0 %
------------------------- ------------ ------------ ----------
Total APFs Requested 3420.6 665.7 2052378
Other Asynchronous Prefetch Statistics
APFs Used 3.8 0.7 2277 n/a
APF Waits for I/O 2.3 0.5 1403 n/a
APF Discards 0.0 0.0 0 n/a
Dirty Read Behavior
Page Requests 13637.9 2654.1 8182738 n/a
-------------------------------------------------------------------------------
Cache: default data cache
per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Spinlock Contention n/a n/a n/a 93.0 %
Utilization n/a n/a n/a 87.1 %
Cache Searches
Cache Hits 81624.0 15885.3 48974383 99.8 %
Found in Wash 101.1 19.7 60682 0.1 %
Cache Misses 132.7 25.8 79628 0.2 %
------------------------- ------------ ------------ ----------
Total Cache Searches 81756.7 15911.1 49054011
Pool Turnover
2 Kb Pool
LRU Buffer Grab 242.9 47.3 145742 100.0 %
Grabbed Dirty 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Cache Turnover 242.9 47.3 145742
Buffer Wash Behavior
Buffers Passed Clean 79.6 15.5 47780 100.0 %
Buffers Already in I/O 0.0 0.0 0 0.0 %
Buffers Washed Dirty 0.0 0.0 0 0.0 %
Cache Strategy
Cached (LRU) Buffers 69663.9 13557.7 41798320 85.3 %
Discarded (MRU) Buffers 12025.0 2340.2 7214990 14.7 %
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 13624.6 2651.6 8174730 n/a
Tuning Recommendations for Data cache : default data cache
-------------------------------------
- Consider using 'relaxed LRU replacement policy'
for this cache.
- Consider adding a large I/O pool for this cache.
- Consider using Named Caches or Cache partitions or both.
-------------------------------------------------------------------------------
Cache: tempdb_cache
per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Spinlock Contention n/a n/a n/a 7.0 %
Utilization n/a n/a n/a 12.9 %
Cache Searches
Cache Hits 11867.8 2309.7 7120673 98.0 %
Found in Wash 33.8 6.6 20252 0.3 %
Cache Misses 237.7 46.3 142601 2.0 %
------------------------- ------------ ------------ ----------
Total Cache Searches 12105.5 2355.9 7263274
Pool Turnover
2 Kb Pool
LRU Buffer Grab 139.8 27.2 83858 100.0 %
Grabbed Dirty 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Cache Turnover 139.8 27.2 83858
Buffer Wash Behavior
Statistics Not Available - No Buffers Entered Wash Section Yet
Cache Strategy
Cached (LRU) Buffers 11862.1 2308.5 7117234 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 13.3 2.6 8008 n/a
Tuning Recommendations for Data cache : tempdb_cache
-------------------------------------
- Consider using 'relaxed LRU replacement policy'
for this cache.
- Consider adding a large I/O pool for this cache.
===============================================================================
Procedure Cache Management per sec per xact count % of total
--------------------------- ------------ ------------ ---------- ----------
Procedure Requests 2.1 0.4 1241 n/a
Procedure Reads from Disk 0.1 0.0 45 3.6 %
Procedure Writes to Disk 0.0 0.0 3 0.2 %
Procedure Removals 0.1 0.0 80 n/a
===============================================================================
Memory Management per sec per xact count % of total
--------------------------- ------------ ------------ ---------- ----------
Pages Allocated 0.4 0.1 256 n/a
Pages Released 0.4 0.1 255 n/a
===============================================================================
Recovery Management
-------------------
Checkpoints per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
# of Normal Checkpoints 0.0 0.0 14 100.0 %
# of Free Checkpoints 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Checkpoints 0.0 0.0 14
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 58 n/a
Engine 0 n/a n/a 20 n/a
Engine 1 n/a n/a 20 n/a
Engine 2 n/a n/a 13 n/a
Engine 3 n/a n/a 21 n/a
Engine 4 n/a n/a 20 n/a
Engine 5 n/a n/a 21 n/a
Engine 6 n/a n/a 12 n/a
Engine 7 n/a n/a 23 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 292.2 56.9 175311
Completed Disk I/O's
Engine 0 26.8 5.2 16064 9.2 %
Engine 1 25.4 4.9 15235 8.7 %
Engine 2 35.1 6.8 21031 12.0 %
Engine 3 36.4 7.1 21833 12.5 %
Engine 4 62.5 12.2 37486 21.4 %
Engine 5 28.7 5.6 17195 9.8 %
Engine 6 29.2 5.7 17511 10.0 %
Engine 7 48.2 9.4 28944 16.5 %
------------------------- ------------ ------------ ----------
Total Completed I/Os 292.2 56.9 175299
Device Activity Detail
----------------------
Device:
E:\temp_data1
temp_data1 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.2 0.0 94 0.1 %
Writes 133.8 26.0 80272 99.9 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 133.9 26.1 80366 45.8 %
Device Semaphore Granted 131.7 25.6 79030 96.7 %
Device Semaphore Waited 4.5 0.9 2680 3.3 %
-----------------------------------------------------------------------------
Device:
E:\wldb_data1
wldb_data1 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.6 0.1 347 1.7 %
Non-APF 32.7 6.4 19636 97.2 %
Writes 0.4 0.1 229 1.1 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 33.7 6.6 20212 11.5 %
Device Semaphore Granted 33.5 6.5 20088 99.4 %
Device Semaphore Waited 0.2 0.0 131 0.6 %
-----------------------------------------------------------------------------
Device:
E:\wldb_data2
wldb_data2 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:
E:\wldb_data3
wldb_data3 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 1.0 0.2 605 5.5 %
Non-APF 17.1 3.3 10245 92.4 %
Writes 0.4 0.1 242 2.2 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 18.5 3.6 11092 6.3 %
Device Semaphore Granted 18.5 3.6 11070 99.8 %
Device Semaphore Waited 0.0 0.0 23 0.2 %
-----------------------------------------------------------------------------
Device:
E:\wldb_data4
wldb_data4 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.3 0.0 151 2.3 %
Non-APF 10.3 2.0 6176 95.8 %
Writes 0.2 0.0 123 1.9 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 10.8 2.1 6450 3.7 %
Device Semaphore Granted 10.7 2.1 6440 99.8 %
Device Semaphore Waited 0.0 0.0 10 0.2 %
-----------------------------------------------------------------------------
Device:
E:\wldb_data5
wldb_data5 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.9 0.2 510 3.1 %
Non-APF 26.7 5.2 16016 96.1 %
Writes 0.2 0.0 135 0.8 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 27.8 5.4 16661 9.5 %
Device Semaphore Granted 27.6 5.4 16577 99.5 %
Device Semaphore Waited 0.1 0.0 85 0.5 %
-----------------------------------------------------------------------------
Device:
E:\wldb_data6
wldb_data6 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 1.2 0.2 742 64.3 %
Writes 0.7 0.1 412 35.7 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 1.9 0.4 1154 0.7 %
Device Semaphore Granted 1.9 0.4 1154 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
F:\temp_log1
temp_log1 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.1 0.0 40 0.3 %
Writes 19.7 3.8 11824 99.7 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 19.8 3.8 11864 6.8 %
Device Semaphore Granted 19.8 3.8 11855 99.8 %
Device Semaphore Waited 0.0 0.0 18 0.2 %
-----------------------------------------------------------------------------
Device:
F:\wldb_log1
wldb_log1 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 1.2 0.2 710 3.6 %
Non-APF 31.3 6.1 18805 95.6 %
Writes 0.3 0.0 151 0.8 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 32.8 6.4 19666 11.2 %
Device Semaphore Granted 32.7 6.4 19609 99.7 %
Device Semaphore Waited 0.1 0.0 58 0.3 %
-----------------------------------------------------------------------------
Device:
F:\wldb_log2
wldb_log2 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 12 0.3 %
Non-APF 7.5 1.5 4528 96.5 %
Writes 0.3 0.0 152 3.2 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 7.8 1.5 4692 2.7 %
Device Semaphore Granted 7.8 1.5 4691 100.0 %
Device Semaphore Waited 0.0 0.0 1 0.0 %
-----------------------------------------------------------------------------
Device:
F:\wldb_log3
wldb_log3 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 4 0.2 %
Writes 2.8 0.5 1679 99.8 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 2.8 0.5 1683 1.0 %
Device Semaphore Granted 2.8 0.5 1681 99.8 %
Device Semaphore Waited 0.0 0.0 4 0.2 %
-----------------------------------------------------------------------------
Device:
c:\sybase\data\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 10 0.7 %
Writes 2.4 0.5 1437 99.3 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 2.4 0.5 1447 0.8 %
Device Semaphore Granted 2.4 0.5 1447 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
c:\sybase\data\sybprocs.dat
sysprocsdev per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 17 100.0 %
Writes 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 17 0.0 %
Device Semaphore Granted 0.0 0.0 17 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
===============================================================================
Network I/O Management
----------------------
Total Network I/O Requests 463.6 90.2 278140 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 31.4 6.1 18852 15.2 %
Engine 1 28.3 5.5 16952 13.7 %
Engine 2 23.3 4.5 14009 11.3 %
Engine 3 23.8 4.6 14299 11.5 %
Engine 4 24.0 4.7 14406 11.6 %
Engine 5 24.8 4.8 14880 12.0 %
Engine 6 22.8 4.4 13681 11.0 %
Engine 7 28.4 5.5 17031 13.7 %
------------------------- ------------ ------------ ----------
Total TDS Packets Rec'd 206.9 40.3 124110
Total Bytes Received per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 3227.6 628.1 1936564 14.3 %
Engine 1 3026.3 589.0 1815770 13.4 %
Engine 2 2817.3 548.3 1690402 12.5 %
Engine 3 2531.6 492.7 1518967 11.2 %
Engine 4 2731.9 531.7 1639121 12.1 %
Engine 5 2691.7 523.8 1615020 11.9 %
Engine 6 2665.9 518.8 1599560 11.8 %
Engine 7 2913.0 566.9 1747817 12.9 %
------------------------- ------------ ------------ ----------
Total Bytes Rec'd 22605.4 4399.4 13563221
Avg Bytes Rec'd per Packet n/a n/a 109 n/a
-----------------------------------------------------------------------------
Total TDS Packets Sent per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 36.7 7.1 22026 14.3 %
Engine 1 31.7 6.2 19046 12.3 %
Engine 2 31.0 6.0 18615 12.1 %
Engine 3 28.3 5.5 16991 11.0 %
Engine 4 29.0 5.6 17402 11.3 %
Engine 5 29.4 5.7 17650 11.4 %
Engine 6 29.7 5.8 17790 11.5 %
Engine 7 41.6 8.1 24950 16.2 %
------------------------- ------------ ------------ ----------
Total TDS Packets Sent 257.5 50.1 154470
Total Bytes Sent per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 6239.9 1214.4 3743962 13.7 %
Engine 1 5714.6 1112.2 3428776 12.5 %
Engine 2 6049.2 1177.3 3629546 13.3 %
Engine 3 5031.6 979.2 3018959 11.0 %
Engine 4 5360.7 1043.3 3216415 11.7 %
Engine 5 5775.2 1124.0 3465138 12.7 %
Engine 6 5243.7 1020.5 3146228 11.5 %
Engine 7 6217.5 1210.0 3730472 13.6 %
------------------------- ------------ ------------ ----------
Total Bytes Sent 45632.5 8880.8 27379496
Avg Bytes Sent per Packet n/a n/a 177 n/a
=============================== End of Report =================================
(1 row affected)
(return status = 0) |
|
免费注册
发表于 2004-03-16 14:58
