Server RunDate ------------------------------ -------------------------- SEQUOIA Aug 6 2012 9:00AM (1 row affected) =============================================================================== Sybase Adaptive Server Enterprise System Performance Report =============================================================================== Server Version: Adaptive Server Enterprise/15.0.3/EBF 16742 ESD#2/P/RS60 Server Name: SEQUOIA Run Date: Aug 06, 2012 Sampling Started at: Aug 06, 2012 09:00:01 Sampling Ended at: Aug 06, 2012 10:00:00 Sample Interval: 00:59:59 Sample Mode: No Clear Counters Last Cleared: Aug 05, 2012 13:03:40 =============================================================================== Kernel Utilization ------------------ Your Runnable Process Search Count is set to 50 and I/O Polling Process Count is set to 10 Engine Busy Utilization CPU Busy I/O Busy Idle ------------------------ -------- -------- -------- Engine 0 22.3 % 7.9 % 69.8 % Engine 1 21.0 % 8.8 % 70.2 % Engine 2 27.6 % 6.6 % 65.8 % Engine 3 39.7 % 9.9 % 50.4 % ------------------------ -------- -------- -------- Summary Total 110.6 % 33.2 % 256.2 % Average 27.7 % 8.3 % 64.0 % CPU Yields by Engine per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Engine 0 195.4 1.9 703181 36.3 % Engine 1 126.1 1.3 453801 23.5 % Engine 2 115.9 1.2 417145 21.6 % Engine 3 100.3 1.0 361003 18.7 % ------------------------- ------------ ------------ ---------- Total CPU Yields 537.7 5.3 1935130 Network Checks Non-Blocking 12588.5 125.0 45306135 97.4 % Blocking 338.7 3.4 1218938 2.6 % ------------------------- ------------ ------------ ---------- Total Network I/O Checks 12927.2 128.4 46525073 Avg Net I/Os per Check n/a n/a 0.04724 n/a Disk I/O Checks Total Disk I/O Checks 13442.6 133.5 48379795 n/a Checks Returning I/O 3913.2 38.9 14083619 29.1 % Avg Disk I/Os Returned n/a n/a 0.10231 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 1.2 0.0 4139 n/a Task Context Switches by Engine Engine 0 146.8 1.5 528281 18.0 % Engine 1 128.8 1.3 463435 15.8 % Engine 2 110.0 1.1 395768 13.5 % Engine 3 429.4 4.3 1545541 52.7 % ------------------------- ------------ ------------ ---------- Total Task Switches: 815.0 8.1 2933025 Task Context Switches Due To: Voluntary Yields 37.3 0.4 134412 4.6 % Cache Search Misses 12.3 0.1 44275 1.5 % Exceeding I/O batch size 0.9 0.0 3327 0.1 % System Disk Writes 25.7 0.3 92604 3.2 % Logical Lock Contention 0.0 0.0 54 0.0 % Address Lock Contention 0.0 0.0 1 0.0 % Latch Contention 0.1 0.0 389 0.0 % Log Semaphore Contention 0.1 0.0 277 0.0 % PLC Lock Contention 0.0 0.0 40 0.0 % Group Commit Sleeps 0.6 0.0 2127 0.1 % Last Log Page Writes 28.6 0.3 102894 3.5 % Modify Conflicts 0.9 0.0 3267 0.1 % I/O Device Contention 0.0 0.0 0 0.0 % Network Packet Received 291.8 2.9 1050165 35.8 % Network Packet Sent 56.2 0.6 202386 6.9 % Network services 340.5 3.4 1225361 41.8 % Other Causes 19.9 0.2 71446 2.4 % =============================================================================== Application Management ---------------------- Application Statistics Summary (All Applications) ------------------------------------------------- Priority Changes per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- To High Priority 0.2 0.0 801 0.7 % To Medium Priority 17.6 0.2 63356 51.7 % To Low Priority 16.2 0.2 58418 47.7 % ------------------------- ------------ ------------ ---------- Total Priority Changes 34.1 0.3 122575 Allotted Slices Exhausted per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- High Priority 0.0 0.0 3 0.0 % Medium Priority 2.2 0.0 8024 98.2 % Low Priority 0.0 0.0 146 1.8 % ------------------------- ------------ ------------ ---------- Total Slices Exhausted 2.3 0.0 8173 Skipped Tasks By Engine per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Total Engine Skips 0.0 0.0 0 n/a Engine Scope Changes 1.2 0.0 4139 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 1325.5 13.2 4770525 93.5 % Dirty 92.4 0.9 332393 6.5 % ------------ ------------ ---------- Total Washes 1417.9 14.1 5102918 Garbage Collections 1.6 0.0 5764 n/a Pages Processed in GC 0.0 0.0 11 n/a Statistics Updates 0.7 0.0 2588 n/a =============================================================================== 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.9 0.0 3248 n/a Maximum SQL Text Requested n/a n/a 1215640 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 608598 (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 100.7 n/a 362477 n/a Transaction Detail per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Inserts APL Heap Table 1762.6 17.5 6343676 91.8 % APL Clustered Table 7.1 0.1 25554 0.4 % Data Only Lock Table 150.5 1.5 541583 7.8 % Fast Bulk Insert 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total Rows Inserted 1920.2 19.1 6910813 90.7 % Updates APL Deferred 6.6 0.1 23606 18.1 % APL Direct In-place 4.8 0.0 17285 13.2 % APL Direct Cheap 7.4 0.1 26656 20.4 % APL Direct Expensive 0.2 0.0 589 0.5 % DOL Deferred 1.6 0.0 5581 4.3 % DOL Direct 15.9 0.2 57052 43.6 % ------------------------- ------------ ------------ ---------- ---------- Total Rows Updated 36.3 0.4 130769 1.7 % Data Only Locked Updates DOL Replace 13.2 0.1 47659 76.1 % DOL Shrink 0.8 0.0 2877 4.6 % DOL Cheap Expand 0.1 0.0 410 0.7 % DOL Expensive Expand 3.0 0.0 10734 17.1 % DOL Expand & Forward 0.3 0.0 953 1.5 % DOL Fwd Row Returned 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total DOL Rows Updated 17.4 0.2 62633 0.8 % Deletes APL Deferred 6.5 0.1 23343 4.0 % APL Direct 11.4 0.1 41156 7.1 % DOL 143.3 1.4 515648 88.9 % ------------------------- ------------ ------------ ---------- ---------- Total Rows Deleted 161.2 1.6 580147 7.6 % ========================= ============ ============ ========== Total Rows Affected 2117.7 21.0 7621729 =============================================================================== Transaction Management ---------------------- ULC Flushes to Xact Log per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- by Full ULC 9.9 0.1 35495 6.9 % by End Transaction 55.5 0.6 199669 38.8 % by Change of Database 0.0 0.0 121 0.0 % by Single Log Record 1.5 0.0 5222 1.0 % by Unpin 76.1 0.8 273898 53.2 % by Other 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total ULC Flushes 142.9 1.4 514405 ULC Flushes Skipped per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- by PLC Discards 46.3 0.5 166476 100.0 % ------------------------- ------------ ------------ ---------- Total ULC Discards 46.3 0.5 166476 ULC Log Records 2864.4 28.4 10308924 n/a Max ULC Size During Sample n/a n/a 0 n/a ULC Semaphore Requests Granted 5934.6 58.9 21358621 100.0 % Waited 0.0 0.0 40 0.0 % ------------------------- ------------ ------------ ---------- Total ULC Semaphore Req 5934.6 58.9 21358661 Log Semaphore Requests Granted 224.5 2.2 808106 100.0 % Waited 0.1 0.0 277 0.0 % ------------------------- ------------ ------------ ---------- Total Log Semaphore Req 224.6 2.2 808383 Transaction Log Writes 206.6 2.1 743674 n/a Transaction Log Alloc 229.1 2.3 824447 n/a Avg # Writes per Log Page n/a n/a 0.90203 n/a =============================================================================== Index Management ---------------- Nonclustered Maintenance per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Ins/Upd Requiring Maint 17.2 0.2 62073 n/a # of NC Ndx Maint 17.9 0.2 64554 n/a Avg NC Ndx Maint / Op n/a n/a 1.03997 n/a Deletes Requiring Maint 2.9 0.0 10473 n/a # of NC Ndx Maint 2.5 0.0 9098 n/a Avg NC Ndx Maint / Op n/a n/a 0.86871 n/a RID Upd from Clust Split 0.0 0.0 156 n/a # of NC Ndx Maint 0.8 0.0 2817 n/a Avg NC Ndx Maint / Op n/a n/a 18.05769 n/a Upd/Del DOL Req Maint 160.7 1.6 578281 n/a # of DOL Ndx Maint 170.7 1.7 614258 n/a Avg DOL Ndx Maint / Op n/a n/a 1.06221 n/a Page Splits 0.7 0.0 2502 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 60 n/a Deadlocks % Deadlock Retries Exceeded 0.0 0.0 0 0.0 % Index Scans per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Ascending Scans 705.4 7.0 2538816 21.6 % DOL Ascending Scans 2550.4 25.3 9178969 77.9 % Descending Scans 17.2 0.2 61922 0.5 % DOL Descending Scans 0.0 0.0 1 0.0 % ------------ ------------ ---------- Total Scans 3273.1 32.5 11779708 =============================================================================== Metadata Cache Management ------------------------- Metadata Cache Summary per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Open Object Usage Active n/a n/a 4694 n/a Max Ever Used Since Boot n/a n/a 4694 n/a Free n/a n/a 2806 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 5271 n/a Max Ever Used Since Boot n/a n/a 5271 n/a Free n/a n/a 1729 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 5271 n/a Max Ever Used Since Boot n/a n/a 5271 n/a Free n/a n/a 1729 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 8 n/a Max Ever Used Since Boot n/a n/a 8 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.2 % 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 24278.9 241.1 87379793 n/a Avg Lock Contention 0.0 0.0 55 0.0 % Deadlock Percentage 0.0 0.0 0 0.0 % Lock Detail per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Table Lock Hashtable Lookups 2280.3 22.6 8206839 n/a Avg Chain Length n/a n/a 0.02569 n/a Spinlock Contention n/a n/a n/a 0.0 % Exclusive Table Granted 91.5 0.9 329428 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total EX-Table Requests 91.5 0.9 329428 0.4 % Shared Table Granted 0.2 0.0 850 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total SH-Table Requests 0.2 0.0 850 0.0 % Exclusive Intent Granted 159.5 1.6 573981 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total EX-Intent Requests 159.5 1.6 573981 0.7 % Shared Intent Granted 1971.3 19.6 7094868 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total SH-Intent Requests 1971.3 19.6 7094868 8.1 % Page & Row Lock HashTable Lookups 20824.5 206.8 74947300 n/a Avg Chain Length n/a n/a 0.00326 n/a Spinlock Contention n/a n/a n/a 0.1 % Exclusive Page Granted 18.2 0.2 65658 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total EX-Page Requests 18.2 0.2 65658 0.1 % Update Page Granted 3.7 0.0 13139 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total UP-Page Requests 3.7 0.0 13139 0.0 % Shared Page Granted 5139.1 51.0 18495541 100.0 % Waited 0.0 0.0 14 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total SH-Page Requests 5139.1 51.0 18495555 21.2 % Exclusive Row Granted 333.6 3.3 1200589 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total EX-Row Requests 333.6 3.3 1200589 1.4 % Update Row Granted 151.8 1.5 546150 100.0 % Waited 0.0 0.0 39 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total UP-Row Requests 151.8 1.5 546189 0.6 % Shared Row Granted 14872.3 147.7 53525504 100.0 % Waited 0.0 0.0 1 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total SH-Row Requests 14872.3 147.7 53525505 61.3 % Next-Key Total Next-Key Requests 0.0 0.0 0 n/a Address Lock Hashtable Lookups 1537.7 15.3 5534032 n/a Avg Chain Length n/a n/a 0.00011 n/a Spinlock Contention n/a n/a n/a 0.0 % Exclusive Address Granted 70.5 0.7 253727 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total EX-Address Requests 70.5 0.7 253727 0.3 % Shared Address Granted 1467.2 14.6 5280303 100.0 % Waited 0.0 0.0 1 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total SH-Address Requests 1467.2 14.6 5280304 6.0 % Last Page Locks on Heaps Granted 1762.6 17.5 6343676 100.0 % Waited 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- ---------- Total Last Pg Locks 1762.6 17.5 6343676 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 14 n/a Searches Skipped 0.0 0.0 0 0.0 % Avg Deadlocks per Search n/a n/a 0.00000 n/a Lock Promotions Ex-Page to Ex-Table 0.0 0.0 119 100.0 % Sh-Page to Sh-Table 0.0 0.0 0 0.0 % Ex-Row to Ex-Table 0.0 0.0 0 0.0 % Sh-Row to Sh-Table 0.0 0.0 0 0.0 % Sh-Next-Key to Sh-Table 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total Lock Promotions 0.0 0.0 119 Lock Timeouts by Lock Type per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Total Timeouts 0.0 0.0 0 n/a Tuning Recommendations for Lock Management ------------------------------------------ - Consider increasing the 'deadlock checking period' parameter by 50 ms. =============================================================================== Data Cache Management --------------------- Cache Statistics Summary (All Caches) ------------------------------------- per sec per xact count % of total ------------ ------------ ---------- ---------- Cache Search Summary Total Cache Hits 113681.2 1128.7 409138542 99.5 % Total Cache Misses 559.1 5.6 2012145 0.5 % ------------------------- ------------ ------------ ---------- Total Cache Searches 114240.3 1134.3 411150687 Cache Turnover Buffers Grabbed 722.4 7.2 2599844 n/a Buffers Grabbed Dirty 0.0 0.0 0 0.0 % Cache Strategy Summary Cached (LRU) Buffers 113401.3 1126.0 408131278 100.0 % Discarded (MRU) Buffers 0.0 0.0 103 0.0 % Large I/O Usage Large I/Os Performed 8.6 0.1 31020 5.6 % Large I/Os Denied due to Pool < Prefetch Size 1.4 0.0 4895 0.9 % Pages Requested Reside in Another Buffer Pool 144.8 1.4 521184 93.6 % ------------------------- ------------ ------------ ---------- Total Large I/O Requests 154.8 1.5 557099 Large I/O Effectiveness Pages by Lrg I/O Cached 23.4 0.2 84382 n/a Pages by Lrg I/O Used 14.9 0.1 53804 63.8 % Asynchronous Prefetch Activity APFs Issued 3.8 0.0 13678 1.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 7 0.0 % W/o Spinlock Held 378.5 3.8 1362252 99.0 % ------------------------- ------------ ------------ ---------- Total APFs Requested 382.3 3.8 1375937 Other Asynchronous Prefetch Statistics APFs Used 3.6 0.0 12830 n/a APF Waits for I/O 1.4 0.0 4974 n/a APF Discards 0.0 0.0 0 n/a Dirty Read Behavior Page Requests 213.7 2.1 769029 n/a Re-Starts 0.0 0.0 1 0.0 % ------------------------------------------------------------------------------- Cache: dbcc_cache per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Spinlock Contention n/a n/a n/a 0.3 % Utilization n/a n/a n/a 0.0 % Cache Searches Cache Hits 0.1 0.0 180 100.0 % Found in Wash 0.1 0.0 180 100.0 % Cache Misses 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total Cache Searches 0.1 0.0 180 Pool Turnover 0.0 0.0 0 n/a Buffer Wash Behavior Statistics Not Available - No Buffers Entered Wash Section Yet Cache Strategy Cached (LRU) Buffers 0.1 0.0 180 100.0 % Discarded (MRU) Buffers 0.0 0.0 0 0.0 % 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 using 'relaxed LRU replacement policy' for this 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.5 % Utilization n/a n/a n/a 86.9 % Cache Searches Cache Hits 99253.8 985.5 357214525 100.0 % Found in Wash 977.1 9.7 3516716 1.0 % Cache Misses 6.5 0.1 23459 0.0 % ------------------------- ------------ ------------ ---------- Total Cache Searches 99260.3 985.5 357237984 Pool Turnover 2 Kb Pool LRU Buffer Grab 9.0 0.1 32244 95.9 % Grabbed Dirty 0.0 0.0 0 0.0 % 8 Kb Pool LRU Buffer Grab 0.4 0.0 1381 4.1 % Grabbed Dirty 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total Cache Turnover 9.3 0.1 33625 Buffer Wash Behavior Statistics Not Available - No Buffers Entered Wash Section Yet Cache Strategy Cached (LRU) Buffers 99497.4 987.9 358091101 100.0 % Discarded (MRU) Buffers 0.0 0.0 103 0.0 % Large I/O Usage Large I/Os Performed 0.4 0.0 1381 52.5 % Large I/Os Denied due to Pool < Prefetch Size 0.0 0.0 0 0.0 % Pages Requested Reside in Another Buffer Pool 0.3 0.0 1249 47.5 % ------------------------- ------------ ------------ ---------- Total Large I/O Requests 0.7 0.0 2630 Large I/O Detail 8 Kb Pool Pages Cached 1.5 0.0 5524 n/a Pages Used 1.1 0.0 3845 69.6 % Dirty Read Behavior Page Requests 211.6 2.1 761432 n/a Tuning Recommendations for Data cache : default data cache ------------------------------------- - Consider using 'relaxed LRU replacement policy' for this cache. ------------------------------------------------------------------------------- Cache: alpha_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 1.4 % Cache Searches Cache Hits 1634.7 16.2 5883421 99.7 % Found in Wash 180.4 1.8 649342 11.0 % Cache Misses 5.4 0.1 19336 0.3 % ------------------------- ------------ ------------ ---------- Total Cache Searches 1640.1 16.3 5902757 Pool Turnover 2 Kb Pool LRU Buffer Grab 12.2 0.1 43948 96.8 % Grabbed Dirty 0.0 0.0 0 0.0 % 8 Kb Pool LRU Buffer Grab 0.4 0.0 1436 3.2 % Grabbed Dirty 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total Cache Turnover 12.6 0.1 45384 Buffer Wash Behavior Statistics Not Available - No Buffers Entered Wash Section Yet Cache Strategy Cached (LRU) Buffers 769.9 7.6 2770704 100.0 % Discarded (MRU) Buffers 0.0 0.0 0 0.0 % Large I/O Usage Large I/Os Performed 0.4 0.0 1436 81.1 % Large I/Os Denied due to Pool < Prefetch Size 0.0 0.0 0 0.0 % Pages Requested Reside in Another Buffer Pool 0.1 0.0 334 18.9 % ------------------------- ------------ ------------ ---------- Total Large I/O Requests 0.5 0.0 1770 Large I/O Detail 8 Kb Pool Pages Cached 1.6 0.0 5744 n/a Pages Used 0.5 0.0 1907 33.2 % Dirty Read Behavior Page Requests 2.1 0.0 7597 n/a Tuning Recommendations for Data cache : alpha_cache ------------------------------------- - Consider using 'relaxed LRU replacement policy' for this cache. ------------------------------------------------------------------------------- Cache: log_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 Cache Hits 45.1 0.4 162386 100.0 % Found in Wash 0.0 0.0 0 0.0 % Cache Misses 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total Cache Searches 45.1 0.4 162386 Pool Turnover 2 Kb Pool LRU Buffer Grab 0.0 0.0 156 0.8 % Grabbed Dirty 0.0 0.0 0 0.0 % 4 Kb Pool LRU Buffer Grab 5.5 0.1 19849 99.2 % Grabbed Dirty 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total Cache Turnover 5.6 0.1 20005 Buffer Wash Behavior Buffers Passed Clean 5.5 0.1 19830 100.0 % Buffers Already in I/O 0.0 0.0 0 0.0 % Buffers Washed Dirty 0.0 0.0 0 0.0 % Cache Strategy Cached (LRU) Buffers 11.1 0.1 39989 100.0 % Discarded (MRU) Buffers 0.0 0.0 0 0.0 % Large I/O Usage Large I/Os Performed 5.5 0.1 19849 99.2 % 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 156 0.8 % ------------------------- ------------ ------------ ---------- Total Large I/O Requests 5.6 0.1 20005 Large I/O Detail 4 Kb Pool Pages Cached 11.0 0.1 39698 n/a Pages Used 11.0 0.1 39698 100.0 % Dirty Read Behavior Page Requests 0.0 0.0 0 n/a Tuning Recommendations for Data cache : log_cache ------------------------------------- - Consider using 'relaxed LRU replacement policy' for this cache. ------------------------------------------------------------------------------- Cache: beta_cache per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Spinlock Contention n/a n/a n/a 0.2 % Utilization n/a n/a n/a 6.5 % Cache Searches Cache Hits 7468.7 74.2 26879998 100.0 % Found in Wash 193.1 1.9 694877 2.6 % Cache Misses 0.4 0.0 1480 0.0 % ------------------------- ------------ ------------ ---------- Total Cache Searches 7469.2 74.2 26881478 Pool Turnover 2 Kb Pool LRU Buffer Grab 1.5 0.0 5443 100.0 % Grabbed Dirty 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total Cache Turnover 1.5 0.0 5443 Buffer Wash Behavior Statistics Not Available - No Buffers Entered Wash Section Yet Cache Strategy Cached (LRU) Buffers 7460.5 74.1 26850269 100.0 % Discarded (MRU) Buffers 0.0 0.0 0 0.0 % Large I/O Usage Total Large I/O Requests 0.0 0.0 0 n/a Large I/O Detail 8 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 : beta_cache ------------------------------------- - Consider using 'relaxed LRU replacement policy' for this cache. ------------------------------------------------------------------------------- Cache: tempdb_cache per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Spinlock Contention n/a n/a n/a 0.1 % Utilization n/a n/a n/a 5.1 % Cache Searches Cache Hits 5278.7 52.4 18998032 90.6 % Found in Wash 47.7 0.5 171800 0.9 % Cache Misses 546.8 5.4 1967870 9.4 % ------------------------- ------------ ------------ ---------- Total Cache Searches 5825.5 57.8 20965902 Pool Turnover 2 Kb Pool LRU Buffer Grab 691.0 6.9 2487033 99.7 % Grabbed Dirty 0.0 0.0 0 0.0 % 8 Kb Pool LRU Buffer Grab 2.3 0.0 8354 0.3 % Grabbed Dirty 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total Cache Turnover 693.4 6.9 2495387 Buffer Wash Behavior Statistics Not Available - No Buffers Entered Wash Section Yet Cache Strategy Cached (LRU) Buffers 5662.4 56.2 20379035 100.0 % Discarded (MRU) Buffers 0.0 0.0 0 0.0 % Large I/O Usage Large I/Os Performed 2.3 0.0 8354 1.6 % Large I/Os Denied due to Pool < Prefetch Size 0.9 0.0 3156 0.6 % Pages Requested Reside in Another Buffer Pool 144.8 1.4 521184 97.8 % ------------------------- ------------ ------------ ---------- Total Large I/O Requests 148.0 1.5 532694 Large I/O Detail 8 Kb Pool Pages Cached 9.3 0.1 33416 n/a Pages Used 2.3 0.0 8354 25.0 % Dirty Read Behavior Page Requests 0.0 0.0 0 n/a =============================================================================== Procedure Cache Management per sec per xact count % of total --------------------------- ------------ ------------ ---------- ---------- Procedure Requests 96.8 1.0 348490 n/a Procedure Reads from Disk 0.9 0.0 3373 1.0 % Procedure Writes to Disk 0.1 0.0 533 0.2 % Procedure Removals 1.8 0.0 6562 n/a Procedure Recompilations 0.7 0.0 2587 n/a Recompilations Requests: Execution Phase 0.5 0.0 1884 72.8 % Compilation Phase 0.2 0.0 703 27.2 % Execute Cursor Execution 0.0 0.0 0 0.0 % Redefinition Phase 0.0 0.0 0 0.0 % Recompilation Reasons: Table Missing 0.7 0.0 2381 n/a Temporary Table Missing 0.7 0.0 2381 n/a Schema Change 0.0 0.0 2 n/a Index Change 0.0 0.0 0 n/a Isolation Level Change 0.0 0.0 0 n/a Permissions Change 0.0 0.0 0 n/a Cursor Permissions Change 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.0 0 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 140.0 1.4 503938 n/a =============================================================================== Memory Management per sec per xact count % of total --------------------------- ------------ ------------ ---------- ---------- Pages Allocated 171.6 1.7 617459 n/a Pages Released 171.6 1.7 617464 n/a =============================================================================== Recovery Management ------------------- Checkpoints per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- # of Normal Checkpoints 0.0 0.0 136 100.0 % # of Free Checkpoints 0.0 0.0 0 0.0 % ------------------------- ------------ ------------ ---------- Total Checkpoints 0.0 0.0 136 Avg Time per Normal Chkpt 1.93382 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 282 n/a Engine 1 n/a n/a 206 n/a Engine 2 n/a n/a 207 n/a Engine 3 n/a n/a 248 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 400.4 4.0 1440950 Completed Disk I/O's Asynchronous I/O's Engine 0 93.5 0.9 336392 23.3 % Engine 1 100.6 1.0 362114 25.1 % Engine 2 92.5 0.9 332779 23.1 % Engine 3 113.8 1.1 409670 28.4 % Synchronous I/O's Total Completed I/Os 0.0 0.0 0 n/a ------------------------- ------------ ------------ ---------- Total Completed I/Os 400.4 4.0 1440955 Device Activity Detail ---------------------- Device: /prod2/ase15/system15/data/dbcclog.dat dbcclog 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: /prod2/ase15/system15/data/dbcclog2.dat dbcclog2 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: /prod2/ase15/system15/data/dbcclog3.dat dbcclog3 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: /prod2/ase15/system15/data/dbccscan.dat dbccscan 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 60 100.0 % ------------------------- ------------ ------------ ---------- ---------- Total I/Os 0.0 0.0 60 0.0 % ----------------------------------------------------------------------------- Device: /prod2/ase15/system15/data/dbcctext.dat dbcctext 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: /prod2/ase15/system15/data/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 11 0.1 % Writes 2.3 0.0 8378 99.9 % ------------------------- ------------ ------------ ---------- ---------- Total I/Os 2.3 0.0 8389 0.6 % ----------------------------------------------------------------------------- Device: /prod2/ase15/system15/data/mondev1.dat mondev1 per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Reads APF 0.0 0.0 0 0.0 % Non-APF 0.2 0.0 826 0.2 % Writes 115.4 1.1 415468 99.8 % ------------------------- ------------ ------------ ---------- ---------- Total I/Os 115.7 1.1 416294 28.9 % ----------------------------------------------------------------------------- Device: /prod2/ase15/system15/data/monlog1.dat monlog1 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 174.0 1.7 626332 100.0 % ------------------------- ------------ ------------ ---------- ---------- Total I/Os 174.0 1.7 626332 43.5 % ----------------------------------------------------------------------------- Device: /prod2/ase15/system15/data/surdev1.dat surdev1 per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Reads APF 0.1 0.0 185 1.3 % Non-APF 1.6 0.0 5633 40.8 % Writes 2.2 0.0 7977 57.8 % ------------------------- ------------ ------------ ---------- ---------- Total I/Os 3.8 0.0 13795 1.0 % ----------------------------------------------------------------------------- Device: /prod2/ase15/system15/data/surdev2.dat surdev2 per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Reads APF 0.4 0.0 1329 17.5 % Non-APF 1.4 0.0 4879 64.1 % Writes 0.4 0.0 1406 18.5 % ------------------------- ------------ ------------ ---------- ---------- Total I/Os 2.1 0.0 7614 0.5 % ----------------------------------------------------------------------------- Device: /prod2/ase15/system15/data/surdev3.dat surdev3 per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Reads APF 0.1 0.0 205 1.5 % Non-APF 1.7 0.0 6074 44.4 % Writes 2.1 0.0 7395 54.1 % ------------------------- ------------ ------------ ---------- ---------- Total I/Os 3.8 0.0 13674 0.9 % ----------------------------------------------------------------------------- Device: /prod2/ase15/system15/data/surdev4.dat surdev4 per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Reads APF 0.2 0.0 630 6.4 % Non-APF 1.6 0.0 5760 58.9 % Writes 0.9 0.0 3395 34.7 % ------------------------- ------------ ------------ ---------- ---------- Total I/Os 2.7 0.0 9785 0.7 % ----------------------------------------------------------------------------- Device: /prod2/ase15/system15/data/surdev5.dat surdev5 per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Reads APF 0.2 0.0 607 6.4 % Non-APF 1.4 0.0 5147 54.2 % Writes 1.0 0.0 3740 39.4 % ------------------------- ------------ ------------ ---------- ---------- Total I/Os 2.6 0.0 9494 0.7 % ----------------------------------------------------------------------------- Device: /prod2/ase15/system15/data/surdev6.dat surdev6 per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Reads APF 0.2 0.0 842 3.8 % Non-APF 1.3 0.0 4625 20.8 % Writes 4.7 0.0 16809 75.5 % ------------------------- ------------ ------------ ---------- ---------- Total I/Os 6.2 0.1 22276 1.5 % ----------------------------------------------------------------------------- Device: /prod2/ase15/system15/data/surdev7.dat surdev7 per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Reads APF 0.2 0.0 747 11.2 % Non-APF 0.9 0.0 3256 48.6 % Writes 0.7 0.0 2693 40.2 % ------------------------- ------------ ------------ ---------- ---------- Total I/Os 1.9 0.0 6696 0.5 % ----------------------------------------------------------------------------- Device: /prod2/ase15/system15/data/surdev8.dat surdev8 per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Reads APF 0.8 0.0 3053 23.4 % Non-APF 1.3 0.0 4730 36.3 % Writes 1.5 0.0 5253 40.3 % ------------------------- ------------ ------------ ---------- ---------- Total I/Os 3.6 0.0 13036 0.9 % ----------------------------------------------------------------------------- Device: /prod2/ase15/system15/data/surdev9.dat surdev9 per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Reads APF 1.5 0.0 5298 26.5 % Non-APF 0.9 0.0 3186 15.9 % Writes 3.2 0.0 11513 57.6 % ------------------------- ------------ ------------ ---------- ---------- Total I/Os 5.6 0.1 19997 1.4 % ----------------------------------------------------------------------------- Device: /prod2/ase15/system15/data/surlog1.dat surlog1 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 34.0 0.3 122454 100.0 % ------------------------- ------------ ------------ ---------- ---------- Total I/Os 34.0 0.3 122454 8.5 % ----------------------------------------------------------------------------- Device: /prod2/ase15/system15/data/surlog2.dat surlog2 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: /prod2/ase15/system15/data/surlog3.dat surlog3 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: /prod2/ase15/system15/data/surlog4.dat surlog4 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: /prod2/ase15/system15/data/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: /prod2/ase15/system15/data/sysprocs.dat sysprocsdev per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Reads APF 0.2 0.0 782 79.1 % Non-APF 0.0 0.0 147 14.9 % Writes 0.0 0.0 60 6.1 % ------------------------- ------------ ------------ ---------- ---------- Total I/Os 0.3 0.0 989 0.1 % ----------------------------------------------------------------------------- Device: /prod2/ase15/system15/data/tmpdbdev1.dat tempdbdev per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Reads APF 0.0 0.0 0 0.0 % Non-APF 0.0 0.0 1 0.0 % Writes 30.0 0.3 107901 100.0 % ------------------------- ------------ ------------ ---------- ---------- Total I/Os 30.0 0.3 107902 7.5 % ----------------------------------------------------------------------------- Device: /prod2/ase15/system15/data/tmpdbdev2.dat tmpdbdev2 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 11.5 0.1 41449 100.0 % ------------------------- ------------ ------------ ---------- ---------- Total I/Os 11.5 0.1 41449 2.9 % ----------------------------------------------------------------------------- Device: /prod2/ase15/system15/data/tmpdblog1.dat tmpdblog1 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.2 0.0 716 100.0 % ------------------------- ------------ ------------ ---------- ---------- Total I/Os 0.2 0.0 716 0.0 % ----------------------------------------------------------------------------- =============================================================================== Network I/O Management ---------------------- Total Network I/O Requests 348.0 3.5 1252552 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 43.5 0.4 156601 14.9 % Engine 1 33.2 0.3 119385 11.4 % Engine 2 30.6 0.3 110264 10.5 % Engine 3 184.5 1.8 663870 63.2 % ------------------------- ------------ ------------ ---------- Total TDS Packets Rec'd 291.8 2.9 1050120 Total Bytes Received per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Engine 0 7577.7 75.2 27272101 14.2 % Engine 1 6590.0 65.4 23717278 12.4 % Engine 2 6567.5 65.2 23636389 12.3 % Engine 3 32533.1 323.0 117086571 61.1 % ------------------------- ------------ ------------ ---------- Total Bytes Rec'd 53268.2 528.9 191712339 Avg Bytes Rec'd per Packet n/a n/a 182 n/a ----------------------------------------------------------------------------- Total TDS Packets Sent per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Engine 0 47.7 0.5 171577 14.9 % Engine 1 34.9 0.3 125621 10.9 % Engine 2 37.8 0.4 136136 11.9 % Engine 3 198.5 2.0 714346 62.2 % ------------------------- ------------ ------------ ---------- Total TDS Packets Sent 318.9 3.2 1147680 Total Bytes Sent per sec per xact count % of total ------------------------- ------------ ------------ ---------- ---------- Engine 0 14177.9 140.8 51026322 15.9 % Engine 1 8466.9 84.1 30472417 9.5 % Engine 2 14979.0 148.7 53909391 16.8 % Engine 3 51571.1 512.0 185604481 57.8 % ------------------------- ------------ ------------ ---------- Total Bytes Sent 89194.9 885.6 321012611 Avg Bytes Sent per Packet n/a n/a 279 n/a =============================== End of Report ================================= (return status = 0) Server RunDate ------------------------------ -------------------------- SEQUOIA Aug 6 2012 10:00AM (1 row affected)