02-14-2011
this is my input file.
Code :
===============================================================================
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:
Please use code tags.
Last edited by Scott; 02-14-2011 at 11:18 AM ..
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi
I would like to know wheather there is anyway to pass a variable to grep argument like this
grep "$myvar" $myfile
i would put this in a function and then call this function by setting different values to myvar and myfile.
is this possible at all.
regards
Hrishy (4 Replies)
Discussion started by: xiamin
4 Replies
2. Shell Programming and Scripting
I have a large file that I am grepping to find a certain string.
grep 'C:\Data\Directory\Test.txt' test.txt
It can not find it even though I know it is in there . I know that there is a problem with the backslashes but I can't get it to work. I tried
grep... (2 Replies)
Discussion started by: lesstjm
2 Replies
3. UNIX for Dummies Questions & Answers
Hi there, this is a very simple question.
When I do grep -c "PWD" filename, I get 5. This means the filename contains 5 lines of "PWD" occurence.
I tried to assign to a variable. int= grep -c "PWD" filename
When I typed echo $int
The output:
5
I get an empty line space. Now I... (1 Reply)
Discussion started by: felixwhoals
1 Replies
4. Shell Programming and Scripting
I have a problem. Suppose I have a log named transport.log
>>
tp finished with return code: 203
meaning:
wrong syntax in tp call
....
tp finished with return code: 0
meaning:
Everything ok.
<<
What i want to do is to get the return code of the 1st one. So I would probably do:... (2 Replies)
Discussion started by: kdyzsa
2 Replies
5. Homework & Coursework Questions
Changed Problem its a sed actually...
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
Use a sed command to create an output file from the input file. The input... (2 Replies)
Discussion started by: skalidindi
2 Replies
6. Shell Programming and Scripting
Hi,
When i try this it is not executing either result or total, pls can any one help me in this.
max=month_134.log
grep result|total $max > log.txt
In month_134.log, it should contain either result or total and then send it to log.txt.It should execute result or total in log.txt
... (3 Replies)
Discussion started by: NehaKrish
3 Replies
7. UNIX for Dummies Questions & Answers
Hi
I am trying to grep a string in a directory which is having 5000 files.
PA>> grep -iH 'linc.unisure_pr13n' *
bash: /usr/bin/grep: Arg list too long
I am getting the error. i also tried
PA>> ls -ltr | grep -iH 'linc.unisure_pr13n' *
but still i am getting the error
Please Advice... (4 Replies)
Discussion started by: subhotech
4 Replies
8. Shell Programming and Scripting
Hi everyone
i am facing a strange problem in grep below is the code
RC=0
grep $ERROR_MASK $LOG_FILE 2>&1 > /dev/null && RC=1 || RC=0
what does the above statment do i mean it search for error mask into log file and redirect the error to console null then what's the meaning of RC=1 ||... (2 Replies)
Discussion started by: aishsimplesweet
2 Replies
9. Shell Programming and Scripting
Hello. I'm learning shell scripting right now and I'm trying simple scripts. I have a problem with the one below. The idea is to found the number of files containing asd in their name. Here's the code:
#!/bin/sh
pattern=asd
total=0
for f in *
do
&& continue
if grep $pattern $f >... (3 Replies)
Discussion started by: EmZvr
3 Replies
10. UNIX for Dummies Questions & Answers
I don't know if you guys get this problem sometimes at Terminal but I had been having this problem since yesterday :( Maybe I overdid the Terminal. Even the codes that used to work doesn't work anymore.
Here is what 's happening:
* I wanted to remove lines containing digits so I used this... (25 Replies)
Discussion started by: Nexeu
25 Replies