Sysmon-0.1.2: data/sysmon_2.out
===============================================================================
Sybase Adaptive Server Enterprise System Performance Report
===============================================================================
Server Version: Adaptive Server Enterprise/15.0.3/EBF 16548 ESD#1/P/Sun_
Server Name: Test
Run Date: Jan 27, 2010
Sampling Started at: Jan 27, 2010 15:42:27
Sampling Ended at: Jan 27, 2010 15:43:27
Sample Interval: 00:01:00
Sample Mode: No Clear
Counters Last Cleared: Jan 20, 2010 11:35:52
===============================================================================
Kernel Utilization
------------------
Your Runnable Process Search Count is set to 2000
and I/O Polling Process Count is set to 10
Engine Busy Utilization CPU Busy I/O Busy Idle
------------------------ -------- -------- --------
Engine 0 0.0 % 0.0 % 100.0 %
Engine 1 0.0 % 0.0 % 100.0 %
Engine 2 0.0 % 0.0 % 100.0 %
Engine 3 0.0 % 0.0 % 100.0 %
Engine 4 0.0 % 0.0 % 100.0 %
Engine 5 0.2 % 0.0 % 99.8 %
Engine 6 0.0 % 0.0 % 100.0 %
Engine 7 12.5 % 77.9 % 9.6 %
Engine 8 0.0 % 0.2 % 99.8 %
Engine 9 0.0 % 0.0 % 100.0 %
Engine 10 0.0 % 0.0 % 100.0 %
Engine 11 0.0 % 1.8 % 98.2 %
------------------------ -------- -------- --------
Summary Total 12.6 % 79.9 % 1107.5 %
Average 1.1 % 6.7 % 92.3 %
CPU Yields by Engine per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 58.5 24.2 3512 8.8 %
Engine 1 58.9 24.4 3536 8.9 %
Engine 2 58.9 24.4 3534 8.9 %
Engine 3 58.9 24.4 3536 8.9 %
Engine 4 58.9 24.4 3532 8.9 %
Engine 5 58.8 24.3 3530 8.9 %
Engine 6 58.9 24.4 3531 8.9 %
Engine 7 5.5 2.3 332 0.8 %
Engine 8 58.9 24.4 3534 8.9 %
Engine 9 69.9 28.9 4193 10.5 %
Engine 10 59.1 24.5 3546 8.9 %
Engine 11 58.2 24.1 3494 8.8 %
------------------------- ------------ ------------ ----------
Total CPU Yields 663.5 274.6 39810
Network Checks
Non-Blocking 343984.4 142338.4 20639065 99.8 %
Blocking 662.8 274.3 39770 0.2 %
------------------------- ------------ ------------ ----------
Total Network I/O Checks 344647.3 142612.7 20678835
Avg Net I/Os per Check n/a n/a 0.00010 n/a
Disk I/O Checks
Total Disk I/O Checks 345442.4 142941.7 20726542 n/a
Checks Returning I/O 325037.2 134498.2 19502231 94.1 %
Avg Disk I/Os Returned n/a n/a 0.00216 n/a
Tuning Recommendations for Kernel Utilization
---------------------------------------------
- Consider decreasing the 'runnable process search count'
configuration parameter if you require the CPU's on
the machine to be used for other applications.
===============================================================================
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.1 0.0 4 n/a
Task Context Switches by Engine
Engine 0 3.5 1.4 207 0.8 %
Engine 1 0.6 0.2 33 0.1 %
Engine 2 1.3 0.5 75 0.3 %
Engine 3 3.0 1.2 181 0.7 %
Engine 4 0.6 0.2 34 0.1 %
Engine 5 1.6 0.7 97 0.4 %
Engine 6 1.8 0.7 105 0.4 %
Engine 7 411.4 170.2 24683 93.4 %
Engine 8 0.7 0.3 42 0.2 %
Engine 9 7.1 2.9 427 1.6 %
Engine 10 5.6 2.3 336 1.3 %
Engine 11 3.5 1.5 211 0.8 %
------------------------- ------------ ------------ ----------
Total Task Switches: 440.5 182.3 26431
Task Context Switches Due To:
Voluntary Yields 8.1 3.4 487 1.8 %
Cache Search Misses 32.7 13.5 1959 7.4 %
Exceeding I/O batch size 0.0 0.0 0 0.0 %
System Disk Writes 1.9 0.8 113 0.4 %
Logical Lock Contention 0.0 0.0 0 0.0 %
Address Lock Contention 0.0 0.0 0 0.0 %
Latch Contention 0.0 0.0 0 0.0 %
Log Semaphore Contention 0.0 0.0 0 0.0 %
PLC Lock Contention 0.0 0.0 0 0.0 %
Group Commit Sleeps 0.1 0.0 5 0.0 %
Last Log Page Writes 1.2 0.5 72 0.3 %
Modify Conflicts 0.0 0.0 0 0.0 %
I/O Device Contention 0.0 0.0 0 0.0 %
Network Packet Received 8.4 3.5 503 1.9 %
Network Packet Sent 0.8 0.3 46 0.2 %
Network services 9.2 3.8 549 2.1 %
Other Causes 378.3 156.5 22697 85.9 %
===============================================================================
Application Management
----------------------
Application Statistics Summary (All Applications)
-------------------------------------------------
Priority Changes per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
To High Priority 0.0 0.0 0 0.0 %
To Medium Priority 2.1 0.8 123 50.4 %
To Low Priority 2.0 0.8 121 49.6 %
------------------------- ------------ ------------ ----------
Total Priority Changes 4.1 1.7 244
Allotted Slices Exhausted per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
High Priority 0.0 0.0 0 0.0 %
Medium Priority 0.1 0.0 4 100.0 %
Low Priority 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Slices Exhausted 0.1 0.0 4
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 291.2 120.5 17470 97.5 %
Dirty 7.5 3.1 450 2.5 %
------------ ------------ ----------
Total Washes 298.7 123.6 17920
Garbage Collections 2.4 1.0 144 n/a
Pages Processed in GC 0.0 0.0 0 n/a
Statistics Updates 0.4 0.2 24 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 1655 n/a
(since beginning of sample)
Tuning Recommendations for Monitor Access to Executing SQL
----------------------------------------------------------
- Consider decreasing the 'max SQL text monitored' parameter
to 4923 (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 2.4 n/a 145 n/a
Transaction Detail per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Inserts
APL Heap Table 23.1 9.6 1386 11.1 %
APL Clustered Table 0.0 0.0 0 0.0 %
Data Only Lock Table 184.5 76.3 11067 88.9 %
Fast Bulk Insert 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Inserted 207.6 85.9 12453 99.9 %
Updates
APL Deferred 0.0 0.0 0 0.0 %
APL Direct In-place 0.0 0.0 0 0.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.2 0.1 12 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Updated 0.2 0.1 12 0.1 %
Data Only Locked Updates
DOL Replace 0.2 0.1 12 100.0 %
DOL Shrink 0.0 0.0 0 0.0 %
DOL Cheap Expand 0.0 0.0 0 0.0 %
DOL Expensive Expand 0.0 0.0 0 0.0 %
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 0.2 0.1 12 0.1 %
Deletes
Total Rows Deleted 0.0 0.0 0 n/a
========================= ============ ============ ==========
Total Rows Affected 207.8 86.0 12465
===============================================================================
Transaction Management
----------------------
ULC Flushes to Xact Log per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
by Full ULC 0.7 0.3 39 26.7 %
by End Transaction 1.1 0.5 68 46.6 %
by Change of Database 0.1 0.0 4 2.7 %
by Single Log Record 0.1 0.1 8 5.5 %
by Unpin 0.5 0.2 27 18.5 %
by Other 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total ULC Flushes 2.4 1.0 146
ULC Flushes Skipped per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
by PLC Discards 2.0 0.8 118 100.0 %
------------------------- ------------ ------------ ----------
Total ULC Discards 2.0 0.8 118
ULC Log Records 55.2 22.8 3309 n/a
Max ULC Size During Sample n/a n/a 0 n/a
ULC Semaphore Requests
Granted 81.1 33.6 4866 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total ULC Semaphore Req 81.1 33.6 4866
Log Semaphore Requests
Granted 3.4 1.4 206 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Log Semaphore Req 3.4 1.4 206
Transaction Log Writes 2.0 0.8 122 n/a
Transaction Log Alloc 3.0 1.2 177 n/a
Avg # Writes per Log Page n/a n/a 0.68927 n/a
Tuning Recommendations for Transaction Management
-------------------------------------------------
- Consider increasing the 'user log cache size'
configuration parameter.
===============================================================================
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 0.2 0.1 12 n/a
# of DOL Ndx Maint 0.6 0.2 36 n/a
Avg DOL Ndx Maint / Op n/a n/a 3.00000 n/a
Page Splits 0.0 0.0 2 n/a
Retries 0.0 0.0 0 0.0 %
Deadlocks 0.0 0.0 0 0.0 %
Add Index Level 0.0 0.0 0 0.0 %
Page Shrinks 0.0 0.0 0 n/a
Index Scans per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Ascending Scans 24.0 9.9 1439 12.7 %
DOL Ascending Scans 165.1 68.3 9907 87.1 %
Descending Scans 0.1 0.0 5 0.0 %
DOL Descending Scans 0.4 0.2 23 0.2 %
------------ ------------ ----------
Total Scans 189.6 78.4 11374
===============================================================================
Lock Management
---------------
Lock Summary per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total Lock Requests 137.3 56.8 8240 n/a
Avg Lock Contention 0.0 0.0 0 0.0 %
Deadlock Percentage 0.0 0.0 0 0.0 %
Lock Detail per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Table Lock Hashtable
Lookups 38.3 15.9 2300 n/a
Avg Chain Length n/a n/a 0.00043 n/a
Spinlock Contention n/a n/a n/a 0.0 %
Exclusive Table
Total EX-Table Requests 0.0 0.0 0 n/a
Shared Table
Total SH-Table Requests 0.0 0.0 0 n/a
Exclusive Intent
Granted 2.7 1.1 160 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Intent Requests 2.7 1.1 160 1.9 %
Shared Intent
Granted 35.0 14.5 2101 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Intent Requests 35.0 14.5 2101 25.5 %
Page & Row Lock HashTable
Lookups 54.2 22.4 3253 n/a
Avg Chain Length n/a n/a 0.00338 n/a
Spinlock Contention n/a n/a n/a 0.0 %
Exclusive Page
Granted 0.7 0.3 44 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Page Requests 0.7 0.3 44 0.5 %
Update Page
Total UP-Page Requests 0.0 0.0 0 n/a
Shared Page
Granted 21.9 9.0 1312 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Page Requests 21.9 9.0 1312 15.9 %
Exclusive Row
Granted 0.6 0.3 38 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Row Requests 0.6 0.3 38 0.5 %
Update Row
Granted 0.4 0.2 22 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total UP-Row Requests 0.4 0.2 22 0.3 %
Shared Row
Granted 21.8 9.0 1310 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Row Requests 21.8 9.0 1310 15.9 %
Next-Key
Total Next-Key Requests 0.0 0.0 0 n/a
Address Lock Hashtable
Lookups 54.2 22.4 3253 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 0.3 0.1 15 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Address Requests 0.3 0.1 15 0.2 %
Shared Address
Granted 54.0 22.3 3238 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Address Requests 54.0 22.3 3238 39.3 %
Last Page Locks on Heaps
Granted 23.1 9.6 1386 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total Last Pg Locks 23.1 9.6 1386 100.0 %
Deadlocks by Lock Type per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total Deadlocks 0.0 0.0 0 n/a
Deadlock Detection
Deadlock Searches 0.0 0.0 0 n/a
Lock Promotions
Total Lock Promotions 0.0 0.0 0 n/a
Lock Timeouts by Lock Type per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total Timeouts 0.0 0.0 0 n/a
===============================================================================
Data Cache Management
---------------------
Cache Statistics Summary (All Caches)
-------------------------------------
per sec per xact count % of total
------------ ------------ ---------- ----------
Cache Search Summary
Total Cache Hits 6347.2 2626.4 380833 91.4 %
Total Cache Misses 594.6 246.0 35675 8.6 %
------------------------- ------------ ------------ ----------
Total Cache Searches 6941.8 2872.5 416508
Cache Turnover
Buffers Grabbed 1525.3 631.2 91520 n/a
Buffers Grabbed Dirty 0.0 0.0 0 0.0 %
Cache Strategy Summary
Cached (LRU) Buffers 6554.0 2712.0 393238 94.7 %
Discarded (MRU) Buffers 363.4 150.4 21806 5.3 %
Large I/O Usage
Large I/Os Performed 103.2 42.7 6194 10.9 %
Large I/Os Denied due to
Pool < Prefetch Size 848.1 350.9 50883 89.1 %
Pages Requested
Reside in Another
Buffer Pool 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Large I/O Requests 951.3 393.6 57077
Large I/O Effectiveness
Pages by Lrg I/O Cached 817.1 338.1 49026 n/a
Pages by Lrg I/O Used 822.7 340.4 49359 100.7 %
Asynchronous Prefetch Activity
APFs Issued 658.3 272.4 39498 23.3 %
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.2 0.1 12 0.0 %
W/o Spinlock Held 2170.2 898.0 130210 76.7 %
------------------------- ------------ ------------ ----------
Total APFs Requested 2828.7 1170.5 169720
Other Asynchronous Prefetch Statistics
APFs Used 656.9 271.8 39414 n/a
APF Waits for I/O 375.5 155.4 22528 n/a
APF Discards 0.0 0.0 0 n/a
Dirty Read Behavior
Page Requests 0.0 0.0 0 n/a
-------------------------------------------------------------------------------
Cache: dbcc_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 0.0 %
Cache Searches
Total Cache Searches 0.0 0.0 0 n/a
------------------------- ------------ ------------ ----------
Total Cache Searches 0.0 0.0 0
Pool Turnover 0.0 0.0 0 n/a
Buffer Wash Behavior
Statistics Not Available - No Buffers Entered Wash Section Yet
Cache Strategy
Statistics Not Available - No Buffers Displaced Yet
Large I/O Usage
Total Large I/O Requests 0.0 0.0 0 n/a
Large I/O Detail
16 Kb Pool
Pages Cached 0.0 0.0 0 n/a
Pages Used 0.0 0.0 0 n/a
Dirty Read Behavior
Page Requests 0.0 0.0 0 n/a
Tuning Recommendations for Data cache : dbcc_cache
-------------------------------------
- Consider removing the 16k 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 100.0 %
Cache Searches
Cache Hits 6347.2 2626.4 380833 91.4 %
Found in Wash 112.5 46.5 6747 1.8 %
Cache Misses 594.6 246.0 35675 8.6 %
------------------------- ------------ ------------ ----------
Total Cache Searches 6941.8 2872.5 416508
Pool Turnover
2 Kb Pool
LRU Buffer Grab 1422.1 588.4 85325 93.2 %
Grabbed Dirty 0.0 0.0 0 0.0 %
4 Kb Pool
LRU Buffer Grab 1.5 0.6 89 0.1 %
Grabbed Dirty 0.0 0.0 0 0.0 %
16 Kb Pool
LRU Buffer Grab 101.8 42.1 6106 6.7 %
Grabbed Dirty 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Cache Turnover 1525.3 631.2 91520
Buffer Wash Behavior
Statistics Not Available - No Buffers Entered Wash Section Yet
Cache Strategy
Cached (LRU) Buffers 6554.0 2712.0 393238 94.7 %
Discarded (MRU) Buffers 363.4 150.4 21806 5.3 %
Large I/O Usage
Large I/Os Performed 103.2 42.7 6194 10.9 %
Large I/Os Denied due to
Pool < Prefetch Size 56.2 23.3 3374 5.9 %
Pages Requested
Reside in Another
Buffer Pool 791.8 327.6 47509 83.2 %
------------------------- ------------ ------------ ----------
Total Large I/O Requests 951.3 393.6 57077
Large I/O Detail
4 Kb Pool
Pages Cached 3.0 1.2 178 n/a
Pages Used 3.0 1.2 178 100.0 %
16 Kb Pool
Pages Cached 814.1 336.9 48848 n/a
Pages Used 819.7 339.2 49181 100.7 %
Dirty Read Behavior
Page Requests 0.0 0.0 0 n/a
-------------------------------------------------------------------------------
Cache: tempdb_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 0.0 %
Cache Searches
Total Cache Searches 0.0 0.0 0 n/a
------------------------- ------------ ------------ ----------
Total Cache Searches 0.0 0.0 0
Pool Turnover 0.0 0.0 0 n/a
Buffer Wash Behavior
Statistics Not Available - No Buffers Entered Wash Section Yet
Cache Strategy
Statistics Not Available - No Buffers Displaced Yet
Large I/O Usage
Total Large I/O Requests 0.0 0.0 0 n/a
Large I/O Detail
4 Kb Pool
Pages Cached 0.0 0.0 0 n/a
Pages Used 0.0 0.0 0 n/a
16 Kb Pool
Pages Cached 0.0 0.0 0 n/a
Pages Used 0.0 0.0 0 n/a
Dirty Read Behavior
Page Requests 0.0 0.0 0 n/a
Tuning Recommendations for Data cache : tempdb_cache
-------------------------------------
- Consider removing the 4k pool for this cache.
- Consider removing the 16k pool for this cache.
===============================================================================
Procedure Cache Management per sec per xact count % of total
--------------------------- ------------ ------------ ---------- ----------
Procedure Requests 6.1 2.5 364 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 1 n/a
Procedure Recompilations 0.0 0.0 0 n/a
SQL Statement Cache:
Statements Cached 0.0 0.0 1 n/a
Statements Found in Cache 0.1 0.0 6 n/a
Statements Not Found 0.0 0.0 1 n/a
Statements Dropped 0.0 0.0 0 n/a
Statements Restored 0.0 0.0 0 n/a
Statements Not Cached 0.0 0.0 0 n/a
===============================================================================
Memory Management per sec per xact count % of total
--------------------------- ------------ ------------ ---------- ----------
Pages Allocated 1.1 0.5 67 n/a
Pages Released 1.1 0.5 67 n/a
===============================================================================
Recovery Management
-------------------
Checkpoints per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
# of Normal Checkpoints 0.1 0.0 4 100.0 %
# of Free Checkpoints 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Checkpoints 0.1 0.0 4
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 255 n/a
Engine 0 n/a n/a 352 n/a
Engine 1 n/a n/a 396 n/a
Engine 2 n/a n/a 425 n/a
Engine 3 n/a n/a 389 n/a
Engine 4 n/a n/a 198 n/a
Engine 5 n/a n/a 218 n/a
Engine 6 n/a n/a 263 n/a
Engine 7 n/a n/a 215 n/a
Engine 8 n/a n/a 263 n/a
Engine 9 n/a n/a 236 n/a
Engine 10 n/a n/a 403 n/a
Engine 11 n/a n/a 181 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 701.8 290.4 42107
Completed Disk I/O's
Asynchronous I/O's
Engine 0 0.0 0.0 0 0.0 %
Engine 1 0.0 0.0 0 0.0 %
Engine 2 0.1 0.0 4 0.0 %
Engine 3 0.4 0.2 26 0.1 %
Engine 4 0.4 0.2 22 0.1 %
Engine 5 1.4 0.6 82 0.2 %
Engine 6 0.4 0.2 23 0.1 %
Engine 7 691.1 286.0 41468 98.5 %
Engine 8 0.0 0.0 1 0.0 %
Engine 9 0.3 0.1 19 0.0 %
Engine 10 0.2 0.1 10 0.0 %
Engine 11 7.6 3.2 458 1.1 %
Synchronous I/O's
Total Completed I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ----------
Total Completed I/Os 701.9 290.4 42113
Device Activity Detail
----------------------
Device:
/sybase/data_01.dat
data_01 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 508.6 210.5 30516 95.1 %
Non-APF 26.3 10.9 1577 4.9 %
Writes 0.2 0.1 9 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 535.0 221.4 32102 76.2 %
-----------------------------------------------------------------------------
Device:
/sybase/data_02.dat
data_02 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 66.4 27.5 3986 98.3 %
Non-APF 1.1 0.5 68 1.7 %
Writes 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 67.6 28.0 4054 9.6 %
-----------------------------------------------------------------------------
Device:
/sybase/data_03.dat
data_03 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 55.1 22.8 3305 96.0 %
Non-APF 2.3 1.0 138 4.0 %
Writes 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 57.4 23.7 3443 8.2 %
-----------------------------------------------------------------------------
Device:
/sybase/data_04.dat
data_04 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.8 0.3 48 100.0 %
Non-APF 0.0 0.0 0 0.0 %
Writes 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.8 0.3 48 0.1 %
-----------------------------------------------------------------------------
===============================================================================
Network I/O Management
----------------------
Total Network I/O Requests 9.2 3.8 549 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 0.1 0.1 8 1.6 %
Engine 1 0.1 0.0 4 0.8 %
Engine 2 0.4 0.2 26 5.2 %
Engine 3 1.0 0.4 60 11.9 %
Engine 4 0.0 0.0 0 0.0 %
Engine 5 0.0 0.0 0 0.0 %
Engine 6 0.0 0.0 0 0.0 %
Engine 7 0.9 0.4 55 10.9 %
Engine 8 0.2 0.1 12 2.4 %
Engine 9 3.1 1.3 188 37.4 %
Engine 10 2.5 1.0 150 29.8 %
Engine 11 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total TDS Packets Rec'd 8.4 3.5 503
Total Bytes Received per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 49.4 20.4 2962 6.0 %
Engine 1 1.5 0.6 88 0.2 %
Engine 2 32.5 13.4 1948 3.9 %
Engine 3 97.6 40.4 5856 11.8 %
Engine 4 0.0 0.0 0 0.0 %
Engine 5 0.0 0.0 0 0.0 %
Engine 6 0.0 0.0 0 0.0 %
Engine 7 211.8 87.7 12710 25.7 %
Engine 8 16.9 7.0 1012 2.0 %
Engine 9 241.7 100.0 14500 29.3 %
Engine 10 173.0 71.6 10380 21.0 %
Engine 11 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Bytes Rec'd 824.3 341.1 49456
Avg Bytes Rec'd per Packet n/a n/a 98 n/a
-----------------------------------------------------------------------------
Total TDS Packets Sent per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 0.1 0.0 6 0.4 %
Engine 1 0.1 0.0 4 0.3 %
Engine 2 0.4 0.2 26 1.7 %
Engine 3 1.0 0.4 60 3.8 %
Engine 4 0.0 0.0 0 0.0 %
Engine 5 0.0 0.0 0 0.0 %
Engine 6 0.0 0.0 0 0.0 %
Engine 7 18.6 7.7 1117 71.6 %
Engine 8 0.2 0.1 12 0.8 %
Engine 9 3.1 1.3 186 11.9 %
Engine 10 2.5 1.0 150 9.6 %
Engine 11 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total TDS Packets Sent 26.0 10.8 1561
Total Bytes Sent per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 24.9 10.3 1493 0.0 %
Engine 1 2.5 1.0 148 0.0 %
Engine 2 113.0 46.7 6778 0.0 %
Engine 3 130.2 53.9 7812 0.0 %
Engine 4 0.0 0.0 0 0.0 %
Engine 5 0.0 0.0 0 0.0 %
Engine 6 0.0 0.0 0 0.0 %
Engine 7 287701.8 119049.0 17262110 99.1 %
Engine 8 47.5 19.6 2848 0.0 %
Engine 9 717.1 296.7 43028 0.2 %
Engine 10 1605.0 664.1 96300 0.6 %
Engine 11 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Bytes Sent 290342.0 120141.5 17420517
Avg Bytes Sent per Packet n/a n/a 11159 n/a
===============================================================================