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.

sysmon analysis

2 posts in General Discussion Last posting was on 2011-11-11 17:01:02.0Z
Raj Posted on 2011-11-10 10:50:02.0Z
Sender: 5a2e.4ebbabac.1804289383@sybase.com
From: Raj
Newsgroups: sybase.public.ase.general
Subject: sysmon analysis
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4ebbac59.5a49.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 10 Nov 2011 02:50:02 -0800
X-Trace: forums-1-dub 1320922202 10.22.241.41 (10 Nov 2011 02:50:02 -0800)
X-Original-Trace: 10 Nov 2011 02:50:02 -0800, 10.22.241.41
Lines: 3329
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30659
Article PK: 73550

Hi,

  One of our production servers running very slow, Trying
find out what is the reason. Have run sysmon report. Can any
of you please have a look and suggest me on tuning ?? Sybase
version is 12.5.4 on IBM AIX. Also, Network checks Blocking
26%. What does it means ? is it alrigt ?

Thanks in advance.



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

Server Version: Adaptive Server Enterprise/12.5.4/EBF
14067 ESD#3/P/RS60
Server Name: xxxxx
Run Date: Nov 07, 2011
Sampling Started at: Nov 07, 2011 16:56:33
Sampling Ended at: Nov 07, 2011 17:01:33
Sample Interval: 00:05:00
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 45.3 % 8.4 %
46.3 %
Engine 1 48.2 % 4.3 %
47.5 %
Engine 2 46.6 % 8.6 %
44.8 %
Engine 3 60.2 % 5.6 %
34.1 %
Engine 4 59.1 % 8.4 %
32.6 %
Engine 5 63.7 % 4.1 %
32.3 %
------------------------ -------- --------
--------
Summary Total 323.1 % 39.4 %
237.6 %
Average 53.8 % 6.6 %
39.6 %

CPU Yields by Engine per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Engine 0 284.2 4.6
85254 24.2 %
Engine 1 189.6 3.0
56869 16.1 %
Engine 2 188.7 3.0
56615 16.1 %
Engine 3 153.2 2.5
45960 13.0 %
Engine 4 175.8 2.8
52746 15.0 %
Engine 5 184.0 2.9
55186 15.6 %
------------------------- ------------ ------------
----------
Total CPU Yields 1175.4 18.8
352630

Network Checks
Non-Blocking 2395.5 38.4
718663 73.4 %
Blocking 870.2 13.9
261047 26.6 %
------------------------- ------------ ------------
----------
Total Network I/O Checks 3265.7 52.3
979710
Avg Net I/Os per Check n/a n/a
1.83202 n/a

Disk I/O Checks
Total Disk I/O Checks 4580.7 73.4
1374212 n/a
Checks Returning I/O 1214.9 19.5
364478 26.5 %
Avg Disk I/Os Returned n/a n/a
0.43059 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.4 0.0
107 n/a

Task Context Switches by Engine
Engine 0 374.1 6.0
112217 18.8 %
Engine 1 385.3 6.2
115603 19.3 %
Engine 2 267.7 4.3
80319 13.4 %
Engine 3 213.0 3.4
63897 10.7 %
Engine 4 347.0 5.6
104107 17.4 %
Engine 5 405.9 6.5
121778 20.4 %
------------------------- ------------ ------------
----------
Total Task Switches: 1993.1 31.9
597921

Task Context Switches Due To:
Voluntary Yields 69.8 1.1
20945 3.5 %
Cache Search Misses 194.6 3.1
58373 9.8 %
System Disk Writes 0.2 0.0
72 0.0 %
I/O Pacing 22.5 0.4
6751 1.1 %
Logical Lock Contention 0.4 0.0
115 0.0 %
Address Lock Contention 0.0 0.0
0 0.0 %
Latch Contention 0.0 0.0
3 0.0 %
Log Semaphore Contention 0.3 0.0
85 0.0 %
PLC Lock Contention 0.0 0.0
1 0.0 %
Group Commit Sleeps 2.0 0.0
606 0.1 %
Last Log Page Writes 49.3 0.8
14777 2.5 %
Modify Conflicts 0.6 0.0
173 0.0 %
I/O Device Contention 0.0 0.0
0 0.0 %
Network Packet Received 445.2 7.1
133561 22.3 %
Network Packet Sent 321.3 5.1
96393 16.1 %
Other Causes 886.9 14.2
266066 44.5 %


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

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

Application Statistics Summary (All Applications)
-------------------------------------------------
Priority Changes per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
To High Priority 0.7 0.0
210 13.9 %
To Medium Priority 2.7 0.0
810 53.6 %
To Low Priority 1.6 0.0
492 32.5 %
------------------------- ------------ ------------
----------
Total Priority Changes 5.0 0.1
1512

Allotted Slices Exhausted per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
High Priority 0.0 0.0
0 0.0 %
Medium Priority 11.1 0.2
3325 100.0 %
Low Priority 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
----------
Total Slices Exhausted 11.1 0.2
3325

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 199.7 3.2
59906 99.6 %
Dirty 0.8 0.0
254 0.4 %
------------ ------------
----------
Total Washes 200.5 3.2
60160

Garbage Collections 1.4 0.0
414 n/a
Pages Processed in GC 0.0 0.0
0 n/a

Statistics Updates 2.0 0.0
588 n/a

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

Monitor Access to Executing SQL
-------------------------------
per sec per xact
count % of total
------------ ------------
---------- ----------
Waits on Execution Plans 0.0 0.0
0 n/a
Number of SQL Text Overflows 10.3 0.2
3079 n/a
Maximum SQL Text Requested n/a n/a
113577 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 57812 (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 62.4 n/a
18732 n/a

Transaction Detail per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Inserts
APL Heap Table 13474.7 215.8
4042403 19.0 %
APL Clustered Table 57148.9 915.3
17144672 80.6 %
Data Only Lock Table 296.7 4.8
89007 0.4 %
------------------------- ------------ ------------
---------- ----------
Total Rows Inserted 70920.3 1135.8
21276082 100.0 %

Updates
APL Deferred 0.1 0.0
41 0.6 %
APL Direct In-place 0.0 0.0
8 0.1 %
APL Direct Cheap 0.4 0.0
130 2.0 %
APL Direct Expensive 0.0 0.0
0 0.0 %
DOL Deferred 0.0 0.0
10 0.2 %
DOL Direct 20.8 0.3
6227 97.1 %
------------------------- ------------ ------------
---------- ----------
Total Rows Updated 21.4 0.3
6416 0.0 %

Data Only Locked Updates
DOL Replace 20.8 0.3
6231 99.9 %
DOL Shrink 0.0 0.0
0 0.0 %
DOL Cheap Expand 0.0 0.0
0 0.0 %
DOL Expensive Expand 0.0 0.0
6 0.1 %
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 20.8 0.3
6237 0.0 %

Deletes
APL Deferred 8.8 0.1
2638 65.6 %
APL Direct 0.8 0.0
229 5.7 %
DOL 3.8 0.1
1154 28.7 %
------------------------- ------------ ------------
---------- ----------
Total Rows Deleted 13.4 0.2
4021 0.0 %

=========================
============
============
==========
Total Rows Affected 70955.1 1136.4
21286519

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

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

ULC Flushes to Xact Log per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
by Full ULC 6.9 0.1
2057 7.0 %
by End Transaction 55.0 0.9
16487 56.4 %
by Change of Database 0.5 0.0
135 0.5 %
by Single Log Record 24.8 0.4
7430 25.4 %
by Unpin 0.6 0.0
177 0.6 %
by Other 9.8 0.2
2925 10.0 %
------------------------- ------------ ------------
----------
Total ULC Flushes 97.4 1.6
29211

ULC Log Records 918.9 14.7
275655 n/a
Max ULC Size During Sample n/a n/a
4096 n/a

ULC Semaphore Requests
Granted 1885.9 30.2
565767 100.0 %
Waited 0.0 0.0
1 0.0 %
------------------------- ------------ ------------
----------
Total ULC Semaphore Req 1885.9 30.2
565768

Log Semaphore Requests
Granted 100.2 1.6
30060 99.7 %
Waited 0.3 0.0
85 0.3 %
------------------------- ------------ ------------
----------
Total Log Semaphore Req 100.5 1.6
30145

Transaction Log Writes 68.4 1.1
20506 n/a
Transaction Log Alloc 19.7 0.3
5919 n/a
Avg # Writes per Log Page n/a n/a
3.46444 n/a

Tuning Recommendations for Transaction Management
-------------------------------------------------
- Consider decreasing the 'user log cache size'
configuration parameter if it is greater than the
logical database page size.

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

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

Nonclustered Maintenance per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Ins/Upd Requiring Maint 1.3 0.0
403 n/a
# of NC Ndx Maint 1.4 0.0
429 n/a
Avg NC Ndx Maint / Op n/a n/a
1.06452 n/a

Deletes Requiring Maint 1.4 0.0
408 n/a
# of NC Ndx Maint 1.4 0.0
434 n/a
Avg NC Ndx Maint / Op n/a n/a
1.06373 n/a

RID Upd from Clust Split 0.0 0.0
0 n/a
# of NC Ndx Maint 0.0 0.0
0 n/a

Upd/Del DOL Req Maint 24.6 0.4
7388 n/a
# of DOL Ndx Maint 14.2 0.2
4255 n/a
Avg DOL Ndx Maint / Op n/a n/a
0.57593 n/a

Page Splits 2.9 0.0
876 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
1 n/a
Deadlocks %
Deadlock Retries Exceeded 0.0 0.0
0 0.0 %

Index Scans per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Ascending Scans 22867.2 366.2
6860153 24.9 %
DOL Ascending Scans 68997.5 1105.0
20699261 75.1 %
Descending Scans 2.2 0.0
647 0.0 %
DOL Descending Scans 0.1 0.0
15 0.0 %
------------ ------------
----------
Total Scans 91866.9 1471.3
27560076

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

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

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

Open Object Usage
Active n/a n/a
6755 n/a
Max Ever Used Since Boot n/a n/a
7088 n/a
Free n/a n/a
33245 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
10755 n/a
Max Ever Used Since Boot n/a n/a
11506 n/a
Free n/a n/a
59245 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
11 n/a
Max Ever Used Since Boot n/a n/a
11 n/a
Free n/a n/a
9 n/a
Reuse Requests
Succeeded n/a n/a
0 n/a
Failed n/a n/a
0 n/a

Object Manager Spinlock Contention n/a n/a
n/a 0.2 %

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

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

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 179785.7 2879.3
53935709 n/a
Avg Lock Contention 0.4 0.0
115 0.0 %
Deadlock Percentage 0.0 0.0
0 0.0 %

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

Table Lock Hashtable
Lookups 2098.2 33.6
629451 n/a
Avg Chain Length n/a n/a
0.21041 n/a
Spinlock Contention n/a n/a
n/a 0.0 %

Exclusive Table
Granted 13.3 0.2
3999 99.4 %
Waited 0.1 0.0
26 0.6 %
------------------------- ------------ ------------
---------- ----------
Total EX-Table Requests 13.4 0.2
4025 0.0 %

Shared Table
Granted 1.6 0.0
487 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total SH-Table Requests 1.6 0.0
487 0.0 %

Exclusive Intent
Granted 60.0 1.0
18002 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total EX-Intent Requests 60.0 1.0
18002 0.0 %

Shared Intent
Granted 2004.9 32.1
601474 100.0 %
Waited 0.2 0.0
55 0.0 %
------------------------- ------------ ------------
---------- ----------
Total SH-Intent Requests 2005.1 32.1
601529 1.1 %

Page & Row Lock HashTable
Lookups 42644.7 683.0
12793395 n/a
Avg Chain Length n/a n/a
0.01196 n/a
Spinlock Contention n/a n/a
n/a 0.0 %

Exclusive Page
Granted 43.1 0.7
12941 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total EX-Page Requests 43.1 0.7
12941 0.0 %

Update Page
Granted 5.3 0.1
1598 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total UP-Page Requests 5.3 0.1
1598 0.0 %

Shared Page
Granted 16968.4 271.8
5090509 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total SH-Page Requests 16968.4 271.8
5090509 9.4 %


Exclusive Row
Granted 104.2 1.7
31273 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total EX-Row Requests 104.2 1.7
31273 0.1 %

Update Row
Granted 21049.7 337.1
6314896 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total UP-Row Requests 21049.7 337.1
6314896 11.7 %

Shared Row
Granted 4449.6 71.3
1334875 100.0 %
Waited 0.1 0.0
34 0.0 %
------------------------- ------------ ------------
---------- ----------
Total SH-Row Requests 4449.7 71.3
1334909 2.5 %


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

Address Lock Hashtable
Lookups 135085.1 2163.4
40525542 n/a
Avg Chain Length n/a n/a
0.00029 n/a
Spinlock Contention n/a n/a
n/a 0.3 %

Exclusive Address
Granted 499.6 8.0
149887 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total EX-Address Requests 499.6 8.0
149887 0.3 %

Shared Address
Granted 134585.5 2155.4
40375653 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total SH-Address Requests 134585.5 2155.4
40375653 74.9 %


Last Page Locks on Heaps
Granted 13474.7 215.8
4042403 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total Last Pg Locks 13474.7 215.8
4042403 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
7 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
72 93.5 %
Sh-Row to Sh-Table 0.0 0.0
5 6.5 %
Sh-Next-Key to Sh-Table 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
----------
Total Lock Promotions 0.3 0.0
77


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 553731.3 8868.2
166119391 99.9 %
Total Cache Misses 361.2 5.8
108357 0.1 %
------------------------- ------------ ------------
----------
Total Cache Searches 554092.5 8874.0
166227748

Cache Turnover
Buffers Grabbed 5262.4 84.3
1578721 n/a
Buffers Grabbed Dirty 0.1 0.0
22 0.0 %

Cache Strategy Summary
Cached (LRU) Buffers 553152.4 8858.9
165945729 100.0 %
Discarded (MRU) Buffers 0.3 0.0
82 0.0 %

Large I/O Usage
Large I/Os Performed 206.8 3.3
62053 99.9 %

Large I/Os Denied due to
Pool < Prefetch Size 0.0 0.0
4 0.0 %
Pages Requested
Reside in Another
Buffer Pool 0.1 0.0
33 0.1 %
------------------------- ------------ ------------
----------
Total Large I/O Requests 207.0 3.3
62090

Large I/O Effectiveness
Pages by Lrg I/O Cached 827.4 13.3
248212 n/a
Pages by Lrg I/O Used 6250.3 100.1
1875100 755.4 %

Asynchronous Prefetch Activity
APFs Issued 48.3 0.8
14477 0.1 %
APFs Denied Due To
APF I/O Overloads 0.2 0.0
48 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 79093.8 1266.7
23728154 99.9 %
------------------------- ------------ ------------
----------
Total APFs Requested 79142.3 1267.5
23742679

Other Asynchronous Prefetch Statistics
APFs Used 48.3 0.8
14487 n/a
APF Waits for I/O 30.1 0.5
9026 n/a
APF Discards 0.0 0.0
0 n/a

Dirty Read Behavior
Page Requests 989.4 15.8
296808 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 3.4 %

Utilization n/a n/a
n/a 61.3 %

Cache Searches
Cache Hits 339663.6 5439.8
101899093 100.0 %
Found in Wash 20.3 0.3
6082 0.0 %
Cache Misses 117.4 1.9
35212 0.0 %
------------------------- ------------ ------------
----------
Total Cache Searches 339781.0 5441.7
101934305

Pool Turnover
4 Kb Pool
LRU Buffer Grab 388.8 6.2
116644 70.2 %
Grabbed Dirty 0.0 0.0
0 0.0 %
16 Kb Pool
LRU Buffer Grab 165.1 2.6
49520 29.8 %
Grabbed Dirty 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
----------
Total Cache Turnover 553.9 8.9
166164

Buffer Wash Behavior
Buffers Passed Clean 81.9 1.3
24569 100.0 %
Buffers Already in I/O 0.0 0.0
0 0.0 %
Buffers Washed Dirty 0.0 0.0
0 0.0 %

Cache Strategy
Cached (LRU) Buffers 338730.1 5424.9
101619038 100.0 %
Discarded (MRU) Buffers 0.3 0.0
82 0.0 %

Large I/O Usage
Large I/Os Performed 165.1 2.6
49520 100.0 %

Large I/Os Denied due to
Pool < Prefetch Size 0.0 0.0
0 0.0 %
Pages Requested
Reside in Another
Buffer Pool 0.0 0.0
4 0.0 %
------------------------- ------------ ------------
----------
Total Large I/O Requests 165.1 2.6
49524

Large I/O Detail
16 Kb Pool
Pages Cached 660.3 10.6
198080 n/a
Pages Used 657.9 10.5
197375 99.6 %

Dirty Read Behavior
Page Requests 979.8 15.7 293942
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 4.2 %

Utilization n/a n/a
n/a 38.7 %

Cache Searches
Cache Hits 214067.7 3428.4
64220298 99.9 %
Found in Wash 0.0 0.0
0 0.0 %
Cache Misses 243.8 3.9
73145 0.1 %
------------------------- ------------ ------------
----------
Total Cache Searches 214311.5 3432.3
64293443

Pool Turnover
4 Kb Pool
LRU Buffer Grab 4666.7 74.7
1400002 99.1 %
Grabbed Dirty 0.1 0.0
22 0.0 %
16 Kb Pool
LRU Buffer Grab 41.8 0.7
12533 0.9 %
Grabbed Dirty 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
----------
Total Cache Turnover 4708.5 75.4
1412557

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

Cache Strategy
Cached (LRU) Buffers 214422.3 3434.1
64326691 100.0 %
Discarded (MRU) Buffers 0.0 0.0
0 0.0 %

Large I/O Usage
Large I/Os Performed 41.8 0.7
12533 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.1 0.0
33 0.3 %
------------------------- ------------ ------------
----------
Total Large I/O Requests 41.9 0.7
12566

Large I/O Detail
16 Kb Pool
Pages Cached 167.1 2.7
50132 n/a
Pages Used 42.5 0.7
12763 25.5 %

Dirty Read Behavior
Page Requests 9.6 0.2 2866
n/a

Tuning Recommendations for Data cache : tempdb_cache
-------------------------------------
- Consider increasing the 'wash size' of the 4k pool for
this cache.

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

Procedure Cache Management per sec per xact
count % of total
--------------------------- ------------ ------------
---------- ----------
Procedure Requests 31.7 0.5
9513 n/a
Procedure Reads from Disk 0.3 0.0
85 0.9 %
Procedure Writes to Disk 0.0 0.0
0 0.0 %
Procedure Removals 0.6 0.0
170 n/a
Procedure Recompilations 0.3 0.0
85 n/a

Recompilations Requests:
Execution Phase 0.3 0.0
85 100.0 %
Compilation Phase 0.0 0.0
0 0.0 %
Execute Cursor Execution 0.0 0.0
0 0.0 %
Redefinition Phase 0.0 0.0
0 0.0 %

Recompilation Reasons:
Table Missing 0.0 0.0
0 n/a
Temporary Table Missing 0.0 0.0
0 n/a
Schema Change 0.3 0.0
85 n/a
Index Change 0.0 0.0
0 n/a
Isolation Level Change 0.0 0.0
0 n/a
Permissions Change 0.0 0.0
0 n/a
Cursor Permissions Change 0.0 0.0
0 n/a

SQL Statement Cache:
Statements Cached 0.0 0.0
0 n/a
Statements Found in Cache 0.0 0.0
0 n/a
Statements Not Found 0.0 0.0
0 n/a
Statements Dropped 0.0 0.0
0 n/a
Statements Restored 0.0 0.0
0 n/a
Statements Not Cached 339.2 5.4
101748 n/a


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

Memory Management per sec per xact
count % of total
--------------------------- ------------ ------------
---------- ----------
Pages Allocated 1.0 0.0
305 n/a
Pages Released 1.0 0.0
301 n/a

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

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

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

Avg Time per Normal Chkpt 0.00000 seconds

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

Disk I/O Management
-------------------

Max Outstanding I/Os per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Server n/a n/a
0 n/a
Engine 0 n/a n/a
255 n/a
Engine 1 n/a n/a
127 n/a
Engine 2 n/a n/a
76 n/a
Engine 3 n/a n/a
50 n/a
Engine 4 n/a n/a
253 n/a
Engine 5 n/a n/a
256 n/a


I/Os Delayed by
Disk I/O Structures n/a n/a
5 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 523.5 8.4
157049

Completed Disk I/O's
Engine 0 112.8 1.8
33825 21.6 %
Engine 1 50.7 0.8
15195 9.7 %
Engine 2 72.5 1.2
21761 13.9 %
Engine 3 67.5 1.1
20250 12.9 %
Engine 4 104.4 1.7
31315 20.0 %
Engine 5 115.3 1.8
34595 22.0 %
------------------------- ------------ ------------
----------
Total Completed I/Os 523.1 8.4
156941


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/mx_auxiliary_d01.dat
mx_auxiliary_d01 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
1 100.0 %
Writes 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
1 0.0 %



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

Device:
/opt/sw/sybase/devices/data/mx_auxiliary_d02.dat
mx_auxiliary_d02 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/mx_auxiliary_d03.dat
mx_auxiliary_d03 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/mx_auxiliary_d04.dat
mx_auxiliary_d04 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:
Device_d01.dat
Device_d01 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 1.5 0.0
439 47.1 %
Non-APF 0.7 0.0
196 21.0 %
Writes 1.0 0.0
297 31.9 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 3.1 0.0
932 0.6 %



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

Device:
Device_d02.dat
Device_d02 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 4.6 0.1
1372 30.5 %
Non-APF 10.0 0.2
3008 67.0 %
Writes 0.4 0.0
112 2.5 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 15.0 0.2
4492 2.9 %



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

Device:
Device_d03.dat
Device_d03 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.5 0.0
150 38.5 %
Non-APF 0.7 0.0
221 56.7 %
Writes 0.1 0.0
19 4.9 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.3 0.0
390 0.2 %



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

Device:
Device_d04.dat
Device_d04 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 1.9 0.0
570 42.8 %
Non-APF 2.5 0.0
741 55.6 %
Writes 0.1 0.0
22 1.7 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 4.4 0.1
1333 0.8 %



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

Device:
Device_d05.dat
Device_d05 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 1.5 0.0
459 50.3 %
Non-APF 1.5 0.0
450 49.3 %
Writes 0.0 0.0
4 0.4 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 3.0 0.0
913 0.6 %



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

Device:
Device_d06.dat
Device_d06 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.1 0.0
33 39.8 %
Non-APF 0.2 0.0
50 60.2 %
Writes 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.3 0.0
83 0.1 %



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

Device:
Device_d07.dat
Device_d07 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.1 0.0
26 39.4 %
Non-APF 0.1 0.0
28 42.4 %
Writes 0.0 0.0
12 18.2 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.2 0.0
66 0.0 %



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

Device:
Device_d08.dat
Device_d08 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.2 0.0
47 63.5 %
Non-APF 0.1 0.0
20 27.0 %
Writes 0.0 0.0
7 9.5 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.2 0.0
74 0.0 %



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

Device:
Device_d09.dat
Device_d09 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.1 0.0
40 65.6 %
Non-APF 0.0 0.0
3 4.9 %
Writes 0.1 0.0
18 29.5 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.2 0.0
61 0.0 %



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

Device:
Device_d10.dat
Device_d10 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.2 0.0
56 48.3 %
Non-APF 0.2 0.0
53 45.7 %
Writes 0.0 0.0
7 6.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.4 0.0
116 0.1 %



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

Device:
Device_d11.dat
Device_d11 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.2 0.0
70 64.2 %
Non-APF 0.1 0.0
17 15.6 %
Writes 0.1 0.0
22 20.2 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.4 0.0
109 0.1 %



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

Device:
Device_d12.dat
Device_d12 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.2 0.0
49 80.3 %
Non-APF 0.0 0.0
5 8.2 %
Writes 0.0 0.0
7 11.5 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.2 0.0
61 0.0 %



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

Device:
Device_d13.dat
Device_d13 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.3 0.0
103 55.4 %
Non-APF 0.2 0.0
74 39.8 %
Writes 0.0 0.0
9 4.8 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.6 0.0
186 0.1 %



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

Device:
Device_d14.dat
Device_d14 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.1 0.0
21 53.8 %
Non-APF 0.0 0.0
3 7.7 %
Writes 0.1 0.0
15 38.5 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.1 0.0
39 0.0 %



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

Device:
Device_d15.dat
Device_d15 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.8 0.0
247 62.5 %
Non-APF 0.4 0.0
120 30.4 %
Writes 0.1 0.0
28 7.1 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.3 0.0
395 0.3 %



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

Device:
Device_d16.dat
Device_d16 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.5 0.0
144 68.9 %
Non-APF 0.1 0.0
33 15.8 %
Writes 0.1 0.0
32 15.3 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.7 0.0
209 0.1 %



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

Device:
Device_d17.dat
Device_d17 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 1.1 0.0
322 61.2 %
Non-APF 0.6 0.0
193 36.7 %
Writes 0.0 0.0
11 2.1 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.8 0.0
526 0.3 %



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

Device:
Device_d18.dat
Device_d18 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 3.9 0.1
1171 36.7 %
Non-APF 6.5 0.1
1952 61.2 %
Writes 0.2 0.0
68 2.1 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 10.6 0.2
3191 2.0 %



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

Device:
Device_d19.dat
Device_d19 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 7.9 0.1
2381 31.1 %
Non-APF 17.5 0.3
5235 68.4 %
Writes 0.1 0.0
33 0.4 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 25.5 0.4
7649 4.9 %



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

Device:
Device_d20.dat
Device_d20 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 10.0 0.2
2993 24.7 %
Non-APF 30.4 0.5
9128 75.2 %
Writes 0.0 0.0
11 0.1 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 40.4 0.6
12132 7.7 %



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

Device:
Device_d21.dat
Device_d21 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 10.8 0.2
3240 21.0 %
Non-APF 40.7 0.7
12199 78.9 %
Writes 0.0 0.0
14 0.1 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 51.5 0.8
15453 9.8 %



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

Device:
Device_d22.dat
Device_d22 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
0 0.0 %
Writes 0.1 0.0
17 100.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.1 0.0
17 0.0 %



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

Device:
Device_d23.dat
Device_d23 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
6 2.2 %
Writes 0.9 0.0
266 97.8 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.9 0.0
272 0.2 %



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

Device:
Device_d24.dat
Device_d24 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.2 0.0
60 38.7 %
Non-APF 0.3 0.0
87 56.1 %
Writes 0.0 0.0
8 5.2 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.5 0.0
155 0.1 %



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

Device:
Device_d25.dat
Device_d25 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
3 10.7 %
Non-APF 0.1 0.0
15 53.6 %
Writes 0.0 0.0
10 35.7 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.1 0.0
28 0.0 %



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

Device:
Device_d26.dat
Device_d26 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
14 100.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
14 0.0 %



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

Device:
Device_d27.dat
Device_d27 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
10 26.3 %
Non-APF 0.1 0.0
21 55.3 %
Writes 0.0 0.0
7 18.4 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.1 0.0
38 0.0 %



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

Device:
Device_d28.dat
Device_d28 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.7 0.0
201 54.6 %
Non-APF 0.5 0.0
140 38.0 %
Writes 0.1 0.0
27 7.3 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.2 0.0
368 0.2 %



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

Device:
Device_d29.dat
Device_d29 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.2 0.0
57 33.7 %
Non-APF 0.3 0.0
91 53.8 %
Writes 0.1 0.0
21 12.4 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.6 0.0
169 0.1 %



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

Device:
Device_d30.dat
Device_d30 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.4 0.0
128 12.7 %
Non-APF 2.8 0.0
846 84.0 %
Writes 0.1 0.0
33 3.3 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 3.4 0.1
1007 0.6 %



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

Device:
Device_d31.dat
Device_d31 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
11 7.5 %
Writes 0.5 0.0
135 92.5 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.5 0.0
146 0.1 %



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

Device:
Device_d32.dat
Device_d32 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.1 0.0
31 6.5 %
Non-APF 0.4 0.0
118 24.9 %
Writes 1.1 0.0
325 68.6 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.6 0.0
474 0.3 %



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

Device:
Device_d33.dat
Device_d33 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.2 0.0
58 31.9 %
Non-APF 0.1 0.0
37 20.3 %
Writes 0.3 0.0
87 47.8 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.6 0.0
182 0.1 %



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

Device:
Device_d34.dat
Device_d34 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.4 0.0
114 100.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.4 0.0
114 0.1 %



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

Device:
Device_d35.dat
Device_d35 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
0 0.0 %
Writes 0.0 0.0
1 100.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
1 0.0 %



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

Device:
Device_d36.dat
Device_d36 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.1 0.0
15 60.0 %
Writes 0.0 0.0
10 40.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.1 0.0
25 0.0 %



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

Device:
Device_d37.dat
Device_d37 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
2 6.9 %
Writes 0.1 0.0
27 93.1 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.1 0.0
29 0.0 %



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

Device:
Device_d38.dat
Device_d38 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
5 1.0 %
Writes 1.7 0.0
519 99.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.7 0.0
524 0.3 %



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

Device:
Device_d39.dat
Device_d39 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
2 2.9 %
Writes 0.2 0.0
66 97.1 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.2 0.0
68 0.0 %



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

Device:
Device_d40.dat
Device_d40 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
5 3.3 %
Writes 0.5 0.0
148 96.7 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.5 0.0
153 0.1 %



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

Device:
Device_d41.dat
Device_d41 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
1 8.3 %
Writes 0.0 0.0
11 91.7 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
12 0.0 %



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

Device:
Device_d42.dat
Device_d42 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
1 4.2 %
Non-APF 0.0 0.0
3 12.5 %
Writes 0.1 0.0
20 83.3 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.1 0.0
24 0.0 %



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

Device:
Device_d43.dat
Device_d43 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
2 100.0 %
Writes 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
2 0.0 %



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

Device:
Device_d44.dat
Device_d44 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
6 10.9 %
Writes 0.2 0.0
49 89.1 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.2 0.0
55 0.0 %



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

Device:
Device_d45.dat
Device_d45 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
2 25.0 %
Writes 0.0 0.0
6 75.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
8 0.0 %



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

Device:
Device_d46.dat
Device_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
12 100.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
12 0.0 %



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

Device:
Device_d47.dat
Device_d47 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
13 12.1 %
Non-APF 0.0 0.0
2 1.9 %
Writes 0.3 0.0
92 86.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.4 0.0
107 0.1 %



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

Device:
Device_d48.dat
Device_d48 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
2 0.6 %
Writes 1.0 0.0
311 99.4 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.0 0.0
313 0.2 %



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

Device:
Device_d49.dat
Device_d49 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
5 38.5 %
Writes 0.0 0.0
8 61.5 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
13 0.0 %



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

Device:
Device_d50.dat
Device_d50 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
1 100.0 %
Writes 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
1 0.0 %



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

Device:
Device_d51.dat
Device_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:
Device_d52.dat
Device_d52 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
11 9.2 %
Writes 0.4 0.0
108 90.8 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.4 0.0
119 0.1 %



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

Device:
Device_d53.dat
Device_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:
Device_d54.dat
Device_d54 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
3 100.0 %
Writes 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
3 0.0 %



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

Device:
Device_d55.dat
Device_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:
Device_d56.dat
Device_d56 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
0 0.0 %
Writes 0.1 0.0
34 100.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.1 0.0
34 0.0 %



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

Device:
Device_d57.dat
Device_d57 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:
Device_d58.dat
Device_d58 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:
Device_d59.dat
Device_d59 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:
Device_d60.dat
Device_d60 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:
Device_d61.dat
Device_d61 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:
Device_d62.dat
Device_d62 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:
Device_d63.dat
Device_d63 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
0 0.0 %
Writes 0.0 0.0
1 100.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
1 0.0 %



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

Device:
Device_d64.dat
Device_d64 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:
Device_d65.dat
Device_d65 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:
Device_d66.dat
Device_d66 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
2 100.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
2 0.0 %



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

Device:
Device_d67.dat
Device_d67 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:
Device_d68.dat
Device_d68 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
0 0.0 %
Writes 0.0 0.0
1 100.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
1 0.0 %



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

Device:
Device_d69.dat
Device_d69 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:
Device_d70.dat
Device_d70 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:
Device_d71.dat
Device_d71 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:
sybsecurity_d01.dat
sybsecurity_d01 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
5 100.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
5 0.0 %



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

Device:
sybsecurity_d02.dat
sybsecurity_d02 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
0 0.0 %
Writes 0.1 0.0
15 100.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.1 0.0
15 0.0 %



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

Device:
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:
mx_auxiliary_l01.dat
mx_auxiliary_l01 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
0 0.0 %
Writes 0.1 0.0
33 100.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.1 0.0
33 0.0 %



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

Device:
Device_l01.dat
Device_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/Device_l02.dat
Device_l02 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:
Device_l03.dat
Device_l03 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 54.0 0.9
16205 100.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 54.0 0.9
16205 10.3 %



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

Device:
sybsecurity_l01.dat
sybsecurity_l01 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
0 0.0 %
Writes 0.1 0.0
35 100.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.1 0.0
35 0.0 %



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

Device:
/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:
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:
master.dat
master per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.5 0.0
147 41.5 %
Writes 0.7 0.0
207 58.5 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.2 0.0
354 0.2 %



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

Device:
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:
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:
tempdb_d01.dat
tempdb_d01 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
6 0.0 %
Non-APF 30.8 0.5
9231 18.6 %
Writes 134.4 2.2
40314 81.4 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 165.2 2.6
49551 31.6 %



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

Device:
tempdb_d02.dat
tempdb_d02 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 12.9 0.2
3880 30.2 %
Writes 29.9 0.5
8971 69.8 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 42.8 0.7
12851 8.2 %



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

Device:
tempdb_d03.dat
tempdb_d03 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 6.4 0.1
1931 87.6 %
Writes 0.9 0.0
273 12.4 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 7.3 0.1
2204 1.4 %



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

Device:
tempdb_d04.dat
tempdb_d04 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 13.3 0.2
3989 87.9 %
Writes 1.8 0.0
547 12.1 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 15.1 0.2
4536 2.9 %



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

Device:
tempdb_d05.dat
tempdb_d05 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 13.4 0.2
4030 22.1 %
Writes 47.4 0.8
14221 77.9 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 60.8 1.0
18251 11.6 %



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

Device:
tempdb_d06.dat
tempdb_d06 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
0 n/a
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
0 0.0 %



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



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

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

Total Network I/O Requests 766.5 12.3
229954 n/a
Network I/Os Delayed 0.0 0.0
0 0.0 %


Total TDS Packets Received per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Engine 0 43.7 0.7
13117 9.8 %
Engine 1 46.9 0.8
14066 10.5 %
Engine 2 53.7 0.9
16116 12.1 %
Engine 3 54.7 0.9
16413 12.3 %
Engine 4 87.3 1.4
26193 19.6 %
Engine 5 158.7 2.5
47623 35.7 %
------------------------- ------------ ------------
----------
Total TDS Packets Rec'd 445.1 7.1
133528


Total Bytes Received per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Engine 0 11393.8 182.5
3418147 6.6 %
Engine 1 13712.0 219.6
4113605 7.9 %
Engine 2 20718.7 331.8
6215622 12.0 %
Engine 3 28344.2 453.9
8503246 16.4 %
Engine 4 50465.8 808.2
15139738 29.2 %
Engine 5 48100.3 770.3
14430100 27.8 %
------------------------- ------------ ------------
----------
Total Bytes Rec'd 172734.9 2766.4
51820458


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


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

Total TDS Packets Sent per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Engine 0 1475.4 23.6
442621 26.6 %
Engine 1 2132.5 34.2
639739 38.5 %
Engine 2 761.2 12.2
228361 13.7 %
Engine 3 118.4 1.9
35532 2.1 %
Engine 4 834.6 13.4
250372 15.1 %
Engine 5 215.7 3.5
64698 3.9 %
------------------------- ------------ ------------
----------
Total TDS Packets Sent 5537.7 88.7
1661323


Total Bytes Sent per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Arithmetic overflow occurred.
(return status = 0)


J Posted on 2011-11-11 17:01:02.0Z
From: jtotally_bogus@sbcglobal.net (J)
Newsgroups: sybase.public.ase.general
Subject: Re: sysmon analysis
Reply-To: J@bogusemailAddress.com
Message-ID: <4ebd54a5.93343453@forums.sybase.com>
References: <4ebbac59.5a49.1681692777@sybase.com>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 11 Nov 2011 09:01:02 -0800
X-Trace: forums-1-dub 1321030862 10.22.241.152 (11 Nov 2011 09:01:02 -0800)
X-Original-Trace: 11 Nov 2011 09:01:02 -0800, vip152.sybase.com
Lines: 3337
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30679
Article PK: 73570

On 10 Nov 2011 02:50:02 -0800, Raj wrote:

I would look at the number of disk i/o structures. ROT is 300-400
times number of engines.

J

>Hi,
>
>=a0 One of our production servers running very slow, Trying
>find out what is the reason. Have run sysmon report. Can any
>of you please have a look and suggest me on tuning ?? Sybase
>version is 12.5.4 on IBM AIX. Also, Network checks Blocking
>26%. What does it means ? is it alrigt ?
>
>Thanks in advance.
>
>
>
>=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d
> Sybase Adaptive Server Enterprise System Performance
>Report
>=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d
>
>Server Version: Adaptive Server Enterprise/12.5.4/EBF
>14067 ESD#3/P/RS60
>Server Name: xxxxx
>Run Date: Nov 07, 2011
>Sampling Started at: Nov 07, 2011 16:56:33
>Sampling Ended at: Nov 07, 2011 17:01:33
>Sample Interval: 00:05:00
>Sample Mode: Reset Counters
>
>=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d
>
>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 45.3 % 8.4 %
>46.3 %
> Engine 1 48.2 % 4.3 %
>47.5 %
> Engine 2 46.6 % 8.6 %
>44.8 %
> Engine 3 60.2 % 5.6 %
>34.1 %
> Engine 4 59.1 % 8.4 %
>32.6 %
> Engine 5 63.7 % 4.1 %
>32.3 %
> ------------------------ -------- --------
>--------
> Summary Total 323.1 % 39.4 %
>237.6 %
> Average 53.8 % 6.6 %
>39.6 %
>
> CPU Yields by Engine per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Engine 0 284.2 4.6
> 85254 24.2 %
> Engine 1 189.6 3.0
> 56869 16.1 %
> Engine 2 188.7 3.0
> 56615 16.1 %
> Engine 3 153.2 2.5
> 45960 13.0 %
> Engine 4 175.8 2.8
> 52746 15.0 %
> Engine 5 184.0 2.9
> 55186 15.6 %
> ------------------------- ------------ ------------
>----------
> Total CPU Yields 1175.4 18.8
>352630
>
> Network Checks
> Non-Blocking 2395.5 38.4
>718663 73.4 %
> Blocking 870.2 13.9
>261047 26.6 %
> ------------------------- ------------ ------------
>----------
> Total Network I/O Checks 3265.7 52.3
>979710
> Avg Net I/Os per Check n/a n/a
>1.83202 n/a
>
> Disk I/O Checks
> Total Disk I/O Checks 4580.7 73.4
>1374212 n/a
> Checks Returning I/O 1214.9 19.5
>364478 26.5 %
> Avg Disk I/Os Returned n/a n/a
>0.43059 n/a
>
>
>=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d
>
>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.
>
>
>=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d
>
>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
>
>=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d
>
>Task Management per sec per xact
> count % of total
>--------------------------- ------------ ------------
>---------- ----------
>
> Connections Opened 0.4 0.0
> 107 n/a
>
> Task Context Switches by Engine
> Engine 0 374.1 6.0
>112217 18.8 %
> Engine 1 385.3 6.2
>115603 19.3 %
> Engine 2 267.7 4.3
> 80319 13.4 %
> Engine 3 213.0 3.4
> 63897 10.7 %
> Engine 4 347.0 5.6
>104107 17.4 %
> Engine 5 405.9 6.5
>121778 20.4 %
> ------------------------- ------------ ------------
>----------
> Total Task Switches: 1993.1 31.9
>597921
>
> Task Context Switches Due To:
> Voluntary Yields 69.8 1.1
> 20945 3.5 %
> Cache Search Misses 194.6 3.1
> 58373 9.8 %
> System Disk Writes 0.2 0.0
> 72 0.0 %
> I/O Pacing 22.5 0.4
> 6751 1.1 %
> Logical Lock Contention 0.4 0.0
> 115 0.0 %
> Address Lock Contention 0.0 0.0
> 0 0.0 %
> Latch Contention 0.0 0.0
> 3 0.0 %
> Log Semaphore Contention 0.3 0.0
> 85 0.0 %
> PLC Lock Contention 0.0 0.0
> 1 0.0 %
> Group Commit Sleeps 2.0 0.0
> 606 0.1 %
> Last Log Page Writes 49.3 0.8
> 14777 2.5 %
> Modify Conflicts 0.6 0.0
> 173 0.0 %
> I/O Device Contention 0.0 0.0
> 0 0.0 %
> Network Packet Received 445.2 7.1
>133561 22.3 %
> Network Packet Sent 321.3 5.1
> 96393 16.1 %
> Other Causes 886.9 14.2
>266066 44.5 %
>
>
>=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d
>
>Application Management
>----------------------
>
> Application Statistics Summary (All Applications)
> -------------------------------------------------
> Priority Changes per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> To High Priority 0.7 0.0
> 210 13.9 %
> To Medium Priority 2.7 0.0
> 810 53.6 %
> To Low Priority 1.6 0.0
> 492 32.5 %
> ------------------------- ------------ ------------
>----------
> Total Priority Changes 5.0 0.1
> 1512
>
> Allotted Slices Exhausted per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> High Priority 0.0 0.0
> 0 0.0 %
> Medium Priority 11.1 0.2
> 3325 100.0 %
> Low Priority 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>----------
> Total Slices Exhausted 11.1 0.2
> 3325
>
> 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
>
>=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d
>
>ESP Management per sec per xact
> count % of total
>--------------------------- ------------ ------------
>---------- ----------
> ESP Requests 0.0 0.0
> 0 n/a
>=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d
>
>Housekeeper Task Activity
>-------------------------
> per sec per xact
> count % of total
> ------------ ------------
>----------
>Buffer Cache Washes
> Clean 199.7 3.2
>59906 99.6 %
> Dirty 0.8 0.0
> 254 0.4 %
> ------------ ------------
>----------
>Total Washes 200.5 3.2
>60160
>
>Garbage Collections 1.4 0.0
> 414 n/a
>Pages Processed in GC 0.0 0.0
> 0 n/a
>
>Statistics Updates 2.0 0.0
> 588 n/a
>
>=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d
>
>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 10.3 0.2
> 3079 n/a
> Maximum SQL Text Requested n/a n/a
>113577 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 57812 (i.e., half way from its current value
> to Maximum SQL Text Requested).
>
>=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d
>
>Transaction Profile
>-------------------
>
> Transaction Summary per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Committed Xacts 62.4 n/a
> 18732 n/a
>
> Transaction Detail per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Inserts
> APL Heap Table 13474.7 215.8
>4042403 19.0 %
> APL Clustered Table 57148.9 915.3
>17144672 80.6 %
> Data Only Lock Table 296.7 4.8
> 89007 0.4 %
> ------------------------- ------------ ------------
>---------- ----------
> Total Rows Inserted 70920.3 1135.8
>21276082 100.0 %
>
> Updates
> APL Deferred 0.1 0.0
> 41 0.6 %
> APL Direct In-place 0.0 0.0
> 8 0.1 %
> APL Direct Cheap 0.4 0.0
> 130 2.0 %
> APL Direct Expensive 0.0 0.0
> 0 0.0 %
> DOL Deferred 0.0 0.0
> 10 0.2 %
> DOL Direct 20.8 0.3
> 6227 97.1 %
> ------------------------- ------------ ------------
>---------- ----------
> Total Rows Updated 21.4 0.3
> 6416 0.0 %
>
> Data Only Locked Updates
> DOL Replace 20.8 0.3
> 6231 99.9 %
> DOL Shrink 0.0 0.0
> 0 0.0 %
> DOL Cheap Expand 0.0 0.0
> 0 0.0 %
> DOL Expensive Expand 0.0 0.0
> 6 0.1 %
> 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 20.8 0.3
> 6237 0.0 %
>
> Deletes
> APL Deferred 8.8 0.1
> 2638 65.6 %
> APL Direct 0.8 0.0
> 229 5.7 %
> DOL 3.8 0.1
> 1154 28.7 %
> ------------------------- ------------ ------------
>---------- ----------
> Total Rows Deleted 13.4 0.2
> 4021 0.0 %
>
>=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d
> =3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d
>=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d
>=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d
> Total Rows Affected 70955.1 1136.4
>21286519
>
>=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d
>
>Transaction Management
>----------------------
>
> ULC Flushes to Xact Log per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> by Full ULC 6.9 0.1
> 2057 7.0 %
> by End Transaction 55.0 0.9
> 16487 56.4 %
> by Change of Database 0.5 0.0
> 135 0.5 %
> by Single Log Record 24.8 0.4
> 7430 25.4 %
> by Unpin 0.6 0.0
> 177 0.6 %
> by Other 9.8 0.2
> 2925 10.0 %
> ------------------------- ------------ ------------
>----------
> Total ULC Flushes 97.4 1.6
> 29211
>
> ULC Log Records 918.9 14.7
>275655 n/a
> Max ULC Size During Sample n/a n/a
> 4096 n/a
>
> ULC Semaphore Requests
> Granted 1885.9 30.2
>565767 100.0 %
> Waited 0.0 0.0
> 1 0.0 %
> ------------------------- ------------ ------------
>----------
> Total ULC Semaphore Req 1885.9 30.2
>565768
>
> Log Semaphore Requests
> Granted 100.2 1.6
> 30060 99.7 %
> Waited 0.3 0.0
> 85 0.3 %
> ------------------------- ------------ ------------
>----------
> Total Log Semaphore Req 100.5 1.6
> 30145
>
> Transaction Log Writes 68.4 1.1
> 20506 n/a
> Transaction Log Alloc 19.7 0.3
> 5919 n/a
> Avg # Writes per Log Page n/a n/a
>3.46444 n/a
>
> Tuning Recommendations for Transaction Management
> -------------------------------------------------
> - Consider decreasing the 'user log cache size'
> configuration parameter if it is greater than the
> logical database page size.
>
>=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d
>
>Index Management
>----------------
>
> Nonclustered Maintenance per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Ins/Upd Requiring Maint 1.3 0.0
> 403 n/a
> # of NC Ndx Maint 1.4 0.0
> 429 n/a
> Avg NC Ndx Maint / Op n/a n/a
>1.06452 n/a
>
> Deletes Requiring Maint 1.4 0.0
> 408 n/a
> # of NC Ndx Maint 1.4 0.0
> 434 n/a
> Avg NC Ndx Maint / Op n/a n/a
>1.06373 n/a
>
> RID Upd from Clust Split 0.0 0.0
> 0 n/a
> # of NC Ndx Maint 0.0 0.0
> 0 n/a
>
> Upd/Del DOL Req Maint 24.6 0.4
> 7388 n/a
> # of DOL Ndx Maint 14.2 0.2
> 4255 n/a
> Avg DOL Ndx Maint / Op n/a n/a
>0.57593 n/a
>
> Page Splits 2.9 0.0
> 876 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
> 1 n/a
> Deadlocks %
> Deadlock Retries Exceeded 0.0 0.0
> 0 0.0 %
>
> Index Scans per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Ascending Scans 22867.2 366.2
>6860153 24.9 %
> DOL Ascending Scans 68997.5 1105.0
>20699261 75.1 %
> Descending Scans 2.2 0.0
> 647 0.0 %
> DOL Descending Scans 0.1 0.0
> 15 0.0 %
> ------------ ------------
>----------
> Total Scans 91866.9 1471.3
>27560076
>
>=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d
>
>Metadata Cache Management
>-------------------------
>
> Metadata Cache Summary per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
>
> Open Object Usage
> Active n/a n/a
> 6755 n/a
> Max Ever Used Since Boot n/a n/a
> 7088 n/a
> Free n/a n/a
> 33245 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
> 10755 n/a
> Max Ever Used Since Boot n/a n/a
> 11506 n/a
> Free n/a n/a
> 59245 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
> 11 n/a
> Max Ever Used Since Boot n/a n/a
> 11 n/a
> Free n/a n/a
> 9 n/a
> Reuse Requests
> Succeeded n/a n/a
> 0 n/a
> Failed n/a n/a
> 0 n/a
>
> Object Manager Spinlock Contention n/a n/a
> n/a 0.2 %
>
> Object Spinlock Contention n/a n/a
> n/a 0.0 %
>
> Index Spinlock Contention n/a n/a
> n/a 0.0 %
>
> Hash Spinlock Contention n/a n/a
> n/a 0.0 %
>
>=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d
>
>Lock Management
>---------------
>
> Lock Summary per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Total Lock Requests 179785.7 2879.3
>53935709 n/a
> Avg Lock Contention 0.4 0.0
> 115 0.0 %
> Deadlock Percentage 0.0 0.0
> 0 0.0 %
>
> Lock Detail per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
>
> Table Lock Hashtable
> Lookups 2098.2 33.6
>629451 n/a
> Avg Chain Length n/a n/a
>0.21041 n/a
> Spinlock Contention n/a n/a
> n/a 0.0 %
>
> Exclusive Table
> Granted 13.3 0.2
> 3999 99.4 %
> Waited 0.1 0.0
> 26 0.6 %
> ------------------------- ------------ ------------
>---------- ----------
> Total EX-Table Requests 13.4 0.2
> 4025 0.0 %
>
> Shared Table
> Granted 1.6 0.0
> 487 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total SH-Table Requests 1.6 0.0
> 487 0.0 %
>
> Exclusive Intent
> Granted 60.0 1.0
> 18002 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total EX-Intent Requests 60.0 1.0
> 18002 0.0 %
>
> Shared Intent
> Granted 2004.9 32.1
>601474 100.0 %
> Waited 0.2 0.0
> 55 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total SH-Intent Requests 2005.1 32.1
>601529 1.1 %
>
> Page & Row Lock HashTable
> Lookups 42644.7 683.0
>12793395 n/a
> Avg Chain Length n/a n/a
>0.01196 n/a
> Spinlock Contention n/a n/a
> n/a 0.0 %
>
> Exclusive Page
> Granted 43.1 0.7
> 12941 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total EX-Page Requests 43.1 0.7
> 12941 0.0 %
>
> Update Page
> Granted 5.3 0.1
> 1598 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total UP-Page Requests 5.3 0.1
> 1598 0.0 %
>
> Shared Page
> Granted 16968.4 271.8
>5090509 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total SH-Page Requests 16968.4 271.8
>5090509 9.4 %
>
>
> Exclusive Row
> Granted 104.2 1.7
> 31273 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total EX-Row Requests 104.2 1.7
> 31273 0.1 %
>
> Update Row
> Granted 21049.7 337.1
>6314896 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total UP-Row Requests 21049.7 337.1
>6314896 11.7 %
>
> Shared Row
> Granted 4449.6 71.3
>1334875 100.0 %
> Waited 0.1 0.0
> 34 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total SH-Row Requests 4449.7 71.3
>1334909 2.5 %
>
>
> Next-Key
> Total Next-Key Requests 0.0 0.0
> 0 n/a
>
> Address Lock Hashtable
> Lookups 135085.1 2163.4
>40525542 n/a
> Avg Chain Length n/a n/a
>0.00029 n/a
> Spinlock Contention n/a n/a
> n/a 0.3 %
>
> Exclusive Address
> Granted 499.6 8.0
>149887 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total EX-Address Requests 499.6 8.0
>149887 0.3 %
>
> Shared Address
> Granted 134585.5 2155.4
>40375653 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total SH-Address Requests 134585.5 2155.4
>40375653 74.9 %
>
>
> Last Page Locks on Heaps
> Granted 13474.7 215.8
>4042403 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total Last Pg Locks 13474.7 215.8
>4042403 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
> 7 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
> 72 93.5 %
> Sh-Row to Sh-Table 0.0 0.0
> 5 6.5 %
> Sh-Next-Key to Sh-Table 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>----------
> Total Lock Promotions 0.3 0.0
> 77
>
>
> 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.
>
>
>=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d
>
>Data Cache Management
>---------------------
>
> Cache Statistics Summary (All Caches)
> -------------------------------------
> per sec per xact
> count % of total
> ------------ ------------
>---------- ----------
>
> Cache Search Summary
> Total Cache Hits 553731.3 8868.2
>166119391 99.9 %
> Total Cache Misses 361.2 5.8
>108357 0.1 %
> ------------------------- ------------ ------------
>----------
> Total Cache Searches 554092.5 8874.0
>166227748
>
> Cache Turnover
> Buffers Grabbed 5262.4 84.3
>1578721 n/a
> Buffers Grabbed Dirty 0.1 0.0
> 22 0.0 %
>
> Cache Strategy Summary
> Cached (LRU) Buffers 553152.4 8858.9
>165945729 100.0 %
> Discarded (MRU) Buffers 0.3 0.0
> 82 0.0 %
>
> Large I/O Usage
> Large I/Os Performed 206.8 3.3
> 62053 99.9 %
>
> Large I/Os Denied due to
> Pool < Prefetch Size 0.0 0.0
> 4 0.0 %
> Pages Requested
> Reside in Another
> Buffer Pool 0.1 0.0
> 33 0.1 %
> ------------------------- ------------ ------------
>----------
> Total Large I/O Requests 207.0 3.3
> 62090
>
> Large I/O Effectiveness
> Pages by Lrg I/O Cached 827.4 13.3
>248212 n/a
> Pages by Lrg I/O Used 6250.3 100.1
>1875100 755.4 %
>
> Asynchronous Prefetch Activity
> APFs Issued 48.3 0.8
> 14477 0.1 %
> APFs Denied Due To
> APF I/O Overloads 0.2 0.0
> 48 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 79093.8 1266.7
>23728154 99.9 %
> ------------------------- ------------ ------------
>----------
> Total APFs Requested 79142.3 1267.5
>23742679
>
> Other Asynchronous Prefetch Statistics
> APFs Used 48.3 0.8
> 14487 n/a
> APF Waits for I/O 30.1 0.5
> 9026 n/a
> APF Discards 0.0 0.0
> 0 n/a
>
> Dirty Read Behavior
> Page Requests 989.4 15.8
>296808 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 3.4 %
>
> Utilization n/a n/a
> n/a 61.3 %
>
> Cache Searches
> Cache Hits 339663.6 5439.8
>101899093 100.0 %
> Found in Wash 20.3 0.3
> 6082 0.0 %
> Cache Misses 117.4 1.9
> 35212 0.0 %
> ------------------------- ------------ ------------
>----------
> Total Cache Searches 339781.0 5441.7
>101934305
>
> Pool Turnover
> 4 Kb Pool
> LRU Buffer Grab 388.8 6.2
>116644 70.2 %
> Grabbed Dirty 0.0 0.0
> 0 0.0 %
> 16 Kb Pool
> LRU Buffer Grab 165.1 2.6
> 49520 29.8 %
> Grabbed Dirty 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>----------
> Total Cache Turnover 553.9 8.9
>166164
>
> Buffer Wash Behavior
> Buffers Passed Clean 81.9 1.3
> 24569 100.0 %
> Buffers Already in I/O 0.0 0.0
> 0 0.0 %
> Buffers Washed Dirty 0.0 0.0
> 0 0.0 %
>
> Cache Strategy
> Cached (LRU) Buffers 338730.1 5424.9
>101619038 100.0 %
> Discarded (MRU) Buffers 0.3 0.0
> 82 0.0 %
>
> Large I/O Usage
> Large I/Os Performed 165.1 2.6
> 49520 100.0 %
>
> Large I/Os Denied due to
> Pool < Prefetch Size 0.0 0.0
> 0 0.0 %
> Pages Requested
> Reside in Another
> Buffer Pool 0.0 0.0
> 4 0.0 %
> ------------------------- ------------ ------------
>----------
> Total Large I/O Requests 165.1 2.6
> 49524
>
> Large I/O Detail
> 16 Kb Pool
> Pages Cached 660.3 10.6
>198080 n/a
> Pages Used 657.9 10.5
>197375 99.6 %
>
> Dirty Read Behavior
> Page Requests 979.8 15.7 293942
> 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 4.2 %
>
> Utilization n/a n/a
> n/a 38.7 %
>
> Cache Searches
> Cache Hits 214067.7 3428.4
>64220298 99.9 %
> Found in Wash 0.0 0.0
> 0 0.0 %
> Cache Misses 243.8 3.9
> 73145 0.1 %
> ------------------------- ------------ ------------
>----------
> Total Cache Searches 214311.5 3432.3
>64293443
>
> Pool Turnover
> 4 Kb Pool
> LRU Buffer Grab 4666.7 74.7
>1400002 99.1 %
> Grabbed Dirty 0.1 0.0
> 22 0.0 %
> 16 Kb Pool
> LRU Buffer Grab 41.8 0.7
> 12533 0.9 %
> Grabbed Dirty 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>----------
> Total Cache Turnover 4708.5 75.4
>1412557
>
> Buffer Wash Behavior
> Statistics Not Available - No Buffers Entered Wash
>Section Yet
>
> Cache Strategy
> Cached (LRU) Buffers 214422.3 3434.1
>64326691 100.0 %
> Discarded (MRU) Buffers 0.0 0.0
> 0 0.0 %
>
> Large I/O Usage
> Large I/Os Performed 41.8 0.7
> 12533 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.1 0.0
> 33 0.3 %
> ------------------------- ------------ ------------
>----------
> Total Large I/O Requests 41.9 0.7
> 12566
>
> Large I/O Detail
> 16 Kb Pool
> Pages Cached 167.1 2.7
> 50132 n/a
> Pages Used 42.5 0.7
> 12763 25.5 %
>
> Dirty Read Behavior
> Page Requests 9.6 0.2 2866
> n/a
>
> Tuning Recommendations for Data cache : tempdb_cache
> -------------------------------------
> - Consider increasing the 'wash size' of the 4k pool for
>this cache.
>
>=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d
>
>Procedure Cache Management per sec per xact
> count % of total
>--------------------------- ------------ ------------
>---------- ----------
> Procedure Requests 31.7 0.5
> 9513 n/a
> Procedure Reads from Disk 0.3 0.0
> 85 0.9 %
> Procedure Writes to Disk 0.0 0.0
> 0 0.0 %
> Procedure Removals 0.6 0.0
> 170 n/a
> Procedure Recompilations 0.3 0.0
> 85 n/a
>
> Recompilations Requests:
> Execution Phase 0.3 0.0
> 85 100.0 %
> Compilation Phase 0.0 0.0
> 0 0.0 %
> Execute Cursor Execution 0.0 0.0
> 0 0.0 %
> Redefinition Phase 0.0 0.0
> 0 0.0 %
>
> Recompilation Reasons:
> Table Missing 0.0 0.0
> 0 n/a
> Temporary Table Missing 0.0 0.0
> 0 n/a
> Schema Change 0.3 0.0
> 85 n/a
> Index Change 0.0 0.0
> 0 n/a
> Isolation Level Change 0.0 0.0
> 0 n/a
> Permissions Change 0.0 0.0
> 0 n/a
> Cursor Permissions Change 0.0 0.0
> 0 n/a
>
> SQL Statement Cache:
> Statements Cached 0.0 0.0
> 0 n/a
> Statements Found in Cache 0.0 0.0
> 0 n/a
> Statements Not Found 0.0 0.0
> 0 n/a
> Statements Dropped 0.0 0.0
> 0 n/a
> Statements Restored 0.0 0.0
> 0 n/a
> Statements Not Cached 339.2 5.4
>101748 n/a
>
>
>=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d
>
>Memory Management per sec per xact
> count % of total
>--------------------------- ------------ ------------
>---------- ----------
> Pages Allocated 1.0 0.0
> 305 n/a
> Pages Released 1.0 0.0
> 301 n/a
>
>=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d
>
>Recovery Management
>-------------------
>
> Checkpoints per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> # of Normal Checkpoints 0.0 0.0
> 8 100.0 %
> # of Free Checkpoints 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>----------
> Total Checkpoints 0.0 0.0
> 8
>
> Avg Time per Normal Chkpt 0.00000 seconds
>
>=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d
>
>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
> 255 n/a
> Engine 1 n/a n/a
> 127 n/a
> Engine 2 n/a n/a
> 76 n/a
> Engine 3 n/a n/a
> 50 n/a
> Engine 4 n/a n/a
> 253 n/a
> Engine 5 n/a n/a
> 256 n/a
>
>
> I/Os Delayed by
> Disk I/O Structures n/a n/a
> 5 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 523.5 8.4
>157049
>
> Completed Disk I/O's
> Engine 0 112.8 1.8
> 33825 21.6 %
> Engine 1 50.7 0.8
> 15195 9.7 %
> Engine 2 72.5 1.2
> 21761 13.9 %
> Engine 3 67.5 1.1
> 20250 12.9 %
> Engine 4 104.4 1.7
> 31315 20.0 %
> Engine 5 115.3 1.8
> 34595 22.0 %
> ------------------------- ------------ ------------
>----------
> Total Completed I/Os 523.1 8.4
>156941
>
>
> 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/mx_auxiliary_d01.dat
> mx_auxiliary_d01 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 1 100.0 %
> Writes 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.0 0.0
> 1 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> /opt/sw/sybase/devices/data/mx_auxiliary_d02.dat
> mx_auxiliary_d02 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/mx_auxiliary_d03.dat
> mx_auxiliary_d03 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/mx_auxiliary_d04.dat
> mx_auxiliary_d04 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:
> Device_d01.dat
> Device_d01 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 1.5 0.0
> 439 47.1 %
> Non-APF 0.7 0.0
> 196 21.0 %
> Writes 1.0 0.0
> 297 31.9 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 3.1 0.0
> 932 0.6 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d02.dat
> Device_d02 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 4.6 0.1
> 1372 30.5 %
> Non-APF 10.0 0.2
> 3008 67.0 %
> Writes 0.4 0.0
> 112 2.5 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 15.0 0.2
> 4492 2.9 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d03.dat
> Device_d03 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.5 0.0
> 150 38.5 %
> Non-APF 0.7 0.0
> 221 56.7 %
> Writes 0.1 0.0
> 19 4.9 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.3 0.0
> 390 0.2 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d04.dat
> Device_d04 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 1.9 0.0
> 570 42.8 %
> Non-APF 2.5 0.0
> 741 55.6 %
> Writes 0.1 0.0
> 22 1.7 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 4.4 0.1
> 1333 0.8 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d05.dat
> Device_d05 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 1.5 0.0
> 459 50.3 %
> Non-APF 1.5 0.0
> 450 49.3 %
> Writes 0.0 0.0
> 4 0.4 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 3.0 0.0
> 913 0.6 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d06.dat
> Device_d06 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.1 0.0
> 33 39.8 %
> Non-APF 0.2 0.0
> 50 60.2 %
> Writes 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.3 0.0
> 83 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d07.dat
> Device_d07 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.1 0.0
> 26 39.4 %
> Non-APF 0.1 0.0
> 28 42.4 %
> Writes 0.0 0.0
> 12 18.2 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.2 0.0
> 66 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d08.dat
> Device_d08 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.2 0.0
> 47 63.5 %
> Non-APF 0.1 0.0
> 20 27.0 %
> Writes 0.0 0.0
> 7 9.5 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.2 0.0
> 74 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d09.dat
> Device_d09 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.1 0.0
> 40 65.6 %
> Non-APF 0.0 0.0
> 3 4.9 %
> Writes 0.1 0.0
> 18 29.5 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.2 0.0
> 61 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d10.dat
> Device_d10 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.2 0.0
> 56 48.3 %
> Non-APF 0.2 0.0
> 53 45.7 %
> Writes 0.0 0.0
> 7 6.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.4 0.0
> 116 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d11.dat
> Device_d11 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.2 0.0
> 70 64.2 %
> Non-APF 0.1 0.0
> 17 15.6 %
> Writes 0.1 0.0
> 22 20.2 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.4 0.0
> 109 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d12.dat
> Device_d12 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.2 0.0
> 49 80.3 %
> Non-APF 0.0 0.0
> 5 8.2 %
> Writes 0.0 0.0
> 7 11.5 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.2 0.0
> 61 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d13.dat
> Device_d13 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.3 0.0
> 103 55.4 %
> Non-APF 0.2 0.0
> 74 39.8 %
> Writes 0.0 0.0
> 9 4.8 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.6 0.0
> 186 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d14.dat
> Device_d14 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.1 0.0
> 21 53.8 %
> Non-APF 0.0 0.0
> 3 7.7 %
> Writes 0.1 0.0
> 15 38.5 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.1 0.0
> 39 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d15.dat
> Device_d15 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.8 0.0
> 247 62.5 %
> Non-APF 0.4 0.0
> 120 30.4 %
> Writes 0.1 0.0
> 28 7.1 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.3 0.0
> 395 0.3 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d16.dat
> Device_d16 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.5 0.0
> 144 68.9 %
> Non-APF 0.1 0.0
> 33 15.8 %
> Writes 0.1 0.0
> 32 15.3 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.7 0.0
> 209 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d17.dat
> Device_d17 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 1.1 0.0
> 322 61.2 %
> Non-APF 0.6 0.0
> 193 36.7 %
> Writes 0.0 0.0
> 11 2.1 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.8 0.0
> 526 0.3 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d18.dat
> Device_d18 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 3.9 0.1
> 1171 36.7 %
> Non-APF 6.5 0.1
> 1952 61.2 %
> Writes 0.2 0.0
> 68 2.1 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 10.6 0.2
> 3191 2.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d19.dat
> Device_d19 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 7.9 0.1
> 2381 31.1 %
> Non-APF 17.5 0.3
> 5235 68.4 %
> Writes 0.1 0.0
> 33 0.4 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 25.5 0.4
> 7649 4.9 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d20.dat
> Device_d20 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 10.0 0.2
> 2993 24.7 %
> Non-APF 30.4 0.5
> 9128 75.2 %
> Writes 0.0 0.0
> 11 0.1 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 40.4 0.6
> 12132 7.7 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d21.dat
> Device_d21 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 10.8 0.2
> 3240 21.0 %
> Non-APF 40.7 0.7
> 12199 78.9 %
> Writes 0.0 0.0
> 14 0.1 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 51.5 0.8
> 15453 9.8 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d22.dat
> Device_d22 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 0 0.0 %
> Writes 0.1 0.0
> 17 100.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.1 0.0
> 17 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d23.dat
> Device_d23 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 6 2.2 %
> Writes 0.9 0.0
> 266 97.8 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.9 0.0
> 272 0.2 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d24.dat
> Device_d24 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.2 0.0
> 60 38.7 %
> Non-APF 0.3 0.0
> 87 56.1 %
> Writes 0.0 0.0
> 8 5.2 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.5 0.0
> 155 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d25.dat
> Device_d25 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 3 10.7 %
> Non-APF 0.1 0.0
> 15 53.6 %
> Writes 0.0 0.0
> 10 35.7 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.1 0.0
> 28 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d26.dat
> Device_d26 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
> 14 100.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.0 0.0
> 14 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d27.dat
> Device_d27 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 10 26.3 %
> Non-APF 0.1 0.0
> 21 55.3 %
> Writes 0.0 0.0
> 7 18.4 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.1 0.0
> 38 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d28.dat
> Device_d28 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.7 0.0
> 201 54.6 %
> Non-APF 0.5 0.0
> 140 38.0 %
> Writes 0.1 0.0
> 27 7.3 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.2 0.0
> 368 0.2 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d29.dat
> Device_d29 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.2 0.0
> 57 33.7 %
> Non-APF 0.3 0.0
> 91 53.8 %
> Writes 0.1 0.0
> 21 12.4 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.6 0.0
> 169 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d30.dat
> Device_d30 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.4 0.0
> 128 12.7 %
> Non-APF 2.8 0.0
> 846 84.0 %
> Writes 0.1 0.0
> 33 3.3 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 3.4 0.1
> 1007 0.6 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d31.dat
> Device_d31 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 11 7.5 %
> Writes 0.5 0.0
> 135 92.5 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.5 0.0
> 146 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d32.dat
> Device_d32 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.1 0.0
> 31 6.5 %
> Non-APF 0.4 0.0
> 118 24.9 %
> Writes 1.1 0.0
> 325 68.6 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.6 0.0
> 474 0.3 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d33.dat
> Device_d33 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.2 0.0
> 58 31.9 %
> Non-APF 0.1 0.0
> 37 20.3 %
> Writes 0.3 0.0
> 87 47.8 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.6 0.0
> 182 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d34.dat
> Device_d34 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.4 0.0
> 114 100.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.4 0.0
> 114 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d35.dat
> Device_d35 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 0 0.0 %
> Writes 0.0 0.0
> 1 100.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.0 0.0
> 1 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d36.dat
> Device_d36 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.1 0.0
> 15 60.0 %
> Writes 0.0 0.0
> 10 40.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.1 0.0
> 25 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d37.dat
> Device_d37 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 2 6.9 %
> Writes 0.1 0.0
> 27 93.1 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.1 0.0
> 29 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d38.dat
> Device_d38 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 5 1.0 %
> Writes 1.7 0.0
> 519 99.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.7 0.0
> 524 0.3 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d39.dat
> Device_d39 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 2 2.9 %
> Writes 0.2 0.0
> 66 97.1 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.2 0.0
> 68 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d40.dat
> Device_d40 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 5 3.3 %
> Writes 0.5 0.0
> 148 96.7 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.5 0.0
> 153 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d41.dat
> Device_d41 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 1 8.3 %
> Writes 0.0 0.0
> 11 91.7 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.0 0.0
> 12 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d42.dat
> Device_d42 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 1 4.2 %
> Non-APF 0.0 0.0
> 3 12.5 %
> Writes 0.1 0.0
> 20 83.3 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.1 0.0
> 24 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d43.dat
> Device_d43 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 2 100.0 %
> Writes 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.0 0.0
> 2 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d44.dat
> Device_d44 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 6 10.9 %
> Writes 0.2 0.0
> 49 89.1 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.2 0.0
> 55 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d45.dat
> Device_d45 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 2 25.0 %
> Writes 0.0 0.0
> 6 75.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.0 0.0
> 8 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d46.dat
> Device_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
> 12 100.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.0 0.0
> 12 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d47.dat
> Device_d47 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 13 12.1 %
> Non-APF 0.0 0.0
> 2 1.9 %
> Writes 0.3 0.0
> 92 86.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.4 0.0
> 107 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d48.dat
> Device_d48 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 2 0.6 %
> Writes 1.0 0.0
> 311 99.4 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.0 0.0
> 313 0.2 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d49.dat
> Device_d49 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 5 38.5 %
> Writes 0.0 0.0
> 8 61.5 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.0 0.0
> 13 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d50.dat
> Device_d50 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 1 100.0 %
> Writes 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.0 0.0
> 1 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d51.dat
> Device_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:
> Device_d52.dat
> Device_d52 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 11 9.2 %
> Writes 0.4 0.0
> 108 90.8 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.4 0.0
> 119 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d53.dat
> Device_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:
> Device_d54.dat
> Device_d54 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 3 100.0 %
> Writes 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.0 0.0
> 3 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d55.dat
> Device_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:
> Device_d56.dat
> Device_d56 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 0 0.0 %
> Writes 0.1 0.0
> 34 100.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.1 0.0
> 34 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d57.dat
> Device_d57 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:
> Device_d58.dat
> Device_d58 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:
> Device_d59.dat
> Device_d59 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:
> Device_d60.dat
> Device_d60 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:
> Device_d61.dat
> Device_d61 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:
> Device_d62.dat
> Device_d62 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:
> Device_d63.dat
> Device_d63 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 0 0.0 %
> Writes 0.0 0.0
> 1 100.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.0 0.0
> 1 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d64.dat
> Device_d64 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:
> Device_d65.dat
> Device_d65 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:
> Device_d66.dat
> Device_d66 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
> 2 100.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.0 0.0
> 2 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d67.dat
> Device_d67 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:
> Device_d68.dat
> Device_d68 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 0 0.0 %
> Writes 0.0 0.0
> 1 100.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.0 0.0
> 1 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_d69.dat
> Device_d69 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:
> Device_d70.dat
> Device_d70 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:
> Device_d71.dat
> Device_d71 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:
> sybsecurity_d01.dat
> sybsecurity_d01 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
> 5 100.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.0 0.0
> 5 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> sybsecurity_d02.dat
> sybsecurity_d02 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 0 0.0 %
> Writes 0.1 0.0
> 15 100.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.1 0.0
> 15 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> 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:
>mx_auxiliary_l01.dat
> mx_auxiliary_l01 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 0 0.0 %
> Writes 0.1 0.0
> 33 100.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.1 0.0
> 33 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> Device_l01.dat
> Device_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/Device_l02.dat
> Device_l02 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:
> Device_l03.dat
> Device_l03 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 54.0 0.9
> 16205 100.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 54.0 0.9
> 16205 10.3 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> sybsecurity_l01.dat
> sybsecurity_l01 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 0 0.0 %
> Writes 0.1 0.0
> 35 100.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.1 0.0
> 35 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> /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:
> 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:
> master.dat
> master per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.5 0.0
> 147 41.5 %
> Writes 0.7 0.0
> 207 58.5 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.2 0.0
> 354 0.2 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> 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:
> 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:
> tempdb_d01.dat
> tempdb_d01 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 6 0.0 %
> Non-APF 30.8 0.5
> 9231 18.6 %
> Writes 134.4 2.2
> 40314 81.4 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 165.2 2.6
> 49551 31.6 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> tempdb_d02.dat
> tempdb_d02 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 12.9 0.2
> 3880 30.2 %
> Writes 29.9 0.5
> 8971 69.8 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 42.8 0.7
> 12851 8.2 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> tempdb_d03.dat
> tempdb_d03 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 6.4 0.1
> 1931 87.6 %
> Writes 0.9 0.0
> 273 12.4 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 7.3 0.1
> 2204 1.4 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> tempdb_d04.dat
> tempdb_d04 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 13.3 0.2
> 3989 87.9 %
> Writes 1.8 0.0
> 547 12.1 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 15.1 0.2
> 4536 2.9 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> tempdb_d05.dat
> tempdb_d05 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 13.4 0.2
> 4030 22.1 %
> Writes 47.4 0.8
> 14221 77.9 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 60.8 1.0
> 18251 11.6 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> tempdb_d06.dat
> tempdb_d06 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 %
>
>
>
>-----------------------------------------------------------------------------
>
>
>
>=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d=3d
>
>Network I/O Management
>----------------------
>
> Total Network I/O Requests 766.5 12.3
>229954 n/a
> Network I/Os Delayed 0.0 0.0
> 0 0.0 %
>
>
> Total TDS Packets Received per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Engine 0 43.7 0.7
> 13117 9.8 %
> Engine 1 46.9 0.8
> 14066 10.5 %
> Engine 2 53.7 0.9
> 16116 12.1 %
> Engine 3 54.7 0.9
> 16413 12.3 %
> Engine 4 87.3 1.4
> 26193 19.6 %
> Engine 5 158.7 2.5
> 47623 35.7 %
> ------------------------- ------------ ------------
>----------
> Total TDS Packets Rec'd 445.1 7.1
>133528
>
>
> Total Bytes Received per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Engine 0 11393.8 182.5
>3418147 6.6 %
> Engine 1 13712.0 219.6
>4113605 7.9 %
> Engine 2 20718.7 331.8
>6215622 12.0 %
> Engine 3 28344.2 453.9
>8503246 16.4 %
> Engine 4 50465.8 808.2
>15139738 29.2 %
> Engine 5 48100.3 770.3
>14430100 27.8 %
> ------------------------- ------------ ------------
>----------
> Total Bytes Rec'd 172734.9 2766.4
>51820458
>
>
> Avg Bytes Rec'd per Packet n/a n/a
> 388 n/a
>
>
>-----------------------------------------------------------------------------
>
> Total TDS Packets Sent per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Engine 0 1475.4 23.6
>442621 26.6 %
> Engine 1 2132.5 34.2
>639739 38.5 %
> Engine 2 761.2 12.2
>228361 13.7 %
> Engine 3 118.4 1.9
> 35532 2.1 %
> Engine 4 834.6 13.4
>250372 15.1 %
> Engine 5 215.7 3.5
> 64698 3.9 %
> ------------------------- ------------ ------------
>----------
> Total TDS Packets Sent 5537.7 88.7
>1661323
>
>
> Total Bytes Sent per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
>Arithmetic overflow occurred.
>(return status =3d 0)