- 论坛徽章:
- 0
|
'housekeeper free write percent'多少合适?
这玩意太长,怕大家不愿意看,服务器配置太高,呵呵
DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.
===============================================================================
Sybase Adaptive Server Enterprise System Performance Report
===============================================================================
Server Version: Adaptive Server Enterprise/12.5.0.3/EBF 11442 ESD#4/P/Su
Server Name: SYBASE1
Run Date: Dec 15, 2004
Statistics Cleared at: 09:28:13
Statistics Sampled at: 09:48:14
Sample Interval: 00:20:00
===============================================================================
Kernel Utilization
------------------
Your Runnable Process Search Count is set to 1000
and I/O Polling Process Count is set to 10
Engine Busy Utilization CPU Busy I/O Busy Idle
------------------------ -------- -------- --------
Engine 0 4.7 % 0.5 % 94.8 %
Engine 1 14.4 % 0.8 % 84.9 %
Engine 2 13.2 % 0.6 % 86.2 %
Engine 3 10.9 % 0.6 % 88.5 %
Engine 4 14.0 % 0.6 % 85.4 %
Engine 5 11.5 % 0.8 % 87.7 %
Engine 6 7.4 % 0.4 % 92.1 %
Engine 7 10.5 % 0.8 % 88.7 %
Engine 8 10.8 % 0.5 % 88.7 %
Engine 9 9.5 % 0.4 % 90.1 %
------------------------ -------- -------- --------
Summary Total 106.9 % 6.0 % 887.1 %
Average 10.7 % 0.6 % 88.7 %
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 102780.4 9756.1 123336531 99.5 %
Blocking 498.8 47.4 598602 0.5 %
------------------------- ------------ ------------ ----------
Total Network I/O Checks 103279.3 9803.4 123935133
Avg Net I/Os per Check n/a n/a 0.00382 n/a
Disk I/O Checks
Total Disk I/O Checks 103648.2 9838.5 124377811 n/a
Checks Returning I/O 8284.2 786.4 9941092 8.0 %
Avg Disk I/Os Returned n/a n/a 0.01274 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 50 n/a
Task Context Switches by Engine
Engine 0 29.5 2.8 35459 5.6 %
Engine 1 65.2 6.2 78292 12.3 %
Engine 2 69.4 6.6 83339 13.1 %
Engine 3 54.0 5.1 64788 10.2 %
Engine 4 66.0 6.3 79221 12.4 %
Engine 5 62.5 5.9 74948 11.7 %
Engine 6 37.6 3.6 45098 7.1 %
Engine 7 52.6 5.0 63096 9.9 %
Engine 8 43.5 4.1 52149 8.2 %
Engine 9 51.5 4.9 61803 9.7 %
------------------------- ------------ ------------ ----------
Total Task Switches: 531.8 50.5 638193
Task Context Switches Due To:
Voluntary Yields 19.1 1.8 22934 3.6 %
Cache Search Misses 0.1 0.0 79 0.0 %
System Disk Writes 4.0 0.4 4755 0.7 %
I/O Pacing 12.1 1.1 14472 2.3 %
Logical Lock Contention 0.2 0.0 276 0.0 %
Address Lock Contention 0.0 0.0 0 0.0 %
Latch Contention 0.0 0.0 5 0.0 %
Log Semaphore Contention 0.0 0.0 45 0.0 %
PLC Lock Contention 0.0 0.0 3 0.0 %
Group Commit Sleeps 0.0 0.0 22 0.0 %
Last Log Page Writes 6.2 0.6 7432 1.2 %
Modify Conflicts 0.1 0.0 93 0.0 %
I/O Device Contention 0.0 0.0 0 0.0 %
Network Packet Received 185.4 17.6 222436 34.9 %
Network Packet Sent 209.5 19.9 251383 39.4 %
Other Causes 95.2 9.0 114258 17.9 %
===============================================================================
Application Management
----------------------
Application Statistics Summary (All Applications)
-------------------------------------------------
Priority Changes per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
To High Priority 0.3 0.0 333 1.2 %
To Medium Priority 11.4 1.1 13690 50.1 %
To Low Priority 11.1 1.1 13310 48.7 %
------------------------- ------------ ------------ ----------
Total Priority Changes 22.8 2.2 27333
Allotted Slices Exhausted per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
High Priority 0.0 0.0 3 0.1 %
Medium Priority 3.9 0.4 4722 99.8 %
Low Priority 0.0 0.0 8 0.2 %
------------------------- ------------ ------------ ----------
Total Slices Exhausted 3.9 0.4 4733
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 456.8 43.4 548200 93.1 %
Dirty 33.7 3.2 40454 6.9 %
------------ ------------ ----------
Total Washes 490.5 46.6 588654
Garbage Collections 2.1 0.2 2520 n/a
Pages Processed in GC 0.0 0.0 0 n/a
Statistics Updates 2.4 0.2 2910 n/a
Tuning Recommendations for Housekeeper
--------------------------------------
- Consider increasing the 'housekeeper free write percent'
configuration parameter.
===============================================================================
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 10.5 n/a 12642 n/a
Transaction Detail per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Inserts
APL Heap Table 137.9 13.1 165525 45.1 %
APL Clustered Table 166.0 15.8 199194 54.3 %
Data Only Lock Table 1.8 0.2 2167 0.6 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Inserted 305.7 29.0 366886 59.5 %
Updates
APL Deferred 7.7 0.7 9240 10.8 %
APL Direct In-place 42.2 4.0 50683 59.0 %
APL Direct Cheap 20.6 2.0 24729 28.8 %
APL Direct Expensive 0.0 0.0 2 0.0 %
DOL Deferred 0.1 0.0 139 0.2 %
DOL Direct 0.9 0.1 1038 1.2 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Updated 71.5 6.8 85831 13.9 %
Data Only Locked Updates
DOL Replace 1.0 0.1 1168 99.2 %
DOL Shrink 0.0 0.0 6 0.5 %
DOL Cheap Expand 0.0 0.0 0 0.0 %
DOL Expensive Expand 0.0 0.0 3 0.3 %
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 1.0 0.1 1177 0.2 %
Deletes
APL Deferred 97.8 9.3 117323 71.6 %
APL Direct 37.3 3.5 44755 27.3 %
DOL 1.4 0.1 1694 1.0 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Deleted 136.5 13.0 163772 26.6 %
========================= ============ ============ ==========
Total Rows Affected 513.7 48.8 616489
===============================================================================
Transaction Management
----------------------
ULC Flushes to Xact Log per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
by Full ULC 2.0 0.2 2393 2.8 %
by End Transaction 10.9 1.0 13085 15.3 %
by Change of Database 1.8 0.2 2217 2.6 %
by Single Log Record 53.8 5.1 64555 75.5 %
by Other 2.7 0.3 3254 3.8 %
------------------------- ------------ ------------ ----------
Total ULC Flushes 71.3 6.8 85504
ULC Log Records 627.4 59.6 752919 n/a
Max ULC Size During Sample n/a n/a 81920 n/a
ULC Semaphore Requests
Granted 1226.6 116.4 1471968 100.0 %
Waited 0.0 0.0 3 0.0 %
------------------------- ------------ ------------ ----------
Total ULC Semaphore Req 1226.6 116.4 1471971
Log Semaphore Requests
Granted 85.8 8.1 102970 100.0 %
Waited 0.0 0.0 45 0.0 %
------------------------- ------------ ------------ ----------
Total Log Semaphore Req 85.8 8.1 103015
Transaction Log Writes 35.7 3.4 42865 n/a
Transaction Log Alloc 59.3 5.6 71128 n/a
Avg # Writes per Log Page n/a n/a 0.60265 n/a
Tuning Recommendations for Transaction Management
-------------------------------------------------
- Consider decreasing the 'user log cache size'
configuration parameter if it is greater than the
logical database page size.
===============================================================================
Index Management
----------------
Nonclustered Maintenance per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Ins/Upd Requiring Maint 33.1 3.1 39733 n/a
# of NC Ndx Maint 16.2 1.5 19420 n/a
Avg NC Ndx Maint / Op n/a n/a 0.48876 n/a
Deletes Requiring Maint 28.6 2.7 34359 n/a
# of NC Ndx Maint 11.7 1.1 14046 n/a
Avg NC Ndx Maint / Op n/a n/a 0.40880 n/a
RID Upd from Clust Split 0.0 0.0 32 n/a
# of NC Ndx Maint 0.2 0.0 243 n/a
Avg NC Ndx Maint / Op n/a n/a 7.59375 n/a
Upd/Del DOL Req Maint 2.4 0.2 2871 n/a
# of DOL Ndx Maint 2.5 0.2 2971 n/a
Avg DOL Ndx Maint / Op n/a n/a 1.03483 n/a
Page Splits 0.4 0.0 424 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.1 0.0 92 n/a
Deadlocks %
Deadlock Retries Exceeded 0.0 0.0 0 0.0 %
Index Scans per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Ascending Scans 3251.1 308.6 3901344 83.4 %
DOL Ascending Scans 644.7 61.2 773669 16.5 %
Descending Scans 2.6 0.2 3127 0.1 %
DOL Descending Scans 0.0 0.0 0 0.0 %
------------ ------------ ----------
Total Scans 3898.5 370.0 4678140
===============================================================================
Metadata Cache Management
-------------------------
Metadata Cache Summary per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Open Object Usage
Active n/a n/a 27109 n/a
Max Ever Used Since Boot n/a n/a 30963 n/a
Free n/a n/a 62891 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 9729 n/a
Max Ever Used Since Boot n/a n/a 9965 n/a
Free n/a n/a 10271 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 11 n/a
Max Ever Used Since Boot n/a n/a 11 n/a
Free n/a n/a 9 n/a
Reuse Requests
Succeeded n/a n/a 0 n/a
Failed n/a n/a 0 n/a
Object Manager Spinlock Contention n/a n/a n/a 0.0 %
Object Spinlock Contention n/a n/a n/a 0.0 %
Index Spinlock Contention n/a n/a n/a 0.0 %
Hash Spinlock Contention n/a n/a n/a 0.0 %
===============================================================================
Lock Management
---------------
Lock Summary per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total Lock Requests 54301.0 5154.3 65161191 n/a
Avg Lock Contention 0.2 0.0 276 0.0 %
Deadlock Percentage 0.0 0.0 1 0.0 %
Lock Detail per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Table Lock Hashtable
Lookups 628.2 59.6 753876 n/a
Avg Chain Length n/a n/a 0.98675 n/a
Spinlock Contention n/a n/a n/a 0.0 %
Exclusive Table
Granted 27.7 2.6 33208 99.6 %
Waited 0.1 0.0 136 0.4 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Table Requests 27.8 2.6 33344 0.1 %
Shared Table
Granted 1.4 0.1 1682 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Table Requests 1.4 0.1 1682 0.0 %
Exclusive Intent
Granted 7.9 0.7 9464 99.9 %
Waited 0.0 0.0 7 0.1 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Intent Requests 7.9 0.7 9471 0.0 %
Shared Intent
Granted 575.2 54.6 690271 100.0 %
Waited 0.1 0.0 104 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Intent Requests 575.3 54.6 690375 1.1 %
Page & Row Lock HashTable
Lookups 49008.7 4652.0 58810428 n/a
Avg Chain Length n/a n/a 0.00674 n/a
Spinlock Contention n/a n/a n/a 0.0 %
Exclusive Page
Granted 76.4 7.3 91682 100.0 %
Waited 0.0 0.0 2 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Page Requests 76.4 7.3 91684 0.1 %
Update Page
Granted 70.2 6.7 84199 100.0 %
Waited 0.0 0.0 2 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total UP-Page Requests 70.2 6.7 84201 0.1 %
Shared Page
Granted 44508.1 4224.8 53409708 100.0 %
Waited 0.0 0.0 21 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Page Requests 44508.1 4224.8 53409729 82.0 %
Exclusive Row
Granted 4.6 0.4 5466 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Row Requests 4.6 0.4 5466 0.0 %
Update Row
Granted 1.3 0.1 1536 99.9 %
Waited 0.0 0.0 1 0.1 %
------------------------- ------------ ------------ ---------- ----------
Total UP-Row Requests 1.3 0.1 1537 0.0 %
Shared Row
Granted 4028.1 382.3 4833662 100.0 %
Waited 0.0 0.0 3 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Row Requests 4028.1 382.3 4833665 7.4 %
Next-Key
Total Next-Key Requests 0.0 0.0 0 n/a
Address Lock Hashtable
Lookups 5000.0 474.6 6000037 n/a
Avg Chain Length n/a n/a 0.00007 n/a
Spinlock Contention n/a n/a n/a 0.0 %
Exclusive Address
Granted 126.0 12.0 151181 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Address Requests 126.0 12.0 151181 0.2 %
Shared Address
Granted 4874.0 462.7 5848856 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Address Requests 4874.0 462.7 5848856 9.0 %
Last Page Locks on Heaps
Granted 137.9 13.1 165525 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total Last Pg Locks 137.9 13.1 165525 100.0 %
Deadlocks by Lock Type per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Exclusive Table 0.0 0.0 0 0.0 %
Shared Table 0.0 0.0 0 0.0 %
Exclusive Intent 0.0 0.0 0 0.0 %
Shared Intent 0.0 0.0 0 0.0 %
Exclusive Page 0.0 0.0 1 100.0 %
Update Page 0.0 0.0 0 0.0 %
Shared Page 0.0 0.0 0 0.0 %
Exclusive Row 0.0 0.0 0 0.0 %
Update Row 0.0 0.0 0 0.0 %
Shared Row 0.0 0.0 0 0.0 %
Shared Next-Key 0.0 0.0 0 0.0 %
Exclusive Address 0.0 0.0 0 0.0 %
Shared Address 0.0 0.0 0 0.0 %
Others 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Deadlocks 0.0 0.0 1
Deadlock Detection
Deadlock Searches 0.0 0.0 4 n/a
Searches Skipped 0.0 0.0 0 0.0 %
Avg Deadlocks per Search n/a n/a 0.25000 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 75776.8 7192.9 90932211 99.9 %
Total Cache Misses 81.2 7.7 97383 0.1 %
------------------------- ------------ ------------ ----------
Total Cache Searches 75858.0 7200.6 91029594
Cache Turnover
Buffers Grabbed 78.2 7.4 93834 n/a
Buffers Grabbed Dirty 0.0 0.0 0 0.0 %
Cache Strategy Summary
Cached (LRU) Buffers 75432.0 7160.1 90518438 100.0 %
Discarded (MRU) Buffers 3.5 0.3 4144 0.0 %
Large I/O Usage
Large I/Os Performed 29.7 2.8 35626 99.2 %
Large I/Os Denied due to
Pool < Prefetch Size 0.2 0.0 284 0.8 %
------------------------- ------------ ------------ ----------
Total Large I/O Requests 29.9 2.8 35910
Large I/O Effectiveness
Pages by Lrg I/O Cached 59.9 5.7 71906 n/a
Pages by Lrg I/O Used 0.0 0.0 56 0.1 %
Asynchronous Prefetch Activity
APFs Issued 0.0 0.0 4 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 10621.4 1008.2 12745734 100.0 %
------------------------- ------------ ------------ ----------
Total APFs Requested 10621.4 1008.2 12745738
Other Asynchronous Prefetch Statistics
APFs Used 0.0 0.0 4 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 34 n/a
-------------------------------------------------------------------------------
Cache: default data cache
per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Spinlock Contention n/a n/a n/a 1.0 %
Utilization n/a n/a n/a 97.5 %
Cache Searches
Cache Hits 73944.7 7019.0 88733655 99.9 %
Found in Wash 440.6 41.8 528736 0.6 %
Cache Misses 53.3 5.1 63945 0.1 %
------------------------- ------------ ------------ ----------
Total Cache Searches 73998.0 7024.0 88797600
Pool Turnover
2 Kb Pool
LRU Buffer Grab 48.4 4.6 58067 71.6 %
Grabbed Dirty 0.0 0.0 0 0.0 %
4 Kb Pool
LRU Buffer Grab 19.1 1.8 22895 28.2 %
Grabbed Dirty 0.0 0.0 0 0.0 %
16 Kb Pool
LRU Buffer Grab 0.1 0.0 109 0.1 %
Grabbed Dirty 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Cache Turnover 67.6 6.4 81071
Buffer Wash Behavior
Statistics Not Available - No Buffers Entered Wash Section Yet
Cache Strategy
Cached (LRU) Buffers 73635.4 6989.6 88362466 100.0 %
Discarded (MRU) Buffers 3.5 0.3 4144 0.0 %
Large I/O Usage
Large I/Os Performed 19.2 1.8 23004 99.2 %
Large I/Os Denied due to
Pool < Prefetch Size 0.2 0.0 284 1.2 %
------------------------- ------------ ------------ ----------
Total Large I/O Requests 19.3 1.8 23190
Large I/O Detail
4 Kb Pool
Pages Cached 38.2 3.6 45790 n/a
Pages Used 0.0 0.0 0 0.0 %
16 Kb Pool
Pages Cached 0.7 0.1 872 n/a
Pages Used 0.0 0.0 56 6.4 %
Dirty Read Behavior
Page Requests 0.0 0.0 34 n/a
Tuning Recommendations for Data cache : default data cache
-------------------------------------
- Consider using 'relaxed LRU replacement policy'
for this cache.
-------------------------------------------------------------------------------
Cache: named 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 2.5 %
Cache Searches
Cache Hits 1832.1 173.9 2198556 98.5 %
Found in Wash 56.6 5.4 67860 3.1 %
Cache Misses 27.9 2.6 33438 1.5 %
------------------------- ------------ ------------ ----------
Total Cache Searches 1860.0 176.6 2231994
Pool Turnover
2 Kb Pool
LRU Buffer Grab 0.1 0.0 141 1.1 %
Grabbed Dirty 0.0 0.0 0 0.0 %
4 Kb Pool
LRU Buffer Grab 10.5 1.0 12622 98.9 %
Grabbed Dirty 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Cache Turnover 10.6 1.0 12763
Buffer Wash Behavior
Statistics Not Available - No Buffers Entered Wash Section Yet
Cache Strategy
Cached (LRU) Buffers 1796.6 170.5 2155972 100.0 %
Discarded (MRU) Buffers 0.0 0.0 0 0.0 %
Large I/O Usage
Large I/Os Performed 10.5 1.0 12622 99.2 %
Large I/Os Denied due to
Pool < Prefetch Size 0.2 0.0 284 2.2 %
------------------------- ------------ ------------ ----------
Total Large I/O Requests 10.6 1.0 12720
Large I/O Detail
4 Kb Pool
Pages Cached 21.0 2.0 25244 n/a
Pages Used 0.0 0.0 0 0.0 %
Dirty Read Behavior
Page Requests 0.0 0.0 0 n/a
Tuning Recommendations for Data cache : named cache
-------------------------------------
- Consider using 'relaxed LRU replacement policy'
for this cache.
===============================================================================
Procedure Cache Management per sec per xact count % of total
--------------------------- ------------ ------------ ---------- ----------
Procedure Requests 15.5 1.5 18618 n/a
Procedure Reads from Disk 0.0 0.0 2 0.0 %
Procedure Writes to Disk 3.5 0.3 4219 22.7 %
Procedure Removals 0.0 0.0 0 n/a
Procedure Recompilations 0.0 0.0 0 n/a
===============================================================================
Memory Management per sec per xact count % of total
--------------------------- ------------ ------------ ---------- ----------
Pages Allocated 4.8 0.5 5759 n/a
Pages Released 4.8 0.5 5759 n/a
===============================================================================
Recovery Management
-------------------
Checkpoints per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
# of Normal Checkpoints 0.0 0.0 56 100.0 %
# of Free Checkpoints 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Checkpoints 0.0 0.0 56
Avg Time per Normal Chkpt 0.55357 seconds
===============================================================================
Disk I/O Management
-------------------
Max Outstanding I/Os per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Server n/a n/a 42 n/a
Engine 0 n/a n/a 19 n/a
Engine 1 n/a n/a 14 n/a
Engine 2 n/a n/a 31 n/a
Engine 3 n/a n/a 18 n/a
Engine 4 n/a n/a 11 n/a
Engine 5 n/a n/a 19 n/a
Engine 6 n/a n/a 18 n/a
Engine 7 n/a n/a 42 n/a
Engine 8 n/a n/a 16 n/a
Engine 9 n/a n/a 17 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 105.5 10.0 126643
Completed Disk I/O's
Engine 0 9.3 0.9 11109 8.8 %
Engine 1 13.5 1.3 16142 12.7 %
Engine 2 10.5 1.0 12629 10.0 %
Engine 3 11.0 1.0 13175 10.4 %
Engine 4 9.5 0.9 11440 9.0 %
Engine 5 14.9 1.4 17866 14.1 %
Engine 6 6.9 0.7 8319 6.6 %
Engine 7 14.3 1.4 17207 13.6 %
Engine 8 8.6 0.8 10320 8.1 %
Engine 9 7.0 0.7 8436 6.7 %
------------------------- ------------ ------------ ----------
Total Completed I/Os 105.5 10.0 126643
Device Activity Detail
----------------------
Device:
/dev/md/sybds/rdsk/d100
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 2.2 0.2 2693 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 2.2 0.2 2693 2.1 %
-----------------------------------------------------------------------------
Device:
/dev/md/sybds/rdsk/d101
sysprocsdev per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/md/sybds/rdsk/d102
cwtemp0 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 24.3 2.3 29211 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 24.3 2.3 29211 23.1 %
-----------------------------------------------------------------------------
Device:
/dev/md/sybds/rdsk/d103
cwdata1 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.1 0.0 67 9.4 %
Writes 0.5 0.1 648 90.6 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.6 0.1 715 0.6 %
-----------------------------------------------------------------------------
Device:
/dev/md/sybds/rdsk/d104
cwlog1 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/md/sybds/rdsk/d105
cwlog1_2 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/md/sybds/rdsk/d106
cwlog1_3 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/md/sybds/rdsk/d109
tempdb002 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 12.7 1.2 15232 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 12.7 1.2 15232 12.0 %
-----------------------------------------------------------------------------
Device:
/dev/md/sybds/rdsk/d113
cwdata6 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/md/sybds/rdsk/d114
cwlog61 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/md/sybds/rdsk/d115
cwlog62 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/md/sybds/rdsk/d116
cwlog63 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/md/sybds/rdsk/d117
cwlog1_4 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 4 0.1 %
Non-APF 0.0 0.0 6 0.2 %
Writes 2.9 0.3 3521 99.7 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 2.9 0.3 3531 2.8 %
-----------------------------------------------------------------------------
Device:
/dev/md/sybds/rdsk/d118
cwlog64 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/md/sybds/rdsk/d119
cwdata3 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/md/sybds/rdsk/d120
cwlog3 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/md/sybds/rdsk/d121
cwlog3_1 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/md/sybds/rdsk/d123
cwdata1_1 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 6 0.6 %
Writes 0.9 0.1 1045 99.4 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.9 0.1 1051 0.8 %
-----------------------------------------------------------------------------
Device:
/dev/md/sybds/rdsk/d124
tempdb1_dev 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 41.1 3.9 49262 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 41.1 3.9 49262 38.9 %
-----------------------------------------------------------------------------
Device:
/dev/md/sybds/rdsk/d125
tempdb2_dev 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 20.8 2.0 24948 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 20.8 2.0 24948 19.7 %
-----------------------------------------------------------------------------
===============================================================================
Network I/O Management
----------------------
Total Network I/O Requests 233.1 22.1 279751 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 6.0 0.6 7188 3.2 %
Engine 1 24.2 2.3 29069 13.1 %
Engine 2 26.4 2.5 31711 14.3 %
Engine 3 19.3 1.8 23171 10.4 %
Engine 4 25.1 2.4 30101 13.5 %
Engine 5 23.0 2.2 27597 12.4 %
Engine 6 13.1 1.2 15775 7.1 %
Engine 7 18.6 1.8 22318 10.0 %
Engine 8 12.1 1.1 14499 6.5 %
Engine 9 17.5 1.7 21007 9.4 %
------------------------- ------------ ------------ ----------
Total TDS Packets Rec'd 185.4 17.6 222436
Total Bytes Received per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 660.2 62.7 792200 3.2 %
Engine 1 2957.4 280.7 3548891 14.5 %
Engine 2 3074.1 291.8 3688952 15.1 %
Engine 3 2003.5 190.2 2404201 9.8 %
Engine 4 2735.8 259.7 3282967 13.4 %
Engine 5 2394.3 227.3 2873114 11.8 %
Engine 6 1211.6 115.0 1453975 6.0 %
Engine 7 2152.8 204.3 2583307 10.6 %
Engine 8 1294.5 122.9 1553420 6.4 %
Engine 9 1870.9 177.6 2245067 9.2 %
------------------------- ------------ ------------ ----------
Total Bytes Rec'd 20355.1 1932.1 24426094
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 6.4 0.6 7699 3.1 %
Engine 1 28.5 2.7 34226 13.6 %
Engine 2 30.3 2.9 36391 14.5 %
Engine 3 19.3 1.8 23210 9.2 %
Engine 4 28.6 2.7 34301 13.6 %
Engine 5 24.7 2.3 29654 11.8 %
Engine 6 14.2 1.4 17071 6.8 %
Engine 7 26.2 2.5 31462 12.5 %
Engine 8 12.8 1.2 15344 6.1 %
Engine 9 18.4 1.7 22025 8.8 %
------------------------- ------------ ------------ ----------
Total TDS Packets Sent 209.5 19.9 251383
Total Bytes Sent per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 633.6 60.1 760355 2.3 %
Engine 1 4443.2 421.8 5331786 16.0 %
Engine 2 4194.0 398.1 5032788 15.1 %
Engine 3 1689.2 160.3 2027044 6.1 %
Engine 4 3805.4 361.2 4566454 13.7 %
Engine 5 2709.4 257.2 3251334 9.8 %
Engine 6 1496.0 142.0 1795181 5.4 %
Engine 7 5538.5 525.7 6646192 20.0 %
Engine 8 1344.1 127.6 1612936 4.8 %
Engine 9 1864.4 177.0 2237248 6.7 %
------------------------- ------------ ------------ ----------
Total Bytes Sent 27717.8 2631.0 33261318
Avg Bytes Sent per Packet n/a n/a 132 n/a
===============================================================================
Replication Agent
-----------------
Replication Agent: cwbase1
Replication Server: rs880_rs
per sec per xact count % of total
------------ ------------ ---------- ----------
Log Scan Summary
Log Records Scanned n/a n/a 23923 n/a
Log Records Processed n/a n/a 10731 n/a
Log Scan Activity
Updates n/a n/a 2007 n/a
Inserts n/a n/a 2126 n/a
Deletes n/a n/a 1259 n/a
Store Procedures n/a n/a 0 n/a
DDL Log Records n/a n/a 0 n/a
Writetext Log Records n/a n/a 0 n/a
Text/Image Log Records n/a n/a 0 n/a
CLRs n/a n/a 0 n/a
Transaction Activity
Opened n/a n/a 2670 n/a
Commited n/a n/a 2616 n/a
Aborted n/a n/a 52 n/a
Prepared n/a n/a 52 n/a
Maintenance User n/a n/a 0 n/a
Log Extension Wait
Count n/a n/a 2002 n/a
Amount of time (ms |
|