=============================================================================== 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 ===============================================================================