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.

Disk I/O structures.

2 posts in General Discussion Last posting was on 2011-12-01 17:58:20.0Z
Raj Posted on 2011-12-01 00:30:48.0Z
Sender: 46af.4ed6c5c9.1804289383@sybase.com
From: Raj
Newsgroups: sybase.public.ase.general
Subject: Disk I/O structures.
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4ed6cab8.4793.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 30 Nov 2011 16:30:48 -0800
X-Trace: forums-1-dub 1322699448 10.22.241.41 (30 Nov 2011 16:30:48 -0800)
X-Original-Trace: 30 Nov 2011 16:30:48 -0800, 10.22.241.41
Lines: 3330
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30729
Article PK: 73620

Hi,

We have some performance issues and been running sysmon
reports to see what is causing issues. One of the things is
Disk I/O structures count is >0 sometimes. It was 5196 at
one point. Is it an issue ? Do we need to increase Disk i/o
structures ? If yes, what is the best value to set ? Please
find few of our config options related to it below ? Also,
sysmon report when the disk I/O structures count is high.




1> sp_configure 'disk i/o structures'
2> go
Parameter Name Default Memory Used
Config Value Run Value Unit Type
------------------------------ ----------- -----------
------------ ----------- -------------------- ----------
disk i/o structures 256 58
256 256 number dynamic

(1 row affected)
(return status = 0)
1> sp_configure 'max async'
2> go
Parameter Name Default Memory Used
Config Value Run Value Unit Type
------------------------------ ----------- -----------
------------ ----------- -------------------- ----------
max async i/os per engine 2147483647 0
2147483647 2147483647 number static
max async i/os per server 2147483647 0
2147483647 2147483647 number static




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

Server Version: Adaptive Server Enterprise/12.5.4/EBF
14067 ESD#3/P/RS6000/AIX 5.1
Server Name:
Sample Interval: 00:10: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 64.1 % 6.0 %
29.9 %
Engine 1 61.7 % 6.2 %
32.1 %
Engine 2 57.6 % 6.2 %
36.3 %
Engine 3 61.7 % 10.0 %
28.4 %
Engine 4 55.4 % 4.4 %
40.2 %
Engine 5 72.7 % 6.5 %
20.7 %
------------------------ -------- --------
--------
Summary Total 373.3 % 39.2 %
187.5 %
Average 62.2 % 6.5 %
31.3 %

CPU Yields by Engine per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Engine 0 331.0 1.9
198578 18.0 %
Engine 1 354.2 2.0
212493 19.2 %
Engine 2 326.8 1.9
196052 17.8 %
Engine 3 313.7 1.8
188247 17.0 %
Engine 4 238.7 1.4
143209 13.0 %
Engine 5 275.9 1.6
165514 15.0 %
------------------------- ------------ ------------
----------
Total CPU Yields 1840.2 10.5
1104093

Network Checks
Non-Blocking 3872.4 22.0
2323436 72.0 %
Blocking 1504.0 8.6
902385 28.0 %
------------------------- ------------ ------------
----------
Total Network I/O Checks 5376.4 30.6
3225821
Avg Net I/Os per Check n/a n/a
0.62798 n/a

Disk I/O Checks
Total Disk I/O Checks 7515.2 42.8
4509117 n/a
Checks Returning I/O 1561.5 8.9
936903 20.8 %
Avg Disk I/Os Returned n/a n/a
0.59404 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.2 0.0
108 n/a

Task Context Switches by Engine
Engine 0 717.3 4.1
430372 20.7 %
Engine 1 574.4 3.3
344626 16.5 %
Engine 2 530.6 3.0
318357 15.3 %
Engine 3 533.0 3.0
319773 15.4 %
Engine 4 344.1 2.0
206443 9.9 %
Engine 5 771.5 4.4
462878 22.2 %
------------------------- ------------ ------------
----------
Total Task Switches: 3470.7 19.8
2082449

Task Context Switches Due To:
Voluntary Yields 228.7 1.3
137234 6.6 %
Cache Search Misses 93.2 0.5
55905 2.7 %
System Disk Writes 0.2 0.0
99 0.0 %
I/O Pacing 97.7 0.6
58626 2.8 %
Logical Lock Contention 1.1 0.0
647 0.0 %
Address Lock Contention 2.1 0.0
1286 0.1 %
Latch Contention 35.0 0.2
20987 1.0 %
Log Semaphore Contention 15.6 0.1
9372 0.5 %
PLC Lock Contention 54.6 0.3
32752 1.6 %
Group Commit Sleeps 89.6 0.5
53733 2.6 %
Last Log Page Writes 116.4 0.7
69819 3.4 %
Modify Conflicts 29.5 0.2
17676 0.8 %
I/O Device Contention 0.0 0.0
0 0.0 %
Network Packet Received 918.3 5.2
551002 26.5 %
Network Packet Sent 412.2 2.3
247327 11.9 %
Other Causes 1376.6 7.8
825984 39.7 %


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

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

Application Statistics Summary (All Applications)
-------------------------------------------------
Priority Changes per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
To High Priority 54.0 0.3
32371 48.8 %
To Medium Priority 55.4 0.3
33244 50.1 %
To Low Priority 1.3 0.0
765 1.2 %
------------------------- ------------ ------------
----------
Total Priority Changes 110.6 0.6
66380

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

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 204.8 1.2
122879 100.0 %
Dirty 0.0 0.0
1 0.0 %
------------ ------------
----------
Total Washes 204.8 1.2
122880

Garbage Collections 1.2 0.0
714 n/a
Pages Processed in GC 0.0 0.0
4 n/a

Statistics Updates 3.5 0.0
2114 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 179.9 1.0
107946 n/a
Maximum SQL Text Requested n/a n/a
28109 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 15078 (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 175.7 n/a
105423 n/a

Transaction Detail per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Inserts
APL Heap Table 1240.0 7.1
743971 57.3 %
APL Clustered Table 216.4 1.2
129854 10.0 %
Data Only Lock Table 709.1 4.0
425439 32.7 %
------------------------- ------------ ------------
---------- ----------
Total Rows Inserted 2165.4 12.3
1299264 90.4 %

Updates
APL Deferred 0.0 0.0
3 0.0 %
APL Direct In-place 0.0 0.0
1 0.0 %
APL Direct Cheap 0.1 0.0
61 0.0 %
APL Direct Expensive 0.0 0.0
0 0.0 %
DOL Deferred 210.0 1.2
126026 92.4 %
DOL Direct 17.1 0.1
10259 7.5 %
------------------------- ------------ ------------
---------- ----------
Total Rows Updated 227.3 1.3
136350 9.5 %

Data Only Locked Updates
DOL Replace 62.1 0.4
37275 27.4 %
DOL Shrink 0.0 0.0
0 0.0 %
DOL Cheap Expand 12.9 0.1
7737 5.7 %
DOL Expensive Expand 152.1 0.9
91269 67.0 %
DOL Expand & Forward 0.0 0.0
4 0.0 %
DOL Fwd Row Returned 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total DOL Rows Updated 227.1 1.3
136285 9.5 %

Deletes
APL Deferred 1.3 0.0
759 40.0 %
APL Direct 0.4 0.0
219 11.5 %
DOL 1.5 0.0
919 48.4 %
------------------------- ------------ ------------
---------- ----------
Total Rows Deleted 3.2 0.0
1897 0.1 %
========================= ============ ============
==========
Total Rows Affected 2395.9 13.6
1437511

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

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

ULC Flushes to Xact Log per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
by Full ULC 66.8 0.4
40091 15.6 %
by End Transaction 175.8 1.0
105477 40.9 %
by Change of Database 0.0 0.0
15 0.0 %
by Single Log Record 34.9 0.2
20937 8.1 %
by Unpin 150.6 0.9
90379 35.1 %
by Other 1.5 0.0
919 0.4 %
------------------------- ------------ ------------
----------
Total ULC Flushes 429.7 2.4
257818

ULC Log Records 3625.8 20.6
2175466 n/a
Max ULC Size During Sample n/a n/a
4096 n/a

ULC Semaphore Requests
Granted 7427.6 42.3
4456534 99.3 %
Waited 54.6 0.3
32752 0.7 %
------------------------- ------------ ------------
----------
Total ULC Semaphore Req 7482.1 42.6
4489286

Log Semaphore Requests
Granted 400.9 2.3
240561 96.3 %
Waited 15.6 0.1
9372 3.7 %
------------------------- ------------ ------------
----------
Total Log Semaphore Req 416.6 2.4
249933

Transaction Log Writes 308.5 1.8
185123 n/a
Transaction Log Alloc 192.1 1.1
115277 n/a
Avg # Writes per Log Page n/a n/a
1.60590 n/a

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

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

Nonclustered Maintenance per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Ins/Upd Requiring Maint 0.4 0.0
264 n/a
# of NC Ndx Maint 0.3 0.0
203 n/a
Avg NC Ndx Maint / Op n/a n/a
0.76894 n/a

Deletes Requiring Maint 0.5 0.0
280 n/a
# of NC Ndx Maint 0.4 0.0
219 n/a
Avg NC Ndx Maint / Op n/a n/a
0.78214 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 228.7 1.3
137204 n/a
# of DOL Ndx Maint 9.3 0.1
5563 n/a
Avg DOL Ndx Maint / Op n/a n/a
0.04055 n/a

Page Splits 13.5 0.1
8075 n/a
Retries 0.0 0.0
0 0.0 %
Deadlocks 0.0 0.0
0 0.0 %
Add Index Level 0.0 0.0
0 0.0 %

Page Shrinks 0.0 0.0
0 n/a

Index Scans per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Ascending Scans 44112.5 251.1
26467521 55.5 %
DOL Ascending Scans 35360.6 201.2
21216344 44.5 %
Descending Scans 1.8 0.0
1097 0.0 %
DOL Descending Scans 0.0 0.0
4 0.0 %
------------ ------------
----------
Total Scans 79474.9 452.3
47684966

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

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

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

Open Object Usage
Active n/a n/a
6839 n/a
Max Ever Used Since Boot n/a n/a
7363 n/a
Free n/a n/a
33161 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
10847 n/a
Max Ever Used Since Boot n/a n/a
11928 n/a
Free n/a n/a
59153 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.4 %

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.1 %

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

Lock Management
---------------

Lock Summary per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Total Lock Requests 189064.1 1076.0
113438457 n/a
Avg Lock Contention 3.2 0.0
1933 0.0 %
Deadlock Percentage 0.0 0.0
0 0.0 %

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

Table Lock Hashtable
Lookups 3203.6 18.2
1922171 n/a
Avg Chain Length n/a n/a
0.29954 n/a
Spinlock Contention n/a n/a
n/a 0.1 %

Exclusive Table
Granted 5.0 0.0
2988 98.9 %
Waited 0.1 0.0
32 1.1 %
------------------------- ------------ ------------
---------- ----------
Total EX-Table Requests 5.0 0.0
3020 0.0 %

Shared Table
Granted 0.5 0.0
311 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total SH-Table Requests 0.5 0.0
311 0.0 %

Exclusive Intent
Granted 177.5 1.0
106520 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total EX-Intent Requests 177.5 1.0
106520 0.1 %

Shared Intent
Granted 2723.3 15.5
1633988 100.0 %
Waited 0.1 0.0
37 0.0 %
------------------------- ------------ ------------
---------- ----------
Total SH-Intent Requests 2723.4 15.5
1634025 1.4 %

Page & Row Lock HashTable
Lookups 110372.0 628.2
66223225 n/a
Avg Chain Length n/a n/a
0.08905 n/a
Spinlock Contention n/a n/a
n/a 0.3 %

Exclusive Page
Granted 3.1 0.0
1883 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total EX-Page Requests 3.1 0.0
1883 0.0 %

Update Page
Granted 2.4 0.0
1416 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total UP-Page Requests 2.4 0.0
1416 0.0 %

Shared Page
Granted 102517.6 583.5
61510533 100.0 %
Waited 0.0 0.0
2 0.0 %
------------------------- ------------ ------------
---------- ----------
Total SH-Page Requests 102517.6 583.5
61510535 54.2 %


Exclusive Row
Granted 568.5 3.2
341113 99.8 %
Waited 0.9 0.0
558 0.2 %
------------------------- ------------ ------------
---------- ----------
Total EX-Row Requests 569.5 3.2
341671 0.3 %

Update Row
Granted 14.1 0.1
8478 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total UP-Row Requests 14.1 0.1
8478 0.0 %

Shared Row
Granted 7259.5 41.3
4355704 100.0 %
Waited 0.0 0.0
18 0.0 %
------------------------- ------------ ------------
---------- ----------
Total SH-Row Requests 7259.5 41.3
4355722 3.8 %


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

Address Lock Hashtable
Lookups 75793.9 431.4
45476317 n/a
Avg Chain Length n/a n/a
0.00000 n/a
Spinlock Contention n/a n/a
n/a 0.3 %

Exclusive Address
Granted 33.8 0.2
20298 99.8 %
Waited 0.1 0.0
46 0.2 %
------------------------- ------------ ------------
---------- ----------
Total EX-Address Requests 33.9 0.2
20344 0.0 %

Shared Address
Granted 75755.5 431.2
45453292 100.0 %
Waited 2.1 0.0
1240 0.0 %
------------------------- ------------ ------------
---------- ----------
Total SH-Address Requests 75757.6 431.2
45454532 40.1 %


Last Page Locks on Heaps
Granted 1240.0 7.1
743971 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total Last Pg Locks 1240.0 7.1
743971 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.1 0.0
67 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
115 97.5 %
Sh-Row to Sh-Table 0.0 0.0
0 0.0 %
Sh-Next-Key to Sh-Table 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
----------
Total Lock Promotions 0.2 0.0
118


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 353980.9 2014.6
212388537 99.9 %
Total Cache Misses 242.5 1.4
145508 0.1 %
------------------------- ------------ ------------
----------
Total Cache Searches 354223.4 2016.0
212534045

Cache Turnover
Buffers Grabbed 31259.5 177.9
18755689 n/a
Buffers Grabbed Dirty 0.0 0.0
4 0.0 %

Cache Strategy Summary
Cached (LRU) Buffers 342832.9 1951.2
205699728 100.0 %
Discarded (MRU) Buffers 0.0 0.0
1 0.0 %

Large I/O Usage
Large I/Os Performed 147.7 0.8
88602 97.1 %

Large I/Os Denied due to
Pool < Prefetch Size 3.3 0.0
1993 2.2 %
Pages Requested
Reside in Another
Buffer Pool 1.0 0.0
624 0.7 %
------------------------- ------------ ------------
----------
Total Large I/O Requests 152.0 0.9
91219

Large I/O Effectiveness
Pages by Lrg I/O Cached 590.7 3.4
354408 n/a
Pages by Lrg I/O Used 31996.3 182.1
19197792 5417 %

Asynchronous Prefetch Activity
APFs Issued 29.1 0.2
17475 0.0 %
APFs Denied Due To
APF I/O Overloads 1.0 0.0
573 0.0 %
APF Limit Overloads 0.0 0.0
0 0.0 %
APF Reused Overloads 0.0 0.0
23 0.0 %
APF Buffers Found in Cache
With Spinlock Held 0.0 0.0
0 0.0 %
W/o Spinlock Held 61188.9 348.2
36713351 100.0 %
------------------------- ------------ ------------
----------
Total APFs Requested 61219.0 348.4
36731422

Other Asynchronous Prefetch Statistics
APFs Used 29.3 0.2
17552 n/a
APF Waits for I/O 11.0 0.1
6601 n/a
APF Discards 0.0 0.0
0 n/a

Dirty Read Behavior
Page Requests 1265.9 7.2
759542 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 4.8 %

Utilization n/a n/a
n/a 98.1 %

Cache Searches
Cache Hits 347251.7 1976.3
208351033 100.0 %
Found in Wash 20.5 0.1
12274 0.0 %
Cache Misses 85.8 0.5
51477 0.0 %
------------------------- ------------ ------------
----------
Total Cache Searches 347337.5 1976.8
208402510

Pool Turnover
4 Kb Pool
LRU Buffer Grab 523.8 3.0
314254 82.9 %
Grabbed Dirty 0.0 0.0
0 0.0 %
16 Kb Pool
LRU Buffer Grab 107.7 0.6
64621 17.1 %
Grabbed Dirty 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
----------
Total Cache Turnover 631.5 3.6
378875

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

Cache Strategy
Cached (LRU) Buffers 335918.0 1911.8
201550787 100.0 %
Discarded (MRU) Buffers 0.0 0.0
1 0.0 %

Large I/O Usage
Large I/Os Performed 107.7 0.6
64621 97.0 %

Large I/Os Denied due to
Pool < Prefetch Size 0.0 0.0
0 0.0 %
Pages Requested
Reside in Another
Buffer Pool 3.3 0.0
1993 3.0 %
------------------------- ------------ ------------
----------
Total Large I/O Requests 111.0 0.6
66614

Large I/O Detail
16 Kb Pool
Pages Cached 430.8 2.5
258484 n/a
Pages Used 301.1 1.7
180653 69.9 %

Dirty Read Behavior
Page Requests 1260.4 7.2
756230 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 8.8 %

Utilization n/a n/a
n/a 1.9 %

Cache Searches
Cache Hits 6729.2 38.3
4037504 97.7 %
Found in Wash 0.0 0.0
0 0.0 %
Cache Misses 156.7 0.9
94031 2.3 %
------------------------- ------------ ------------
----------
Total Cache Searches 6885.9 39.2
4131535

Pool Turnover
4 Kb Pool
LRU Buffer Grab 30588.0 174.1
18352829 99.9 %
Grabbed Dirty 0.0 0.0
4 0.0 %
16 Kb Pool
LRU Buffer Grab 40.0 0.2
23981 0.1 %
Grabbed Dirty 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
----------
Total Cache Turnover 30628.0 174.3
18376814

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

Cache Strategy
Cached (LRU) Buffers 6914.9 39.4
4148941 100.0 %
Discarded (MRU) Buffers 0.0 0.0
0 0.0 %

Large I/O Usage
Large I/Os Performed 40.0 0.2
23981 97.5 %

Large I/Os Denied due to
Pool < Prefetch Size 0.0 0.0
0 0.0 %
Pages Requested
Reside in Another
Buffer Pool 1.0 0.0
624 2.5 %
------------------------- ------------ ------------
----------
Total Large I/O Requests 41.0 0.2
24605

Large I/O Detail
16 Kb Pool
Pages Cached 159.9 0.9
95924 n/a
Pages Used 48.0 0.3
28794 30.0 %

Dirty Read Behavior
Page Requests 5.5 0.0
3312 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 32.4 0.2
19416 n/a
Procedure Reads from Disk 0.0 0.0
2 0.0 %
Procedure Writes to Disk 0.0 0.0
0 0.0 %
Procedure Removals 0.0 0.0
4 n/a
Procedure Recompilations 0.0 0.0
2 n/a

Recompilations Requests:
Execution Phase 0.0 0.0
2 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.0 0.0
2 n/a
Index Change 0.0 0.0
0 n/a
Isolation Level Change 0.0 0.0
0 n/a
Permissions Change 0.0 0.0
0 n/a
Cursor Permissions Change 0.0 0.0
0 n/a

SQL Statement Cache:
Statements Cached 0.0 0.0
0 n/a
Statements Found in Cache 0.0 0.0
0 n/a
Statements Not Found 0.0 0.0
0 n/a
Statements Dropped 0.0 0.0
0 n/a
Statements Restored 0.0 0.0
0 n/a
Statements Not Cached 447.5 2.5
268527 n/a


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

Memory Management per sec per xact
count % of total
--------------------------- ------------ ------------
---------- ----------
Pages Allocated 0.2 0.0
101 n/a
Pages Released 0.2 0.0
99 n/a

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

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

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

Avg Time per Normal Chkpt 1.22222 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
256 n/a
Engine 2 n/a n/a
256 n/a
Engine 3 n/a n/a
256 n/a
Engine 4 n/a n/a
256 n/a
Engine 5 n/a n/a
256 n/a


I/Os Delayed by
Disk I/O Structures n/a n/a
5196 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 932.2 5.3
559307

Completed Disk I/O's
Engine 0 130.5 0.7
78287 14.1 %
Engine 1 108.0 0.6
64791 11.6 %
Engine 2 107.3 0.6
64360 11.6 %
Engine 3 91.1 0.5
54665 9.8 %
Engine 4 68.6 0.4
41151 7.4 %
Engine 5 422.2 2.4
253301 45.5 %
------------------------- ------------ ------------
----------
Total Completed I/Os 927.6 5.3
556555


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

Device:
xxxdata/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:
xxxdata/xxxxxxxxx_d01.dat
xxxxxxxxx_d01 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
8 13.1 %
Non-APF 0.1 0.0
53 86.9 %
Writes 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.1 0.0
61 0.0 %



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

Device:
xxxdata/xxxxxxxxx_d02.dat
xxxxxxxxx_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:
xxxdata/xxxxxxxxx_d03.dat
xxxxxxxxx_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:
xxxdata/xxxxxxxxx_d04.dat
xxxxxxxxx_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:
xxxdata/XXXXX01_d01.dat
XXXXX01_d01 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.6 0.0
349 34.4 %
Non-APF 0.8 0.0
465 45.8 %
Writes 0.3 0.0
202 19.9 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.7 0.0
1016 0.2 %



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

Device:
xxxdata/XXXXX01_d02.dat
XXXXX01_d02 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.3 0.0
150 23.4 %
Non-APF 0.8 0.0
474 73.8 %
Writes 0.0 0.0
18 2.8 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.1 0.0
642 0.1 %



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

Device:
xxxdata/XXXXX01_d03.dat
XXXXX01_d03 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.1 0.0
63 7.8 %
Non-APF 0.9 0.0
545 67.5 %
Writes 0.3 0.0
199 24.7 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.3 0.0
807 0.1 %



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

Device:
xxxdata/XXXXX01_d04.dat
XXXXX01_d04 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.3 0.0
208 18.1 %
Non-APF 1.3 0.0
769 67.0 %
Writes 0.3 0.0
171 14.9 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.9 0.0
1148 0.2 %



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

Device:
xxxdata/XXXXX01_d05.dat
XXXXX01_d05 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.1 0.0
51 9.0 %
Non-APF 0.8 0.0
474 83.7 %
Writes 0.1 0.0
41 7.2 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.9 0.0
566 0.1 %



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

Device:
xxxdata/XXXXX01_d06.dat
XXXXX01_d06 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.2 0.0
102 16.5 %
Non-APF 0.9 0.0
518 83.5 %
Writes 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.0 0.0
620 0.1 %



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

Device:
xxxdata/XXXXX01_d07.dat
XXXXX01_d07 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.2 0.0
111 17.8 %
Non-APF 0.9 0.0
511 81.9 %
Writes 0.0 0.0
2 0.3 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.0 0.0
624 0.1 %



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

Device:
xxxdata/XXXXX01_d08.dat
XXXXX01_d08 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.4 0.0
221 20.1 %
Non-APF 1.5 0.0
879 79.8 %
Writes 0.0 0.0
1 0.1 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.8 0.0
1101 0.2 %



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

Device:
xxxdata/XXXXX01_d09.dat
XXXXX01_d09 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.3 0.0
156 26.9 %
Non-APF 0.7 0.0
415 71.6 %
Writes 0.0 0.0
9 1.6 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.0 0.0
580 0.1 %



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

Device:
xxxdata/XXXXX01_d10.dat
XXXXX01_d10 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.4 0.0
243 22.8 %
Non-APF 1.4 0.0
822 77.0 %
Writes 0.0 0.0
3 0.3 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.8 0.0
1068 0.2 %



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

Device:
xxxdata/XXXXX01_d11.dat
XXXXX01_d11 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.3 0.0
207 22.6 %
Non-APF 1.0 0.0
597 65.2 %
Writes 0.2 0.0
112 12.2 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.5 0.0
916 0.2 %



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

Device:
xxxdata/XXXXX01_d12.dat
XXXXX01_d12 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.1 0.0
72 7.0 %
Non-APF 1.6 0.0
960 92.8 %
Writes 0.0 0.0
3 0.3 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.7 0.0
1035 0.2 %



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

Device:
xxxdata/XXXXX01_d13.dat
XXXXX01_d13 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.2 0.0
117 11.4 %
Non-APF 1.5 0.0
908 88.5 %
Writes 0.0 0.0
1 0.1 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.7 0.0
1026 0.2 %



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

Device:
xxxdata/XXXXX01_d14.dat
XXXXX01_d14 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.3 0.0
188 21.8 %
Non-APF 1.1 0.0
674 78.0 %
Writes 0.0 0.0
2 0.2 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.4 0.0
864 0.2 %



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

Device:
xxxdata/XXXXX01_d15.dat
XXXXX01_d15 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.4 0.0
264 27.0 %
Non-APF 1.0 0.0
596 61.0 %
Writes 0.2 0.0
117 12.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.6 0.0
977 0.2 %



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

Device:
xxxdata/XXXXX01_d16.dat
XXXXX01_d16 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.3 0.0
174 5.4 %
Non-APF 2.6 0.0
1551 48.5 %
Writes 2.5 0.0
1474 46.1 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 5.3 0.0
3199 0.6 %



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

Device:
xxxdata/XXXXX01_d17.dat
XXXXX01_d17 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.3 0.0
154 21.6 %
Non-APF 0.9 0.0
547 76.7 %
Writes 0.0 0.0
12 1.7 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.2 0.0
713 0.1 %



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

Device:
xxxdata/XXXXX01_d18.dat
XXXXX01_d18 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.9 0.0
518 53.2 %
Non-APF 0.8 0.0
455 46.7 %
Writes 0.0 0.0
1 0.1 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.6 0.0
974 0.2 %



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

Device:
xxxdata/XXXXX01_d19.dat
XXXXX01_d19 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 1.0 0.0
622 57.3 %
Non-APF 0.8 0.0
461 42.4 %
Writes 0.0 0.0
3 0.3 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.8 0.0
1086 0.2 %



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

Device:
xxxdata/XXXXX01_d20.dat
XXXXX01_d20 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.7 0.0
399 50.3 %
Non-APF 0.6 0.0
389 49.1 %
Writes 0.0 0.0
5 0.6 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.3 0.0
793 0.1 %



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

Device:
xxxdata/XXXXX01_d21.dat
XXXXX01_d21 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.7 0.0
397 51.3 %
Non-APF 0.6 0.0
376 48.6 %
Writes 0.0 0.0
1 0.1 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.3 0.0
774 0.1 %



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

Device:
xxxdata/XXXXX01_d22.dat
XXXXX01_d22 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.9 0.0
542 59.2 %
Non-APF 0.6 0.0
355 38.8 %
Writes 0.0 0.0
19 2.1 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.5 0.0
916 0.2 %



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

Device:
xxxdata/XXXXX01_d23.dat
XXXXX01_d23 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.5 0.0
291 50.7 %
Non-APF 0.4 0.0
269 46.9 %
Writes 0.0 0.0
14 2.4 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.0 0.0
574 0.1 %



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

Device:
xxxdata/XXXXX01_d24.dat
XXXXX01_d24 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.6 0.0
387 57.9 %
Non-APF 0.4 0.0
234 35.0 %
Writes 0.1 0.0
47 7.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.1 0.0
668 0.1 %



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

Device:
xxxdata/XXXXX01_d25.dat
XXXXX01_d25 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.5 0.0
302 59.7 %
Non-APF 0.3 0.0
169 33.4 %
Writes 0.1 0.0
35 6.9 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.8 0.0
506 0.1 %



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

Device:
xxxdata/XXXXX01_d26.dat
XXXXX01_d26 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.6 0.0
337 61.7 %
Non-APF 0.2 0.0
128 23.4 %
Writes 0.1 0.0
81 14.8 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.9 0.0
546 0.1 %



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

Device:
xxxdata/XXXXX01_d27.dat
XXXXX01_d27 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.7 0.0
400 63.7 %
Non-APF 0.1 0.0
80 12.7 %
Writes 0.2 0.0
148 23.6 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.0 0.0
628 0.1 %



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

Device:
xxxdata/XXXXX01_d28.dat
XXXXX01_d28 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.4 0.0
241 63.6 %
Non-APF 0.2 0.0
134 35.4 %
Writes 0.0 0.0
4 1.1 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.6 0.0
379 0.1 %



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

Device:
xxxdata/XXXXX01_d29.dat
XXXXX01_d29 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 1.0 0.0
626 64.1 %
Non-APF 0.6 0.0
350 35.9 %
Writes 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.6 0.0
976 0.2 %



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

Device:
xxxdata/XXXXX01_d30.dat
XXXXX01_d30 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 6.5 0.0
3873 13.5 %
Non-APF 41.2 0.2
24723 86.4 %
Writes 0.0 0.0
3 0.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 47.7 0.3
28599 5.1 %



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

Device:
xxxdata/XXXXX01_d31.dat
XXXXX01_d31 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.8 0.0
459 46.0 %
Non-APF 0.9 0.0
529 53.1 %
Writes 0.0 0.0
9 0.9 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.7 0.0
997 0.2 %



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

Device:
xxxdata/XXXXX01_d32.dat
XXXXX01_d32 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.3 0.0
190 90.5 %
Non-APF 0.0 0.0
19 9.0 %
Writes 0.0 0.0
1 0.5 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.4 0.0
210 0.0 %



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

Device:
xxxdata/XXXXX01_d33.dat
XXXXX01_d33 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 1.1 0.0
672 30.8 %
Non-APF 2.3 0.0
1389 63.6 %
Writes 0.2 0.0
124 5.7 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 3.6 0.0
2185 0.4 %



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

Device:
xxxdata/XXXXX01_d34.dat
XXXXX01_d34 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.2 0.0
116 13.6 %
Non-APF 1.2 0.0
727 85.1 %
Writes 0.0 0.0
11 1.3 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.4 0.0
854 0.2 %



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

Device:
xxxdata/XXXXX01_d35.dat
XXXXX01_d35 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
9 0.4 %
Non-APF 3.3 0.0
1967 98.3 %
Writes 0.0 0.0
26 1.3 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 3.3 0.0
2002 0.4 %



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

Device:
xxxdata/XXXXX01_d36.dat
XXXXX01_d36 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
2 0.1 %
Non-APF 2.7 0.0
1597 97.8 %
Writes 0.1 0.0
34 2.1 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 2.7 0.0
1633 0.3 %



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

Device:
xxxdata/XXXXX01_d37.dat
XXXXX01_d37 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.6 0.0
374 54.1 %
Non-APF 0.5 0.0
311 45.0 %
Writes 0.0 0.0
6 0.9 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.2 0.0
691 0.1 %



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

Device:
xxxdata/XXXXX01_d38.dat
XXXXX01_d38 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.7 0.0
437 80.9 %
Non-APF 0.2 0.0
99 18.3 %
Writes 0.0 0.0
4 0.7 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.9 0.0
540 0.1 %



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

Device:
xxxdata/XXXXX01_d39.dat
XXXXX01_d39 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.7 0.0
420 82.0 %
Non-APF 0.1 0.0
80 15.6 %
Writes 0.0 0.0
12 2.3 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.9 0.0
512 0.1 %



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

Device:
xxxdata/XXXXX01_d40.dat
XXXXX01_d40 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.3 0.0
200 75.8 %
Non-APF 0.1 0.0
64 24.2 %
Writes 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.4 0.0
264 0.0 %



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

Device:
xxxdata/XXXXX01_d41.dat
XXXXX01_d41 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.4 0.0
255 64.6 %
Non-APF 0.1 0.0
67 17.0 %
Writes 0.1 0.0
73 18.5 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.7 0.0
395 0.1 %



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

Device:
xxxdata/XXXXX01_d42.dat
XXXXX01_d42 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.2 0.0
113 1.1 %
Non-APF 4.5 0.0
2729 26.1 %
Writes 12.7 0.1
7601 72.8 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 17.4 0.1
10443 1.9 %



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

Device:
xxxdata/XXXXX01_d43.dat
XXXXX01_d43 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
20 52.6 %
Non-APF 0.0 0.0
12 31.6 %
Writes 0.0 0.0
6 15.8 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.1 0.0
38 0.0 %



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

Device:
xxxdata/XXXXX01_d44.dat
XXXXX01_d44 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.3 0.0
176 85.0 %
Non-APF 0.0 0.0
25 12.1 %
Writes 0.0 0.0
6 2.9 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.3 0.0
207 0.0 %



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

Device:
xxxdata/XXXXX01_d45.dat
XXXXX01_d45 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.4 0.0
212 82.5 %
Non-APF 0.1 0.0
45 17.5 %
Writes 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.4 0.0
257 0.0 %



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

Device:
xxxdata/XXXXX01_d46.dat
XXXXX01_d46 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.3 0.0
164 19.5 %
Non-APF 0.2 0.0
120 14.3 %
Writes 0.9 0.0
555 66.2 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 1.4 0.0
839 0.2 %



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

Device:
xxxdata/XXXXX01_d47.dat
XXXXX01_d47 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.7 0.0
433 84.7 %
Non-APF 0.1 0.0
74 14.5 %
Writes 0.0 0.0
4 0.8 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.9 0.0
511 0.1 %



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

Device:
xxxdata/XXXXX01_d48.dat
XXXXX01_d48 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.2 0.0
147 35.7 %
Non-APF 0.1 0.0
45 10.9 %
Writes 0.4 0.0
220 53.4 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.7 0.0
412 0.1 %



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

Device:
xxxdata/XXXXX01_d49.dat
XXXXX01_d49 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.6 0.0
356 85.2 %
Non-APF 0.1 0.0
45 10.8 %
Writes 0.0 0.0
17 4.1 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.7 0.0
418 0.1 %



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

Device:
xxxdata/XXXXX01_d50.dat
XXXXX01_d50 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
4 0.1 %
Writes 9.7 0.1
5819 99.9 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 9.7 0.1
5823 1.0 %



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

Device:
xxxdata/XXXXX01_d51.dat
XXXXX01_d51 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
12 0.1 %
Non-APF 1.2 0.0
736 8.4 %
Writes 13.4 0.1
8038 91.5 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 14.6 0.1
8786 1.6 %



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

Device:
xxxdata/XXXXX01_d52.dat
XXXXX01_d52 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
14 38.9 %
Non-APF 0.0 0.0
21 58.3 %
Writes 0.0 0.0
1 2.8 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.1 0.0
36 0.0 %



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

Device:
xxxdata/XXXXX01_d53.dat
XXXXX01_d53 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.5 0.0
311 0.6 %
Writes 82.5 0.5
49479 99.4 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 83.0 0.5
49790 9.0 %



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

Device:
xxxdata/XXXXX01_d54.dat
XXXXX01_d54 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:
xxxdata/XXXXX01_d55.dat
XXXXX01_d55 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
10 34.5 %
Non-APF 0.0 0.0
19 65.5 %
Writes 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
29 0.0 %



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

Device:
xxxdata/XXXXX01_d56.dat
XXXXX01_d56 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:
xxxdata/XXXXX01_d57.dat
XXXXX01_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:
xxxdata/XXXXX01_d58.dat
XXXXX01_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:
xxxdata/XXXXX01_d59.dat
XXXXX01_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:
xxxdata/XXXXX01_d60.dat
XXXXX01_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:
xxxdata/XXXXX01_d61.dat
XXXXX01_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:
xxxdata/XXXXX01_d62.dat
XXXXX01_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:
xxxdata/XXXXX01_d63.dat
XXXXX01_d63 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
6 14.0 %
Non-APF 0.1 0.0
37 86.0 %
Writes 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.1 0.0
43 0.0 %



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

Device:
xxxdata/XXXXX01_d64.dat
XXXXX01_d64 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
1 5.9 %
Non-APF 0.0 0.0
16 94.1 %
Writes 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
17 0.0 %



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

Device:
xxxdata/XXXXX01_d65.dat
XXXXX01_d65 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
6 9.2 %
Non-APF 0.1 0.0
59 90.8 %
Writes 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.1 0.0
65 0.0 %



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

Device:
xxxdata/XXXXX01_d66.dat
XXXXX01_d66 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
2 8.7 %
Non-APF 0.0 0.0
19 82.6 %
Writes 0.0 0.0
2 8.7 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
23 0.0 %



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

Device:
xxxdata/XXXXX01_d67.dat
XXXXX01_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:
xxxdata/XXXXX01_d68.dat
XXXXX01_d68 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:
xxxdata/XXXXX01_d69.dat
XXXXX01_d69 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
6 100.0 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.0 0.0
6 0.0 %



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

Device:
xxxdata/XXXXX01_d70.dat
XXXXX01_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:
xxxdata/XXXXX01_d71.dat
XXXXX01_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:
xxxdata/sybsecurity_d01.dat
sybsecurity_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:
xxxdata/sybsecurity_d02.dat
sybsecurity_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:
xxxlog/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:
xxxlog/xxxxxxxxx_l01.dat
xxxxxxxxx_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:
xxxlog/XXXXX01_l01.dat
XXXXX01_l01 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.7 0.0
428 0.2 %
Writes 298.8 1.7
179294 99.8 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 299.5 1.7
179722 32.3 %



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

Device:
xxxlog/XXXXX01_l02.dat
XXXXX01_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:
xxxlog/XXXXX01_l03.dat
XXXXX01_l03 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:
xxxlog/sybsecurity_l01.dat
sybsecurity_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:
xxxsystem/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:
xxxsystem/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:
xxxsystem/master.dat
master per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.1 0.0
49 20.2 %
Writes 0.3 0.0
194 79.8 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 0.4 0.0
243 0.0 %



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

Device:
xxxsystem/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:
xxxsystem/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:
xxxtempdb/tempdb_d01.dat
tempdb_d01 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 1.2 0.0
706 0.7 %
Non-APF 2.9 0.0
1755 1.7 %
Writes 166.2 0.9
99691 97.6 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 170.3 1.0
102152 18.4 %



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

Device:
xxxtempdb/tempdb_d02.dat
tempdb_d02 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.3 0.0
190 0.4 %
Non-APF 1.7 0.0
1004 1.9 %
Writes 86.7 0.5
52005 97.8 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 88.7 0.5
53199 9.6 %



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

Device:
xxxtempdb/tempdb_d03.dat
tempdb_d03 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.6 0.0
336 2.7 %
Writes 20.1 0.1
12068 97.3 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 20.7 0.1
12404 2.2 %



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

Device:
xxxtempdb/tempdb_d04.dat
tempdb_d04 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 1.6 0.0
948 2.3 %
Writes 67.3 0.4
40377 97.7 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 68.9 0.4
41325 7.4 %



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

Device:
xxxtempdb/tempdb_d05.dat
tempdb_d05 per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.6 0.0
338 1.4 %
Writes 40.9 0.2
24518 98.6 %
------------------------- ------------ ------------
---------- ----------
Total I/Os 41.4 0.2
24856 4.5 %



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

Device:
xxxtempdb/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 1330.6 7.6
798330 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 199.3 1.1
119604 21.7 %
Engine 1 144.9 0.8
86910 15.8 %
Engine 2 136.7 0.8
82043 14.9 %
Engine 3 158.1 0.9
94831 17.2 %
Engine 4 60.7 0.3
36399 6.6 %
Engine 5 218.7 1.2
131208 23.8 %
------------------------- ------------ ------------
----------
Total TDS Packets Rec'd 918.3 5.2
550995


Total Bytes Received per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Engine 0 259166.6 1475.0
155499939 25.2 %
Engine 1 231820.6 1319.4
139092375 22.5 %
Engine 2 95911.5 545.9
57546879 9.3 %
Engine 3 120045.3 683.2
72027189 11.7 %
Engine 4 45873.6 261.1
27524184 4.5 %
Engine 5 275533.8 1568.2
165320279 26.8 %
------------------------- ------------ ------------
----------
Total Bytes Rec'd 1028351.4 5852.7
617010845


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


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

Total TDS Packets Sent per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Engine 0 263.6 1.5
158175 10.7 %
Engine 1 179.1 1.0
107440 7.3 %
Engine 2 656.7 3.7
394011 26.7 %
Engine 3 311.7 1.8
187035 12.7 %
Engine 4 233.8 1.3
140287 9.5 %
Engine 5 813.0 4.6
487817 33.1 %
------------------------- ------------ ------------
----------
Total TDS Packets Sent 2457.9 14.0
1474765


Total Bytes Sent per sec per xact
count % of total
------------------------- ------------ ------------
---------- ----------
Arithmetic overflow occurred.


J Posted on 2011-12-01 17:58:20.0Z
From: jtotally_bogus@sbcglobal.net (J)
Newsgroups: sybase.public.ase.general
Subject: Re: Disk I/O structures.
Reply-To: J@bogusemailAddress.com
Message-ID: <4ed7bfdd.265640750@forums.sybase.com>
References: <4ed6cab8.4793.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: 1 Dec 2011 09:58:20 -0800
X-Trace: forums-1-dub 1322762300 10.22.241.152 (1 Dec 2011 09:58:20 -0800)
X-Original-Trace: 1 Dec 2011 09:58:20 -0800, vip152.sybase.com
Lines: 3339
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30731
Article PK: 73626

On 30 Nov 2011 16:30:48 -0800, Raj wrote:

The "rule of thumb" I have heard for disk i/o stuctures is 300-400 per
engine. I would use 4096 and then possibly back down from this after
you see the max per engine when you know you have plenty.

Jay

>Hi,
>
> We have some performance issues and been running sysmon
>reports to see what is causing issues. One of the things is
>Disk I/O structures count is >0 sometimes. It was 5196 at
>one point. Is it an issue ? Do we need to increase Disk i/o
>structures ? If yes, what is the best value to set ? Please
>find few of our config options related to it below ? Also,
>sysmon report when the disk I/O structures count is high.
>
>
>
>
>1> sp_configure 'disk i/o structures'
>2> go
> Parameter Name Default Memory Used
>Config Value Run Value Unit Type
> ------------------------------ ----------- -----------
>------------ ----------- -------------------- ----------
> disk i/o structures 256 58
> 256 256 number dynamic
>
>(1 row affected)
>(return status = 0)
>1> sp_configure 'max async'
>2> go
> Parameter Name Default Memory Used
>Config Value Run Value Unit Type
> ------------------------------ ----------- -----------
>------------ ----------- -------------------- ----------
> max async i/os per engine 2147483647 0
>2147483647 2147483647 number static
> max async i/os per server 2147483647 0
>2147483647 2147483647 number static
>
>
>
>
>===============================================================================
> Sybase Adaptive Server Enterprise System Performance
>Report
>===============================================================================
>
>Server Version: Adaptive Server Enterprise/12.5.4/EBF
>14067 ESD#3/P/RS6000/AIX 5.1
>Server Name:
>Sample Interval: 00:10: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 64.1 % 6.0 %
>29.9 %
> Engine 1 61.7 % 6.2 %
>32.1 %
> Engine 2 57.6 % 6.2 %
>36.3 %
> Engine 3 61.7 % 10.0 %
>28.4 %
> Engine 4 55.4 % 4.4 %
>40.2 %
> Engine 5 72.7 % 6.5 %
>20.7 %
> ------------------------ -------- --------
>--------
> Summary Total 373.3 % 39.2 %
>187.5 %
> Average 62.2 % 6.5 %
>31.3 %
>
> CPU Yields by Engine per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Engine 0 331.0 1.9
>198578 18.0 %
> Engine 1 354.2 2.0
>212493 19.2 %
> Engine 2 326.8 1.9
>196052 17.8 %
> Engine 3 313.7 1.8
>188247 17.0 %
> Engine 4 238.7 1.4
>143209 13.0 %
> Engine 5 275.9 1.6
>165514 15.0 %
> ------------------------- ------------ ------------
>----------
> Total CPU Yields 1840.2 10.5
>1104093
>
> Network Checks
> Non-Blocking 3872.4 22.0
>2323436 72.0 %
> Blocking 1504.0 8.6
>902385 28.0 %
> ------------------------- ------------ ------------
>----------
> Total Network I/O Checks 5376.4 30.6
>3225821
> Avg Net I/Os per Check n/a n/a
>0.62798 n/a
>
> Disk I/O Checks
> Total Disk I/O Checks 7515.2 42.8
>4509117 n/a
> Checks Returning I/O 1561.5 8.9
>936903 20.8 %
> Avg Disk I/Os Returned n/a n/a
>0.59404 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.2 0.0
> 108 n/a
>
> Task Context Switches by Engine
> Engine 0 717.3 4.1
>430372 20.7 %
> Engine 1 574.4 3.3
>344626 16.5 %
> Engine 2 530.6 3.0
>318357 15.3 %
> Engine 3 533.0 3.0
>319773 15.4 %
> Engine 4 344.1 2.0
>206443 9.9 %
> Engine 5 771.5 4.4
>462878 22.2 %
> ------------------------- ------------ ------------
>----------
> Total Task Switches: 3470.7 19.8
>2082449
>
> Task Context Switches Due To:
> Voluntary Yields 228.7 1.3
>137234 6.6 %
> Cache Search Misses 93.2 0.5
> 55905 2.7 %
> System Disk Writes 0.2 0.0
> 99 0.0 %
> I/O Pacing 97.7 0.6
> 58626 2.8 %
> Logical Lock Contention 1.1 0.0
> 647 0.0 %
> Address Lock Contention 2.1 0.0
> 1286 0.1 %
> Latch Contention 35.0 0.2
> 20987 1.0 %
> Log Semaphore Contention 15.6 0.1
> 9372 0.5 %
> PLC Lock Contention 54.6 0.3
> 32752 1.6 %
> Group Commit Sleeps 89.6 0.5
> 53733 2.6 %
> Last Log Page Writes 116.4 0.7
> 69819 3.4 %
> Modify Conflicts 29.5 0.2
> 17676 0.8 %
> I/O Device Contention 0.0 0.0
> 0 0.0 %
> Network Packet Received 918.3 5.2
>551002 26.5 %
> Network Packet Sent 412.2 2.3
>247327 11.9 %
> Other Causes 1376.6 7.8
>825984 39.7 %
>
>
>===============================================================================
>
>Application Management
>----------------------
>
> Application Statistics Summary (All Applications)
> -------------------------------------------------
> Priority Changes per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> To High Priority 54.0 0.3
> 32371 48.8 %
> To Medium Priority 55.4 0.3
> 33244 50.1 %
> To Low Priority 1.3 0.0
> 765 1.2 %
> ------------------------- ------------ ------------
>----------
> Total Priority Changes 110.6 0.6
> 66380
>
> Allotted Slices Exhausted per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> High Priority 0.0 0.0
> 0 0.0 %
> Medium Priority 8.1 0.0
> 4884 100.0 %
> Low Priority 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>----------
> Total Slices Exhausted 8.1 0.0
> 4884
>
> 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 204.8 1.2
>122879 100.0 %
> Dirty 0.0 0.0
> 1 0.0 %
> ------------ ------------
>----------
>Total Washes 204.8 1.2
>122880
>
>Garbage Collections 1.2 0.0
> 714 n/a
>Pages Processed in GC 0.0 0.0
> 4 n/a
>
>Statistics Updates 3.5 0.0
> 2114 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 179.9 1.0
>107946 n/a
> Maximum SQL Text Requested n/a n/a
>28109 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 15078 (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 175.7 n/a
>105423 n/a
>
> Transaction Detail per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Inserts
> APL Heap Table 1240.0 7.1
>743971 57.3 %
> APL Clustered Table 216.4 1.2
>129854 10.0 %
> Data Only Lock Table 709.1 4.0
>425439 32.7 %
> ------------------------- ------------ ------------
>---------- ----------
> Total Rows Inserted 2165.4 12.3
>1299264 90.4 %
>
> Updates
> APL Deferred 0.0 0.0
> 3 0.0 %
> APL Direct In-place 0.0 0.0
> 1 0.0 %
> APL Direct Cheap 0.1 0.0
> 61 0.0 %
> APL Direct Expensive 0.0 0.0
> 0 0.0 %
> DOL Deferred 210.0 1.2
>126026 92.4 %
> DOL Direct 17.1 0.1
> 10259 7.5 %
> ------------------------- ------------ ------------
>---------- ----------
> Total Rows Updated 227.3 1.3
>136350 9.5 %
>
> Data Only Locked Updates
> DOL Replace 62.1 0.4
> 37275 27.4 %
> DOL Shrink 0.0 0.0
> 0 0.0 %
> DOL Cheap Expand 12.9 0.1
> 7737 5.7 %
> DOL Expensive Expand 152.1 0.9
> 91269 67.0 %
> DOL Expand & Forward 0.0 0.0
> 4 0.0 %
> DOL Fwd Row Returned 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total DOL Rows Updated 227.1 1.3
>136285 9.5 %
>
> Deletes
> APL Deferred 1.3 0.0
> 759 40.0 %
> APL Direct 0.4 0.0
> 219 11.5 %
> DOL 1.5 0.0
> 919 48.4 %
> ------------------------- ------------ ------------
>---------- ----------
> Total Rows Deleted 3.2 0.0
> 1897 0.1 %
> ========================= ============ ============
>==========
> Total Rows Affected 2395.9 13.6
>1437511
>
>===============================================================================
>
>Transaction Management
>----------------------
>
> ULC Flushes to Xact Log per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> by Full ULC 66.8 0.4
> 40091 15.6 %
> by End Transaction 175.8 1.0
>105477 40.9 %
> by Change of Database 0.0 0.0
> 15 0.0 %
> by Single Log Record 34.9 0.2
> 20937 8.1 %
> by Unpin 150.6 0.9
> 90379 35.1 %
> by Other 1.5 0.0
> 919 0.4 %
> ------------------------- ------------ ------------
>----------
> Total ULC Flushes 429.7 2.4
>257818
>
> ULC Log Records 3625.8 20.6
>2175466 n/a
> Max ULC Size During Sample n/a n/a
> 4096 n/a
>
> ULC Semaphore Requests
> Granted 7427.6 42.3
>4456534 99.3 %
> Waited 54.6 0.3
> 32752 0.7 %
> ------------------------- ------------ ------------
>----------
> Total ULC Semaphore Req 7482.1 42.6
>4489286
>
> Log Semaphore Requests
> Granted 400.9 2.3
>240561 96.3 %
> Waited 15.6 0.1
> 9372 3.7 %
> ------------------------- ------------ ------------
>----------
> Total Log Semaphore Req 416.6 2.4
>249933
>
> Transaction Log Writes 308.5 1.8
>185123 n/a
> Transaction Log Alloc 192.1 1.1
>115277 n/a
> Avg # Writes per Log Page n/a n/a
>1.60590 n/a
>
>===============================================================================
>
>Index Management
>----------------
>
> Nonclustered Maintenance per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Ins/Upd Requiring Maint 0.4 0.0
> 264 n/a
> # of NC Ndx Maint 0.3 0.0
> 203 n/a
> Avg NC Ndx Maint / Op n/a n/a
>0.76894 n/a
>
> Deletes Requiring Maint 0.5 0.0
> 280 n/a
> # of NC Ndx Maint 0.4 0.0
> 219 n/a
> Avg NC Ndx Maint / Op n/a n/a
>0.78214 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 228.7 1.3
>137204 n/a
> # of DOL Ndx Maint 9.3 0.1
> 5563 n/a
> Avg DOL Ndx Maint / Op n/a n/a
>0.04055 n/a
>
> Page Splits 13.5 0.1
> 8075 n/a
> Retries 0.0 0.0
> 0 0.0 %
> Deadlocks 0.0 0.0
> 0 0.0 %
> Add Index Level 0.0 0.0
> 0 0.0 %
>
> Page Shrinks 0.0 0.0
> 0 n/a
>
> Index Scans per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Ascending Scans 44112.5 251.1
>26467521 55.5 %
> DOL Ascending Scans 35360.6 201.2
>21216344 44.5 %
> Descending Scans 1.8 0.0
> 1097 0.0 %
> DOL Descending Scans 0.0 0.0
> 4 0.0 %
> ------------ ------------
>----------
> Total Scans 79474.9 452.3
>47684966
>
>===============================================================================
>
>Metadata Cache Management
>-------------------------
>
> Metadata Cache Summary per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
>
> Open Object Usage
> Active n/a n/a
> 6839 n/a
> Max Ever Used Since Boot n/a n/a
> 7363 n/a
> Free n/a n/a
> 33161 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
> 10847 n/a
> Max Ever Used Since Boot n/a n/a
> 11928 n/a
> Free n/a n/a
> 59153 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.4 %
>
> 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.1 %
>
>===============================================================================
>
>Lock Management
>---------------
>
> Lock Summary per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Total Lock Requests 189064.1 1076.0
>113438457 n/a
> Avg Lock Contention 3.2 0.0
> 1933 0.0 %
> Deadlock Percentage 0.0 0.0
> 0 0.0 %
>
> Lock Detail per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
>
> Table Lock Hashtable
> Lookups 3203.6 18.2
>1922171 n/a
> Avg Chain Length n/a n/a
>0.29954 n/a
> Spinlock Contention n/a n/a
> n/a 0.1 %
>
> Exclusive Table
> Granted 5.0 0.0
> 2988 98.9 %
> Waited 0.1 0.0
> 32 1.1 %
> ------------------------- ------------ ------------
>---------- ----------
> Total EX-Table Requests 5.0 0.0
> 3020 0.0 %
>
> Shared Table
> Granted 0.5 0.0
> 311 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total SH-Table Requests 0.5 0.0
> 311 0.0 %
>
> Exclusive Intent
> Granted 177.5 1.0
>106520 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total EX-Intent Requests 177.5 1.0
>106520 0.1 %
>
> Shared Intent
> Granted 2723.3 15.5
>1633988 100.0 %
> Waited 0.1 0.0
> 37 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total SH-Intent Requests 2723.4 15.5
>1634025 1.4 %
>
> Page & Row Lock HashTable
> Lookups 110372.0 628.2
>66223225 n/a
> Avg Chain Length n/a n/a
>0.08905 n/a
> Spinlock Contention n/a n/a
> n/a 0.3 %
>
> Exclusive Page
> Granted 3.1 0.0
> 1883 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total EX-Page Requests 3.1 0.0
> 1883 0.0 %
>
> Update Page
> Granted 2.4 0.0
> 1416 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total UP-Page Requests 2.4 0.0
> 1416 0.0 %
>
> Shared Page
> Granted 102517.6 583.5
>61510533 100.0 %
> Waited 0.0 0.0
> 2 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total SH-Page Requests 102517.6 583.5
>61510535 54.2 %
>
>
> Exclusive Row
> Granted 568.5 3.2
>341113 99.8 %
> Waited 0.9 0.0
> 558 0.2 %
> ------------------------- ------------ ------------
>---------- ----------
> Total EX-Row Requests 569.5 3.2
>341671 0.3 %
>
> Update Row
> Granted 14.1 0.1
> 8478 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total UP-Row Requests 14.1 0.1
> 8478 0.0 %
>
> Shared Row
> Granted 7259.5 41.3
>4355704 100.0 %
> Waited 0.0 0.0
> 18 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total SH-Row Requests 7259.5 41.3
>4355722 3.8 %
>
>
> Next-Key
> Total Next-Key Requests 0.0 0.0
> 0 n/a
>
> Address Lock Hashtable
> Lookups 75793.9 431.4
>45476317 n/a
> Avg Chain Length n/a n/a
>0.00000 n/a
> Spinlock Contention n/a n/a
> n/a 0.3 %
>
> Exclusive Address
> Granted 33.8 0.2
> 20298 99.8 %
> Waited 0.1 0.0
> 46 0.2 %
> ------------------------- ------------ ------------
>---------- ----------
> Total EX-Address Requests 33.9 0.2
> 20344 0.0 %
>
> Shared Address
> Granted 75755.5 431.2
>45453292 100.0 %
> Waited 2.1 0.0
> 1240 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total SH-Address Requests 75757.6 431.2
>45454532 40.1 %
>
>
> Last Page Locks on Heaps
> Granted 1240.0 7.1
>743971 100.0 %
> Waited 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total Last Pg Locks 1240.0 7.1
>743971 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.1 0.0
> 67 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
> 115 97.5 %
> Sh-Row to Sh-Table 0.0 0.0
> 0 0.0 %
> Sh-Next-Key to Sh-Table 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>----------
> Total Lock Promotions 0.2 0.0
> 118
>
>
> 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 353980.9 2014.6
>212388537 99.9 %
> Total Cache Misses 242.5 1.4
>145508 0.1 %
> ------------------------- ------------ ------------
>----------
> Total Cache Searches 354223.4 2016.0
>212534045
>
> Cache Turnover
> Buffers Grabbed 31259.5 177.9
>18755689 n/a
> Buffers Grabbed Dirty 0.0 0.0
> 4 0.0 %
>
> Cache Strategy Summary
> Cached (LRU) Buffers 342832.9 1951.2
>205699728 100.0 %
> Discarded (MRU) Buffers 0.0 0.0
> 1 0.0 %
>
> Large I/O Usage
> Large I/Os Performed 147.7 0.8
> 88602 97.1 %
>
> Large I/Os Denied due to
> Pool < Prefetch Size 3.3 0.0
> 1993 2.2 %
> Pages Requested
> Reside in Another
> Buffer Pool 1.0 0.0
> 624 0.7 %
> ------------------------- ------------ ------------
>----------
> Total Large I/O Requests 152.0 0.9
> 91219
>
> Large I/O Effectiveness
> Pages by Lrg I/O Cached 590.7 3.4
>354408 n/a
> Pages by Lrg I/O Used 31996.3 182.1
>19197792 5417 %
>
> Asynchronous Prefetch Activity
> APFs Issued 29.1 0.2
> 17475 0.0 %
> APFs Denied Due To
> APF I/O Overloads 1.0 0.0
> 573 0.0 %
> APF Limit Overloads 0.0 0.0
> 0 0.0 %
> APF Reused Overloads 0.0 0.0
> 23 0.0 %
> APF Buffers Found in Cache
> With Spinlock Held 0.0 0.0
> 0 0.0 %
> W/o Spinlock Held 61188.9 348.2
>36713351 100.0 %
> ------------------------- ------------ ------------
>----------
> Total APFs Requested 61219.0 348.4
>36731422
>
> Other Asynchronous Prefetch Statistics
> APFs Used 29.3 0.2
> 17552 n/a
> APF Waits for I/O 11.0 0.1
> 6601 n/a
> APF Discards 0.0 0.0
> 0 n/a
>
> Dirty Read Behavior
> Page Requests 1265.9 7.2
>759542 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 4.8 %
>
> Utilization n/a n/a
> n/a 98.1 %
>
> Cache Searches
> Cache Hits 347251.7 1976.3
>208351033 100.0 %
> Found in Wash 20.5 0.1
> 12274 0.0 %
> Cache Misses 85.8 0.5
> 51477 0.0 %
> ------------------------- ------------ ------------
>----------
> Total Cache Searches 347337.5 1976.8
>208402510
>
> Pool Turnover
> 4 Kb Pool
> LRU Buffer Grab 523.8 3.0
>314254 82.9 %
> Grabbed Dirty 0.0 0.0
> 0 0.0 %
> 16 Kb Pool
> LRU Buffer Grab 107.7 0.6
> 64621 17.1 %
> Grabbed Dirty 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>----------
> Total Cache Turnover 631.5 3.6
>378875
>
> Buffer Wash Behavior
> Statistics Not Available - No Buffers Entered Wash
>Section Yet
>
> Cache Strategy
> Cached (LRU) Buffers 335918.0 1911.8
>201550787 100.0 %
> Discarded (MRU) Buffers 0.0 0.0
> 1 0.0 %
>
> Large I/O Usage
> Large I/Os Performed 107.7 0.6
> 64621 97.0 %
>
> Large I/Os Denied due to
> Pool < Prefetch Size 0.0 0.0
> 0 0.0 %
> Pages Requested
> Reside in Another
> Buffer Pool 3.3 0.0
> 1993 3.0 %
> ------------------------- ------------ ------------
>----------
> Total Large I/O Requests 111.0 0.6
> 66614
>
> Large I/O Detail
> 16 Kb Pool
> Pages Cached 430.8 2.5
>258484 n/a
> Pages Used 301.1 1.7
>180653 69.9 %
>
> Dirty Read Behavior
> Page Requests 1260.4 7.2
>756230 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 8.8 %
>
> Utilization n/a n/a
> n/a 1.9 %
>
> Cache Searches
> Cache Hits 6729.2 38.3
>4037504 97.7 %
> Found in Wash 0.0 0.0
> 0 0.0 %
> Cache Misses 156.7 0.9
> 94031 2.3 %
> ------------------------- ------------ ------------
>----------
> Total Cache Searches 6885.9 39.2
>4131535
>
> Pool Turnover
> 4 Kb Pool
> LRU Buffer Grab 30588.0 174.1
>18352829 99.9 %
> Grabbed Dirty 0.0 0.0
> 4 0.0 %
> 16 Kb Pool
> LRU Buffer Grab 40.0 0.2
> 23981 0.1 %
> Grabbed Dirty 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>----------
> Total Cache Turnover 30628.0 174.3
>18376814
>
> Buffer Wash Behavior
> Statistics Not Available - No Buffers Entered Wash
>Section Yet
>
> Cache Strategy
> Cached (LRU) Buffers 6914.9 39.4
>4148941 100.0 %
> Discarded (MRU) Buffers 0.0 0.0
> 0 0.0 %
>
> Large I/O Usage
> Large I/Os Performed 40.0 0.2
> 23981 97.5 %
>
> Large I/Os Denied due to
> Pool < Prefetch Size 0.0 0.0
> 0 0.0 %
> Pages Requested
> Reside in Another
> Buffer Pool 1.0 0.0
> 624 2.5 %
> ------------------------- ------------ ------------
>----------
> Total Large I/O Requests 41.0 0.2
> 24605
>
> Large I/O Detail
> 16 Kb Pool
> Pages Cached 159.9 0.9
> 95924 n/a
> Pages Used 48.0 0.3
> 28794 30.0 %
>
> Dirty Read Behavior
> Page Requests 5.5 0.0
> 3312 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 32.4 0.2
> 19416 n/a
> Procedure Reads from Disk 0.0 0.0
> 2 0.0 %
> Procedure Writes to Disk 0.0 0.0
> 0 0.0 %
> Procedure Removals 0.0 0.0
> 4 n/a
> Procedure Recompilations 0.0 0.0
> 2 n/a
>
> Recompilations Requests:
> Execution Phase 0.0 0.0
> 2 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.0 0.0
> 2 n/a
> Index Change 0.0 0.0
> 0 n/a
> Isolation Level Change 0.0 0.0
> 0 n/a
> Permissions Change 0.0 0.0
> 0 n/a
> Cursor Permissions Change 0.0 0.0
> 0 n/a
>
> SQL Statement Cache:
> Statements Cached 0.0 0.0
> 0 n/a
> Statements Found in Cache 0.0 0.0
> 0 n/a
> Statements Not Found 0.0 0.0
> 0 n/a
> Statements Dropped 0.0 0.0
> 0 n/a
> Statements Restored 0.0 0.0
> 0 n/a
> Statements Not Cached 447.5 2.5
>268527 n/a
>
>
>===============================================================================
>
>Memory Management per sec per xact
> count % of total
>--------------------------- ------------ ------------
>---------- ----------
> Pages Allocated 0.2 0.0
> 101 n/a
> Pages Released 0.2 0.0
> 99 n/a
>
>===============================================================================
>
>Recovery Management
>-------------------
>
> Checkpoints per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> # of Normal Checkpoints 0.0 0.0
> 18 100.0 %
> # of Free Checkpoints 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>----------
> Total Checkpoints 0.0 0.0
> 18
>
> Avg Time per Normal Chkpt 1.22222 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
> 256 n/a
> Engine 2 n/a n/a
> 256 n/a
> Engine 3 n/a n/a
> 256 n/a
> Engine 4 n/a n/a
> 256 n/a
> Engine 5 n/a n/a
> 256 n/a
>
>
> I/Os Delayed by
> Disk I/O Structures n/a n/a
> 5196 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 932.2 5.3
>559307
>
> Completed Disk I/O's
> Engine 0 130.5 0.7
> 78287 14.1 %
> Engine 1 108.0 0.6
> 64791 11.6 %
> Engine 2 107.3 0.6
> 64360 11.6 %
> Engine 3 91.1 0.5
> 54665 9.8 %
> Engine 4 68.6 0.4
> 41151 7.4 %
> Engine 5 422.2 2.4
>253301 45.5 %
> ------------------------- ------------ ------------
>----------
> Total Completed I/Os 927.6 5.3
>556555
>
>
> Device Activity Detail
> ----------------------
>
> Device:
> xxxdata/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:
> xxxdata/xxxxxxxxx_d01.dat
> xxxxxxxxx_d01 per sec per xact
>count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 8 13.1 %
> Non-APF 0.1 0.0
> 53 86.9 %
> Writes 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.1 0.0
> 61 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/xxxxxxxxx_d02.dat
> xxxxxxxxx_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:
> xxxdata/xxxxxxxxx_d03.dat
> xxxxxxxxx_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:
> xxxdata/xxxxxxxxx_d04.dat
> xxxxxxxxx_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:
> xxxdata/XXXXX01_d01.dat
> XXXXX01_d01 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.6 0.0
> 349 34.4 %
> Non-APF 0.8 0.0
> 465 45.8 %
> Writes 0.3 0.0
> 202 19.9 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.7 0.0
> 1016 0.2 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d02.dat
> XXXXX01_d02 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.3 0.0
> 150 23.4 %
> Non-APF 0.8 0.0
> 474 73.8 %
> Writes 0.0 0.0
> 18 2.8 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.1 0.0
> 642 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d03.dat
> XXXXX01_d03 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.1 0.0
> 63 7.8 %
> Non-APF 0.9 0.0
> 545 67.5 %
> Writes 0.3 0.0
> 199 24.7 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.3 0.0
> 807 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d04.dat
> XXXXX01_d04 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.3 0.0
> 208 18.1 %
> Non-APF 1.3 0.0
> 769 67.0 %
> Writes 0.3 0.0
> 171 14.9 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.9 0.0
> 1148 0.2 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d05.dat
> XXXXX01_d05 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.1 0.0
> 51 9.0 %
> Non-APF 0.8 0.0
> 474 83.7 %
> Writes 0.1 0.0
> 41 7.2 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.9 0.0
> 566 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d06.dat
> XXXXX01_d06 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.2 0.0
> 102 16.5 %
> Non-APF 0.9 0.0
> 518 83.5 %
> Writes 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.0 0.0
> 620 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d07.dat
> XXXXX01_d07 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.2 0.0
> 111 17.8 %
> Non-APF 0.9 0.0
> 511 81.9 %
> Writes 0.0 0.0
> 2 0.3 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.0 0.0
> 624 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d08.dat
> XXXXX01_d08 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.4 0.0
> 221 20.1 %
> Non-APF 1.5 0.0
> 879 79.8 %
> Writes 0.0 0.0
> 1 0.1 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.8 0.0
> 1101 0.2 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d09.dat
> XXXXX01_d09 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.3 0.0
> 156 26.9 %
> Non-APF 0.7 0.0
> 415 71.6 %
> Writes 0.0 0.0
> 9 1.6 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.0 0.0
> 580 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d10.dat
> XXXXX01_d10 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.4 0.0
> 243 22.8 %
> Non-APF 1.4 0.0
> 822 77.0 %
> Writes 0.0 0.0
> 3 0.3 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.8 0.0
> 1068 0.2 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d11.dat
> XXXXX01_d11 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.3 0.0
> 207 22.6 %
> Non-APF 1.0 0.0
> 597 65.2 %
> Writes 0.2 0.0
> 112 12.2 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.5 0.0
> 916 0.2 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d12.dat
> XXXXX01_d12 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.1 0.0
> 72 7.0 %
> Non-APF 1.6 0.0
> 960 92.8 %
> Writes 0.0 0.0
> 3 0.3 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.7 0.0
> 1035 0.2 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d13.dat
> XXXXX01_d13 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.2 0.0
> 117 11.4 %
> Non-APF 1.5 0.0
> 908 88.5 %
> Writes 0.0 0.0
> 1 0.1 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.7 0.0
> 1026 0.2 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d14.dat
> XXXXX01_d14 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.3 0.0
> 188 21.8 %
> Non-APF 1.1 0.0
> 674 78.0 %
> Writes 0.0 0.0
> 2 0.2 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.4 0.0
> 864 0.2 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d15.dat
> XXXXX01_d15 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.4 0.0
> 264 27.0 %
> Non-APF 1.0 0.0
> 596 61.0 %
> Writes 0.2 0.0
> 117 12.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.6 0.0
> 977 0.2 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d16.dat
> XXXXX01_d16 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.3 0.0
> 174 5.4 %
> Non-APF 2.6 0.0
> 1551 48.5 %
> Writes 2.5 0.0
> 1474 46.1 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 5.3 0.0
> 3199 0.6 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d17.dat
> XXXXX01_d17 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.3 0.0
> 154 21.6 %
> Non-APF 0.9 0.0
> 547 76.7 %
> Writes 0.0 0.0
> 12 1.7 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.2 0.0
> 713 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d18.dat
> XXXXX01_d18 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.9 0.0
> 518 53.2 %
> Non-APF 0.8 0.0
> 455 46.7 %
> Writes 0.0 0.0
> 1 0.1 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.6 0.0
> 974 0.2 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d19.dat
> XXXXX01_d19 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 1.0 0.0
> 622 57.3 %
> Non-APF 0.8 0.0
> 461 42.4 %
> Writes 0.0 0.0
> 3 0.3 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.8 0.0
> 1086 0.2 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d20.dat
> XXXXX01_d20 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.7 0.0
> 399 50.3 %
> Non-APF 0.6 0.0
> 389 49.1 %
> Writes 0.0 0.0
> 5 0.6 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.3 0.0
> 793 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d21.dat
> XXXXX01_d21 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.7 0.0
> 397 51.3 %
> Non-APF 0.6 0.0
> 376 48.6 %
> Writes 0.0 0.0
> 1 0.1 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.3 0.0
> 774 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d22.dat
> XXXXX01_d22 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.9 0.0
> 542 59.2 %
> Non-APF 0.6 0.0
> 355 38.8 %
> Writes 0.0 0.0
> 19 2.1 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.5 0.0
> 916 0.2 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d23.dat
> XXXXX01_d23 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.5 0.0
> 291 50.7 %
> Non-APF 0.4 0.0
> 269 46.9 %
> Writes 0.0 0.0
> 14 2.4 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.0 0.0
> 574 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d24.dat
> XXXXX01_d24 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.6 0.0
> 387 57.9 %
> Non-APF 0.4 0.0
> 234 35.0 %
> Writes 0.1 0.0
> 47 7.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.1 0.0
> 668 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d25.dat
> XXXXX01_d25 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.5 0.0
> 302 59.7 %
> Non-APF 0.3 0.0
> 169 33.4 %
> Writes 0.1 0.0
> 35 6.9 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.8 0.0
> 506 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d26.dat
> XXXXX01_d26 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.6 0.0
> 337 61.7 %
> Non-APF 0.2 0.0
> 128 23.4 %
> Writes 0.1 0.0
> 81 14.8 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.9 0.0
> 546 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d27.dat
> XXXXX01_d27 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.7 0.0
> 400 63.7 %
> Non-APF 0.1 0.0
> 80 12.7 %
> Writes 0.2 0.0
> 148 23.6 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.0 0.0
> 628 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d28.dat
> XXXXX01_d28 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.4 0.0
> 241 63.6 %
> Non-APF 0.2 0.0
> 134 35.4 %
> Writes 0.0 0.0
> 4 1.1 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.6 0.0
> 379 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d29.dat
> XXXXX01_d29 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 1.0 0.0
> 626 64.1 %
> Non-APF 0.6 0.0
> 350 35.9 %
> Writes 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.6 0.0
> 976 0.2 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d30.dat
> XXXXX01_d30 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 6.5 0.0
> 3873 13.5 %
> Non-APF 41.2 0.2
> 24723 86.4 %
> Writes 0.0 0.0
> 3 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 47.7 0.3
> 28599 5.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d31.dat
> XXXXX01_d31 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.8 0.0
> 459 46.0 %
> Non-APF 0.9 0.0
> 529 53.1 %
> Writes 0.0 0.0
> 9 0.9 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.7 0.0
> 997 0.2 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d32.dat
> XXXXX01_d32 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.3 0.0
> 190 90.5 %
> Non-APF 0.0 0.0
> 19 9.0 %
> Writes 0.0 0.0
> 1 0.5 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.4 0.0
> 210 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d33.dat
> XXXXX01_d33 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 1.1 0.0
> 672 30.8 %
> Non-APF 2.3 0.0
> 1389 63.6 %
> Writes 0.2 0.0
> 124 5.7 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 3.6 0.0
> 2185 0.4 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d34.dat
> XXXXX01_d34 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.2 0.0
> 116 13.6 %
> Non-APF 1.2 0.0
> 727 85.1 %
> Writes 0.0 0.0
> 11 1.3 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.4 0.0
> 854 0.2 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d35.dat
> XXXXX01_d35 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 9 0.4 %
> Non-APF 3.3 0.0
> 1967 98.3 %
> Writes 0.0 0.0
> 26 1.3 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 3.3 0.0
> 2002 0.4 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d36.dat
> XXXXX01_d36 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 2 0.1 %
> Non-APF 2.7 0.0
> 1597 97.8 %
> Writes 0.1 0.0
> 34 2.1 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 2.7 0.0
> 1633 0.3 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d37.dat
> XXXXX01_d37 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.6 0.0
> 374 54.1 %
> Non-APF 0.5 0.0
> 311 45.0 %
> Writes 0.0 0.0
> 6 0.9 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.2 0.0
> 691 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d38.dat
> XXXXX01_d38 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.7 0.0
> 437 80.9 %
> Non-APF 0.2 0.0
> 99 18.3 %
> Writes 0.0 0.0
> 4 0.7 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.9 0.0
> 540 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d39.dat
> XXXXX01_d39 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.7 0.0
> 420 82.0 %
> Non-APF 0.1 0.0
> 80 15.6 %
> Writes 0.0 0.0
> 12 2.3 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.9 0.0
> 512 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d40.dat
> XXXXX01_d40 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.3 0.0
> 200 75.8 %
> Non-APF 0.1 0.0
> 64 24.2 %
> Writes 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.4 0.0
> 264 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d41.dat
> XXXXX01_d41 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.4 0.0
> 255 64.6 %
> Non-APF 0.1 0.0
> 67 17.0 %
> Writes 0.1 0.0
> 73 18.5 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.7 0.0
> 395 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d42.dat
> XXXXX01_d42 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.2 0.0
> 113 1.1 %
> Non-APF 4.5 0.0
> 2729 26.1 %
> Writes 12.7 0.1
> 7601 72.8 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 17.4 0.1
> 10443 1.9 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d43.dat
> XXXXX01_d43 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 20 52.6 %
> Non-APF 0.0 0.0
> 12 31.6 %
> Writes 0.0 0.0
> 6 15.8 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.1 0.0
> 38 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d44.dat
> XXXXX01_d44 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.3 0.0
> 176 85.0 %
> Non-APF 0.0 0.0
> 25 12.1 %
> Writes 0.0 0.0
> 6 2.9 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.3 0.0
> 207 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d45.dat
> XXXXX01_d45 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.4 0.0
> 212 82.5 %
> Non-APF 0.1 0.0
> 45 17.5 %
> Writes 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.4 0.0
> 257 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d46.dat
> XXXXX01_d46 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.3 0.0
> 164 19.5 %
> Non-APF 0.2 0.0
> 120 14.3 %
> Writes 0.9 0.0
> 555 66.2 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 1.4 0.0
> 839 0.2 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d47.dat
> XXXXX01_d47 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.7 0.0
> 433 84.7 %
> Non-APF 0.1 0.0
> 74 14.5 %
> Writes 0.0 0.0
> 4 0.8 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.9 0.0
> 511 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d48.dat
> XXXXX01_d48 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.2 0.0
> 147 35.7 %
> Non-APF 0.1 0.0
> 45 10.9 %
> Writes 0.4 0.0
> 220 53.4 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.7 0.0
> 412 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d49.dat
> XXXXX01_d49 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.6 0.0
> 356 85.2 %
> Non-APF 0.1 0.0
> 45 10.8 %
> Writes 0.0 0.0
> 17 4.1 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.7 0.0
> 418 0.1 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d50.dat
> XXXXX01_d50 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.0 0.0
> 4 0.1 %
> Writes 9.7 0.1
> 5819 99.9 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 9.7 0.1
> 5823 1.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d51.dat
> XXXXX01_d51 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 12 0.1 %
> Non-APF 1.2 0.0
> 736 8.4 %
> Writes 13.4 0.1
> 8038 91.5 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 14.6 0.1
> 8786 1.6 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d52.dat
> XXXXX01_d52 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 14 38.9 %
> Non-APF 0.0 0.0
> 21 58.3 %
> Writes 0.0 0.0
> 1 2.8 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.1 0.0
> 36 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d53.dat
> XXXXX01_d53 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.5 0.0
> 311 0.6 %
> Writes 82.5 0.5
> 49479 99.4 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 83.0 0.5
> 49790 9.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d54.dat
> XXXXX01_d54 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:
> xxxdata/XXXXX01_d55.dat
> XXXXX01_d55 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 10 34.5 %
> Non-APF 0.0 0.0
> 19 65.5 %
> Writes 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.0 0.0
> 29 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d56.dat
> XXXXX01_d56 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:
> xxxdata/XXXXX01_d57.dat
> XXXXX01_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:
> xxxdata/XXXXX01_d58.dat
> XXXXX01_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:
> xxxdata/XXXXX01_d59.dat
> XXXXX01_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:
> xxxdata/XXXXX01_d60.dat
> XXXXX01_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:
> xxxdata/XXXXX01_d61.dat
> XXXXX01_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:
> xxxdata/XXXXX01_d62.dat
> XXXXX01_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:
> xxxdata/XXXXX01_d63.dat
> XXXXX01_d63 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 6 14.0 %
> Non-APF 0.1 0.0
> 37 86.0 %
> Writes 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.1 0.0
> 43 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d64.dat
> XXXXX01_d64 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 1 5.9 %
> Non-APF 0.0 0.0
> 16 94.1 %
> Writes 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.0 0.0
> 17 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d65.dat
> XXXXX01_d65 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 6 9.2 %
> Non-APF 0.1 0.0
> 59 90.8 %
> Writes 0.0 0.0
> 0 0.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.1 0.0
> 65 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d66.dat
> XXXXX01_d66 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 2 8.7 %
> Non-APF 0.0 0.0
> 19 82.6 %
> Writes 0.0 0.0
> 2 8.7 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.0 0.0
> 23 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d67.dat
> XXXXX01_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:
> xxxdata/XXXXX01_d68.dat
> XXXXX01_d68 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:
> xxxdata/XXXXX01_d69.dat
> XXXXX01_d69 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
> 6 100.0 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.0 0.0
> 6 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxdata/XXXXX01_d70.dat
> XXXXX01_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:
> xxxdata/XXXXX01_d71.dat
> XXXXX01_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:
> xxxdata/sybsecurity_d01.dat
> sybsecurity_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:
> xxxdata/sybsecurity_d02.dat
> sybsecurity_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:
> xxxlog/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:
> xxxlog/xxxxxxxxx_l01.dat
> xxxxxxxxx_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:
> xxxlog/XXXXX01_l01.dat
> XXXXX01_l01 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.7 0.0
> 428 0.2 %
> Writes 298.8 1.7
>179294 99.8 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 299.5 1.7
>179722 32.3 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxlog/XXXXX01_l02.dat
> XXXXX01_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:
> xxxlog/XXXXX01_l03.dat
> XXXXX01_l03 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:
> xxxlog/sybsecurity_l01.dat
> sybsecurity_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:
> xxxsystem/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:
> xxxsystem/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:
> xxxsystem/master.dat
> master per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.1 0.0
> 49 20.2 %
> Writes 0.3 0.0
> 194 79.8 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 0.4 0.0
> 243 0.0 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxsystem/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:
> xxxsystem/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:
> xxxtempdb/tempdb_d01.dat
> tempdb_d01 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 1.2 0.0
> 706 0.7 %
> Non-APF 2.9 0.0
> 1755 1.7 %
> Writes 166.2 0.9
> 99691 97.6 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 170.3 1.0
>102152 18.4 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxtempdb/tempdb_d02.dat
> tempdb_d02 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.3 0.0
> 190 0.4 %
> Non-APF 1.7 0.0
> 1004 1.9 %
> Writes 86.7 0.5
> 52005 97.8 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 88.7 0.5
> 53199 9.6 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxtempdb/tempdb_d03.dat
> tempdb_d03 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.6 0.0
> 336 2.7 %
> Writes 20.1 0.1
> 12068 97.3 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 20.7 0.1
> 12404 2.2 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxtempdb/tempdb_d04.dat
> tempdb_d04 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 1.6 0.0
> 948 2.3 %
> Writes 67.3 0.4
> 40377 97.7 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 68.9 0.4
> 41325 7.4 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxtempdb/tempdb_d05.dat
> tempdb_d05 per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Reads
> APF 0.0 0.0
> 0 0.0 %
> Non-APF 0.6 0.0
> 338 1.4 %
> Writes 40.9 0.2
> 24518 98.6 %
> ------------------------- ------------ ------------
>---------- ----------
> Total I/Os 41.4 0.2
> 24856 4.5 %
>
>
>
>-----------------------------------------------------------------------------
>
> Device:
> xxxtempdb/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 1330.6 7.6
>798330 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 199.3 1.1
>119604 21.7 %
> Engine 1 144.9 0.8
> 86910 15.8 %
> Engine 2 136.7 0.8
> 82043 14.9 %
> Engine 3 158.1 0.9
> 94831 17.2 %
> Engine 4 60.7 0.3
> 36399 6.6 %
> Engine 5 218.7 1.2
>131208 23.8 %
> ------------------------- ------------ ------------
>----------
> Total TDS Packets Rec'd 918.3 5.2
>550995
>
>
> Total Bytes Received per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Engine 0 259166.6 1475.0
>155499939 25.2 %
> Engine 1 231820.6 1319.4
>139092375 22.5 %
> Engine 2 95911.5 545.9
>57546879 9.3 %
> Engine 3 120045.3 683.2
>72027189 11.7 %
> Engine 4 45873.6 261.1
>27524184 4.5 %
> Engine 5 275533.8 1568.2
>165320279 26.8 %
> ------------------------- ------------ ------------
>----------
> Total Bytes Rec'd 1028351.4 5852.7
>617010845
>
>
> Avg Bytes Rec'd per Packet n/a n/a
> 1119 n/a
>
>
>-----------------------------------------------------------------------------
>
> Total TDS Packets Sent per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
> Engine 0 263.6 1.5
>158175 10.7 %
> Engine 1 179.1 1.0
>107440 7.3 %
> Engine 2 656.7 3.7
>394011 26.7 %
> Engine 3 311.7 1.8
>187035 12.7 %
> Engine 4 233.8 1.3
>140287 9.5 %
> Engine 5 813.0 4.6
>487817 33.1 %
> ------------------------- ------------ ------------
>----------
> Total TDS Packets Sent 2457.9 14.0
>1474765
>
>
> Total Bytes Sent per sec per xact
> count % of total
> ------------------------- ------------ ------------
>---------- ----------
>Arithmetic overflow occurred.