|
Search Forums |
Tag Search |
Advanced Search |
Quick Links |
Contact Us |
Forum Rules |
Today's Posts |
FAQ |
Pictures & Albums |
All Albums |
Miscellaneous |
What is My IP |
Whois |
Mark Forums Read |
=============================================================================== Sybase Adaptive Server Enterprise System Performance Report =============================================================================== Server Version: Adaptive Server Enterprise/15.0.3/EBF 16549 ESD#1/P/x86_ Server Name: RMS_D15 Run Date: Feb 09, 2011 Sampling Started at: Feb 09, 2011 16:18:08 Sampling Ended at: Feb 09, 2011 16:19:08 Sample Interval: 00:01:00 Sample Mode: No Clear Counters Last Cleared: Oct 21, 2010 10:47:51 =============================================================================== Kernel Utilization ------------------ Your Runnable Process Search Count is set to 3 and I/O Polling Process Count is set to 6 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.2 % 0.0 % 99.8 % Engine 3 0.0 % 0.0 % 100.0 % Engine 4 0.0 % 0.0 % 100.0 % Engine 5 0.0 % 0.0 % 100.0 % Engine 6 0.0 % 0.0 % 100.0 % Engine 7 0.0 % 0.0 % 100.0 % 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 % Engine 12 0.0 % 0.0 % 100.0 % Engine 13 0.0 % 0.0 % 100.0 % Engine 14 0.0 % 0.0 % 100.0 % ------------------------ -------- -------- -------- Summary Total 0.2 % 0.0 % 1499.8 % Average 0.0 % 0.0 % 100.0 % CPU Yields by Engine per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Engine 0 59.0 141.6 3541 6.7 % Engine 1 59.0 141.7 3542 6.7 % Engine 2 59.0 141.5 3537 6.7 % Engine 3 59.0 141.6 3540 6.7 % Engine 4 59.0 141.6 3539 6.7 % Engine 5 59.0 141.7 3542 6.7 % Engine 6 59.0 141.6 3540 6.7 % Engine 7 59.0 141.7 3542 6.7 % Engine 8 59.0 141.6 3540 6.7 % Engine 9 59.0 141.7 3542 6.7 % Engine 10 59.0 141.6 3539 6.7 % Engine 11 59.0 141.7 3542 6.7 % Engine 12 59.0 141.6 3540 6.7 % Engine 13 59.0 141.7 3542 6.7 % Engine 14 58.9 141.4 3535 6.7 % ------------------------- ------------ ------------ ---------- Total CPU Yields 885.1 2124.1 53103 Network Checks Non-Blocking 892.1 2141.1 53527 50.2 % Blocking 885.1 2124.1 53103 49.8 % ------------------------- ------------ ------------ ---------- Total Network I/O Checks 1777.2 4265.2 106630 Avg Net I/Os per Check n/a n/a 0.00007 n/a Disk I/O Checks Total Disk I/O Checks 1786.4 4287.3 107182 n/a Checks Returning I/O 6.8 16.3 408 0.4 % Avg Disk I/Os Returned n/a n/a 0.04902 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 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.0 0.0 0 n/a Task Context Switches by Engine Engine 0 3.5 8.4 211 44.7 % Engine 1 0.3 0.6 16 3.4 % Engine 2 0.7 1.7 42 8.9 % Engine 3 0.3 0.7 17 3.6 % Engine 4 0.3 0.6 16 3.4 % Engine 5 0.3 0.7 17 3.6 % Engine 6 0.3 0.6 16 3.4 % Engine 7 0.3 0.6 16 3.4 % Engine 8 0.3 0.6 16 3.4 % Engine 9 0.3 0.6 16 3.4 % Engine 10 0.3 0.6 16 3.4 % Engine 11 0.3 0.6 16 3.4 % Engine 12 0.3 0.6 16 3.4 % Engine 13 0.4 0.9 22 4.7 % Engine 14 0.3 0.8 19 4.0 % ------------------------- ------------ ------------ ---------- Total Task Switches: 7.9 18.9 472 Task Context Switches Due To: Voluntary Yields 6.9 16.4 411 87.1 % Cache Search Misses 0.0 0.0 0 0.0 % Exceeding I/O batch size 0.0 0.0 0 0.0 % System Disk Writes 0.4 0.9 22 4.7 % 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.0 0.0 0 0.0 % Last Log Page Writes 0.0 0.0 0 0.0 % Modify Conflicts 0.0 0.0 0 0.0 % I/O Device Contention 0.0 0.0 0 0.0 % Network Packet Received 0.1 0.1 3 0.6 % Network Packet Sent 0.0 0.0 0 0.0 % Network services 0.1 0.2 4 0.8 % Other Causes 0.5 1.3 32 6.8 % =============================================================================== 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.2 0.4 11 50.0 % To Low Priority 0.2 0.4 11 50.0 % ------------------------- ------------ ------------ ---------- Total Priority Changes 0.4 0.9 22 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 1.6 3.9 97 63.8 % Dirty 0.9 2.2 55 36.2 % ------------ ------------ ---------- Total Washes 2.5 6.1 152 Garbage Collections 2.8 6.6 165 n/a Pages Processed in GC 0.0 0.0 0 n/a Statistics Updates 0.5 1.2 30 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 122633 n/a (since beginning of sample) Tuning Recommendations for Monitor Access to Executing SQL ---------------------------------------------------------- - Consider increasing the 'max SQL text monitored' parameter to at least 84615 (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 0.4 n/a 25 n/a Transaction Detail per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Inserts APL Heap Table 572.7 1374.4 34360 100.0 % APL Clustered Table 0.0 0.0 0 0.0 % Data Only Lock Table 0.1 0.3 7 0.0 % Fast Bulk Insert 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total Rows Inserted 572.8 1374.7 34367 100.0 % Updates Total Rows Updated 0.0 0.0 0 n/a ------------------------- ------------ ------------ ---------- ---------- Total Rows Updated 0.0 0.0 0 0.0 % Data Only Locked Updates Total Rows Updated 0.0 0.0 0 n/a ------------------------- ------------ ------------ ---------- ---------- Total DOL Rows Updated 0.0 0.0 0 0.0 % Deletes Total Rows Deleted 0.0 0.0 0 n/a ========================= ============ ============ ========== Total Rows Affected 572.8 1374.7 34367 =============================================================================== Transaction Management ---------------------- ULC Flushes to Xact Log per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- by Full ULC 0.0 0.0 0 0.0 % by End Transaction 0.1 0.2 4 80.0 % by Change of Database 0.0 0.0 1 20.0 % by Single Log Record 0.0 0.0 0 0.0 % by Unpin 0.0 0.0 0 0.0 % by Other 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total ULC Flushes 0.1 0.2 5 ULC Flushes Skipped per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- by PLC Discards 0.4 0.9 22 100.0 % ------------------------- ------------ ------------ ---------- Total ULC Discards 0.4 0.9 22 ULC Log Records 1.0 2.4 61 n/a Max ULC Size During Sample n/a n/a 0 n/a ULC Semaphore Requests Granted 3.0 7.2 179 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total ULC Semaphore Req 3.0 7.2 179 Log Semaphore Requests Granted 0.5 1.2 31 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total Log Semaphore Req 0.5 1.2 31 Transaction Log Writes 0.0 0.0 1 n/a Transaction Log Alloc 0.0 0.0 1 n/a Avg # Writes per Log Page n/a n/a 1.00000 n/a =============================================================================== 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.0 0.0 0 n/a # of DOL Ndx Maint 0.0 0.0 0 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 0.6 1.4 34 27.9 % DOL Ascending Scans 1.5 3.5 87 71.3 % Descending Scans 0.0 0.0 1 0.8 % DOL Descending Scans 0.0 0.0 0 0.0 % ------------ ------------ ---------- Total Scans 2.0 4.9 122 =============================================================================== Metadata Cache Management ------------------------- Metadata Cache Summary per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Open Object Usage Active n/a n/a 4868 n/a Max Ever Used Since Boot n/a n/a 6123 n/a Free n/a n/a 5132 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 4537 n/a Max Ever Used Since Boot n/a n/a 4553 n/a Free n/a n/a 5463 n/a Reuse Requests Succeeded n/a n/a 0 n/a Failed n/a n/a 0 n/a Open Partition Usage Active n/a n/a 6401 n/a Max Ever Used Since Boot n/a n/a 7247 n/a Free n/a n/a 3599 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 14 n/a Max Ever Used Since Boot n/a n/a 15 n/a Free n/a n/a 4 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 % Index Hash Spinlock Contention n/a n/a n/a 0.0 % Partition Spinlock Contention n/a n/a n/a 0.0 % Partition 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 5.1 12.2 306 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 1.6 3.8 96 n/a Avg Chain Length n/a n/a 0.00000 n/a Spinlock Contention n/a n/a n/a 0.0 % Exclusive Table Granted 0.0 0.1 2 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total EX-Table Requests 0.0 0.1 2 0.7 % Shared Table Total SH-Table Requests 0.0 0.0 0 n/a Exclusive Intent Granted 0.2 0.4 11 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total EX-Intent Requests 0.2 0.4 11 3.6 % Shared Intent Granted 1.3 3.1 78 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total SH-Intent Requests 1.3 3.1 78 25.5 % Page & Row Lock HashTable Lookups 2.6 6.2 156 n/a Avg Chain Length n/a n/a 0.00000 n/a Spinlock Contention n/a n/a n/a 0.0 % Exclusive Page Granted 0.1 0.2 5 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total EX-Page Requests 0.1 0.2 5 1.6 % Update Page Total UP-Page Requests 0.0 0.0 0 n/a Shared Page Granted 0.5 1.2 30 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total SH-Page Requests 0.5 1.2 30 9.8 % Exclusive Row Granted 0.1 0.3 7 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total EX-Row Requests 0.1 0.3 7 2.3 % Update Row Granted 0.0 0.1 2 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total UP-Row Requests 0.0 0.1 2 0.7 % Shared Row Granted 1.6 3.8 96 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total SH-Row Requests 1.6 3.8 96 31.4 % Next-Key Total Next-Key Requests 0.0 0.0 0 n/a Address Lock Hashtable Lookups 1.3 3.0 75 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.4 0.9 23 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total EX-Address Requests 0.4 0.9 23 7.5 % Shared Address Granted 0.9 2.1 52 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total SH-Address Requests 0.9 2.1 52 17.0 % Last Page Locks on Heaps Granted 572.7 1374.4 34360 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total Last Pg Locks 572.7 1374.4 34360 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 614.8 1475.4 36886 100.0 % Total Cache Misses 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total Cache Searches 614.8 1475.4 36886 Cache Turnover Buffers Grabbed 0.3 0.8 20 n/a Buffers Grabbed Dirty 0.0 0.0 0 0.0 % Cache Strategy Summary Cached (LRU) Buffers 623.3 1496.0 37400 100.0 % Discarded (MRU) Buffers 0.0 0.0 0 0.0 % Large I/O Usage Large I/Os Performed 0.3 0.7 18 100.0 % Large I/Os Denied due to Pool < Prefetch Size 0.0 0.0 0 0.0 % Pages Requested Reside in Another Buffer Pool 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total Large I/O Requests 0.3 0.7 18 Large I/O Effectiveness Pages by Lrg I/O Cached 2.4 5.8 144 n/a Pages by Lrg I/O Used 2.3 5.6 139 96.5 % Asynchronous Prefetch Activity APFs Issued 0.0 0.0 0 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 0.2 0.5 13 100.0 % ------------------------- ------------ ------------ ---------- Total APFs Requested 0.2 0.5 13 Other Asynchronous Prefetch Statistics APFs Used 0.0 0.0 0 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 0 n/a ------------------------------------------------------------------------------- Cache: dbccdb_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 32 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 : dbccdb_cache ------------------------------------- - Consider removing the 32k 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 614.8 1475.4 36886 100.0 % Found in Wash 2.2 5.2 131 0.4 % Cache Misses 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total Cache Searches 614.8 1475.4 36886 Pool Turnover 4 Kb Pool LRU Buffer Grab 0.0 0.1 2 10.0 % Grabbed Dirty 0.0 0.0 0 0.0 % 32 Kb Pool LRU Buffer Grab 0.3 0.7 18 90.0 % Grabbed Dirty 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total Cache Turnover 0.3 0.8 20 Buffer Wash Behavior Statistics Not Available - No Buffers Entered Wash Section Yet Cache Strategy Cached (LRU) Buffers 623.3 1496.0 37400 100.0 % Discarded (MRU) Buffers 0.0 0.0 0 0.0 % Large I/O Usage Large I/Os Performed 0.3 0.7 18 100.0 % Large I/Os Denied due to Pool < Prefetch Size 0.0 0.0 0 0.0 % Pages Requested Reside in Another Buffer Pool 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total Large I/O Requests 0.3 0.7 18 Large I/O Detail 32 Kb Pool Pages Cached 2.4 5.8 144 n/a Pages Used 2.3 5.6 139 96.5 % Dirty Read Behavior Page Requests 0.0 0.0 0 n/a Tuning Recommendations for Data cache : default data cache ------------------------------------- - Consider using 'relaxed LRU replacement policy' for this cache. =============================================================================== Procedure Cache Management per sec per xact count % of total --------------------------- ------------ ------------ ---------- ---------- Procedure Requests 0.1 0.1 3 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 0 n/a Procedure Recompilations 0.0 0.0 0 n/a SQL Statement Cache: Statements Cached 0.0 0.0 0 n/a Statements Found in Cache 0.0 0.1 2 n/a Statements Not Found 0.0 0.0 0 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 2.3 5.5 138 n/a Pages Released 2.3 5.5 138 n/a =============================================================================== Recovery Management ------------------- Checkpoints per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- # of Normal Checkpoints 0.0 0.0 1 100.0 % # of Free Checkpoints 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total Checkpoints 0.0 0.0 1 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 0 n/a Engine 0 n/a n/a 609 n/a Engine 1 n/a n/a 427 n/a Engine 2 n/a n/a 395 n/a Engine 3 n/a n/a 768 n/a Engine 4 n/a n/a 373 n/a Engine 5 n/a n/a 439 n/a Engine 6 n/a n/a 370 n/a Engine 7 n/a n/a 368 n/a Engine 8 n/a n/a 525 n/a Engine 9 n/a n/a 414 n/a Engine 10 n/a n/a 513 n/a Engine 11 n/a n/a 1062 n/a Engine 12 n/a n/a 636 n/a Engine 13 n/a n/a 1058 n/a Engine 14 n/a n/a 2048 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 1.2 2.9 72 Completed Disk I/O's Asynchronous I/O's Engine 0 0.0 0.1 2 10.0 % Engine 1 0.0 0.0 0 0.0 % Engine 2 0.3 0.7 18 90.0 % Engine 3 0.0 0.0 0 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 0.0 0.0 0 0.0 % Engine 8 0.0 0.0 0 0.0 % Engine 9 0.0 0.0 0 0.0 % Engine 10 0.0 0.0 0 0.0 % Engine 11 0.0 0.0 0 0.0 % Engine 12 0.0 0.0 0 0.0 % Engine 13 0.0 0.0 0 0.0 % Engine 14 0.0 0.0 0 0.0 % Synchronous I/O's Total Completed I/Os 0.9 2.1 52 100.0 % ------------------------- ------------ ------------ ---------- Total Completed I/Os 1.2 2.9 72 Device Activity Detail ---------------------- Device: /sybase/dbfiles/RMS_D15/algosuiteDA001.dat algosuiteDA001 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 0.0 0.1 2 100.0 % ------------------------- ------------ ------------ ---------- ---------- Total I/Os 0.0 0.1 2 2.8 % Mirror Semaphore Granted 0.0 0.1 2 100.0 % Mirror Semaphore Waited 0.0 0.0 0 0.0 % ----------------------------------------------------------------------------- Device: /sybase/dbfiles/RMS_D15/algosuiteLOG001.dat algosuiteLOG001 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: /sybase/dbfiles/RMS_D15/dbccdbDA001.dat dbccdbDA001 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 0.0 0.1 2 100.0 % ------------------------- ------------ ------------ ---------- ---------- Total I/Os 0.0 0.1 2 2.8 % Mirror Semaphore Granted 0.0 0.1 2 100.0 % Mirror Semaphore Waited 0.0 0.0 0 0.0 % ----------------------------------------------------------------------------- Device: /sybase/dbfiles/RMS_D15/dbccdbLG001.dat dbccdbLG001 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: /sybase/dbfiles/RMS_D15/gianniDA001.dat gianniDA001 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 0.0 0.1 2 100.0 % ------------------------- ------------ ------------ ---------- ---------- Total I/Os 0.0 0.1 2 2.8 % Mirror Semaphore Granted 0.0 0.1 2 100.0 % Mirror Semaphore Waited 0.0 0.0 0 0.0 % ----------------------------------------------------------------------------- Device: /sybase/dbfiles/RMS_D15/gianniDA002.dat gianniDA002 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: /sybase/dbfiles/RMS_D15/gianniLOG001.dat gianniLOG001 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: /sybase/dbfiles/RMS_D15/gianniLOG002.dat gianniLOG002 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: /sybase/dbfiles/RMS_D15/intesasuiteDA001.dat intesasuiteDA001 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 0.0 0.1 2 100.0 % ------------------------- ------------ ------------ ---------- ---------- Total I/Os 0.0 0.1 2 2.8 % Mirror Semaphore Granted 0.0 0.1 2 100.0 % Mirror Semaphore Waited 0.0 0.0 0 0.0 % ----------------------------------------------------------------------------- Device: /sybase/dbfiles/RMS_D15/intesasuiteLOG001.dat intesasuiteLOG001 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: /sybase/dbfiles/RMS_D15/master.dat master per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Reads APF 0.0 0.0 0 0.0 % Non-APF 0.0 0.0 0 0.0 % Writes 0.1 0.2 4 100.0 % ------------------------- ------------ ------------ ---------- ---------- Total I/Os 0.1 0.2 4 5.6 % Mirror Semaphore Granted 0.1 0.2 4 100.0 % Mirror Semaphore Waited 0.0 0.0 0 0.0 % ----------------------------------------------------------------------------- Device: /sybase/dbfiles/RMS_D15/plDA010.dat plDA010 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 0.0 0.1 2 100.0 % ------------------------- ------------ ------------ ---------- ---------- Total I/Os 0.0 0.1 2 2.8 % Mirror Semaphore Granted 0.0 0.1 2 100.0 % Mirror Semaphore Waited 0.0 0.0 0 0.0 % ----------------------------------------------------------------------------- Device: /sybase/dbfiles/RMS_D15/plDA020.dat plDA020 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: /sybase/dbfiles/RMS_D15/plDA030.dat plDA030 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: /sybase/dbfiles/RMS_D15/plDA040.dat plDA040 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: /sybase/dbfiles/RMS_D15/plLOG010.dat plLOG010 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: /sybase/dbfiles/RMS_D15/plLOG020.dat plLOG020 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: /sybase/dbfiles/RMS_D15/retailDA001.dat retailDA001 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 0.0 0.1 2 100.0 % ------------------------- ------------ ------------ ---------- ---------- Total I/Os 0.0 0.1 2 2.8 % Mirror Semaphore Granted 0.0 0.1 2 100.0 % Mirror Semaphore Waited 0.0 0.0 0 0.0 % ----------------------------------------------------------------------------- Device: /sybase/dbfiles/RMS_D15/retailLOG001.dat retailLOG001 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: /sybase/dbfiles/RMS_D15/sybsecurityDA001.dat sybsecurityDA001 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 0.0 0.1 2 100.0 % ------------------------- ------------ ------------ ---------- ---------- Total I/Os 0.0 0.1 2 2.8 % Mirror Semaphore Granted 0.0 0.1 2 100.0 % Mirror Semaphore Waited 0.0 0.0 0 0.0 % ----------------------------------------------------------------------------- Device: /sybase/dbfiles/RMS_D15/sybsecurityLG001.dat sybsecurityLG001 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: /sybase/dbfiles/RMS_D15/sybsysdb.dat systemdbdev 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: /sybase/dbfiles/RMS_D15/sysprocs.dat sysprocsdev 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 0.0 0.1 2 100.0 % ------------------------- ------------ ------------ ---------- ---------- Total I/Os 0.0 0.1 2 2.8 % Mirror Semaphore Granted 0.0 0.1 2 100.0 % Mirror Semaphore Waited 0.0 0.0 0 0.0 % ----------------------------------------------------------------------------- Device: /tempdb_device/tempdb01DA001.dat tempdb01DA001 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 0.0 0.0 1 100.0 % ------------------------- ------------ ------------ ---------- ---------- Total I/Os 0.0 0.0 1 1.4 % Mirror Semaphore Granted 0.0 0.0 1 100.0 % Mirror Semaphore Waited 0.0 0.0 0 0.0 % ----------------------------------------------------------------------------- Device: /tempdb_device/tempdb02DA001.dat tempdb02DA001 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 0.9 2.0 51 100.0 % ------------------------- ------------ ------------ ---------- ---------- Total I/Os 0.9 2.0 51 70.8 % Mirror Semaphore Granted 0.9 2.0 51 100.0 % Mirror Semaphore Waited 0.0 0.0 0 0.0 % ----------------------------------------------------------------------------- Device: /tempdb_device/tempdbDA01.dat tempdbDA01 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: /tempdb_device/tempdbdev.dat tempdbdev 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 % ----------------------------------------------------------------------------- =============================================================================== Network I/O Management ---------------------- Total Network I/O Requests 0.1 0.1 3 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.0 0.0 0 0.0 % Engine 2 0.0 0.0 1 25.0 % Engine 3 0.0 0.0 0 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 0.0 0.0 0 0.0 % Engine 8 0.0 0.0 0 0.0 % Engine 9 0.0 0.0 0 0.0 % Engine 10 0.0 0.0 0 0.0 % Engine 11 0.0 0.0 0 0.0 % Engine 12 0.0 0.0 0 0.0 % Engine 13 0.1 0.1 3 75.0 % Engine 14 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total TDS Packets Rec'd 0.1 0.2 4 Total Bytes Received per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Engine 0 0.0 0.0 0 0.0 % Engine 1 0.0 0.0 0 0.0 % Engine 2 0.0 0.0 0 0.0 % Engine 3 0.0 0.0 0 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 0.0 0.0 0 0.0 % Engine 8 0.0 0.0 0 0.0 % Engine 9 0.0 0.0 0 0.0 % Engine 10 0.0 0.0 0 0.0 % Engine 11 0.0 0.0 0 0.0 % Engine 12 0.0 0.0 0 0.0 % Engine 13 4.1 9.8 246 100.0 % Engine 14 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total Bytes Rec'd 4.1 9.8 246 Avg Bytes Rec'd per Packet n/a n/a 61 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.0 0.0 0 0.0 % Engine 2 0.0 0.0 0 0.0 % Engine 3 0.0 0.0 0 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 0.0 0.0 0 0.0 % Engine 8 0.0 0.0 0 0.0 % Engine 9 0.0 0.0 0 0.0 % Engine 10 0.0 0.0 0 0.0 % Engine 11 0.0 0.0 0 0.0 % Engine 12 0.0 0.0 0 0.0 % Engine 13 0.1 0.1 3 100.0 % Engine 14 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total TDS Packets Sent 0.1 0.1 3 Total Bytes Sent per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Engine 0 0.0 0.0 0 0.0 % Engine 1 0.0 0.0 0 0.0 % Engine 2 0.0 0.0 0 0.0 % Engine 3 0.0 0.0 0 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 0.0 0.0 0 0.0 % Engine 8 0.0 0.0 0 0.0 % Engine 9 0.0 0.0 0 0.0 % Engine 10 0.0 0.0 0 0.0 % Engine 11 0.0 0.0 0 0.0 % Engine 12 0.0 0.0 0 0.0 % Engine 13 3.4 8.1 203 100.0 % Engine 14 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total Bytes Sent 3.4 8.1 203 Avg Bytes Sent per Packet n/a n/a 67 n/a =============================== End of Report ================================= (return status = 0)
Moderator's Comments: | ||
|
# sed '/Engine 0/,/Average/!d;/Average/q' input Engine 0 0.0 % 0.0 % 100.0 % Engine 1 0.0 % 0.0 % 100.0 % Engine 2 0.2 % 0.0 % 99.8 % Engine 3 0.0 % 0.0 % 100.0 % Engine 4 0.0 % 0.0 % 100.0 % Engine 5 0.0 % 0.0 % 100.0 % Engine 6 0.0 % 0.0 % 100.0 % Engine 7 0.0 % 0.0 % 100.0 % 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 % Engine 12 0.0 % 0.0 % 100.0 % Engine 13 0.0 % 0.0 % 100.0 % Engine 14 0.0 % 0.0 % 100.0 % ------------------------ -------- -------- -------- Summary Total 0.2 % 0.0 % 1499.8 % Average 0.0 % 0.0 % 100.0 % #
|
|