Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Performance issues

3 posts in General Discussion Last posting was on 2010-03-21 16:36:23.0Z
Rajasekhar Reddy Posted on 2010-03-18 03:23:48.0Z
Sender: 7f73.4ba19a21.1804289383@sybase.com
From: Rajasekhar Reddy
Newsgroups: sybase.public.ase.general
Subject: Performance issues
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4ba19cc4.7ffa.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 17 Mar 2010 19:23:48 -0800
X-Trace: forums-1-dub 1268882628 10.22.241.41 (17 Mar 2010 19:23:48 -0800)
X-Original-Trace: 17 Mar 2010 19:23:48 -0800, 10.22.241.41
Lines: 2746
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29053
Article PK: 78291

Hello,

We are facing performance issues. It is likely due
Network problems(suspicious/Found). How can I find is it
network issue at database level ? I meant, wanna make sure
is the problem from Network or something else ?

I ran sysmon for 30 min. Please have a look into the below
report. Please let me know is there any other way to find
out ?

===============================================================================
Sybase Adaptive Server Enterprise System Performance
Report
===============================================================================

Server Version: Adaptive Server Enterprise/12.5.4/EBF
14067 ESD#3/P/RS60
Server Name: XXXXXXX
Run Date: Mar 18, 2010
Sampling Started at: Mar 18, 2010 12:24:34
Sampling Ended at: Mar 18, 2010 12:54:35
Sample Interval: 00:30:01
Sample Mode: Reset Counters

===============================================================================

Kernel Utilization
------------------

Your Runnable Process Search Count is set to 3
and I/O Polling Process Count is set to 10

Engine Busy Utilization CPU Busy I/O Busy
Idle
------------------------ -------- --------
--------
Engine 0 19.1 % 3.1 %
77.8 %
Engine 1 13.4 % 3.7 %
82.8 %
Engine 2 13.3 % 3.9 %
82.8 %
Engine 3 13.3 % 4.8 %
82.0 %
Engine 4 21.8 % 3.4 %
74.9 %
Engine 5 27.9 % 40.1 %
32.0 %
------------------------ -------- --------
--------
Summary Total 108.7 % 58.9 %
432.4 %
Average 18.1 % 9.8 %
72.1 %

CPU Yields by Engine per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Engine 0 175.6 1.3
316179 15.3 %
Engine 1 128.2 0.9
230853 11.2 %
Engine 2 127.4 0.9
229438 11.1 %
Engine 3 139.4 1.0
251009 12.1 %
Engine 4 155.1 1.1
279290 13.5 %
Engine 5 422.7 3.1
761298 36.8 %
------------------------- ------------ ------------
----------
Total CPU Yields 1148.3 8.4
2068067

Network Checks
Non-Blocking 2237.8 16.3
4030317 69.9 %
Blocking 961.8 7.0
1732172 30.1 %
------------------------- ------------ ------------
----------
Total Network I/O Checks 3199.6 23.3
5762489
Avg Net I/Os per Check n/a n/a
0.58331 n/a

Disk I/O Checks
Total Disk I/O Checks 4072.5 29.7
7334578 n/a
Checks Returning I/O 632.0 4.6
1138299 15.5 %
Avg Disk I/Os Returned n/a n/a
0.31980 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.1 0.0
225 n/a

Task Context Switches by Engine
Engine 0 100.7 0.7
181287 7.0 %
Engine 1 165.9 1.2
298810 11.5 %
Engine 2 112.4 0.8
202484 7.8 %
Engine 3 106.5 0.8
191895 7.4 %
Engine 4 116.7 0.9
210218 8.1 %
Engine 5 842.7 6.1
1517669 58.3 %
------------------------- ------------ ------------
----------
Total Task Switches: 1445.0 10.5
2602363

Task Context Switches Due To:
Voluntary Yields 152.3 1.1
274239 10.5 %
Cache Search Misses 1.7 0.0
3014 0.1 %
System Disk Writes 0.2 0.0
300 0.0 %
I/O Pacing 27.9 0.2
50305 1.9 %
Logical Lock Contention 0.0 0.0
87 0.0 %
Address Lock Contention 0.0 0.0
0 0.0 %
Latch Contention 0.0 0.0
13 0.0 %
Log Semaphore Contention 0.6 0.0
1035 0.0 %
PLC Lock Contention 0.0 0.0
42 0.0 %
Group Commit Sleeps 5.6 0.0
10010 0.4 %
Last Log Page Writes 131.7 1.0
237103 9.1 %
Modify Conflicts 8.4 0.1
15130 0.6 %
I/O Device Contention 0.0 0.0
0 0.0 %
Network Packet Received 424.0 3.1
763682 29.3 %
Network Packet Sent 119.2 0.9
214763 8.3 %
Other Causes 573.4 4.2
1032640 39.7 %


===============================================================================

Application Management
----------------------

Application Statistics Summary (All Applications)
-------------------------------------------------
Priority Changes per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
To High Priority 0.7 0.0
1183 10.1 %
To Medium Priority 3.3 0.0
5959 50.9 %
To Low Priority 2.5 0.0
4557 39.0 %
------------------------- ------------ ------------
----------
Total Priority Changes 6.5 0.0
11699

Allotted Slices Exhausted per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
High Priority 0.0 0.0
0 0.0 %
Medium Priority 3.3 0.0
5869 100.0 %
Low Priority 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
----------
Total Slices Exhausted 3.3 0.0
5869

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 180.5 1.3
325041 99.7 %
Dirty 0.5 0.0
859 0.3 %
------------ ------------
----------
Total Washes 181.0 1.3
325900

Garbage Collections 1.2 0.0
2148 n/a
Pages Processed in GC 0.0 0.0
2 n/a

Statistics Updates 11.7 0.1
21108 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 3.8 0.0
6777 n/a
Maximum SQL Text Requested n/a n/a
21407 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 11727 (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 137.1 n/a
246963 n/a

Transaction Detail per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Inserts
APL Heap Table 522.7 3.8
941380 3.0 %
APL Clustered Table 16610.8 121.1
29916062 95.3 %
Data Only Lock Table 290.9 2.1
523831 1.7 %
------------------------- ------------ ------------
---------- ----------
Total Rows Inserted 17424.4 127.1
31381273 99.2 %

Updates
APL Deferred 0.0 0.0
0 0.0 %
APL Direct In-place 0.0 0.0
1 0.0 %
APL Direct Cheap 0.0 0.0
11 0.1 %
APL Direct Expensive 0.0 0.0
0 0.0 %
DOL Deferred 0.0 0.0
0 0.0 %
DOL Direct 11.9 0.1
21404 99.9 %
------------------------- ------------ ------------
---------- ----------
Total Rows Updated 11.9 0.1
21416 0.1 %

Data Only Locked Updates
DOL Replace 11.9 0.1
21392 99.9 %
DOL Shrink 0.0 0.0
2 0.0 %
DOL Cheap Expand 0.0 0.0
1 0.0 %
DOL Expensive Expand 0.0 0.0
9 0.0 %
DOL Expand & Forward 0.0 0.0
0 0.0 %
DOL Fwd Row Returned 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total DOL Rows Updated 11.9 0.1
21404 0.1 %

Deletes
APL Deferred 0.8 0.0
1437 0.6 %
APL Direct 0.1 0.0
139 0.1 %
DOL 122.6 0.9
220838 99.3 %
------------------------- ------------ ------------
---------- ----------
Total Rows Deleted 123.5 0.9
222414 0.7 %
========================= ============ ============
==========
Total Rows Affected 17559.7 128.1
31625103

===============================================================================

Transaction Management
----------------------

ULC Flushes to Xact Log per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
by Full ULC 19.0 0.1
34175 11.5 %
by End Transaction 135.8 1.0
244633 82.1 %
by Change of Database 0.0 0.0
39 0.0 %
by Single Log Record 6.4 0.0
11557 3.9 %
by Unpin 0.3 0.0
516 0.2 %
by Other 3.9 0.0
6954 2.3 %
------------------------- ------------ ------------
----------
Total ULC Flushes 165.4 1.2
297874

ULC Log Records 967.0 7.1
1741561 n/a
Max ULC Size During Sample n/a n/a
4096 n/a

ULC Semaphore Requests
Granted 2004.1 14.6
3609347 100.0 %
Waited 0.0 0.0
42 0.0 %
------------------------- ------------ ------------
----------
Total ULC Semaphore Req 2004.1 14.6
3609389

Log Semaphore Requests
Granted 172.6 1.3
310877 99.7 %
Waited 0.6 0.0
1035 0.3 %
------------------------- ------------ ------------
----------
Total Log Semaphore Req 173.2 1.3
311912

Transaction Log Writes 175.6 1.3
316175 n/a
Transaction Log Alloc 43.9 0.3
79034 n/a
Avg # Writes per Log Page n/a n/a
4.00049 n/a

===============================================================================

Index Management
----------------

Nonclustered Maintenance per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Ins/Upd Requiring Maint 0.1 0.0
130 n/a
# of NC Ndx Maint 0.1 0.0
130 n/a
Avg NC Ndx Maint / Op n/a n/a
1.00000 n/a

Deletes Requiring Maint 0.1 0.0
139 n/a
# of NC Ndx Maint 0.1 0.0
139 n/a
Avg NC Ndx Maint / Op n/a n/a
1.00000 n/a

RID Upd from Clust Split 0.0 0.0
1 n/a
# of NC Ndx Maint 0.0 0.0
18 n/a
Avg NC Ndx Maint / Op n/a n/a
18.00000 n/a

Upd/Del DOL Req Maint 14.3 0.1
25767 n/a
# of DOL Ndx Maint 16.0 0.1
28768 n/a
Avg DOL Ndx Maint / Op n/a n/a
1.11647 n/a

Page Splits 1.1 0.0
2048 n/a
Retries 0.0 0.0
0 0.0 %
Deadlocks 0.0 0.0
0 0.0 %
Add Index Level 0.0 0.0
0 0.0 %

Page Shrinks 0.0 0.0
0 n/a

Index Scans per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Ascending Scans 14161.7 103.3
25505261 24.4 %
DOL Ascending Scans 43962.6 320.6
79176580 75.6 %
Descending Scans 0.8 0.0
1390 0.0 %
DOL Descending Scans 0.0 0.0
45 0.0 %
------------ ------------
----------
Total Scans 58125.1 423.9
104683276

===============================================================================

Metadata Cache Management
-------------------------

Metadata Cache Summary per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------

Open Object Usage
Active n/a n/a
6004 n/a
Max Ever Used Since Boot n/a n/a
6004 n/a
Free n/a n/a
33996 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
9494 n/a
Max Ever Used Since Boot n/a n/a
9524 n/a
Free n/a n/a
60506 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
12 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.1 %

Object Spinlock Contention n/a n/a
n/a 0.0 %

Index Spinlock Contention n/a n/a
n/a 0.0 %

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 80881.8 589.8
145668105 n/a
Avg Lock Contention 0.0 0.0
87 0.0 %
Deadlock Percentage 0.0 0.0
0 0.0 %

Lock Detail per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------

Table Lock Hashtable
Lookups 1403.6 10.2
2527965 n/a
Avg Chain Length n/a n/a
0.05397 n/a
Spinlock Contention n/a n/a
n/a 0.0 %

Exclusive Table
Granted 1.4 0.0
2525 99.4 %
Waited 0.0 0.0
16 0.6 %
------------------------- ------------ ------------
---------- ----------
Total EX-Table Requests 1.4 0.0
2541 0.0 %

Shared Table
Granted 0.1 0.0
195 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total SH-Table Requests 0.1 0.0
195 0.0 %

Exclusive Intent
Granted 137.6 1.0
247800 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total EX-Intent Requests 137.6 1.0
247800 0.2 %

Shared Intent
Granted 1249.7 9.1
2250694 100.0 %
Waited 0.0 0.0
40 0.0 %
------------------------- ------------ ------------
---------- ----------
Total SH-Intent Requests 1249.7 9.1
2250734 1.5 %

Page & Row Lock HashTable
Lookups 24688.5 180.0
44463960 n/a
Avg Chain Length n/a n/a
0.00098 n/a
Spinlock Contention n/a n/a
n/a 0.0 %

Exclusive Page
Granted 2.3 0.0
4114 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total EX-Page Requests 2.3 0.0
4114 0.0 %

Update Page
Granted 0.5 0.0
911 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total UP-Page Requests 0.5 0.0
911 0.0 %

Shared Page
Granted 23460.7 171.1
42252644 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total SH-Page Requests 23460.7 171.1
42252644 29.0 %


Exclusive Row
Granted 194.8 1.4
350888 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total EX-Row Requests 194.8 1.4
350888 0.2 %

Update Row
Granted 11.0 0.1
19727 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total UP-Row Requests 11.0 0.1
19727 0.0 %

Shared Row
Granted 996.8 7.3
1795223 100.0 %
Waited 0.0 0.0
31 0.0 %
------------------------- ------------ ------------
---------- ----------
Total SH-Row Requests 996.8 7.3
1795254 1.2 %


Next-Key
Total Next-Key Requests 0.0 0.0
0 n/a

Address Lock Hashtable
Lookups 54826.9 399.8
98743297 n/a
Avg Chain Length n/a n/a
0.00098 n/a
Spinlock Contention n/a n/a
n/a 0.1 %

Exclusive Address
Granted 133.6 1.0
240693 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total EX-Address Requests 133.6 1.0
240693 0.2 %

Shared Address
Granted 54693.3 398.9
98502604 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total SH-Address Requests 54693.3 398.9
98502604 67.6 %


Last Page Locks on Heaps
Granted 522.7 3.8
941380 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total Last Pg Locks 522.7 3.8
941380 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
19 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
0 0.0 %
Sh-Page to Sh-Table 0.0 0.0
0 0.0 %
Ex-Row to Ex-Table 0.2 0.0
383 98.2 %
Sh-Row to Sh-Table 0.0 0.0
7 1.8 %
Sh-Next-Key to Sh-Table 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
----------
Total Lock Promotions 0.2 0.0
390


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 236297.6 1723.2
425571942 100.0 %
Total Cache Misses 25.3 0.2
45586 0.0 %
------------------------- ------------ ------------
----------
Total Cache Searches 236322.9 1723.4
425617528

Cache Turnover
Buffers Grabbed 242.1 1.8
436019 n/a
Buffers Grabbed Dirty 0.0 0.0
0 0.0 %

Cache Strategy Summary
Cached (LRU) Buffers 235925.2 1720.5
424901214 100.0 %
Discarded (MRU) Buffers 0.2 0.0
332 0.0 %

Large I/O Usage
Large I/Os Performed 6.7 0.0
11989 98.5 %

Large I/Os Denied due to
Pool < Prefetch Size 0.1 0.0
152 1.2 %
Pages Requested
Reside in Another
Buffer Pool 0.0 0.0
32 0.3 %
------------------------- ------------ ------------
----------
Total Large I/O Requests 6.8 0.0
12173

Large I/O Effectiveness
Pages by Lrg I/O Cached 26.6 0.2
47956 n/a
Pages by Lrg I/O Used 475.3 3.5
855959 1785 %

Asynchronous Prefetch Activity
APFs Issued 0.3 0.0
560 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 5070.9 37.0
9132685 100.0 %
------------------------- ------------ ------------
----------
Total APFs Requested 5071.2 37.0
9133245

Other Asynchronous Prefetch Statistics
APFs Used 0.3 0.0
558 n/a
APF Waits for I/O 0.1 0.0
137 n/a
APF Discards 0.0 0.0
0 n/a

Dirty Read Behavior
Page Requests 354.3 2.6
638184 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.9 %

Utilization n/a n/a
n/a 78.2 %

Cache Searches
Cache Hits 184713.2 1347.0
332668523 100.0 %
Found in Wash 213.9 1.6
385307 0.1 %
Cache Misses 1.0 0.0
1865 0.0 %
------------------------- ------------ ------------
----------
Total Cache Searches 184714.3 1347.0
332670388

Pool Turnover
4 Kb Pool
LRU Buffer Grab 165.3 1.2
297691 99.6 %
Grabbed Dirty 0.0 0.0
0 0.0 %
16 Kb Pool
LRU Buffer Grab 0.7 0.0
1238 0.4 %
Grabbed Dirty 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
----------
Total Cache Turnover 166.0 1.2
298929

Buffer Wash Behavior
Statistics Not Available - No Buffers Entered Wash
Section Yet

Cache Strategy
Cached (LRU) Buffers 184244.0 1343.6
331823488 100.0 %
Discarded (MRU) Buffers 0.2 0.0
332 0.0 %

Large I/O Usage
Large I/Os Performed 0.7 0.0
1238 89.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
152 10.9 %
------------------------- ------------ ------------
----------
Total Large I/O Requests 0.8 0.0
1390

Large I/O Detail
16 Kb Pool
Pages Cached 2.7 0.0
4952 n/a
Pages Used 0.9 0.0
1540 31.1 %

Dirty Read Behavior
Page Requests 353.5 2.6
636596 n/a

Tuning Recommendations for Data cache : default data
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 21.8 %

Cache Searches
Cache Hits 51584.4 376.2
92903419 100.0 %
Found in Wash 0.0 0.0
0 0.0 %
Cache Misses 24.3 0.2
43721 0.0 %
------------------------- ------------ ------------
----------
Total Cache Searches 51608.6 376.4
92947140

Pool Turnover
4 Kb Pool
LRU Buffer Grab 70.1 0.5
126339 92.2 %
Grabbed Dirty 0.0 0.0
0 0.0 %
16 Kb Pool
LRU Buffer Grab 6.0 0.0
10751 7.8 %
Grabbed Dirty 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
----------
Total Cache Turnover 76.1 0.6
137090

Buffer Wash Behavior
Statistics Not Available - No Buffers Entered Wash
Section Yet

Cache Strategy
Cached (LRU) Buffers 51681.1 376.9
93077726 100.0 %
Discarded (MRU) Buffers 0.0 0.0
0 0.0 %

Large I/O Usage
Large I/Os Performed 6.0 0.0
10751 99.7 %

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
32 0.3 %
------------------------- ------------ ------------
----------
Total Large I/O Requests 6.0 0.0
10783

Large I/O Detail
16 Kb Pool
Pages Cached 23.9 0.2
43004 n/a
Pages Used 6.4 0.0
11571 26.9 %

Dirty Read Behavior
Page Requests 0.9 0.0
1588 n/a

===============================================================================

Procedure Cache Management per sec per xact
count % of total
--------------------------- ------------ ------------
---------- ----------
Procedure Requests 32.4 0.2
58322 n/a
Procedure Reads from Disk 0.0 0.0
4 0.0 %
Procedure Writes to Disk 0.0 0.0
0 0.0 %
Procedure Removals 0.0 0.0
8 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.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 124.5 0.9
224250 n/a


===============================================================================

Memory Management per sec per xact
count % of total
--------------------------- ------------ ------------
---------- ----------
Pages Allocated 0.3 0.0
463 n/a
Pages Released 0.3 0.0
479 n/a

===============================================================================

Recovery Management
-------------------

Checkpoints per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
# of Normal Checkpoints 0.0 0.0
53 100.0 %
# of Free Checkpoints 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
----------
Total Checkpoints 0.0 0.0
53

Avg Time per Normal Chkpt 0.67925 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
147 n/a
Engine 1 n/a n/a
26 n/a
Engine 2 n/a n/a
146 n/a
Engine 3 n/a n/a
131 n/a
Engine 4 n/a n/a
100 n/a
Engine 5 n/a n/a
163 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 202.1 1.5
364046

Completed Disk I/O's
Engine 0 11.6 0.1
20811 5.7 %
Engine 1 7.6 0.1
13635 3.7 %
Engine 2 13.1 0.1
23671 6.5 %
Engine 3 16.5 0.1
29663 8.1 %
Engine 4 13.0 0.1
23400 6.4 %
Engine 5 140.4 1.0
252845 69.5 %
------------------------- ------------ ------------
----------
Total Completed I/Os 202.1 1.5
364025


Device Activity Detail
----------------------

Device:
/opt/sw/sybase/devices/data/dbadmin_d01.dat
dbadmin_d01 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:
/opt/sw/sybase/devices/data/xxxxx01_d01.dat
xxxxx01_d01 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
2 0.2 %
Non-APF 0.0 0.0
88 6.8 %
Writes 0.7 0.0
1211 93.1 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.7 0.0
1301 0.4 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d02.dat
xxxxx01_d02 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
27 10.1 %
Writes 0.1 0.0
240 89.9 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.1 0.0
267 0.1 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d03.dat
xxxxx01_d03 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
11 50.0 %
Writes 0.0 0.0
11 50.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
22 0.0 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d04.dat
xxxxx01_d04 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
11 55.0 %
Writes 0.0 0.0
9 45.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
20 0.0 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d05.dat
xxxxx01_d05 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
22 61.1 %
Writes 0.0 0.0
14 38.9 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
36 0.0 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d06.dat
xxxxx01_d06 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
22 78.6 %
Writes 0.0 0.0
6 21.4 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
28 0.0 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d07.dat
xxxxx01_d07 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
23 11.1 %
Writes 0.1 0.0
184 88.9 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.1 0.0
207 0.1 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d08.dat
xxxxx01_d08 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
11 22.4 %
Writes 0.0 0.0
38 77.6 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
49 0.0 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d09.dat
xxxxx01_d09 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
1 1.2 %
Writes 0.0 0.0
82 98.8 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
83 0.0 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d10.dat
xxxxx01_d10 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
18 58.1 %
Writes 0.0 0.0
13 41.9 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
31 0.0 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d11.dat
xxxxx01_d11 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
37 37.4 %
Writes 0.0 0.0
62 62.6 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.1 0.0
99 0.0 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d12.dat
xxxxx01_d12 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
26 51.0 %
Writes 0.0 0.0
25 49.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
51 0.0 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d13.dat
xxxxx01_d13 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
5 6.1 %
Non-APF 0.0 0.0
69 84.1 %
Writes 0.0 0.0
8 9.8 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
82 0.0 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d14.dat
xxxxx01_d14 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
12 16.2 %
Non-APF 0.0 0.0
40 54.1 %
Writes 0.0 0.0
22 29.7 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
74 0.0 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d15.dat
xxxxx01_d15 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
14 17.7 %
Non-APF 0.0 0.0
39 49.4 %
Writes 0.0 0.0
26 32.9 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
79 0.0 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d16.dat
xxxxx01_d16 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
36 12.9 %
Writes 0.1 0.0
244 87.1 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.2 0.0
280 0.1 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d17.dat
xxxxx01_d17 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
13 26.0 %
Non-APF 0.0 0.0
26 52.0 %
Writes 0.0 0.0
11 22.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
50 0.0 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d18.dat
xxxxx01_d18 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
6 11.8 %
Non-APF 0.0 0.0
29 56.9 %
Writes 0.0 0.0
16 31.4 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
51 0.0 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d19.dat
xxxxx01_d19 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
21 25.3 %
Non-APF 0.0 0.0
54 65.1 %
Writes 0.0 0.0
8 9.6 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
83 0.0 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d20.dat
xxxxx01_d20 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
42 7.6 %
Non-APF 0.0 0.0
52 9.4 %
Writes 0.3 0.0
461 83.1 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.3 0.0
555 0.2 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d21.dat
xxxxx01_d21 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
50 26.5 %
Non-APF 0.0 0.0
38 20.1 %
Writes 0.1 0.0
101 53.4 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.1 0.0
189 0.1 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d22.dat
xxxxx01_d22 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
7 0.9 %
Non-APF 0.0 0.0
70 9.0 %
Writes 0.4 0.0
703 90.1 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.4 0.0
780 0.2 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d23.dat
xxxxx01_d23 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
58 0.7 %
Non-APF 0.2 0.0
276 3.4 %
Writes 4.3 0.0
7759 95.9 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 4.5 0.0
8093 2.2 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d24.dat
xxxxx01_d24 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
38 10.1 %
Non-APF 0.0 0.0
50 13.2 %
Writes 0.2 0.0
290 76.7 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.2 0.0
378 0.1 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d25.dat
xxxxx01_d25 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
14 3.5 %
Non-APF 0.0 0.0
27 6.8 %
Writes 0.2 0.0
357 89.7 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.2 0.0
398 0.1 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d26.dat
xxxxx01_d26 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
56 23.9 %
Non-APF 0.0 0.0
46 19.7 %
Writes 0.1 0.0
132 56.4 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.1 0.0
234 0.1 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d27.dat
xxxxx01_d27 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
33 17.5 %
Non-APF 0.0 0.0
36 19.0 %
Writes 0.1 0.0
120 63.5 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.1 0.0
189 0.1 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d28.dat
xxxxx01_d28 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
3 9.7 %
Non-APF 0.0 0.0
9 29.0 %
Writes 0.0 0.0
19 61.3 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
31 0.0 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d29.dat
xxxxx01_d29 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
8 17.8 %
Non-APF 0.0 0.0
15 33.3 %
Writes 0.0 0.0
22 48.9 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
45 0.0 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d30.dat
xxxxx01_d30 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
8 25.0 %
Non-APF 0.0 0.0
0 0.0 %
Writes 0.0 0.0
24 75.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
32 0.0 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d31.dat
xxxxx01_d31 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.1 0.0
94 0.6 %
Writes 9.4 0.1
16976 99.4 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 9.5 0.1
17070 4.7 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d32.dat
xxxxx01_d32 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
3 42.9 %
Writes 0.0 0.0
4 57.1 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
7 0.0 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d33.dat
xxxxx01_d33 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
13 6.6 %
Non-APF 0.0 0.0
16 8.1 %
Writes 0.1 0.0
169 85.4 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.1 0.0
198 0.1 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d34.dat
xxxxx01_d34 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
22 84.6 %
Writes 0.0 0.0
4 15.4 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
26 0.0 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d35.dat
xxxxx01_d35 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
49 29.7 %
Writes 0.1 0.0
116 70.3 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.1 0.0
165 0.0 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d36.dat
xxxxx01_d36 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
8 44.4 %
Non-APF 0.0 0.0
8 44.4 %
Writes 0.0 0.0
2 11.1 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
18 0.0 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d37.dat
xxxxx01_d37 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
10 33.3 %
Non-APF 0.0 0.0
6 20.0 %
Writes 0.0 0.0
14 46.7 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
30 0.0 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d38.dat
xxxxx01_d38 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
1 3.3 %
Writes 0.0 0.0
29 96.7 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
30 0.0 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d39.dat
xxxxx01_d39 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
19 50.0 %
Non-APF 0.0 0.0
19 50.0 %
Writes 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
38 0.0 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d40.dat
xxxxx01_d40 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
50 17.9 %
Non-APF 0.0 0.0
90 32.3 %
Writes 0.1 0.0
139 49.8 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.2 0.0
279 0.1 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d41.dat
xxxxx01_d41 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
13 20.0 %
Non-APF 0.0 0.0
18 27.7 %
Writes 0.0 0.0
34 52.3 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
65 0.0 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d42.dat
xxxxx01_d42 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
53 1.0 %
Non-APF 0.0 0.0
44 0.9 %
Writes 2.8 0.0
5042 98.1 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 2.9 0.0
5139 1.4 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d43.dat
xxxxx01_d43 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
4 0.6 %
Non-APF 0.0 0.0
2 0.3 %
Writes 0.4 0.0
703 99.2 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.4 0.0
709 0.2 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d44.dat
xxxxx01_d44 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
9 100.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
9 0.0 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d45.dat
xxxxx01_d45 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:
/opt/sw/sybase/devices/data/xxxxx01_d46.dat
xxxxx01_d46 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
22 100.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
22 0.0 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d47.dat
xxxxx01_d47 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:
/opt/sw/sybase/devices/data/xxxxx01_d48.dat
xxxxx01_d48 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
1 0.5 %
Writes 0.1 0.0
197 99.5 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.1 0.0
198 0.1 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d49.dat
xxxxx01_d49 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:
/opt/sw/sybase/devices/data/xxxxx01_d50.dat
xxxxx01_d50 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:
/opt/sw/sybase/devices/data/xxxxx01_d51.dat
xxxxx01_d51 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:
/opt/sw/sybase/devices/data/xxxxx01_d52.dat
xxxxx01_d52 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
12 100.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
12 0.0 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d53.dat
xxxxx01_d53 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:
/opt/sw/sybase/devices/data/xxxxx01_d54.dat
xxxxx01_d54 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
9 100.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
9 0.0 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/data/xxxxx01_d55.dat
xxxxx01_d55 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:
/opt/sw/sybase/devices/log/dbadmin_l01.dat
dbadmin_l01 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:
/opt/sw/sybase/devices/log/xxxxx01_l01.dat
xxxxx01_l01 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.1 0.0
262 0.1 %
Writes 168.9 1.2
304121 99.9 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 169.0 1.2
304383 83.6 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/system/dbccdb_d01.dat
dbccdb_d01 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:
/opt/sw/sybase/devices/system/dbccdb_l01.dat
dbccdb_l01 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:
/opt/sw/sybase/devices/system/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
42 9.7 %
Writes 0.2 0.0
390 90.3 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.2 0.0
432 0.1 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/system/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:
/opt/sw/sybase/devices/system/sysprocs.dat
sysprocsdev 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:
/opt/sw/sybase/devices/tempdb/tempdb_d01.dat
tempdb_d01 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.5 0.0
830 5.0 %
Writes 8.7 0.1
15627 95.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 9.1 0.1
16457 4.5 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/tempdb/tempdb_d02.dat
tempdb_d02 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.1 0.0
186 6.0 %
Writes 1.6 0.0
2902 94.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.7 0.0
3088 0.8 %



-----------------------------------------------------------------------------

Device:
/opt/sw/sybase/devices/tempdb/tempdb_d03.dat
tempdb_d03 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.1 0.0
112 6.1 %
Writes 1.0 0.0
1712 93.9 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.0 0.0
1824 0.5 %



-----------------------------------------------------------------------------



===============================================================================

Network I/O Management
----------------------

Total Network I/O Requests 543.3 4.0
978446 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 23.0 0.2
41378 5.4 %
Engine 1 23.8 0.2
42810 5.6 %
Engine 2 30.9 0.2
55609 7.3 %
Engine 3 30.7 0.2
55213 7.2 %
Engine 4 19.4 0.1
34854 4.6 %
Engine 5 296.4 2.2
533844 69.9 %
------------------------- ------------ ------------
----------
Total TDS Packets Rec'd 424.0 3.1
763708


Total Bytes Received per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Engine 0 12664.9 92.4
22809501 6.3 %
Engine 1 9789.8 71.4
17631345 4.9 %
Engine 2 13578.1 99.0
24454166 6.8 %
Engine 3 16195.6 118.1
29168201 8.1 %
Engine 4 6075.1 44.3
10941180 3.0 %
Engine 5 142551.6 1039.6
256735377 71.0 %
------------------------- ------------ ------------
----------
Total Bytes Rec'd 200855.0 1464.8
361739770


Avg Bytes Rec'd per Packet n/a n/a
473 n/a


-----------------------------------------------------------------------------

Total TDS Packets Sent per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Engine 0 57.6 0.4
103649 4.0 %
Engine 1 500.7 3.7
901723 34.7 %
Engine 2 101.5 0.7
182881 7.0 %
Engine 3 89.8 0.7
161688 6.2 %
Engine 4 345.4 2.5
622118 23.9 %
Engine 5 347.3 2.5
625534 24.1 %
------------------------- ------------ ------------
----------
Total TDS Packets Sent 1442.3 10.5
2597593


Total Bytes Sent per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Engine 0 96751.1 705.6
174248693 -10.8 %
Engine 1 -550040.1 -4011.2
-990622283 61.2 %
Engine 2 285486.7 2081.9
514161464 -31.7 %
Engine 3 209669.2 1529.0
377614307 -23.3 %
Engine 4 -1120637.7 -8172.4
********** 124.6 %
Engine 5 179418.5 1308.4
323132693 -19.9 %
------------------------- ------------ ------------
----------
Total Bytes Sent -899352.3 -6558.6
**********


Avg Bytes Sent per Packet n/a n/a
-623 n/a






Thanks,
Rajasekhar Reddy


"Mark A. Parsons" <iron_horse Posted on 2010-03-18 13:55:57.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Performance issues
References: <4ba19cc4.7ffa.1681692777@sybase.com>
In-Reply-To: <4ba19cc4.7ffa.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Antivirus: avast! (VPS 100313-1, 03/13/2010), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4ba230ed@forums-1-dub>
Date: 18 Mar 2010 05:55:57 -0800
X-Trace: forums-1-dub 1268920557 10.22.241.152 (18 Mar 2010 05:55:57 -0800)
X-Original-Trace: 18 Mar 2010 05:55:57 -0800, vip152.sybase.com
Lines: 2788
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29056
Article PK: 78295

Sorry, not enough info to provide any useful answers ...

- you haven't given us any idea what kind of performance issues you've run into

- you haven't provided us with any details on the suspicious network problem you found

- you haven't mentioned if you've 'fixed' the suspicious network problem and if so, if your ASE performance problems are
still occurring

- you haven't told us if the sp_sysmon session is from a period of time when you were experiencing ASE performance problems

---------------

As for your sp_sysmon output ... and this doesn't necessarily have anything to with your performance problem ...

The couple negative numbers in your 'Total Bytes Sent' column (network section) aren't typical, ie, they should be
positive numbers.

While the negative numbers might be due to counter rollovers, I'd lean more towards a bug with your version of
sp_sysmon, or you have the wrong version of the sp_sysmon% stored procs loaded in your dataserver.

Run the following:

===================
select @@version
go
sp_version
go
===================

If the version strings (@@version; sp_version => installmaster) are different, have your DBA run the installmaster
script against the dataserver. This should insure the dataserver has the correct version of the sp_sysmon% stored procs
loaded.

If, after verifying that you have the correct version of sp_sysmon% stored procs loaded, you still see negative numbers
in the network section ... I'd suggest a) using a smaller sampling period (to reduce counter rolloevers) or b) opening a
case with Sybase TechSupport.

Rajasekhar Reddy wrote:
> Hello,
>
> We are facing performance issues. It is likely due
> Network problems(suspicious/Found). How can I find is it
> network issue at database level ? I meant, wanna make sure
> is the problem from Network or something else ?
>
> I ran sysmon for 30 min. Please have a look into the below
> report. Please let me know is there any other way to find
> out ?
>
> ===============================================================================
> Sybase Adaptive Server Enterprise System Performance
> Report
> ===============================================================================
>
> Server Version: Adaptive Server Enterprise/12.5.4/EBF
> 14067 ESD#3/P/RS60
> Server Name: XXXXXXX
> Run Date: Mar 18, 2010
> Sampling Started at: Mar 18, 2010 12:24:34
> Sampling Ended at: Mar 18, 2010 12:54:35
> Sample Interval: 00:30:01
> Sample Mode: Reset Counters
>
> ===============================================================================
>
> Kernel Utilization
> ------------------
>
> Your Runnable Process Search Count is set to 3
> and I/O Polling Process Count is set to 10
>
> Engine Busy Utilization CPU Busy I/O Busy
> Idle
> ------------------------ -------- --------
> --------
> Engine 0 19.1 % 3.1 %
> 77.8 %
> Engine 1 13.4 % 3.7 %
> 82.8 %
> Engine 2 13.3 % 3.9 %
> 82.8 %
> Engine 3 13.3 % 4.8 %
> 82.0 %
> Engine 4 21.8 % 3.4 %
> 74.9 %
> Engine 5 27.9 % 40.1 %
> 32.0 %
> ------------------------ -------- --------
> --------
> Summary Total 108.7 % 58.9 %
> 432.4 %
> Average 18.1 % 9.8 %
> 72.1 %
>
> CPU Yields by Engine per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Engine 0 175.6 1.3
> 316179 15.3 %
> Engine 1 128.2 0.9
> 230853 11.2 %
> Engine 2 127.4 0.9
> 229438 11.1 %
> Engine 3 139.4 1.0
> 251009 12.1 %
> Engine 4 155.1 1.1
> 279290 13.5 %
> Engine 5 422.7 3.1
> 761298 36.8 %
> ------------------------- ------------ ------------
> ----------
> Total CPU Yields 1148.3 8.4
> 2068067
>
> Network Checks
> Non-Blocking 2237.8 16.3
> 4030317 69.9 %
> Blocking 961.8 7.0
> 1732172 30.1 %
> ------------------------- ------------ ------------
> ----------
> Total Network I/O Checks 3199.6 23.3
> 5762489
> Avg Net I/Os per Check n/a n/a
> 0.58331 n/a
>
> Disk I/O Checks
> Total Disk I/O Checks 4072.5 29.7
> 7334578 n/a
> Checks Returning I/O 632.0 4.6
> 1138299 15.5 %
> Avg Disk I/Os Returned n/a n/a
> 0.31980 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.1 0.0
> 225 n/a
>
> Task Context Switches by Engine
> Engine 0 100.7 0.7
> 181287 7.0 %
> Engine 1 165.9 1.2
> 298810 11.5 %
> Engine 2 112.4 0.8
> 202484 7.8 %
> Engine 3 106.5 0.8
> 191895 7.4 %
> Engine 4 116.7 0.9
> 210218 8.1 %
> Engine 5 842.7 6.1
> 1517669 58.3 %
> ------------------------- ------------ ------------
> ----------
> Total Task Switches: 1445.0 10.5
> 2602363
>
> Task Context Switches Due To:
> Voluntary Yields 152.3 1.1
> 274239 10.5 %
> Cache Search Misses 1.7 0.0
> 3014 0.1 %
> System Disk Writes 0.2 0.0
> 300 0.0 %
> I/O Pacing 27.9 0.2
> 50305 1.9 %
> Logical Lock Contention 0.0 0.0
> 87 0.0 %
> Address Lock Contention 0.0 0.0
> 0 0.0 %
> Latch Contention 0.0 0.0
> 13 0.0 %
> Log Semaphore Contention 0.6 0.0
> 1035 0.0 %
> PLC Lock Contention 0.0 0.0
> 42 0.0 %
> Group Commit Sleeps 5.6 0.0
> 10010 0.4 %
> Last Log Page Writes 131.7 1.0
> 237103 9.1 %
> Modify Conflicts 8.4 0.1
> 15130 0.6 %
> I/O Device Contention 0.0 0.0
> 0 0.0 %
> Network Packet Received 424.0 3.1
> 763682 29.3 %
> Network Packet Sent 119.2 0.9
> 214763 8.3 %
> Other Causes 573.4 4.2
> 1032640 39.7 %
>
>
> ===============================================================================
>
> Application Management
> ----------------------
>
> Application Statistics Summary (All Applications)
> -------------------------------------------------
> Priority Changes per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> To High Priority 0.7 0.0
> 1183 10.1 %
> To Medium Priority 3.3 0.0
> 5959 50.9 %
> To Low Priority 2.5 0.0
> 4557 39.0 %
> ------------------------- ------------ ------------
> ----------
> Total Priority Changes 6.5 0.0
> 11699
>
> Allotted Slices Exhausted per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> High Priority 0.0 0.0
> 0 0.0 %
> Medium Priority 3.3 0.0
> 5869 100.0 %
> Low Priority 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
> ----------
> Total Slices Exhausted 3.3 0.0
> 5869
>
> 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 180.5 1.3
> 325041 99.7 %
> Dirty 0.5 0.0
> 859 0.3 %
> ------------ ------------
> ----------
> Total Washes 181.0 1.3
> 325900
>
> Garbage Collections 1.2 0.0
> 2148 n/a
> Pages Processed in GC 0.0 0.0
> 2 n/a
>
> Statistics Updates 11.7 0.1
> 21108 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 3.8 0.0
> 6777 n/a
> Maximum SQL Text Requested n/a n/a
> 21407 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 11727 (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 137.1 n/a
> 246963 n/a
>
> Transaction Detail per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Inserts
> APL Heap Table 522.7 3.8
> 941380 3.0 %
> APL Clustered Table 16610.8 121.1
> 29916062 95.3 %
> Data Only Lock Table 290.9 2.1
> 523831 1.7 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total Rows Inserted 17424.4 127.1
> 31381273 99.2 %
>
> Updates
> APL Deferred 0.0 0.0
> 0 0.0 %
> APL Direct In-place 0.0 0.0
> 1 0.0 %
> APL Direct Cheap 0.0 0.0
> 11 0.1 %
> APL Direct Expensive 0.0 0.0
> 0 0.0 %
> DOL Deferred 0.0 0.0
> 0 0.0 %
> DOL Direct 11.9 0.1
> 21404 99.9 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total Rows Updated 11.9 0.1
> 21416 0.1 %
>
> Data Only Locked Updates
> DOL Replace 11.9 0.1
> 21392 99.9 %
> DOL Shrink 0.0 0.0
> 2 0.0 %
> DOL Cheap Expand 0.0 0.0
> 1 0.0 %
> DOL Expensive Expand 0.0 0.0
> 9 0.0 %
> DOL Expand & Forward 0.0 0.0
> 0 0.0 %
> DOL Fwd Row Returned 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total DOL Rows Updated 11.9 0.1
> 21404 0.1 %
>
> Deletes
> APL Deferred 0.8 0.0
> 1437 0.6 %
> APL Direct 0.1 0.0
> 139 0.1 %
> DOL 122.6 0.9
> 220838 99.3 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total Rows Deleted 123.5 0.9
> 222414 0.7 %
> ========================= ============ ============
> ==========
> Total Rows Affected 17559.7 128.1
> 31625103
>
> ===============================================================================
>
> Transaction Management
> ----------------------
>
> ULC Flushes to Xact Log per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> by Full ULC 19.0 0.1
> 34175 11.5 %
> by End Transaction 135.8 1.0
> 244633 82.1 %
> by Change of Database 0.0 0.0
> 39 0.0 %
> by Single Log Record 6.4 0.0
> 11557 3.9 %
> by Unpin 0.3 0.0
> 516 0.2 %
> by Other 3.9 0.0
> 6954 2.3 %
> ------------------------- ------------ ------------
> ----------
> Total ULC Flushes 165.4 1.2
> 297874
>
> ULC Log Records 967.0 7.1
> 1741561 n/a
> Max ULC Size During Sample n/a n/a
> 4096 n/a
>
> ULC Semaphore Requests
> Granted 2004.1 14.6
> 3609347 100.0 %
> Waited 0.0 0.0
> 42 0.0 %
> ------------------------- ------------ ------------
> ----------
> Total ULC Semaphore Req 2004.1 14.6
> 3609389
>
> Log Semaphore Requests
> Granted 172.6 1.3
> 310877 99.7 %
> Waited 0.6 0.0
> 1035 0.3 %
> ------------------------- ------------ ------------
> ----------
> Total Log Semaphore Req 173.2 1.3
> 311912
>
> Transaction Log Writes 175.6 1.3
> 316175 n/a
> Transaction Log Alloc 43.9 0.3
> 79034 n/a
> Avg # Writes per Log Page n/a n/a
> 4.00049 n/a
>
> ===============================================================================
>
> Index Management
> ----------------
>
> Nonclustered Maintenance per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Ins/Upd Requiring Maint 0.1 0.0
> 130 n/a
> # of NC Ndx Maint 0.1 0.0
> 130 n/a
> Avg NC Ndx Maint / Op n/a n/a
> 1.00000 n/a
>
> Deletes Requiring Maint 0.1 0.0
> 139 n/a
> # of NC Ndx Maint 0.1 0.0
> 139 n/a
> Avg NC Ndx Maint / Op n/a n/a
> 1.00000 n/a
>
> RID Upd from Clust Split 0.0 0.0
> 1 n/a
> # of NC Ndx Maint 0.0 0.0
> 18 n/a
> Avg NC Ndx Maint / Op n/a n/a
> 18.00000 n/a
>
> Upd/Del DOL Req Maint 14.3 0.1
> 25767 n/a
> # of DOL Ndx Maint 16.0 0.1
> 28768 n/a
> Avg DOL Ndx Maint / Op n/a n/a
> 1.11647 n/a
>
> Page Splits 1.1 0.0
> 2048 n/a
> Retries 0.0 0.0
> 0 0.0 %
> Deadlocks 0.0 0.0
> 0 0.0 %
> Add Index Level 0.0 0.0
> 0 0.0 %
>
> Page Shrinks 0.0 0.0
> 0 n/a
>
> Index Scans per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Ascending Scans 14161.7 103.3
> 25505261 24.4 %
> DOL Ascending Scans 43962.6 320.6
> 79176580 75.6 %
> Descending Scans 0.8 0.0
> 1390 0.0 %
> DOL Descending Scans 0.0 0.0
> 45 0.0 %
> ------------ ------------
> ----------
> Total Scans 58125.1 423.9
> 104683276
>
> ===============================================================================
>
> Metadata Cache Management
> -------------------------
>
> Metadata Cache Summary per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
>
> Open Object Usage
> Active n/a n/a
> 6004 n/a
> Max Ever Used Since Boot n/a n/a
> 6004 n/a
> Free n/a n/a
> 33996 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
> 9494 n/a
> Max Ever Used Since Boot n/a n/a
> 9524 n/a
> Free n/a n/a
> 60506 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
> 12 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.1 %
>
> Object Spinlock Contention n/a n/a
> n/a 0.0 %
>
> Index Spinlock Contention n/a n/a
> n/a 0.0 %
>
> 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 80881.8 589.8
> 145668105 n/a
> Avg Lock Contention 0.0 0.0
> 87 0.0 %
> Deadlock Percentage 0.0 0.0
> 0 0.0 %
>
> Lock Detail per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
>
> Table Lock Hashtable
> Lookups 1403.6 10.2
> 2527965 n/a
> Avg Chain Length n/a n/a
> 0.05397 n/a
> Spinlock Contention n/a n/a
> n/a 0.0 %
>
> Exclusive Table
> Granted 1.4 0.0
> 2525 99.4 %
> Waited 0.0 0.0
> 16 0.6 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total EX-Table Requests 1.4 0.0
> 2541 0.0 %
>
> Shared Table
> Granted 0.1 0.0
> 195 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total SH-Table Requests 0.1 0.0
> 195 0.0 %
>
> Exclusive Intent
> Granted 137.6 1.0
> 247800 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total EX-Intent Requests 137.6 1.0
> 247800 0.2 %
>
> Shared Intent
> Granted 1249.7 9.1
> 2250694 100.0 %
> Waited 0.0 0.0
> 40 0.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total SH-Intent Requests 1249.7 9.1
> 2250734 1.5 %
>
> Page & Row Lock HashTable
> Lookups 24688.5 180.0
> 44463960 n/a
> Avg Chain Length n/a n/a
> 0.00098 n/a
> Spinlock Contention n/a n/a
> n/a 0.0 %
>
> Exclusive Page
> Granted 2.3 0.0
> 4114 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total EX-Page Requests 2.3 0.0
> 4114 0.0 %
>
> Update Page
> Granted 0.5 0.0
> 911 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total UP-Page Requests 0.5 0.0
> 911 0.0 %
>
> Shared Page
> Granted 23460.7 171.1
> 42252644 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total SH-Page Requests 23460.7 171.1
> 42252644 29.0 %
>
>
> Exclusive Row
> Granted 194.8 1.4
> 350888 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total EX-Row Requests 194.8 1.4
> 350888 0.2 %
>
> Update Row
> Granted 11.0 0.1
> 19727 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total UP-Row Requests 11.0 0.1
> 19727 0.0 %
>
> Shared Row
> Granted 996.8 7.3
> 1795223 100.0 %
> Waited 0.0 0.0
> 31 0.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total SH-Row Requests 996.8 7.3
> 1795254 1.2 %
>
>
> Next-Key
> Total Next-Key Requests 0.0 0.0
> 0 n/a
>
> Address Lock Hashtable
> Lookups 54826.9 399.8
> 98743297 n/a
> Avg Chain Length n/a n/a
> 0.00098 n/a
> Spinlock Contention n/a n/a
> n/a 0.1 %
>
> Exclusive Address
> Granted 133.6 1.0
> 240693 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total EX-Address Requests 133.6 1.0
> 240693 0.2 %
>
> Shared Address
> Granted 54693.3 398.9
> 98502604 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total SH-Address Requests 54693.3 398.9
> 98502604 67.6 %
>
>
> Last Page Locks on Heaps
> Granted 522.7 3.8
> 941380 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total Last Pg Locks 522.7 3.8
> 941380 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
> 19 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
> 0 0.0 %
> Sh-Page to Sh-Table 0.0 0.0
> 0 0.0 %
> Ex-Row to Ex-Table 0.2 0.0
> 383 98.2 %
> Sh-Row to Sh-Table 0.0 0.0
> 7 1.8 %
> Sh-Next-Key to Sh-Table 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
> ----------
> Total Lock Promotions 0.2 0.0
> 390
>
>
> 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 236297.6 1723.2
> 425571942 100.0 %
> Total Cache Misses 25.3 0.2
> 45586 0.0 %
> ------------------------- ------------ ------------
> ----------
> Total Cache Searches 236322.9 1723.4
> 425617528
>
> Cache Turnover
> Buffers Grabbed 242.1 1.8
> 436019 n/a
> Buffers Grabbed Dirty 0.0 0.0
> 0 0.0 %
>
> Cache Strategy Summary
> Cached (LRU) Buffers 235925.2 1720.5
> 424901214 100.0 %
> Discarded (MRU) Buffers 0.2 0.0
> 332 0.0 %
>
> Large I/O Usage
> Large I/Os Performed 6.7 0.0
> 11989 98.5 %
>
> Large I/Os Denied due to
> Pool < Prefetch Size 0.1 0.0
> 152 1.2 %
> Pages Requested
> Reside in Another
> Buffer Pool 0.0 0.0
> 32 0.3 %
> ------------------------- ------------ ------------
> ----------
> Total Large I/O Requests 6.8 0.0
> 12173
>
> Large I/O Effectiveness
> Pages by Lrg I/O Cached 26.6 0.2
> 47956 n/a
> Pages by Lrg I/O Used 475.3 3.5
> 855959 1785 %
>
> Asynchronous Prefetch Activity
> APFs Issued 0.3 0.0
> 560 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 5070.9 37.0
> 9132685 100.0 %
> ------------------------- ------------ ------------
> ----------
> Total APFs Requested 5071.2 37.0
> 9133245
>
> Other Asynchronous Prefetch Statistics
> APFs Used 0.3 0.0
> 558 n/a
> APF Waits for I/O 0.1 0.0
> 137 n/a
> APF Discards 0.0 0.0
> 0 n/a
>
> Dirty Read Behavior
> Page Requests 354.3 2.6
> 638184 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.9 %
>
> Utilization n/a n/a
> n/a 78.2 %
>
> Cache Searches
> Cache Hits 184713.2 1347.0
> 332668523 100.0 %
> Found in Wash 213.9 1.6
> 385307 0.1 %
> Cache Misses 1.0 0.0
> 1865 0.0 %
> ------------------------- ------------ ------------
> ----------
> Total Cache Searches 184714.3 1347.0
> 332670388
>
> Pool Turnover
> 4 Kb Pool
> LRU Buffer Grab 165.3 1.2
> 297691 99.6 %
> Grabbed Dirty 0.0 0.0
> 0 0.0 %
> 16 Kb Pool
> LRU Buffer Grab 0.7 0.0
> 1238 0.4 %
> Grabbed Dirty 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
> ----------
> Total Cache Turnover 166.0 1.2
> 298929
>
> Buffer Wash Behavior
> Statistics Not Available - No Buffers Entered Wash
> Section Yet
>
> Cache Strategy
> Cached (LRU) Buffers 184244.0 1343.6
> 331823488 100.0 %
> Discarded (MRU) Buffers 0.2 0.0
> 332 0.0 %
>
> Large I/O Usage
> Large I/Os Performed 0.7 0.0
> 1238 89.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
> 152 10.9 %
> ------------------------- ------------ ------------
> ----------
> Total Large I/O Requests 0.8 0.0
> 1390
>
> Large I/O Detail
> 16 Kb Pool
> Pages Cached 2.7 0.0
> 4952 n/a
> Pages Used 0.9 0.0
> 1540 31.1 %
>
> Dirty Read Behavior
> Page Requests 353.5 2.6
> 636596 n/a
>
> Tuning Recommendations for Data cache : default data
> 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 21.8 %
>
> Cache Searches
> Cache Hits 51584.4 376.2
> 92903419 100.0 %
> Found in Wash 0.0 0.0
> 0 0.0 %
> Cache Misses 24.3 0.2
> 43721 0.0 %
> ------------------------- ------------ ------------
> ----------
> Total Cache Searches 51608.6 376.4
> 92947140
>
> Pool Turnover
> 4 Kb Pool
> LRU Buffer Grab 70.1 0.5
> 126339 92.2 %
> Grabbed Dirty 0.0 0.0
> 0 0.0 %
> 16 Kb Pool
> LRU Buffer Grab 6.0 0.0
> 10751 7.8 %
> Grabbed Dirty 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
> ----------
> Total Cache Turnover 76.1 0.6
> 137090
>
> Buffer Wash Behavior
> Statistics Not Available - No Buffers Entered Wash
> Section Yet
>
> Cache Strategy
> Cached (LRU) Buffers 51681.1 376.9
> 93077726 100.0 %
> Discarded (MRU) Buffers 0.0 0.0
> 0 0.0 %
>
> Large I/O Usage
> Large I/Os Performed 6.0 0.0
> 10751 99.7 %
>
> 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
> 32 0.3 %
> ------------------------- ------------ ------------
> ----------
> Total Large I/O Requests 6.0 0.0
> 10783
>
> Large I/O Detail
> 16 Kb Pool
> Pages Cached 23.9 0.2
> 43004 n/a
> Pages Used 6.4 0.0
> 11571 26.9 %
>
> Dirty Read Behavior
> Page Requests 0.9 0.0
> 1588 n/a
>
> ===============================================================================
>
> Procedure Cache Management per sec per xact
> count % of total
> --------------------------- ------------ ------------
> ---------- ----------
> Procedure Requests 32.4 0.2
> 58322 n/a
> Procedure Reads from Disk 0.0 0.0
> 4 0.0 %
> Procedure Writes to Disk 0.0 0.0
> 0 0.0 %
> Procedure Removals 0.0 0.0
> 8 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.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 124.5 0.9
> 224250 n/a
>
>
> ===============================================================================
>
> Memory Management per sec per xact
> count % of total
> --------------------------- ------------ ------------
> ---------- ----------
> Pages Allocated 0.3 0.0
> 463 n/a
> Pages Released 0.3 0.0
> 479 n/a
>
> ===============================================================================
>
> Recovery Management
> -------------------
>
> Checkpoints per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> # of Normal Checkpoints 0.0 0.0
> 53 100.0 %
> # of Free Checkpoints 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
> ----------
> Total Checkpoints 0.0 0.0
> 53
>
> Avg Time per Normal Chkpt 0.67925 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
> 147 n/a
> Engine 1 n/a n/a
> 26 n/a
> Engine 2 n/a n/a
> 146 n/a
> Engine 3 n/a n/a
> 131 n/a
> Engine 4 n/a n/a
> 100 n/a
> Engine 5 n/a n/a
> 163 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 202.1 1.5
> 364046
>
> Completed Disk I/O's
> Engine 0 11.6 0.1
> 20811 5.7 %
> Engine 1 7.6 0.1
> 13635 3.7 %
> Engine 2 13.1 0.1
> 23671 6.5 %
> Engine 3 16.5 0.1
> 29663 8.1 %
> Engine 4 13.0 0.1
> 23400 6.4 %
> Engine 5 140.4 1.0
> 252845 69.5 %
> ------------------------- ------------ ------------
> ----------
> Total Completed I/Os 202.1 1.5
> 364025
>
>
> Device Activity Detail
> ----------------------
>
> Device:
> /opt/sw/sybase/devices/data/dbadmin_d01.dat
> dbadmin_d01 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:
> /opt/sw/sybase/devices/data/xxxxx01_d01.dat
> xxxxx01_d01 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 2 0.2 %
> Non-APF 0.0 0.0
> 88 6.8 %
> Writes 0.7 0.0
> 1211 93.1 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.7 0.0
> 1301 0.4 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d02.dat
> xxxxx01_d02 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 27 10.1 %
> Writes 0.1 0.0
> 240 89.9 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.1 0.0
> 267 0.1 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d03.dat
> xxxxx01_d03 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 11 50.0 %
> Writes 0.0 0.0
> 11 50.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 22 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d04.dat
> xxxxx01_d04 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 11 55.0 %
> Writes 0.0 0.0
> 9 45.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 20 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d05.dat
> xxxxx01_d05 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 22 61.1 %
> Writes 0.0 0.0
> 14 38.9 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 36 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d06.dat
> xxxxx01_d06 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 22 78.6 %
> Writes 0.0 0.0
> 6 21.4 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 28 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d07.dat
> xxxxx01_d07 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 23 11.1 %
> Writes 0.1 0.0
> 184 88.9 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.1 0.0
> 207 0.1 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d08.dat
> xxxxx01_d08 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 11 22.4 %
> Writes 0.0 0.0
> 38 77.6 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 49 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d09.dat
> xxxxx01_d09 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 1 1.2 %
> Writes 0.0 0.0
> 82 98.8 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 83 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d10.dat
> xxxxx01_d10 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 18 58.1 %
> Writes 0.0 0.0
> 13 41.9 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 31 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d11.dat
> xxxxx01_d11 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 37 37.4 %
> Writes 0.0 0.0
> 62 62.6 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.1 0.0
> 99 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d12.dat
> xxxxx01_d12 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 26 51.0 %
> Writes 0.0 0.0
> 25 49.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 51 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d13.dat
> xxxxx01_d13 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 5 6.1 %
> Non-APF 0.0 0.0
> 69 84.1 %
> Writes 0.0 0.0
> 8 9.8 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 82 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d14.dat
> xxxxx01_d14 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 12 16.2 %
> Non-APF 0.0 0.0
> 40 54.1 %
> Writes 0.0 0.0
> 22 29.7 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 74 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d15.dat
> xxxxx01_d15 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 14 17.7 %
> Non-APF 0.0 0.0
> 39 49.4 %
> Writes 0.0 0.0
> 26 32.9 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 79 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d16.dat
> xxxxx01_d16 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 36 12.9 %
> Writes 0.1 0.0
> 244 87.1 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.2 0.0
> 280 0.1 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d17.dat
> xxxxx01_d17 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 13 26.0 %
> Non-APF 0.0 0.0
> 26 52.0 %
> Writes 0.0 0.0
> 11 22.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 50 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d18.dat
> xxxxx01_d18 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 6 11.8 %
> Non-APF 0.0 0.0
> 29 56.9 %
> Writes 0.0 0.0
> 16 31.4 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 51 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d19.dat
> xxxxx01_d19 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 21 25.3 %
> Non-APF 0.0 0.0
> 54 65.1 %
> Writes 0.0 0.0
> 8 9.6 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 83 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d20.dat
> xxxxx01_d20 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 42 7.6 %
> Non-APF 0.0 0.0
> 52 9.4 %
> Writes 0.3 0.0
> 461 83.1 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.3 0.0
> 555 0.2 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d21.dat
> xxxxx01_d21 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 50 26.5 %
> Non-APF 0.0 0.0
> 38 20.1 %
> Writes 0.1 0.0
> 101 53.4 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.1 0.0
> 189 0.1 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d22.dat
> xxxxx01_d22 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 7 0.9 %
> Non-APF 0.0 0.0
> 70 9.0 %
> Writes 0.4 0.0
> 703 90.1 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.4 0.0
> 780 0.2 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d23.dat
> xxxxx01_d23 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 58 0.7 %
> Non-APF 0.2 0.0
> 276 3.4 %
> Writes 4.3 0.0
> 7759 95.9 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 4.5 0.0
> 8093 2.2 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d24.dat
> xxxxx01_d24 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 38 10.1 %
> Non-APF 0.0 0.0
> 50 13.2 %
> Writes 0.2 0.0
> 290 76.7 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.2 0.0
> 378 0.1 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d25.dat
> xxxxx01_d25 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 14 3.5 %
> Non-APF 0.0 0.0
> 27 6.8 %
> Writes 0.2 0.0
> 357 89.7 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.2 0.0
> 398 0.1 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d26.dat
> xxxxx01_d26 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 56 23.9 %
> Non-APF 0.0 0.0
> 46 19.7 %
> Writes 0.1 0.0
> 132 56.4 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.1 0.0
> 234 0.1 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d27.dat
> xxxxx01_d27 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 33 17.5 %
> Non-APF 0.0 0.0
> 36 19.0 %
> Writes 0.1 0.0
> 120 63.5 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.1 0.0
> 189 0.1 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d28.dat
> xxxxx01_d28 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 3 9.7 %
> Non-APF 0.0 0.0
> 9 29.0 %
> Writes 0.0 0.0
> 19 61.3 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 31 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d29.dat
> xxxxx01_d29 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 8 17.8 %
> Non-APF 0.0 0.0
> 15 33.3 %
> Writes 0.0 0.0
> 22 48.9 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 45 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d30.dat
> xxxxx01_d30 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 8 25.0 %
> Non-APF 0.0 0.0
> 0 0.0 %
> Writes 0.0 0.0
> 24 75.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 32 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d31.dat
> xxxxx01_d31 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.1 0.0
> 94 0.6 %
> Writes 9.4 0.1
> 16976 99.4 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 9.5 0.1
> 17070 4.7 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d32.dat
> xxxxx01_d32 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 3 42.9 %
> Writes 0.0 0.0
> 4 57.1 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 7 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d33.dat
> xxxxx01_d33 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 13 6.6 %
> Non-APF 0.0 0.0
> 16 8.1 %
> Writes 0.1 0.0
> 169 85.4 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.1 0.0
> 198 0.1 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d34.dat
> xxxxx01_d34 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 22 84.6 %
> Writes 0.0 0.0
> 4 15.4 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 26 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d35.dat
> xxxxx01_d35 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 49 29.7 %
> Writes 0.1 0.0
> 116 70.3 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.1 0.0
> 165 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d36.dat
> xxxxx01_d36 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 8 44.4 %
> Non-APF 0.0 0.0
> 8 44.4 %
> Writes 0.0 0.0
> 2 11.1 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 18 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d37.dat
> xxxxx01_d37 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 10 33.3 %
> Non-APF 0.0 0.0
> 6 20.0 %
> Writes 0.0 0.0
> 14 46.7 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 30 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d38.dat
> xxxxx01_d38 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 1 3.3 %
> Writes 0.0 0.0
> 29 96.7 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 30 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d39.dat
> xxxxx01_d39 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 19 50.0 %
> Non-APF 0.0 0.0
> 19 50.0 %
> Writes 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 38 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d40.dat
> xxxxx01_d40 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 50 17.9 %
> Non-APF 0.0 0.0
> 90 32.3 %
> Writes 0.1 0.0
> 139 49.8 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.2 0.0
> 279 0.1 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d41.dat
> xxxxx01_d41 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 13 20.0 %
> Non-APF 0.0 0.0
> 18 27.7 %
> Writes 0.0 0.0
> 34 52.3 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 65 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d42.dat
> xxxxx01_d42 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 53 1.0 %
> Non-APF 0.0 0.0
> 44 0.9 %
> Writes 2.8 0.0
> 5042 98.1 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 2.9 0.0
> 5139 1.4 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d43.dat
> xxxxx01_d43 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 4 0.6 %
> Non-APF 0.0 0.0
> 2 0.3 %
> Writes 0.4 0.0
> 703 99.2 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.4 0.0
> 709 0.2 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d44.dat
> xxxxx01_d44 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
> 9 100.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 9 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d45.dat
> xxxxx01_d45 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:
> /opt/sw/sybase/devices/data/xxxxx01_d46.dat
> xxxxx01_d46 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
> 22 100.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 22 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d47.dat
> xxxxx01_d47 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:
> /opt/sw/sybase/devices/data/xxxxx01_d48.dat
> xxxxx01_d48 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 1 0.5 %
> Writes 0.1 0.0
> 197 99.5 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.1 0.0
> 198 0.1 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d49.dat
> xxxxx01_d49 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:
> /opt/sw/sybase/devices/data/xxxxx01_d50.dat
> xxxxx01_d50 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:
> /opt/sw/sybase/devices/data/xxxxx01_d51.dat
> xxxxx01_d51 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:
> /opt/sw/sybase/devices/data/xxxxx01_d52.dat
> xxxxx01_d52 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
> 12 100.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 12 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d53.dat
> xxxxx01_d53 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:
> /opt/sw/sybase/devices/data/xxxxx01_d54.dat
> xxxxx01_d54 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
> 9 100.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 9 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d55.dat
> xxxxx01_d55 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:
> /opt/sw/sybase/devices/log/dbadmin_l01.dat
> dbadmin_l01 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:
> /opt/sw/sybase/devices/log/xxxxx01_l01.dat
> xxxxx01_l01 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.1 0.0
> 262 0.1 %
> Writes 168.9 1.2
> 304121 99.9 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 169.0 1.2
> 304383 83.6 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/system/dbccdb_d01.dat
> dbccdb_d01 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:
> /opt/sw/sybase/devices/system/dbccdb_l01.dat
> dbccdb_l01 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:
> /opt/sw/sybase/devices/system/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
> 42 9.7 %
> Writes 0.2 0.0
> 390 90.3 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.2 0.0
> 432 0.1 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/system/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:
> /opt/sw/sybase/devices/system/sysprocs.dat
> sysprocsdev 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:
> /opt/sw/sybase/devices/tempdb/tempdb_d01.dat
> tempdb_d01 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.5 0.0
> 830 5.0 %
> Writes 8.7 0.1
> 15627 95.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 9.1 0.1
> 16457 4.5 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/tempdb/tempdb_d02.dat
> tempdb_d02 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.1 0.0
> 186 6.0 %
> Writes 1.6 0.0
> 2902 94.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 1.7 0.0
> 3088 0.8 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/tempdb/tempdb_d03.dat
> tempdb_d03 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.1 0.0
> 112 6.1 %
> Writes 1.0 0.0
> 1712 93.9 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 1.0 0.0
> 1824 0.5 %
>
>
>
> -----------------------------------------------------------------------------
>
>
>
> ===============================================================================
>
> Network I/O Management
> ----------------------
>
> Total Network I/O Requests 543.3 4.0
> 978446 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 23.0 0.2
> 41378 5.4 %
> Engine 1 23.8 0.2
> 42810 5.6 %
> Engine 2 30.9 0.2
> 55609 7.3 %
> Engine 3 30.7 0.2
> 55213 7.2 %
> Engine 4 19.4 0.1
> 34854 4.6 %
> Engine 5 296.4 2.2
> 533844 69.9 %
> ------------------------- ------------ ------------
> ----------
> Total TDS Packets Rec'd 424.0 3.1
> 763708
>
>
> Total Bytes Received per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Engine 0 12664.9 92.4
> 22809501 6.3 %
> Engine 1 9789.8 71.4
> 17631345 4.9 %
> Engine 2 13578.1 99.0
> 24454166 6.8 %
> Engine 3 16195.6 118.1
> 29168201 8.1 %
> Engine 4 6075.1 44.3
> 10941180 3.0 %
> Engine 5 142551.6 1039.6
> 256735377 71.0 %
> ------------------------- ------------ ------------
> ----------
> Total Bytes Rec'd 200855.0 1464.8
> 361739770
>
>
> Avg Bytes Rec'd per Packet n/a n/a
> 473 n/a
>
>
> -----------------------------------------------------------------------------
>
> Total TDS Packets Sent per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Engine 0 57.6 0.4
> 103649 4.0 %
> Engine 1 500.7 3.7
> 901723 34.7 %
> Engine 2 101.5 0.7
> 182881 7.0 %
> Engine 3 89.8 0.7
> 161688 6.2 %
> Engine 4 345.4 2.5
> 622118 23.9 %
> Engine 5 347.3 2.5
> 625534 24.1 %
> ------------------------- ------------ ------------
> ----------
> Total TDS Packets Sent 1442.3 10.5
> 2597593
>
>
> Total Bytes Sent per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Engine 0 96751.1 705.6
> 174248693 -10.8 %
> Engine 1 -550040.1 -4011.2
> -990622283 61.2 %
> Engine 2 285486.7 2081.9
> 514161464 -31.7 %
> Engine 3 209669.2 1529.0
> 377614307 -23.3 %
> Engine 4 -1120637.7 -8172.4
> ********** 124.6 %
> Engine 5 179418.5 1308.4
> 323132693 -19.9 %
> ------------------------- ------------ ------------
> ----------
> Total Bytes Sent -899352.3 -6558.6
> **********
>
>
> Avg Bytes Sent per Packet n/a n/a
> -623 n/a
>
>
>
>
>
>
> Thanks,
> Rajasekhar Reddy


Rob V [ Sybase ] Posted on 2010-03-21 16:36:23.0Z
Reply-To: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
From: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Newsgroups: sybase.public.ase.general
References: <4ba19cc4.7ffa.1681692777@sybase.com>
Subject: Re: Performance issues
Lines: 2783
Organization: Sypron BV / TeamSybase / Sybase
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4ba64b07@forums-1-dub>
Date: 21 Mar 2010 08:36:23 -0800
X-Trace: forums-1-dub 1269189383 10.22.241.152 (21 Mar 2010 08:36:23 -0800)
X-Original-Trace: 21 Mar 2010 08:36:23 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29062
Article PK: 78299

What makes you say that this is due to network I/O ? (don't expect the folks
here to read through your full sp_sysmon output BTW -- I didn't).
You should explain first what a 'problem' looks like in your case --
unexpected slow response times? all the time? only for specific queries or
users? Only at a specific time of day?
sp_sysmon tends to be the last stop to identify the most common causes of
performance problems. Things to check before jumping into sp_sysmon are:
query plans (any tables scans?); out-of-date statistics; locking problems;
client app algorithm problems.
For an overview of the main issues, check out www.sypron.nl/avoidpp -- it's
from a while ago but still just as relevant.

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
-----------------------------------------------------------------

<Rajasekhar Reddy> wrote in message
news:4ba19cc4.7ffa.1681692777@sybase.com...
> Hello,
>
> We are facing performance issues. It is likely due
> Network problems(suspicious/Found). How can I find is it
> network issue at database level ? I meant, wanna make sure
> is the problem from Network or something else ?
>
> I ran sysmon for 30 min. Please have a look into the below
> report. Please let me know is there any other way to find
> out ?
>
> ===============================================================================
> Sybase Adaptive Server Enterprise System Performance
> Report
> ===============================================================================
>
> Server Version: Adaptive Server Enterprise/12.5.4/EBF
> 14067 ESD#3/P/RS60
> Server Name: XXXXXXX
> Run Date: Mar 18, 2010
> Sampling Started at: Mar 18, 2010 12:24:34
> Sampling Ended at: Mar 18, 2010 12:54:35
> Sample Interval: 00:30:01
> Sample Mode: Reset Counters
>
> ===============================================================================
>
> Kernel Utilization
> ------------------
>
> Your Runnable Process Search Count is set to 3
> and I/O Polling Process Count is set to 10
>
> Engine Busy Utilization CPU Busy I/O Busy
> Idle
> ------------------------ -------- --------
> --------
> Engine 0 19.1 % 3.1 %
> 77.8 %
> Engine 1 13.4 % 3.7 %
> 82.8 %
> Engine 2 13.3 % 3.9 %
> 82.8 %
> Engine 3 13.3 % 4.8 %
> 82.0 %
> Engine 4 21.8 % 3.4 %
> 74.9 %
> Engine 5 27.9 % 40.1 %
> 32.0 %
> ------------------------ -------- --------
> --------
> Summary Total 108.7 % 58.9 %
> 432.4 %
> Average 18.1 % 9.8 %
> 72.1 %
>
> CPU Yields by Engine per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Engine 0 175.6 1.3
> 316179 15.3 %
> Engine 1 128.2 0.9
> 230853 11.2 %
> Engine 2 127.4 0.9
> 229438 11.1 %
> Engine 3 139.4 1.0
> 251009 12.1 %
> Engine 4 155.1 1.1
> 279290 13.5 %
> Engine 5 422.7 3.1
> 761298 36.8 %
> ------------------------- ------------ ------------
> ----------
> Total CPU Yields 1148.3 8.4
> 2068067
>
> Network Checks
> Non-Blocking 2237.8 16.3
> 4030317 69.9 %
> Blocking 961.8 7.0
> 1732172 30.1 %
> ------------------------- ------------ ------------
> ----------
> Total Network I/O Checks 3199.6 23.3
> 5762489
> Avg Net I/Os per Check n/a n/a
> 0.58331 n/a
>
> Disk I/O Checks
> Total Disk I/O Checks 4072.5 29.7
> 7334578 n/a
> Checks Returning I/O 632.0 4.6
> 1138299 15.5 %
> Avg Disk I/Os Returned n/a n/a
> 0.31980 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.1 0.0
> 225 n/a
>
> Task Context Switches by Engine
> Engine 0 100.7 0.7
> 181287 7.0 %
> Engine 1 165.9 1.2
> 298810 11.5 %
> Engine 2 112.4 0.8
> 202484 7.8 %
> Engine 3 106.5 0.8
> 191895 7.4 %
> Engine 4 116.7 0.9
> 210218 8.1 %
> Engine 5 842.7 6.1
> 1517669 58.3 %
> ------------------------- ------------ ------------
> ----------
> Total Task Switches: 1445.0 10.5
> 2602363
>
> Task Context Switches Due To:
> Voluntary Yields 152.3 1.1
> 274239 10.5 %
> Cache Search Misses 1.7 0.0
> 3014 0.1 %
> System Disk Writes 0.2 0.0
> 300 0.0 %
> I/O Pacing 27.9 0.2
> 50305 1.9 %
> Logical Lock Contention 0.0 0.0
> 87 0.0 %
> Address Lock Contention 0.0 0.0
> 0 0.0 %
> Latch Contention 0.0 0.0
> 13 0.0 %
> Log Semaphore Contention 0.6 0.0
> 1035 0.0 %
> PLC Lock Contention 0.0 0.0
> 42 0.0 %
> Group Commit Sleeps 5.6 0.0
> 10010 0.4 %
> Last Log Page Writes 131.7 1.0
> 237103 9.1 %
> Modify Conflicts 8.4 0.1
> 15130 0.6 %
> I/O Device Contention 0.0 0.0
> 0 0.0 %
> Network Packet Received 424.0 3.1
> 763682 29.3 %
> Network Packet Sent 119.2 0.9
> 214763 8.3 %
> Other Causes 573.4 4.2
> 1032640 39.7 %
>
>
> ===============================================================================
>
> Application Management
> ----------------------
>
> Application Statistics Summary (All Applications)
> -------------------------------------------------
> Priority Changes per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> To High Priority 0.7 0.0
> 1183 10.1 %
> To Medium Priority 3.3 0.0
> 5959 50.9 %
> To Low Priority 2.5 0.0
> 4557 39.0 %
> ------------------------- ------------ ------------
> ----------
> Total Priority Changes 6.5 0.0
> 11699
>
> Allotted Slices Exhausted per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> High Priority 0.0 0.0
> 0 0.0 %
> Medium Priority 3.3 0.0
> 5869 100.0 %
> Low Priority 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
> ----------
> Total Slices Exhausted 3.3 0.0
> 5869
>
> 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 180.5 1.3
> 325041 99.7 %
> Dirty 0.5 0.0
> 859 0.3 %
> ------------ ------------
> ----------
> Total Washes 181.0 1.3
> 325900
>
> Garbage Collections 1.2 0.0
> 2148 n/a
> Pages Processed in GC 0.0 0.0
> 2 n/a
>
> Statistics Updates 11.7 0.1
> 21108 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 3.8 0.0
> 6777 n/a
> Maximum SQL Text Requested n/a n/a
> 21407 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 11727 (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 137.1 n/a
> 246963 n/a
>
> Transaction Detail per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Inserts
> APL Heap Table 522.7 3.8
> 941380 3.0 %
> APL Clustered Table 16610.8 121.1
> 29916062 95.3 %
> Data Only Lock Table 290.9 2.1
> 523831 1.7 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total Rows Inserted 17424.4 127.1
> 31381273 99.2 %
>
> Updates
> APL Deferred 0.0 0.0
> 0 0.0 %
> APL Direct In-place 0.0 0.0
> 1 0.0 %
> APL Direct Cheap 0.0 0.0
> 11 0.1 %
> APL Direct Expensive 0.0 0.0
> 0 0.0 %
> DOL Deferred 0.0 0.0
> 0 0.0 %
> DOL Direct 11.9 0.1
> 21404 99.9 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total Rows Updated 11.9 0.1
> 21416 0.1 %
>
> Data Only Locked Updates
> DOL Replace 11.9 0.1
> 21392 99.9 %
> DOL Shrink 0.0 0.0
> 2 0.0 %
> DOL Cheap Expand 0.0 0.0
> 1 0.0 %
> DOL Expensive Expand 0.0 0.0
> 9 0.0 %
> DOL Expand & Forward 0.0 0.0
> 0 0.0 %
> DOL Fwd Row Returned 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total DOL Rows Updated 11.9 0.1
> 21404 0.1 %
>
> Deletes
> APL Deferred 0.8 0.0
> 1437 0.6 %
> APL Direct 0.1 0.0
> 139 0.1 %
> DOL 122.6 0.9
> 220838 99.3 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total Rows Deleted 123.5 0.9
> 222414 0.7 %
> ========================= ============ ============
> ==========
> Total Rows Affected 17559.7 128.1
> 31625103
>
> ===============================================================================
>
> Transaction Management
> ----------------------
>
> ULC Flushes to Xact Log per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> by Full ULC 19.0 0.1
> 34175 11.5 %
> by End Transaction 135.8 1.0
> 244633 82.1 %
> by Change of Database 0.0 0.0
> 39 0.0 %
> by Single Log Record 6.4 0.0
> 11557 3.9 %
> by Unpin 0.3 0.0
> 516 0.2 %
> by Other 3.9 0.0
> 6954 2.3 %
> ------------------------- ------------ ------------
> ----------
> Total ULC Flushes 165.4 1.2
> 297874
>
> ULC Log Records 967.0 7.1
> 1741561 n/a
> Max ULC Size During Sample n/a n/a
> 4096 n/a
>
> ULC Semaphore Requests
> Granted 2004.1 14.6
> 3609347 100.0 %
> Waited 0.0 0.0
> 42 0.0 %
> ------------------------- ------------ ------------
> ----------
> Total ULC Semaphore Req 2004.1 14.6
> 3609389
>
> Log Semaphore Requests
> Granted 172.6 1.3
> 310877 99.7 %
> Waited 0.6 0.0
> 1035 0.3 %
> ------------------------- ------------ ------------
> ----------
> Total Log Semaphore Req 173.2 1.3
> 311912
>
> Transaction Log Writes 175.6 1.3
> 316175 n/a
> Transaction Log Alloc 43.9 0.3
> 79034 n/a
> Avg # Writes per Log Page n/a n/a
> 4.00049 n/a
>
> ===============================================================================
>
> Index Management
> ----------------
>
> Nonclustered Maintenance per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Ins/Upd Requiring Maint 0.1 0.0
> 130 n/a
> # of NC Ndx Maint 0.1 0.0
> 130 n/a
> Avg NC Ndx Maint / Op n/a n/a
> 1.00000 n/a
>
> Deletes Requiring Maint 0.1 0.0
> 139 n/a
> # of NC Ndx Maint 0.1 0.0
> 139 n/a
> Avg NC Ndx Maint / Op n/a n/a
> 1.00000 n/a
>
> RID Upd from Clust Split 0.0 0.0
> 1 n/a
> # of NC Ndx Maint 0.0 0.0
> 18 n/a
> Avg NC Ndx Maint / Op n/a n/a
> 18.00000 n/a
>
> Upd/Del DOL Req Maint 14.3 0.1
> 25767 n/a
> # of DOL Ndx Maint 16.0 0.1
> 28768 n/a
> Avg DOL Ndx Maint / Op n/a n/a
> 1.11647 n/a
>
> Page Splits 1.1 0.0
> 2048 n/a
> Retries 0.0 0.0
> 0 0.0 %
> Deadlocks 0.0 0.0
> 0 0.0 %
> Add Index Level 0.0 0.0
> 0 0.0 %
>
> Page Shrinks 0.0 0.0
> 0 n/a
>
> Index Scans per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Ascending Scans 14161.7 103.3
> 25505261 24.4 %
> DOL Ascending Scans 43962.6 320.6
> 79176580 75.6 %
> Descending Scans 0.8 0.0
> 1390 0.0 %
> DOL Descending Scans 0.0 0.0
> 45 0.0 %
> ------------ ------------
> ----------
> Total Scans 58125.1 423.9
> 104683276
>
> ===============================================================================
>
> Metadata Cache Management
> -------------------------
>
> Metadata Cache Summary per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
>
> Open Object Usage
> Active n/a n/a
> 6004 n/a
> Max Ever Used Since Boot n/a n/a
> 6004 n/a
> Free n/a n/a
> 33996 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
> 9494 n/a
> Max Ever Used Since Boot n/a n/a
> 9524 n/a
> Free n/a n/a
> 60506 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
> 12 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.1 %
>
> Object Spinlock Contention n/a n/a
> n/a 0.0 %
>
> Index Spinlock Contention n/a n/a
> n/a 0.0 %
>
> 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 80881.8 589.8
> 145668105 n/a
> Avg Lock Contention 0.0 0.0
> 87 0.0 %
> Deadlock Percentage 0.0 0.0
> 0 0.0 %
>
> Lock Detail per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
>
> Table Lock Hashtable
> Lookups 1403.6 10.2
> 2527965 n/a
> Avg Chain Length n/a n/a
> 0.05397 n/a
> Spinlock Contention n/a n/a
> n/a 0.0 %
>
> Exclusive Table
> Granted 1.4 0.0
> 2525 99.4 %
> Waited 0.0 0.0
> 16 0.6 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total EX-Table Requests 1.4 0.0
> 2541 0.0 %
>
> Shared Table
> Granted 0.1 0.0
> 195 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total SH-Table Requests 0.1 0.0
> 195 0.0 %
>
> Exclusive Intent
> Granted 137.6 1.0
> 247800 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total EX-Intent Requests 137.6 1.0
> 247800 0.2 %
>
> Shared Intent
> Granted 1249.7 9.1
> 2250694 100.0 %
> Waited 0.0 0.0
> 40 0.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total SH-Intent Requests 1249.7 9.1
> 2250734 1.5 %
>
> Page & Row Lock HashTable
> Lookups 24688.5 180.0
> 44463960 n/a
> Avg Chain Length n/a n/a
> 0.00098 n/a
> Spinlock Contention n/a n/a
> n/a 0.0 %
>
> Exclusive Page
> Granted 2.3 0.0
> 4114 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total EX-Page Requests 2.3 0.0
> 4114 0.0 %
>
> Update Page
> Granted 0.5 0.0
> 911 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total UP-Page Requests 0.5 0.0
> 911 0.0 %
>
> Shared Page
> Granted 23460.7 171.1
> 42252644 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total SH-Page Requests 23460.7 171.1
> 42252644 29.0 %
>
>
> Exclusive Row
> Granted 194.8 1.4
> 350888 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total EX-Row Requests 194.8 1.4
> 350888 0.2 %
>
> Update Row
> Granted 11.0 0.1
> 19727 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total UP-Row Requests 11.0 0.1
> 19727 0.0 %
>
> Shared Row
> Granted 996.8 7.3
> 1795223 100.0 %
> Waited 0.0 0.0
> 31 0.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total SH-Row Requests 996.8 7.3
> 1795254 1.2 %
>
>
> Next-Key
> Total Next-Key Requests 0.0 0.0
> 0 n/a
>
> Address Lock Hashtable
> Lookups 54826.9 399.8
> 98743297 n/a
> Avg Chain Length n/a n/a
> 0.00098 n/a
> Spinlock Contention n/a n/a
> n/a 0.1 %
>
> Exclusive Address
> Granted 133.6 1.0
> 240693 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total EX-Address Requests 133.6 1.0
> 240693 0.2 %
>
> Shared Address
> Granted 54693.3 398.9
> 98502604 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total SH-Address Requests 54693.3 398.9
> 98502604 67.6 %
>
>
> Last Page Locks on Heaps
> Granted 522.7 3.8
> 941380 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total Last Pg Locks 522.7 3.8
> 941380 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
> 19 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
> 0 0.0 %
> Sh-Page to Sh-Table 0.0 0.0
> 0 0.0 %
> Ex-Row to Ex-Table 0.2 0.0
> 383 98.2 %
> Sh-Row to Sh-Table 0.0 0.0
> 7 1.8 %
> Sh-Next-Key to Sh-Table 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
> ----------
> Total Lock Promotions 0.2 0.0
> 390
>
>
> 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 236297.6 1723.2
> 425571942 100.0 %
> Total Cache Misses 25.3 0.2
> 45586 0.0 %
> ------------------------- ------------ ------------
> ----------
> Total Cache Searches 236322.9 1723.4
> 425617528
>
> Cache Turnover
> Buffers Grabbed 242.1 1.8
> 436019 n/a
> Buffers Grabbed Dirty 0.0 0.0
> 0 0.0 %
>
> Cache Strategy Summary
> Cached (LRU) Buffers 235925.2 1720.5
> 424901214 100.0 %
> Discarded (MRU) Buffers 0.2 0.0
> 332 0.0 %
>
> Large I/O Usage
> Large I/Os Performed 6.7 0.0
> 11989 98.5 %
>
> Large I/Os Denied due to
> Pool < Prefetch Size 0.1 0.0
> 152 1.2 %
> Pages Requested
> Reside in Another
> Buffer Pool 0.0 0.0
> 32 0.3 %
> ------------------------- ------------ ------------
> ----------
> Total Large I/O Requests 6.8 0.0
> 12173
>
> Large I/O Effectiveness
> Pages by Lrg I/O Cached 26.6 0.2
> 47956 n/a
> Pages by Lrg I/O Used 475.3 3.5
> 855959 1785 %
>
> Asynchronous Prefetch Activity
> APFs Issued 0.3 0.0
> 560 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 5070.9 37.0
> 9132685 100.0 %
> ------------------------- ------------ ------------
> ----------
> Total APFs Requested 5071.2 37.0
> 9133245
>
> Other Asynchronous Prefetch Statistics
> APFs Used 0.3 0.0
> 558 n/a
> APF Waits for I/O 0.1 0.0
> 137 n/a
> APF Discards 0.0 0.0
> 0 n/a
>
> Dirty Read Behavior
> Page Requests 354.3 2.6
> 638184 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.9 %
>
> Utilization n/a n/a
> n/a 78.2 %
>
> Cache Searches
> Cache Hits 184713.2 1347.0
> 332668523 100.0 %
> Found in Wash 213.9 1.6
> 385307 0.1 %
> Cache Misses 1.0 0.0
> 1865 0.0 %
> ------------------------- ------------ ------------
> ----------
> Total Cache Searches 184714.3 1347.0
> 332670388
>
> Pool Turnover
> 4 Kb Pool
> LRU Buffer Grab 165.3 1.2
> 297691 99.6 %
> Grabbed Dirty 0.0 0.0
> 0 0.0 %
> 16 Kb Pool
> LRU Buffer Grab 0.7 0.0
> 1238 0.4 %
> Grabbed Dirty 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
> ----------
> Total Cache Turnover 166.0 1.2
> 298929
>
> Buffer Wash Behavior
> Statistics Not Available - No Buffers Entered Wash
> Section Yet
>
> Cache Strategy
> Cached (LRU) Buffers 184244.0 1343.6
> 331823488 100.0 %
> Discarded (MRU) Buffers 0.2 0.0
> 332 0.0 %
>
> Large I/O Usage
> Large I/Os Performed 0.7 0.0
> 1238 89.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
> 152 10.9 %
> ------------------------- ------------ ------------
> ----------
> Total Large I/O Requests 0.8 0.0
> 1390
>
> Large I/O Detail
> 16 Kb Pool
> Pages Cached 2.7 0.0
> 4952 n/a
> Pages Used 0.9 0.0
> 1540 31.1 %
>
> Dirty Read Behavior
> Page Requests 353.5 2.6
> 636596 n/a
>
> Tuning Recommendations for Data cache : default data
> 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 21.8 %
>
> Cache Searches
> Cache Hits 51584.4 376.2
> 92903419 100.0 %
> Found in Wash 0.0 0.0
> 0 0.0 %
> Cache Misses 24.3 0.2
> 43721 0.0 %
> ------------------------- ------------ ------------
> ----------
> Total Cache Searches 51608.6 376.4
> 92947140
>
> Pool Turnover
> 4 Kb Pool
> LRU Buffer Grab 70.1 0.5
> 126339 92.2 %
> Grabbed Dirty 0.0 0.0
> 0 0.0 %
> 16 Kb Pool
> LRU Buffer Grab 6.0 0.0
> 10751 7.8 %
> Grabbed Dirty 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
> ----------
> Total Cache Turnover 76.1 0.6
> 137090
>
> Buffer Wash Behavior
> Statistics Not Available - No Buffers Entered Wash
> Section Yet
>
> Cache Strategy
> Cached (LRU) Buffers 51681.1 376.9
> 93077726 100.0 %
> Discarded (MRU) Buffers 0.0 0.0
> 0 0.0 %
>
> Large I/O Usage
> Large I/Os Performed 6.0 0.0
> 10751 99.7 %
>
> 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
> 32 0.3 %
> ------------------------- ------------ ------------
> ----------
> Total Large I/O Requests 6.0 0.0
> 10783
>
> Large I/O Detail
> 16 Kb Pool
> Pages Cached 23.9 0.2
> 43004 n/a
> Pages Used 6.4 0.0
> 11571 26.9 %
>
> Dirty Read Behavior
> Page Requests 0.9 0.0
> 1588 n/a
>
> ===============================================================================
>
> Procedure Cache Management per sec per xact
> count % of total
> --------------------------- ------------ ------------
> ---------- ----------
> Procedure Requests 32.4 0.2
> 58322 n/a
> Procedure Reads from Disk 0.0 0.0
> 4 0.0 %
> Procedure Writes to Disk 0.0 0.0
> 0 0.0 %
> Procedure Removals 0.0 0.0
> 8 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.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 124.5 0.9
> 224250 n/a
>
>
> ===============================================================================
>
> Memory Management per sec per xact
> count % of total
> --------------------------- ------------ ------------
> ---------- ----------
> Pages Allocated 0.3 0.0
> 463 n/a
> Pages Released 0.3 0.0
> 479 n/a
>
> ===============================================================================
>
> Recovery Management
> -------------------
>
> Checkpoints per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> # of Normal Checkpoints 0.0 0.0
> 53 100.0 %
> # of Free Checkpoints 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
> ----------
> Total Checkpoints 0.0 0.0
> 53
>
> Avg Time per Normal Chkpt 0.67925 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
> 147 n/a
> Engine 1 n/a n/a
> 26 n/a
> Engine 2 n/a n/a
> 146 n/a
> Engine 3 n/a n/a
> 131 n/a
> Engine 4 n/a n/a
> 100 n/a
> Engine 5 n/a n/a
> 163 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 202.1 1.5
> 364046
>
> Completed Disk I/O's
> Engine 0 11.6 0.1
> 20811 5.7 %
> Engine 1 7.6 0.1
> 13635 3.7 %
> Engine 2 13.1 0.1
> 23671 6.5 %
> Engine 3 16.5 0.1
> 29663 8.1 %
> Engine 4 13.0 0.1
> 23400 6.4 %
> Engine 5 140.4 1.0
> 252845 69.5 %
> ------------------------- ------------ ------------
> ----------
> Total Completed I/Os 202.1 1.5
> 364025
>
>
> Device Activity Detail
> ----------------------
>
> Device:
> /opt/sw/sybase/devices/data/dbadmin_d01.dat
> dbadmin_d01 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:
> /opt/sw/sybase/devices/data/xxxxx01_d01.dat
> xxxxx01_d01 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 2 0.2 %
> Non-APF 0.0 0.0
> 88 6.8 %
> Writes 0.7 0.0
> 1211 93.1 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.7 0.0
> 1301 0.4 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d02.dat
> xxxxx01_d02 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 27 10.1 %
> Writes 0.1 0.0
> 240 89.9 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.1 0.0
> 267 0.1 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d03.dat
> xxxxx01_d03 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 11 50.0 %
> Writes 0.0 0.0
> 11 50.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 22 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d04.dat
> xxxxx01_d04 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 11 55.0 %
> Writes 0.0 0.0
> 9 45.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 20 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d05.dat
> xxxxx01_d05 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 22 61.1 %
> Writes 0.0 0.0
> 14 38.9 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 36 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d06.dat
> xxxxx01_d06 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 22 78.6 %
> Writes 0.0 0.0
> 6 21.4 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 28 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d07.dat
> xxxxx01_d07 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 23 11.1 %
> Writes 0.1 0.0
> 184 88.9 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.1 0.0
> 207 0.1 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d08.dat
> xxxxx01_d08 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 11 22.4 %
> Writes 0.0 0.0
> 38 77.6 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 49 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d09.dat
> xxxxx01_d09 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 1 1.2 %
> Writes 0.0 0.0
> 82 98.8 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 83 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d10.dat
> xxxxx01_d10 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 18 58.1 %
> Writes 0.0 0.0
> 13 41.9 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 31 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d11.dat
> xxxxx01_d11 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 37 37.4 %
> Writes 0.0 0.0
> 62 62.6 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.1 0.0
> 99 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d12.dat
> xxxxx01_d12 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 26 51.0 %
> Writes 0.0 0.0
> 25 49.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 51 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d13.dat
> xxxxx01_d13 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 5 6.1 %
> Non-APF 0.0 0.0
> 69 84.1 %
> Writes 0.0 0.0
> 8 9.8 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 82 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d14.dat
> xxxxx01_d14 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 12 16.2 %
> Non-APF 0.0 0.0
> 40 54.1 %
> Writes 0.0 0.0
> 22 29.7 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 74 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d15.dat
> xxxxx01_d15 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 14 17.7 %
> Non-APF 0.0 0.0
> 39 49.4 %
> Writes 0.0 0.0
> 26 32.9 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 79 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d16.dat
> xxxxx01_d16 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 36 12.9 %
> Writes 0.1 0.0
> 244 87.1 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.2 0.0
> 280 0.1 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d17.dat
> xxxxx01_d17 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 13 26.0 %
> Non-APF 0.0 0.0
> 26 52.0 %
> Writes 0.0 0.0
> 11 22.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 50 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d18.dat
> xxxxx01_d18 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 6 11.8 %
> Non-APF 0.0 0.0
> 29 56.9 %
> Writes 0.0 0.0
> 16 31.4 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 51 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d19.dat
> xxxxx01_d19 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 21 25.3 %
> Non-APF 0.0 0.0
> 54 65.1 %
> Writes 0.0 0.0
> 8 9.6 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 83 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d20.dat
> xxxxx01_d20 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 42 7.6 %
> Non-APF 0.0 0.0
> 52 9.4 %
> Writes 0.3 0.0
> 461 83.1 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.3 0.0
> 555 0.2 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d21.dat
> xxxxx01_d21 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 50 26.5 %
> Non-APF 0.0 0.0
> 38 20.1 %
> Writes 0.1 0.0
> 101 53.4 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.1 0.0
> 189 0.1 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d22.dat
> xxxxx01_d22 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 7 0.9 %
> Non-APF 0.0 0.0
> 70 9.0 %
> Writes 0.4 0.0
> 703 90.1 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.4 0.0
> 780 0.2 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d23.dat
> xxxxx01_d23 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 58 0.7 %
> Non-APF 0.2 0.0
> 276 3.4 %
> Writes 4.3 0.0
> 7759 95.9 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 4.5 0.0
> 8093 2.2 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d24.dat
> xxxxx01_d24 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 38 10.1 %
> Non-APF 0.0 0.0
> 50 13.2 %
> Writes 0.2 0.0
> 290 76.7 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.2 0.0
> 378 0.1 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d25.dat
> xxxxx01_d25 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 14 3.5 %
> Non-APF 0.0 0.0
> 27 6.8 %
> Writes 0.2 0.0
> 357 89.7 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.2 0.0
> 398 0.1 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d26.dat
> xxxxx01_d26 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 56 23.9 %
> Non-APF 0.0 0.0
> 46 19.7 %
> Writes 0.1 0.0
> 132 56.4 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.1 0.0
> 234 0.1 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d27.dat
> xxxxx01_d27 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 33 17.5 %
> Non-APF 0.0 0.0
> 36 19.0 %
> Writes 0.1 0.0
> 120 63.5 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.1 0.0
> 189 0.1 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d28.dat
> xxxxx01_d28 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 3 9.7 %
> Non-APF 0.0 0.0
> 9 29.0 %
> Writes 0.0 0.0
> 19 61.3 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 31 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d29.dat
> xxxxx01_d29 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 8 17.8 %
> Non-APF 0.0 0.0
> 15 33.3 %
> Writes 0.0 0.0
> 22 48.9 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 45 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d30.dat
> xxxxx01_d30 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 8 25.0 %
> Non-APF 0.0 0.0
> 0 0.0 %
> Writes 0.0 0.0
> 24 75.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 32 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d31.dat
> xxxxx01_d31 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.1 0.0
> 94 0.6 %
> Writes 9.4 0.1
> 16976 99.4 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 9.5 0.1
> 17070 4.7 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d32.dat
> xxxxx01_d32 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 3 42.9 %
> Writes 0.0 0.0
> 4 57.1 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 7 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d33.dat
> xxxxx01_d33 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 13 6.6 %
> Non-APF 0.0 0.0
> 16 8.1 %
> Writes 0.1 0.0
> 169 85.4 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.1 0.0
> 198 0.1 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d34.dat
> xxxxx01_d34 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 22 84.6 %
> Writes 0.0 0.0
> 4 15.4 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 26 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d35.dat
> xxxxx01_d35 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 49 29.7 %
> Writes 0.1 0.0
> 116 70.3 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.1 0.0
> 165 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d36.dat
> xxxxx01_d36 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 8 44.4 %
> Non-APF 0.0 0.0
> 8 44.4 %
> Writes 0.0 0.0
> 2 11.1 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 18 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d37.dat
> xxxxx01_d37 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 10 33.3 %
> Non-APF 0.0 0.0
> 6 20.0 %
> Writes 0.0 0.0
> 14 46.7 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 30 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d38.dat
> xxxxx01_d38 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 1 3.3 %
> Writes 0.0 0.0
> 29 96.7 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 30 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d39.dat
> xxxxx01_d39 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 19 50.0 %
> Non-APF 0.0 0.0
> 19 50.0 %
> Writes 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 38 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d40.dat
> xxxxx01_d40 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 50 17.9 %
> Non-APF 0.0 0.0
> 90 32.3 %
> Writes 0.1 0.0
> 139 49.8 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.2 0.0
> 279 0.1 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d41.dat
> xxxxx01_d41 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 13 20.0 %
> Non-APF 0.0 0.0
> 18 27.7 %
> Writes 0.0 0.0
> 34 52.3 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 65 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d42.dat
> xxxxx01_d42 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 53 1.0 %
> Non-APF 0.0 0.0
> 44 0.9 %
> Writes 2.8 0.0
> 5042 98.1 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 2.9 0.0
> 5139 1.4 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d43.dat
> xxxxx01_d43 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 4 0.6 %
> Non-APF 0.0 0.0
> 2 0.3 %
> Writes 0.4 0.0
> 703 99.2 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.4 0.0
> 709 0.2 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d44.dat
> xxxxx01_d44 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
> 9 100.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 9 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d45.dat
> xxxxx01_d45 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:
> /opt/sw/sybase/devices/data/xxxxx01_d46.dat
> xxxxx01_d46 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
> 22 100.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 22 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d47.dat
> xxxxx01_d47 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:
> /opt/sw/sybase/devices/data/xxxxx01_d48.dat
> xxxxx01_d48 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 1 0.5 %
> Writes 0.1 0.0
> 197 99.5 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.1 0.0
> 198 0.1 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d49.dat
> xxxxx01_d49 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:
> /opt/sw/sybase/devices/data/xxxxx01_d50.dat
> xxxxx01_d50 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:
> /opt/sw/sybase/devices/data/xxxxx01_d51.dat
> xxxxx01_d51 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:
> /opt/sw/sybase/devices/data/xxxxx01_d52.dat
> xxxxx01_d52 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
> 12 100.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 12 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d53.dat
> xxxxx01_d53 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:
> /opt/sw/sybase/devices/data/xxxxx01_d54.dat
> xxxxx01_d54 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
> 9 100.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.0 0.0
> 9 0.0 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/xxxxx01_d55.dat
> xxxxx01_d55 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:
> /opt/sw/sybase/devices/log/dbadmin_l01.dat
> dbadmin_l01 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:
> /opt/sw/sybase/devices/log/xxxxx01_l01.dat
> xxxxx01_l01 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.1 0.0
> 262 0.1 %
> Writes 168.9 1.2
> 304121 99.9 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 169.0 1.2
> 304383 83.6 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/system/dbccdb_d01.dat
> dbccdb_d01 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:
> /opt/sw/sybase/devices/system/dbccdb_l01.dat
> dbccdb_l01 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:
> /opt/sw/sybase/devices/system/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
> 42 9.7 %
> Writes 0.2 0.0
> 390 90.3 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 0.2 0.0
> 432 0.1 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/system/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:
> /opt/sw/sybase/devices/system/sysprocs.dat
> sysprocsdev 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:
> /opt/sw/sybase/devices/tempdb/tempdb_d01.dat
> tempdb_d01 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.5 0.0
> 830 5.0 %
> Writes 8.7 0.1
> 15627 95.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 9.1 0.1
> 16457 4.5 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/tempdb/tempdb_d02.dat
> tempdb_d02 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.1 0.0
> 186 6.0 %
> Writes 1.6 0.0
> 2902 94.0 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 1.7 0.0
> 3088 0.8 %
>
>
>
> -----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/tempdb/tempdb_d03.dat
> tempdb_d03 per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.1 0.0
> 112 6.1 %
> Writes 1.0 0.0
> 1712 93.9 %
> ------------------------- ------------ ------------
> ---------- ----------
> Total I/Os 1.0 0.0
> 1824 0.5 %
>
>
>
> -----------------------------------------------------------------------------
>
>
>
> ===============================================================================
>
> Network I/O Management
> ----------------------
>
> Total Network I/O Requests 543.3 4.0
> 978446 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 23.0 0.2
> 41378 5.4 %
> Engine 1 23.8 0.2
> 42810 5.6 %
> Engine 2 30.9 0.2
> 55609 7.3 %
> Engine 3 30.7 0.2
> 55213 7.2 %
> Engine 4 19.4 0.1
> 34854 4.6 %
> Engine 5 296.4 2.2
> 533844 69.9 %
> ------------------------- ------------ ------------
> ----------
> Total TDS Packets Rec'd 424.0 3.1
> 763708
>
>
> Total Bytes Received per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Engine 0 12664.9 92.4
> 22809501 6.3 %
> Engine 1 9789.8 71.4
> 17631345 4.9 %
> Engine 2 13578.1 99.0
> 24454166 6.8 %
> Engine 3 16195.6 118.1
> 29168201 8.1 %
> Engine 4 6075.1 44.3
> 10941180 3.0 %
> Engine 5 142551.6 1039.6
> 256735377 71.0 %
> ------------------------- ------------ ------------
> ----------
> Total Bytes Rec'd 200855.0 1464.8
> 361739770
>
>
> Avg Bytes Rec'd per Packet n/a n/a
> 473 n/a
>
>
> -----------------------------------------------------------------------------
>
> Total TDS Packets Sent per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Engine 0 57.6 0.4
> 103649 4.0 %
> Engine 1 500.7 3.7
> 901723 34.7 %
> Engine 2 101.5 0.7
> 182881 7.0 %
> Engine 3 89.8 0.7
> 161688 6.2 %
> Engine 4 345.4 2.5
> 622118 23.9 %
> Engine 5 347.3 2.5
> 625534 24.1 %
> ------------------------- ------------ ------------
> ----------
> Total TDS Packets Sent 1442.3 10.5
> 2597593
>
>
> Total Bytes Sent per sec per xact
> count % of total
> ------------------------- ------------ ------------
> ---------- ----------
> Engine 0 96751.1 705.6
> 174248693 -10.8 %
> Engine 1 -550040.1 -4011.2
> -990622283 61.2 %
> Engine 2 285486.7 2081.9
> 514161464 -31.7 %
> Engine 3 209669.2 1529.0
> 377614307 -23.3 %
> Engine 4 -1120637.7 -8172.4
> ********** 124.6 %
> Engine 5 179418.5 1308.4
> 323132693 -19.9 %
> ------------------------- ------------ ------------
> ----------
> Total Bytes Sent -899352.3 -6558.6
> **********
>
>
> Avg Bytes Sent per Packet n/a n/a
> -623 n/a
>
>
>
>
>
>
> Thanks,
> Rajasekhar Reddy