=============================================================================== 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:40:56 Sampling Ended at: Jan 27, 2010 15:41:56 Sample Interval: 00:01:00 Sample Mode: No Clear Counters Last Cleared: Jan 20, 2010 11:35:53 =============================================================================== Kernel Utilization ------------------ Engine Busy Utilization CPU Busy I/O Busy Idle ------------------------ -------- -------- -------- Engine 0 0.2 % 0.0 % 99.8 % Engine 1 0.2 % 0.0 % 99.8 % Engine 2 0.0 % 0.0 % 100.0 % Engine 3 0.2 % 0.2 % 99.7 % Engine 4 0.2 % 1.3 % 98.5 % Engine 5 0.0 % 0.2 % 99.8 % Engine 6 0.0 % 0.0 % 100.0 % Engine 7 2.5 % 46.3 % 51.2 % Engine 8 0.0 % 0.0 % 100.0 % Engine 9 0.0 % 0.0 % 100.0 % Engine 10 0.0 % 0.0 % 100.0 % Engine 11 0.0 % 0.0 % 100.0 % ------------------------ -------- -------- -------- Summary Total 3.2 % 48.0 % 1148.8 % Average 0.3 % 4.0 % 95.7 % CPU Yields by Engine per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Engine 0 73.1 28.3 4385 10.2 % Engine 1 69.1 26.7 4146 9.7 % Engine 2 59.0 22.8 3538 8.2 % Engine 3 72.0 27.9 4318 10.1 % Engine 4 58.1 22.5 3484 8.1 % Engine 5 58.9 22.8 3533 8.2 % Engine 6 59.0 22.8 3539 8.2 % Engine 7 30.9 12.0 1854 4.3 % Engine 8 59.0 22.8 3537 8.2 % Engine 9 59.2 22.9 3550 8.3 % Engine 10 59.1 22.9 3548 8.3 % Engine 11 58.9 22.8 3531 8.2 % ------------------------- ------------ ------------ ---------- Total CPU Yields 716.1 277.2 42963 Network Checks Non-Blocking 223674.6 86583.7 13420473 99.7 % Blocking 714.9 276.7 42894 0.3 % ------------------------- ------------ ------------ ---------- Total Network I/O Checks 224389.5 86860.4 13463367 Avg Net I/Os per Check n/a n/a 0.00008 n/a Disk I/O Checks Total Disk I/O Checks 225442.9 87268.2 13526571 n/a Checks Returning I/O 201521.5 78008.3 12091292 89.4 % Avg Disk I/Os Returned n/a n/a 0.00091 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.2 0.1 9 n/a Task Context Switches by Engine Engine 0 3.7 1.4 223 2.1 % Engine 1 1.7 0.7 102 1.0 % Engine 2 1.2 0.5 71 0.7 % Engine 3 4.5 1.7 267 2.5 % Engine 4 2.8 1.1 169 1.6 % Engine 5 1.7 0.7 102 1.0 % Engine 6 1.7 0.7 101 1.0 % Engine 7 144.7 56.0 8680 82.1 % Engine 8 0.7 0.3 44 0.4 % Engine 9 6.4 2.5 381 3.6 % Engine 10 5.3 2.1 319 3.0 % Engine 11 1.8 0.7 110 1.0 % ------------------------- ------------ ------------ ---------- Total Task Switches: 176.2 68.2 10569 Task Context Switches Due To: Voluntary Yields 8.7 3.4 520 4.9 % Cache Search Misses 4.2 1.6 250 2.4 % Exceeding I/O batch size 0.0 0.0 0 0.0 % System Disk Writes 1.7 0.7 101 1.0 % 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 7 0.1 % Last Log Page Writes 1.1 0.4 67 0.6 % Modify Conflicts 0.0 0.0 0 0.0 % I/O Device Contention 0.0 0.0 0 0.0 % Network Packet Received 8.5 3.3 510 4.8 % Network Packet Sent 0.7 0.3 44 0.4 % Network services 9.2 3.6 552 5.2 % Other Causes 142.0 55.0 8518 80.6 % =============================================================================== 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 0.6 0.2 37 54.4 % To Low Priority 0.5 0.2 31 45.6 % ------------------------- ------------ ------------ ---------- Total Priority Changes 1.1 0.4 68 Allotted Slices Exhausted per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Total Slices Exhausted 0.0 0.0 0 n/a 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 120.0 46.5 7202 99.2 % Dirty 1.0 0.4 59 0.8 % ------------ ------------ ---------- Total Washes 121.0 46.8 7261 Garbage Collections 2.8 1.1 168 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.6 n/a 155 n/a Transaction Detail per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Inserts APL Heap Table 23.7 9.2 1419 12.7 % APL Clustered Table 0.0 0.0 0 0.0 % Data Only Lock Table 162.0 62.7 9722 87.3 % Fast Bulk Insert 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total Rows Inserted 185.7 71.9 11141 98.8 % 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 14 100.0 % ------------------------- ------------ ------------ ---------- ---------- Total Rows Updated 0.2 0.1 14 0.1 % Data Only Locked Updates DOL Replace 0.2 0.1 14 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 14 0.1 % Deletes APL Deferred 0.0 0.0 0 0.0 % APL Direct 0.0 0.0 0 0.0 % DOL 2.0 0.8 120 100.0 % ------------------------- ------------ ------------ ---------- ---------- Total Rows Deleted 2.0 0.8 120 1.1 % ========================= ============ ============ ========== Total Rows Affected 187.9 72.7 11275 =============================================================================== Transaction Management ---------------------- ULC Flushes to Xact Log per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- by Full ULC 0.7 0.3 42 28.0 % by End Transaction 0.8 0.3 49 32.7 % by Change of Database 0.1 0.0 4 2.7 % by Single Log Record 0.3 0.1 17 11.3 % by Unpin 0.6 0.2 38 25.3 % by Other 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total ULC Flushes 2.5 1.0 150 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 60.4 23.4 3623 n/a Max ULC Size During Sample n/a n/a 0 n/a ULC Semaphore Requests Granted 90.2 34.9 5413 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total ULC Semaphore Req 90.2 34.9 5413 Log Semaphore Requests Granted 3.6 1.4 213 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total Log Semaphore Req 3.6 1.4 213 Transaction Log Writes 1.9 0.7 111 n/a Transaction Log Alloc 2.8 1.1 168 n/a Avg # Writes per Log Page n/a n/a 0.66071 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 2.2 0.9 134 n/a # of DOL Ndx Maint 2.6 1.0 156 n/a Avg DOL Ndx Maint / Op n/a n/a 1.16418 n/a Page Splits 0.0 0.0 0 n/a Page Shrinks 0.0 0.0 0 n/a Index Scans per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Ascending Scans 34.7 13.4 2082 47.0 % DOL Ascending Scans 38.8 15.0 2329 52.6 % Descending Scans 0.2 0.1 14 0.3 % DOL Descending Scans 0.0 0.0 1 0.0 % ------------ ------------ ---------- Total Scans 73.8 28.6 4426 =============================================================================== Lock Management --------------- Lock Summary per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Total Lock Requests 175.8 68.0 10546 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 40.1 15.5 2406 n/a Avg Chain Length n/a n/a 0.01081 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 3.0 1.2 180 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total EX-Intent Requests 3.0 1.2 180 1.7 % Shared Intent Granted 36.7 14.2 2200 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total SH-Intent Requests 36.7 14.2 2200 20.9 % Page & Row Lock HashTable Lookups 75.9 29.4 4555 n/a Avg Chain Length n/a n/a 0.01537 n/a Spinlock Contention n/a n/a n/a 0.0 % Exclusive Page Granted 0.8 0.3 46 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total EX-Page Requests 0.8 0.3 46 0.4 % Update Page Total UP-Page Requests 0.0 0.0 0 n/a Shared Page Granted 33.0 12.8 1980 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total SH-Page Requests 33.0 12.8 1980 18.8 % Exclusive Row Granted 2.3 0.9 139 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total EX-Row Requests 2.3 0.9 139 1.3 % Update Row Granted 0.7 0.3 41 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total UP-Row Requests 0.7 0.3 41 0.4 % Shared Row Granted 29.5 11.4 1770 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total SH-Row Requests 29.5 11.4 1770 16.8 % Next-Key Total Next-Key Requests 0.0 0.0 0 n/a Address Lock Hashtable Lookups 69.8 27.0 4190 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.5 0.2 27 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total EX-Address Requests 0.5 0.2 27 0.3 % Shared Address Granted 69.4 26.9 4163 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total SH-Address Requests 69.4 26.9 4163 39.5 % Last Page Locks on Heaps Granted 23.7 9.2 1419 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total Last Pg Locks 23.7 9.2 1419 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 1744.9 675.5 104696 84.0 % Total Cache Misses 332.2 128.6 19929 16.0 % ------------------------- ------------ ------------ ---------- Total Cache Searches 2077.1 804.0 124625 Cache Turnover Buffers Grabbed 809.3 313.3 48560 n/a Buffers Grabbed Dirty 0.0 0.0 0 0.0 % Cache Strategy Summary Cached (LRU) Buffers 1554.3 601.7 93259 99.4 % Discarded (MRU) Buffers 9.7 3.8 582 0.6 % Large I/O Usage Large I/Os Performed 40.8 15.8 2445 8.5 % Large I/Os Denied due to Pool < Prefetch Size 435.9 168.7 26154 91.5 % Pages Requested Reside in Another Buffer Pool 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total Large I/O Requests 476.7 184.5 28599 Large I/O Effectiveness Pages by Lrg I/O Cached 317.5 122.9 19050 n/a Pages by Lrg I/O Used 183.7 71.1 11021 57.9 % Asynchronous Prefetch Activity APFs Issued 174.8 67.7 10490 28.8 % 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.1 0.0 3 0.0 % W/o Spinlock Held 433.0 167.6 25977 71.2 % ------------------------- ------------ ------------ ---------- Total APFs Requested 607.8 235.3 36470 Other Asynchronous Prefetch Statistics APFs Used 173.4 67.1 10402 n/a APF Waits for I/O 140.2 54.3 8414 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 1744.9 675.5 104696 84.0 % Found in Wash 2.4 0.9 145 0.1 % Cache Misses 332.2 128.6 19929 16.0 % ------------------------- ------------ ------------ ---------- Total Cache Searches 2077.1 804.0 124625 Pool Turnover 2 Kb Pool LRU Buffer Grab 768.6 297.5 46115 95.0 % Grabbed Dirty 0.0 0.0 0 0.0 % 4 Kb Pool LRU Buffer Grab 1.4 0.5 85 0.2 % Grabbed Dirty 0.0 0.0 0 0.0 % 16 Kb Pool LRU Buffer Grab 39.3 15.2 2360 4.9 % Grabbed Dirty 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total Cache Turnover 809.3 313.3 48560 Buffer Wash Behavior Statistics Not Available - No Buffers Entered Wash Section Yet Cache Strategy Cached (LRU) Buffers 1554.3 601.7 93259 99.4 % Discarded (MRU) Buffers 9.7 3.8 582 0.6 % Large I/O Usage Large I/Os Performed 40.8 15.8 2445 8.5 % Large I/Os Denied due to Pool < Prefetch Size 14.8 5.7 888 3.1 % Pages Requested Reside in Another Buffer Pool 421.1 163.0 25266 88.3 % ------------------------- ------------ ------------ ---------- Total Large I/O Requests 476.7 184.5 28599 Large I/O Detail 4 Kb Pool Pages Cached 2.8 1.1 170 n/a Pages Used 2.8 1.1 167 98.2 % 16 Kb Pool Pages Cached 314.7 121.8 18880 n/a Pages Used 180.9 70.0 10854 57.5 % 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 5.7 2.2 339 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.1 0.1 8 n/a Procedure Recompilations 0.0 0.0 0 n/a SQL Statement Cache: Statements Cached 0.1 0.0 3 n/a Statements Found in Cache 0.2 0.1 10 n/a Statements Not Found 0.1 0.0 3 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.3 0.5 75 n/a Pages Released 1.3 0.5 75 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 183.3 71.0 11000 Completed Disk I/O's Asynchronous I/O's Engine 0 0.0 0.0 0 0.0 % Engine 1 0.1 0.0 4 0.0 % Engine 2 0.0 0.0 0 0.0 % Engine 3 1.0 0.4 57 0.5 % Engine 4 1.9 0.7 116 1.1 % Engine 5 1.4 0.5 83 0.8 % Engine 6 0.7 0.3 43 0.4 % Engine 7 177.4 68.7 10645 96.7 % Engine 8 0.0 0.0 0 0.0 % Engine 9 0.0 0.0 1 0.0 % Engine 10 0.0 0.0 0 0.0 % Engine 11 1.0 0.4 59 0.5 % Synchronous I/O's Total Completed I/Os 0.0 0.0 0 n/a ------------------------- ------------ ------------ ---------- Total Completed I/Os 183.5 71.0 11008 Device Activity Detail ---------------------- Device: /sybase/data_01.dat data_01 per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Reads APF 83.9 32.5 5033 97.0 % Non-APF 2.3 0.9 138 2.7 % Writes 0.3 0.1 16 0.3 % ------------------------- ------------ ------------ ---------- ---------- Total I/Os 86.5 33.5 5187 47.1 % ----------------------------------------------------------------------------- Device: /sybase/data_02.dat data_02 per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Reads APF 50.3 19.5 3017 98.5 % Non-APF 0.8 0.3 46 1.5 % Writes 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total I/Os 51.1 19.8 3063 27.8 % ----------------------------------------------------------------------------- Device: /sybase/data_03.dat data_03 per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Reads APF 36.7 14.2 2204 98.8 % Non-APF 0.4 0.2 26 1.2 % Writes 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total I/Os 37.2 14.4 2230 20.2 % ----------------------------------------------------------------------------- Device: /sybase/data_04.dat data_04 per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Reads APF 1.0 0.4 58 85.3 % Non-APF 0.2 0.1 10 14.7 % Writes 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total I/Os 1.1 0.4 68 0.6 % =============================================================================== Network I/O Management ---------------------- Total Network I/O Requests 9.2 3.6 554 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.0 0.0 0 0.0 % Engine 1 0.5 0.2 27 5.3 % Engine 2 0.4 0.2 26 5.1 % Engine 3 1.4 0.5 84 16.5 % 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.5 0.2 29 5.7 % Engine 8 0.2 0.1 12 2.4 % Engine 9 3.0 1.2 180 35.4 % Engine 10 2.5 1.0 150 29.5 % Engine 11 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total TDS Packets Rec'd 8.5 3.3 508 Total Bytes Received per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Engine 0 0.0 0.0 0 0.0 % Engine 1 86.7 33.6 5203 11.7 % Engine 2 32.5 12.6 1948 4.4 % Engine 3 163.3 63.2 9799 22.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 70.7 27.3 4239 9.5 % Engine 8 16.9 6.5 1012 2.3 % Engine 9 200.0 77.4 12000 26.9 % Engine 10 173.0 67.0 10380 23.3 % Engine 11 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total Bytes Rec'd 743.0 287.6 44581 Avg Bytes Rec'd per Packet n/a n/a 87 n/a ----------------------------------------------------------------------------- Total TDS Packets Sent per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Engine 0 0.0 0.0 0 0.0 % Engine 1 0.4 0.1 22 3.9 % Engine 2 0.4 0.2 26 4.6 % Engine 3 1.4 0.5 82 14.6 % 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 1.5 0.6 89 15.9 % Engine 8 0.2 0.1 12 2.1 % Engine 9 3.0 1.2 180 32.1 % Engine 10 2.5 1.0 150 26.7 % Engine 11 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total TDS Packets Sent 9.4 3.6 561 Total Bytes Sent per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Engine 0 0.0 0.0 0 0.0 % Engine 1 39.9 15.4 2394 0.2 % Engine 2 113.0 43.7 6778 0.7 % Engine 3 162.1 62.7 9723 1.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 13856.2 5363.7 831374 83.9 % Engine 8 47.5 18.4 2848 0.3 % Engine 9 693.0 268.3 41580 4.2 % Engine 10 1605.0 621.3 96300 9.7 % Engine 11 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total Bytes Sent 16516.6 6393.5 990997 Avg Bytes Sent per Packet n/a n/a 1766 n/a ===============================================================================