Taylor
2009-11-25 11:52:12 UTC
Hi,
I got serious performance issue after migration from windows to
Solaris. I posted sysmon output below. Please advice.
Password:
===============================================================================
Sybase Adaptive Server Enterprise System Performance Report
===============================================================================
Server Version: Adaptive Server Enterprise/12.5.3/EBF 13325
ESD#7/P/Sun_
Server
Name:
Run Date: Nov 25,
2009
Sampling Started at: Nov 25, 2009
12:07:49
Sampling Ended at: Nov 25, 2009
12:17:49
Sample Interval:
00:10:00
Sample Mode: Reset
Counters
===============================================================================
Kernel Utilization
------------------
Your Runnable Process Search Count is set to
2000
and I/O Polling Process Count is set to
10
Engine Busy Utilization CPU Busy I/O Busy
Idle
------------------------ -------- -------- --------
Engine 0 31.4 % 0.4 % 68.2
%
CPU Yields by Engine per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Engine 0 33.5 16.2
20123 100.0 %
Network Checks
Non-Blocking 6449.6 3123.3
3869750 99.5 %
Blocking 33.5 16.2
20123 0.5 %
------------------------- ------------ ------------ ----------
Total Network I/O Checks 6483.1 3139.5
3889873
Avg Net I/Os per Check n/a n/a
0.00130 n/a
Disk I/O Checks
Total Disk I/O Checks 6494.3 3144.9
3896571 n/a
Checks Returning I/O 1125.7 545.1
675418 17.3 %
Avg Disk I/Os Returned n/a n/a
0.00513 n/a
===============================================================================
Worker Process Management
-------------------------
per sec per xact count %
of total
------------ ------------ ----------
----------
Worker Process Requests
Total Requests 0.0 0.0
0 n/a
Worker Process Usage
Total Used 0.0 0.0
0 n/a
Max Ever Used During Sample 0.0 0.0
0 n/a
Memory Requests for Worker Processes
Total Requests 0.0 0.0
0 n/a
Tuning Recommendations for Worker
Processes
-------------------------------------------
- Consider decreasing the 'number of worker processes'
configuration parameter.
===============================================================================
Parallel Query Management
-------------------------
Parallel Query Usage per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Total Parallel Queries 0.0 0.0
0 n/a
Merge Lock Requests per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Total # of Requests 0.0 0.0
0 n/a
Sort Buffer Waits per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Total # of Waits 0.0 0.0
0 n/a
===============================================================================
Task Management per sec per xact count %
of total
--------------------------- ------------ ------------ ----------
----------
Connections Opened 0.4 0.2
231 n/a
Task Context Switches by Engine
Engine 0 24.1 11.6
14433 100.0 %
Task Context Switches Due To:
Voluntary Yields 4.3 2.1
2582 17.9 %
Cache Search Misses 1.3 0.6
763 5.3 %
System Disk Writes 0.3 0.1
170 1.2 %
I/O Pacing 1.4 0.7
842 5.8 %
Logical Lock Contention 0.0 0.0
0 0.0 %
Address Lock Contention 0.0 0.0
0 0.0 %
Latch Contention 0.0 0.0
0 0.0 %
Log Semaphore Contention 0.0 0.0
0 0.0 %
PLC Lock Contention 0.0 0.0
0 0.0 %
Group Commit Sleeps 0.0 0.0
6 0.0 %
Last Log Page Writes 2.1 1.0
1272 8.8 %
Modify Conflicts 0.0 0.0
0 0.0 %
I/O Device Contention 0.0 0.0
0 0.0 %
Network Packet Received 4.3 2.1
2570 17.8 %
Network Packet Sent 1.2 0.6
731 5.1 %
Other Causes 9.2 4.4
5497 38.1 %
===============================================================================
Application Management
----------------------
Application Statistics Summary (All Applications)
-------------------------------------------------
Priority Changes per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
To High Priority 0.0 0.0
0 0.0 %
To Medium Priority 0.8 0.4
508 64.6 %
To Low Priority 0.5 0.2
278 35.4 %
------------------------- ------------ ------------ ----------
Total Priority Changes 1.3 0.6
786
Allotted Slices Exhausted per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
High Priority 0.0 0.0
0 0.0 %
Medium Priority 1.5 0.7
917 100.0 %
Low Priority 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
Total Slices Exhausted 1.5 0.7
917
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 22.8 11.1
13707 99.9 %
Dirty 0.0 0.0
7 0.1 %
------------ ------------
----------
Total Washes 22.9 11.1
13714
Garbage Collections 0.2 0.1
119 n/a
Pages Processed in GC 0.0 0.0
0 n/a
Statistics Updates 0.1 0.0
60 n/a
===============================================================================
Monitor Access to Executing SQL
-------------------------------
per sec per xact count %
of total
------------ ------------ ----------
----------
Waits on Execution Plans 0.0 0.0
0 n/a
Number of SQL Text Overflows 0.0 0.0
0 n/a
Maximum SQL Text Requested n/a n/a
458 n/a
(since beginning of
sample)
Tuning Recommendations for Monitor Access to Executing
SQL
----------------------------------------------------------
- Consider decreasing the 'max SQL text monitored' parameter
to 20709 (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 2.1 n/a
1239 n/a
Transaction Detail per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Inserts
APL Heap Table 8.7 4.2
5249 85.8 %
APL Clustered Table 1.3 0.6
768 12.6 %
Data Only Lock Table 0.2 0.1
98 1.6 %
------------------------- ------------ ------------ ----------
----------
Total Rows Inserted 10.2 4.9
6115 90.8 %
Updates
APL Deferred 0.0 0.0
12 100.0 %
APL Direct In-place 0.0 0.0
0 0.0 %
APL Direct Cheap 0.0 0.0
0 0.0 %
APL Direct Expensive 0.0 0.0
0 0.0 %
DOL Deferred 0.0 0.0
0 0.0 %
DOL Direct 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
----------
Total Rows Updated 0.0 0.0
12 0.2 %
Data Only Locked Updates
Total Rows Updated 0.0 0.0
0 n/a
------------------------- ------------ ------------ ----------
----------
Total DOL Rows Updated 0.0 0.0
0 0.0 %
Deletes
APL Deferred 0.7 0.3
410 67.7 %
APL Direct 0.2 0.1
98 16.2 %
DOL 0.2 0.1
98 16.2 %
------------------------- ------------ ------------ ----------
----------
Total Rows Deleted 1.0 0.5
606 9.0 %
========================= ============ ============ ==========
Total Rows Affected 11.2 5.4
6733
===============================================================================
Transaction Management
----------------------
ULC Flushes to Xact Log per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
by Full ULC 0.0 0.0
0 0.0 %
by End Transaction 1.6 0.8
968 38.2 %
by Change of Database 0.0 0.0
20 0.8 %
by Single Log Record 1.1 0.5
652 25.7 %
by Unpin 0.9 0.4
539 21.3 %
by Other 0.6 0.3
356 14.0 %
------------------------- ------------ ------------ ----------
Total ULC Flushes 4.2 2.0
2535
ULC Log Records 8.7 4.2
5228 n/a
Max ULC Size During Sample n/a n/a
2304 n/a
ULC Semaphore Requests
Granted 25.0 12.1
15004 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
Total ULC Semaphore Req 25.0 12.1
15004
Log Semaphore Requests
Granted 4.1 2.0
2475 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
Total Log Semaphore Req 4.1 2.0
2475
Transaction Log Writes 2.5 1.2
1528 n/a
Transaction Log Alloc 0.4 0.2
245 n/a
Avg # Writes per Log Page n/a n/a
6.23673 n/a
Tuning Recommendations for Transaction
Management
-------------------------------------------------
- Consider decreasing the 'user log cache size'
configuration parameter if it is greater than the
logical database page size.
===============================================================================
Index Management
----------------
Nonclustered Maintenance per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Ins/Upd Requiring Maint 0.2 0.1
98 n/a
# of NC Ndx Maint 0.2 0.1
98 n/a
Avg NC Ndx Maint / Op n/a n/a
1.00000 n/a
Deletes Requiring Maint 0.2 0.1
98 n/a
# of NC Ndx Maint 0.2 0.1
98 n/a
Avg NC Ndx Maint / Op n/a n/a
1.00000 n/a
RID Upd from Clust Split 0.0 0.0
0 n/a
# of NC Ndx Maint 0.0 0.0
0 n/a
Upd/Del DOL Req Maint 0.2 0.1
98 n/a
# of DOL Ndx Maint 0.2 0.1
98 n/a
Avg DOL Ndx Maint / Op n/a n/a
1.00000 n/a
Page Splits 0.0 0.0
0 n/a
Page Shrinks 0.0 0.0
0 n/a
Index Scans per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Ascending Scans 88.7 42.9
53208 14.0 %
DOL Ascending Scans 543.1 263.0
325887 85.9 %
Descending Scans 0.4 0.2
215 0.1 %
DOL Descending Scans 0.0 0.0
0 0.0 %
------------ ------------
----------
Total Scans 632.2 306.1
379310
===============================================================================
Metadata Cache Management
-------------------------
Metadata Cache Summary per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Open Object
Usage
Active n/a n/a
213 n/a
Max Ever Used Since Boot n/a n/a
213 n/a
Free n/a n/a
34787 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
167 n/a
Max Ever Used Since Boot n/a n/a
168 n/a
Free n/a n/a
4333 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
20 n/a
Max Ever Used Since Boot n/a n/a
20 n/a
Free n/a n/a
30 n/a
Reuse
Requests
Succeeded n/a n/a
0 n/a
Failed n/a n/a
0 n/a
Object Manager Spinlock Contention n/a n/a n/
a 0.0 %
Object Spinlock Contention n/a n/a n/
a 0.0 %
Index Spinlock Contention n/a n/a n/
a 0.0 %
Hash Spinlock Contention n/a n/a n/
a 0.0 %
===============================================================================
Lock Management
---------------
Lock Summary per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Total Lock Requests 259.7 125.7
155790 n/a
Avg Lock Contention 0.0 0.0
0 0.0 %
Deadlock Percentage 0.0 0.0
0 0.0 %
Lock Detail per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Table Lock Hashtable
Lookups 16.5 8.0
9904 n/a
Avg Chain Length n/a n/a
0.00919 n/a
Spinlock Contention n/a n/a n/
a 0.0 %
Exclusive Table
Granted 2.3 1.1
1373 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
----------
Total EX-Table Requests 2.3 1.1
1373 0.9 %
Shared Table
Granted 0.3 0.2
203 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
----------
Total SH-Table Requests 0.3 0.2
203 0.1 %
Exclusive Intent
Granted 2.3 1.1
1402 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
----------
Total EX-Intent Requests 2.3 1.1
1402 0.9 %
Shared Intent
Granted 11.2 5.4
6723 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
----------
Total SH-Intent Requests 11.2 5.4
6723 4.3 %
Page & Row Lock HashTable
Lookups 123.7 59.9
74214 n/a
Avg Chain Length n/a n/a
0.00039 n/a
Spinlock Contention n/a n/a n/
a 0.0 %
Exclusive Page
Granted 1.3 0.7
807 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
----------
Total EX-Page Requests 1.3 0.7
807 0.5 %
Update Page
Granted 1.0 0.5
617 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
----------
Total UP-Page Requests 1.0 0.5
617 0.4 %
Shared Page
Granted 102.4 49.6
61422 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
----------
Total SH-Page Requests 102.4 49.6
61422 39.4 %
Exclusive Row
Granted 0.4 0.2
264 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
----------
Total EX-Row Requests 0.4 0.2
264 0.2 %
Update Row
Granted 0.2 0.1
98 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
----------
Total UP-Row Requests 0.2 0.1
98 0.1 %
Shared Row
Granted 15.9 7.7
9519 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
----------
Total SH-Row Requests 15.9 7.7
9519 6.1 %
Next-Key
Total Next-Key Requests 0.0 0.0
0 n/a
Address Lock Hashtable
Lookups 122.3 59.2
73362 n/a
Avg Chain Length n/a n/a
0.01373 n/a
Spinlock Contention n/a n/a n/
a 0.0 %
Exclusive Address
Granted 1.8 0.9
1056 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
----------
Total EX-Address Requests 1.8 0.9
1056 0.7 %
Shared Address
Granted 120.5 58.4
72306 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
----------
Total SH-Address Requests 120.5 58.4
72306 46.4 %
Last Page Locks on Heaps
Granted 8.7 4.2
5249 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
----------
Total Last Pg Locks 8.7 4.2
5249 100.0 %
Deadlocks by Lock Type per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Total Deadlocks 0.0 0.0
0 n/a
Deadlock Detection
Deadlock Searches 0.0 0.0
0 n/a
Lock Promotions
Total Lock Promotions 0.0 0.0
0 n/a
Lock Timeouts by Lock Type per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Total Timeouts 0.0 0.0
0 n/a
===============================================================================
Data Cache Management
---------------------
Cache Statistics Summary (All Caches)
-------------------------------------
per sec per xact count %
of total
------------ ------------ ----------
----------
Cache Search Summary
Total Cache Hits 39735.0 19242.1
23841016 100.0 %
Total Cache Misses 1.3 0.6
764 0.0 %
------------------------- ------------ ------------ ----------
Total Cache Searches 39736.3 19242.8
23841780
Cache Turnover
Buffers Grabbed 1.3 0.6
764 n/a
Buffers Grabbed Dirty 0.0 0.0
0 0.0 %
Cache Strategy Summary
Cached (LRU) Buffers 39730.4 19239.9
23838267 100.0 %
Discarded (MRU) Buffers 0.4 0.2
211 0.0 %
Large I/O Usage
Large I/Os Performed 0.0 0.0
8 42.1 %
Large I/Os Denied due
to
Pool < Prefetch Size 0.0 0.0
1 5.3 %
Pages
Requested
Reside in
Another
Buffer Pool 0.0 0.0
10 52.6 %
------------------------- ------------ ------------ ----------
Total Large I/O Requests 0.0 0.0
19
Large I/O Effectiveness
Pages by Lrg I/O Cached 0.1 0.1
64 n/a
Pages by Lrg I/O Used 0.0 0.0
0 0.0 %
Asynchronous Prefetch Activity
APFs Issued 0.0 0.0
0 0.0 %
APFs Denied Due
To
APF I/O Overloads 0.0 0.0
0 0.0 %
APF Limit Overloads 0.0 0.0
0 0.0 %
APF Reused Overloads 0.0 0.0
0 0.0 %
APF Buffers Found in
Cache
With Spinlock Held 0.0 0.0
0 0.0 %
W/o Spinlock Held 8953.7 4335.9
5372205 100.0 %
------------------------- ------------ ------------ ----------
Total APFs Requested 8953.7 4335.9
5372205
Other Asynchronous Prefetch Statistics
APFs Used 0.0 0.0
0 n/a
APF Waits for I/O 0.0 0.0
0 n/a
APF Discards 0.0 0.0
0 n/a
Dirty Read Behavior
Page Requests 0.0 0.0
0 n/a
-------------------------------------------------------------------------------
Cache: default data
cache
per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Spinlock Contention n/a n/a n/
a 0.0 %
Utilization n/a n/a n/
a 100.0 %
Cache Searches
Cache Hits 39735.0 19242.1
23841016 100.0 %
Found in Wash 63.0 30.5
37778 0.2 %
Cache Misses 1.3 0.6
764 0.0 %
------------------------- ------------ ------------ ----------
Total Cache Searches 39736.3 19242.8
23841780
Pool Turnover
2 Kb
Pool
LRU Buffer Grab 1.3 0.6
756 99.0 %
Grabbed Dirty 0.0 0.0
0 0.0 %
16 Kb
Pool
LRU Buffer Grab 0.0 0.0
8 1.0 %
Grabbed Dirty 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
Total Cache Turnover 1.3 0.6
764
Buffer Wash Behavior
Statistics Not Available - No Buffers Entered Wash Section Yet
Cache Strategy
Cached (LRU) Buffers 39730.4 19239.9
23838267 100.0 %
Discarded (MRU) Buffers 0.4 0.2
211 0.0 %
Large I/O Usage
Large I/Os Performed 0.0 0.0
8 42.1 %
Large I/Os Denied due
to
Pool < Prefetch Size 0.0 0.0
1 5.3 %
Pages
Requested
Reside in
Another
Buffer Pool 0.0 0.0
10 52.6 %
------------------------- ------------ ------------ ----------
Total Large I/O Requests 0.0 0.0
19
Large I/O Detail
16 Kb
Pool
Pages Cached 0.1 0.1
64 n/a
Pages Used 0.0 0.0
0 0.0 %
Dirty Read Behavior
Page Requests 0.0 0.0 0 n/
a
===============================================================================
Procedure Cache Management per sec per xact count %
of total
--------------------------- ------------ ------------ ----------
----------
Procedure Requests 0.4 0.2
221 n/a
Procedure Reads from Disk 0.2 0.1
103 46.6 %
Procedure Writes to Disk 0.0 0.0
0 0.0 %
Procedure Removals 0.3 0.2
197 n/a
Procedure Recompilations 0.0 0.0
0 n/a
SQL Statement Cache:
Statements Cached 0.0 0.0
0 n/a
Statements Found in Cache 0.0 0.0
0 n/a
Statements Not Found 0.0 0.0
0 n/a
Statements Dropped 0.0 0.0
0 n/a
Statements Restored 0.0 0.0
0 n/a
Statements Not Cached 0.0 0.0
23 n/a
Tuning Recommendations for Procedure cache
management
-----------------------------------------------------
- Consider increasing the 'procedure cache size'
configuration parameter.
===============================================================================
Memory Management per sec per xact count %
of total
--------------------------- ------------ ------------ ----------
----------
Pages Allocated 0.4 0.2
261 n/a
Pages Released 0.4 0.2
253 n/a
===============================================================================
Recovery Management
-------------------
Checkpoints per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
# of Normal Checkpoints 0.0 0.0
29 100.0 %
# of Free Checkpoints 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
----------
Total Checkpoints 0.0 0.0
29
Avg Time per Normal Chkpt 0.24138
seconds
===============================================================================
Disk I/O Management
-------------------
Max Outstanding I/Os per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Server n/a n/a
14 n/a
Engine 0 n/a n/a
14 n/a
I/Os Delayed by
Disk I/O Structures n/a n/a
0 n/a
Server Config Limit n/a n/a
0 n/a
Engine Config Limit n/a n/a
0 n/a
Operating System Limit n/a n/a
0 n/a
Total Requested Disk I/Os 5.8 2.8
3466
Completed Disk I/O's
Engine 0 5.8 2.8
3465 100.0 %
------------------------- ------------ ------------
----------
Total Completed I/Os 5.8 2.8
3465
Device Activity Detail
----------------------
Device:
/dev/vx/rdsk/dscd04vg/
s02scd3data1
s02scd3data1 per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
11 100.0 %
Writes 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
----------
Total I/Os 0.0 0.0
11 0.3 %
-----------------------------------------------------------------------------
Device:
/dev/vx/rdsk/dscd04vg/
s02scd3data10
s02scd3data10 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:
/dev/vx/rdsk/dscd04vg/
s02scd3data11
s02scd3data11 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:
/dev/vx/rdsk/dscd04vg/
s02scd3data12
s02scd3data12 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:
/dev/vx/rdsk/dscd04vg/
s02scd3data13
s02scd3data13 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:
/dev/vx/rdsk/dscd04vg/
s02scd3data14
s02scd3data14 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:
/dev/vx/rdsk/dscd04vg/
s02scd3data15
s02scd3data15 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:
/dev/vx/rdsk/dscd04vg/
s02scd3data16
s02scd3data16 per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.1 0.1
62 96.9 %
Writes 0.0 0.0
2 3.1 %
------------------------- ------------ ------------ ----------
----------
Total I/Os 0.1 0.1
64 1.8 %
-----------------------------------------------------------------------------
Device:
/dev/vx/rdsk/dscd04vg/
s02scd3data2
s02scd3data2 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:
/dev/vx/rdsk/dscd04vg/
s02scd3data3
s02scd3data3 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:
/dev/vx/rdsk/dscd04vg/
s02scd3data4
s02scd3data4 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:
/dev/vx/rdsk/dscd04vg/
s02scd3data5
s02scd3data5 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:
/dev/vx/rdsk/dscd04vg/
s02scd3data6
s02scd3data6 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:
/dev/vx/rdsk/dscd04vg/
s02scd3data7
s02scd3data7 per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.2 0.1
127 90.1 %
Writes 0.0 0.0
14 9.9 %
------------------------- ------------ ------------ ----------
----------
Total I/Os 0.2 0.1
141 4.1 %
-----------------------------------------------------------------------------
Device:
/dev/vx/rdsk/dscd04vg/
s02scd3data8
s02scd3data8 per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.3 0.2
186 96.9 %
Writes 0.0 0.0
6 3.1 %
------------------------- ------------ ------------ ----------
----------
Total I/Os 0.3 0.2
192 5.5 %
-----------------------------------------------------------------------------
Device:
/dev/vx/rdsk/dscd04vg/
s02scd3data9
s02scd3data9 per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.2 0.1
124 96.9 %
Writes 0.0 0.0
4 3.1 %
------------------------- ------------ ------------ ----------
----------
Total I/Os 0.2 0.1
128 3.7 %
-----------------------------------------------------------------------------
Device:
/dev/vx/rdsk/dscd04vg/
s02scd3dbcc_data
s02scd3dbcc_data 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:
/dev/vx/rdsk/dscd04vg/
s02scd3dbcc_log
s02scd3dbcc_log 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:
/dev/vx/rdsk/dscd04vg/
s02scd3log1
s02scd3log1 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
13 100.0 %
------------------------- ------------ ------------ ----------
----------
Total I/Os 0.0 0.0
13 0.4 %
-----------------------------------------------------------------------------
Device:
/dev/vx/rdsk/dscd04vg/
s02scd3log2
s02scd3log2 per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
0 0.0 %
Writes 0.0 0.0
2 100.0 %
------------------------- ------------ ------------ ----------
----------
Total I/Os 0.0 0.0
2 0.1 %
-----------------------------------------------------------------------------
Device:
/dev/vx/rdsk/dscd04vg/
s02scd3master
master per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.2 0.1
131 42.4 %
Writes 0.3 0.1
178 57.6 %
------------------------- ------------ ------------ ----------
----------
Total I/Os 0.5 0.2
309 8.9 %
-----------------------------------------------------------------------------
Device:
/dev/vx/rdsk/dscd04vg/
s02scd3sybarchdata
s02scd3sybarchdata 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:
/dev/vx/rdsk/dscd04vg/
s02scd3sybarchlog
s02scd3sybarchlog 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:
/dev/vx/rdsk/dscd04vg/
s02scd3sybsecdata
s02scd3sybsecdata 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 1.4 0.7
846 100.0 %
------------------------- ------------ ------------ ----------
----------
Total I/Os 1.4 0.7
846 24.4 %
-----------------------------------------------------------------------------
Device:
/dev/vx/rdsk/dscd04vg/
s02scd3sybseclog
s02scd3sybseclog 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 2.2 1.0
1291 100.0 %
------------------------- ------------ ------------ ----------
----------
Total I/Os 2.2 1.0
1291 37.2 %
-----------------------------------------------------------------------------
Device:
/dev/vx/rdsk/dscd04vg/
s02scd3sybsysdata
s02scd3sybsysdata 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:
/dev/vx/rdsk/dscd04vg/
s02scd3sybsyslog
s02scd3sybsyslog 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:
/dev/vx/rdsk/dscd04vg/
s02scd3sybsysprocs
sysprocsdev per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.2 0.1
121 100.0 %
Writes 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
----------
Total I/Os 0.2 0.1
121 3.5 %
-----------------------------------------------------------------------------
Device:
/dscd04/scd/s02scd3tempdbdata/
tempdb_data.DONT_TOUCH
s02scd3tempdbdata per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
0 0.0 %
Writes 0.2 0.1
110 100.0 %
------------------------- ------------ ------------ ----------
----------
Total I/Os 0.2 0.1
110 3.2 %
-----------------------------------------------------------------------------
Device:
/dscd04/scd/s02scd3tempdblog/
tempdb_log.DONT_TOUCH
s02scd3tempdblog per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
1 0.4 %
Writes 0.4 0.2
237 99.6 %
------------------------- ------------ ------------ ----------
----------
Total I/Os 0.4 0.2
238 6.9 %
-----------------------------------------------------------------------------
===============================================================================
Network I/O Management
----------------------
Total Network I/O Requests 5.5 2.7
3301 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 4.3 2.1
2567 100.0 %
------------------------- ------------ ------------
----------
Total TDS Packets Rec'd 4.3 2.1
2567
Total Bytes Received per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Engine 0 420.5 203.6
252294 100.0 %
------------------------- ------------ ------------
----------
Total Bytes Rec'd 420.5 203.6
252294
Avg Bytes Rec'd per Packet n/a n/a
98 n/a
-----------------------------------------------------------------------------
Total TDS Packets Sent per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Engine 0 4.1 2.0
2480 100.0 %
------------------------- ------------ ------------
----------
Total TDS Packets Sent 4.1 2.0
2480
Total Bytes Sent per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Engine 0 802.4 388.6
481452 100.0 %
------------------------- ------------ ------------
----------
Total Bytes Sent 802.4 388.6
481452
Avg Bytes Sent per Packet n/a n/a
194 n/a
=============================== End of Report
=================================
(return status = 0)
I got serious performance issue after migration from windows to
Solaris. I posted sysmon output below. Please advice.
Password:
===============================================================================
Sybase Adaptive Server Enterprise System Performance Report
===============================================================================
Server Version: Adaptive Server Enterprise/12.5.3/EBF 13325
ESD#7/P/Sun_
Server
Name:
Run Date: Nov 25,
2009
Sampling Started at: Nov 25, 2009
12:07:49
Sampling Ended at: Nov 25, 2009
12:17:49
Sample Interval:
00:10:00
Sample Mode: Reset
Counters
===============================================================================
Kernel Utilization
------------------
Your Runnable Process Search Count is set to
2000
and I/O Polling Process Count is set to
10
Engine Busy Utilization CPU Busy I/O Busy
Idle
------------------------ -------- -------- --------
Engine 0 31.4 % 0.4 % 68.2
%
CPU Yields by Engine per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Engine 0 33.5 16.2
20123 100.0 %
Network Checks
Non-Blocking 6449.6 3123.3
3869750 99.5 %
Blocking 33.5 16.2
20123 0.5 %
------------------------- ------------ ------------ ----------
Total Network I/O Checks 6483.1 3139.5
3889873
Avg Net I/Os per Check n/a n/a
0.00130 n/a
Disk I/O Checks
Total Disk I/O Checks 6494.3 3144.9
3896571 n/a
Checks Returning I/O 1125.7 545.1
675418 17.3 %
Avg Disk I/Os Returned n/a n/a
0.00513 n/a
===============================================================================
Worker Process Management
-------------------------
per sec per xact count %
of total
------------ ------------ ----------
----------
Worker Process Requests
Total Requests 0.0 0.0
0 n/a
Worker Process Usage
Total Used 0.0 0.0
0 n/a
Max Ever Used During Sample 0.0 0.0
0 n/a
Memory Requests for Worker Processes
Total Requests 0.0 0.0
0 n/a
Tuning Recommendations for Worker
Processes
-------------------------------------------
- Consider decreasing the 'number of worker processes'
configuration parameter.
===============================================================================
Parallel Query Management
-------------------------
Parallel Query Usage per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Total Parallel Queries 0.0 0.0
0 n/a
Merge Lock Requests per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Total # of Requests 0.0 0.0
0 n/a
Sort Buffer Waits per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Total # of Waits 0.0 0.0
0 n/a
===============================================================================
Task Management per sec per xact count %
of total
--------------------------- ------------ ------------ ----------
----------
Connections Opened 0.4 0.2
231 n/a
Task Context Switches by Engine
Engine 0 24.1 11.6
14433 100.0 %
Task Context Switches Due To:
Voluntary Yields 4.3 2.1
2582 17.9 %
Cache Search Misses 1.3 0.6
763 5.3 %
System Disk Writes 0.3 0.1
170 1.2 %
I/O Pacing 1.4 0.7
842 5.8 %
Logical Lock Contention 0.0 0.0
0 0.0 %
Address Lock Contention 0.0 0.0
0 0.0 %
Latch Contention 0.0 0.0
0 0.0 %
Log Semaphore Contention 0.0 0.0
0 0.0 %
PLC Lock Contention 0.0 0.0
0 0.0 %
Group Commit Sleeps 0.0 0.0
6 0.0 %
Last Log Page Writes 2.1 1.0
1272 8.8 %
Modify Conflicts 0.0 0.0
0 0.0 %
I/O Device Contention 0.0 0.0
0 0.0 %
Network Packet Received 4.3 2.1
2570 17.8 %
Network Packet Sent 1.2 0.6
731 5.1 %
Other Causes 9.2 4.4
5497 38.1 %
===============================================================================
Application Management
----------------------
Application Statistics Summary (All Applications)
-------------------------------------------------
Priority Changes per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
To High Priority 0.0 0.0
0 0.0 %
To Medium Priority 0.8 0.4
508 64.6 %
To Low Priority 0.5 0.2
278 35.4 %
------------------------- ------------ ------------ ----------
Total Priority Changes 1.3 0.6
786
Allotted Slices Exhausted per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
High Priority 0.0 0.0
0 0.0 %
Medium Priority 1.5 0.7
917 100.0 %
Low Priority 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
Total Slices Exhausted 1.5 0.7
917
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 22.8 11.1
13707 99.9 %
Dirty 0.0 0.0
7 0.1 %
------------ ------------
----------
Total Washes 22.9 11.1
13714
Garbage Collections 0.2 0.1
119 n/a
Pages Processed in GC 0.0 0.0
0 n/a
Statistics Updates 0.1 0.0
60 n/a
===============================================================================
Monitor Access to Executing SQL
-------------------------------
per sec per xact count %
of total
------------ ------------ ----------
----------
Waits on Execution Plans 0.0 0.0
0 n/a
Number of SQL Text Overflows 0.0 0.0
0 n/a
Maximum SQL Text Requested n/a n/a
458 n/a
(since beginning of
sample)
Tuning Recommendations for Monitor Access to Executing
SQL
----------------------------------------------------------
- Consider decreasing the 'max SQL text monitored' parameter
to 20709 (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 2.1 n/a
1239 n/a
Transaction Detail per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Inserts
APL Heap Table 8.7 4.2
5249 85.8 %
APL Clustered Table 1.3 0.6
768 12.6 %
Data Only Lock Table 0.2 0.1
98 1.6 %
------------------------- ------------ ------------ ----------
----------
Total Rows Inserted 10.2 4.9
6115 90.8 %
Updates
APL Deferred 0.0 0.0
12 100.0 %
APL Direct In-place 0.0 0.0
0 0.0 %
APL Direct Cheap 0.0 0.0
0 0.0 %
APL Direct Expensive 0.0 0.0
0 0.0 %
DOL Deferred 0.0 0.0
0 0.0 %
DOL Direct 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
----------
Total Rows Updated 0.0 0.0
12 0.2 %
Data Only Locked Updates
Total Rows Updated 0.0 0.0
0 n/a
------------------------- ------------ ------------ ----------
----------
Total DOL Rows Updated 0.0 0.0
0 0.0 %
Deletes
APL Deferred 0.7 0.3
410 67.7 %
APL Direct 0.2 0.1
98 16.2 %
DOL 0.2 0.1
98 16.2 %
------------------------- ------------ ------------ ----------
----------
Total Rows Deleted 1.0 0.5
606 9.0 %
========================= ============ ============ ==========
Total Rows Affected 11.2 5.4
6733
===============================================================================
Transaction Management
----------------------
ULC Flushes to Xact Log per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
by Full ULC 0.0 0.0
0 0.0 %
by End Transaction 1.6 0.8
968 38.2 %
by Change of Database 0.0 0.0
20 0.8 %
by Single Log Record 1.1 0.5
652 25.7 %
by Unpin 0.9 0.4
539 21.3 %
by Other 0.6 0.3
356 14.0 %
------------------------- ------------ ------------ ----------
Total ULC Flushes 4.2 2.0
2535
ULC Log Records 8.7 4.2
5228 n/a
Max ULC Size During Sample n/a n/a
2304 n/a
ULC Semaphore Requests
Granted 25.0 12.1
15004 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
Total ULC Semaphore Req 25.0 12.1
15004
Log Semaphore Requests
Granted 4.1 2.0
2475 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
Total Log Semaphore Req 4.1 2.0
2475
Transaction Log Writes 2.5 1.2
1528 n/a
Transaction Log Alloc 0.4 0.2
245 n/a
Avg # Writes per Log Page n/a n/a
6.23673 n/a
Tuning Recommendations for Transaction
Management
-------------------------------------------------
- Consider decreasing the 'user log cache size'
configuration parameter if it is greater than the
logical database page size.
===============================================================================
Index Management
----------------
Nonclustered Maintenance per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Ins/Upd Requiring Maint 0.2 0.1
98 n/a
# of NC Ndx Maint 0.2 0.1
98 n/a
Avg NC Ndx Maint / Op n/a n/a
1.00000 n/a
Deletes Requiring Maint 0.2 0.1
98 n/a
# of NC Ndx Maint 0.2 0.1
98 n/a
Avg NC Ndx Maint / Op n/a n/a
1.00000 n/a
RID Upd from Clust Split 0.0 0.0
0 n/a
# of NC Ndx Maint 0.0 0.0
0 n/a
Upd/Del DOL Req Maint 0.2 0.1
98 n/a
# of DOL Ndx Maint 0.2 0.1
98 n/a
Avg DOL Ndx Maint / Op n/a n/a
1.00000 n/a
Page Splits 0.0 0.0
0 n/a
Page Shrinks 0.0 0.0
0 n/a
Index Scans per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Ascending Scans 88.7 42.9
53208 14.0 %
DOL Ascending Scans 543.1 263.0
325887 85.9 %
Descending Scans 0.4 0.2
215 0.1 %
DOL Descending Scans 0.0 0.0
0 0.0 %
------------ ------------
----------
Total Scans 632.2 306.1
379310
===============================================================================
Metadata Cache Management
-------------------------
Metadata Cache Summary per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Open Object
Usage
Active n/a n/a
213 n/a
Max Ever Used Since Boot n/a n/a
213 n/a
Free n/a n/a
34787 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
167 n/a
Max Ever Used Since Boot n/a n/a
168 n/a
Free n/a n/a
4333 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
20 n/a
Max Ever Used Since Boot n/a n/a
20 n/a
Free n/a n/a
30 n/a
Reuse
Requests
Succeeded n/a n/a
0 n/a
Failed n/a n/a
0 n/a
Object Manager Spinlock Contention n/a n/a n/
a 0.0 %
Object Spinlock Contention n/a n/a n/
a 0.0 %
Index Spinlock Contention n/a n/a n/
a 0.0 %
Hash Spinlock Contention n/a n/a n/
a 0.0 %
===============================================================================
Lock Management
---------------
Lock Summary per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Total Lock Requests 259.7 125.7
155790 n/a
Avg Lock Contention 0.0 0.0
0 0.0 %
Deadlock Percentage 0.0 0.0
0 0.0 %
Lock Detail per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Table Lock Hashtable
Lookups 16.5 8.0
9904 n/a
Avg Chain Length n/a n/a
0.00919 n/a
Spinlock Contention n/a n/a n/
a 0.0 %
Exclusive Table
Granted 2.3 1.1
1373 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
----------
Total EX-Table Requests 2.3 1.1
1373 0.9 %
Shared Table
Granted 0.3 0.2
203 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
----------
Total SH-Table Requests 0.3 0.2
203 0.1 %
Exclusive Intent
Granted 2.3 1.1
1402 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
----------
Total EX-Intent Requests 2.3 1.1
1402 0.9 %
Shared Intent
Granted 11.2 5.4
6723 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
----------
Total SH-Intent Requests 11.2 5.4
6723 4.3 %
Page & Row Lock HashTable
Lookups 123.7 59.9
74214 n/a
Avg Chain Length n/a n/a
0.00039 n/a
Spinlock Contention n/a n/a n/
a 0.0 %
Exclusive Page
Granted 1.3 0.7
807 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
----------
Total EX-Page Requests 1.3 0.7
807 0.5 %
Update Page
Granted 1.0 0.5
617 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
----------
Total UP-Page Requests 1.0 0.5
617 0.4 %
Shared Page
Granted 102.4 49.6
61422 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
----------
Total SH-Page Requests 102.4 49.6
61422 39.4 %
Exclusive Row
Granted 0.4 0.2
264 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
----------
Total EX-Row Requests 0.4 0.2
264 0.2 %
Update Row
Granted 0.2 0.1
98 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
----------
Total UP-Row Requests 0.2 0.1
98 0.1 %
Shared Row
Granted 15.9 7.7
9519 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
----------
Total SH-Row Requests 15.9 7.7
9519 6.1 %
Next-Key
Total Next-Key Requests 0.0 0.0
0 n/a
Address Lock Hashtable
Lookups 122.3 59.2
73362 n/a
Avg Chain Length n/a n/a
0.01373 n/a
Spinlock Contention n/a n/a n/
a 0.0 %
Exclusive Address
Granted 1.8 0.9
1056 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
----------
Total EX-Address Requests 1.8 0.9
1056 0.7 %
Shared Address
Granted 120.5 58.4
72306 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
----------
Total SH-Address Requests 120.5 58.4
72306 46.4 %
Last Page Locks on Heaps
Granted 8.7 4.2
5249 100.0 %
Waited 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
----------
Total Last Pg Locks 8.7 4.2
5249 100.0 %
Deadlocks by Lock Type per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Total Deadlocks 0.0 0.0
0 n/a
Deadlock Detection
Deadlock Searches 0.0 0.0
0 n/a
Lock Promotions
Total Lock Promotions 0.0 0.0
0 n/a
Lock Timeouts by Lock Type per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Total Timeouts 0.0 0.0
0 n/a
===============================================================================
Data Cache Management
---------------------
Cache Statistics Summary (All Caches)
-------------------------------------
per sec per xact count %
of total
------------ ------------ ----------
----------
Cache Search Summary
Total Cache Hits 39735.0 19242.1
23841016 100.0 %
Total Cache Misses 1.3 0.6
764 0.0 %
------------------------- ------------ ------------ ----------
Total Cache Searches 39736.3 19242.8
23841780
Cache Turnover
Buffers Grabbed 1.3 0.6
764 n/a
Buffers Grabbed Dirty 0.0 0.0
0 0.0 %
Cache Strategy Summary
Cached (LRU) Buffers 39730.4 19239.9
23838267 100.0 %
Discarded (MRU) Buffers 0.4 0.2
211 0.0 %
Large I/O Usage
Large I/Os Performed 0.0 0.0
8 42.1 %
Large I/Os Denied due
to
Pool < Prefetch Size 0.0 0.0
1 5.3 %
Pages
Requested
Reside in
Another
Buffer Pool 0.0 0.0
10 52.6 %
------------------------- ------------ ------------ ----------
Total Large I/O Requests 0.0 0.0
19
Large I/O Effectiveness
Pages by Lrg I/O Cached 0.1 0.1
64 n/a
Pages by Lrg I/O Used 0.0 0.0
0 0.0 %
Asynchronous Prefetch Activity
APFs Issued 0.0 0.0
0 0.0 %
APFs Denied Due
To
APF I/O Overloads 0.0 0.0
0 0.0 %
APF Limit Overloads 0.0 0.0
0 0.0 %
APF Reused Overloads 0.0 0.0
0 0.0 %
APF Buffers Found in
Cache
With Spinlock Held 0.0 0.0
0 0.0 %
W/o Spinlock Held 8953.7 4335.9
5372205 100.0 %
------------------------- ------------ ------------ ----------
Total APFs Requested 8953.7 4335.9
5372205
Other Asynchronous Prefetch Statistics
APFs Used 0.0 0.0
0 n/a
APF Waits for I/O 0.0 0.0
0 n/a
APF Discards 0.0 0.0
0 n/a
Dirty Read Behavior
Page Requests 0.0 0.0
0 n/a
-------------------------------------------------------------------------------
Cache: default data
cache
per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Spinlock Contention n/a n/a n/
a 0.0 %
Utilization n/a n/a n/
a 100.0 %
Cache Searches
Cache Hits 39735.0 19242.1
23841016 100.0 %
Found in Wash 63.0 30.5
37778 0.2 %
Cache Misses 1.3 0.6
764 0.0 %
------------------------- ------------ ------------ ----------
Total Cache Searches 39736.3 19242.8
23841780
Pool Turnover
2 Kb
Pool
LRU Buffer Grab 1.3 0.6
756 99.0 %
Grabbed Dirty 0.0 0.0
0 0.0 %
16 Kb
Pool
LRU Buffer Grab 0.0 0.0
8 1.0 %
Grabbed Dirty 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
Total Cache Turnover 1.3 0.6
764
Buffer Wash Behavior
Statistics Not Available - No Buffers Entered Wash Section Yet
Cache Strategy
Cached (LRU) Buffers 39730.4 19239.9
23838267 100.0 %
Discarded (MRU) Buffers 0.4 0.2
211 0.0 %
Large I/O Usage
Large I/Os Performed 0.0 0.0
8 42.1 %
Large I/Os Denied due
to
Pool < Prefetch Size 0.0 0.0
1 5.3 %
Pages
Requested
Reside in
Another
Buffer Pool 0.0 0.0
10 52.6 %
------------------------- ------------ ------------ ----------
Total Large I/O Requests 0.0 0.0
19
Large I/O Detail
16 Kb
Pool
Pages Cached 0.1 0.1
64 n/a
Pages Used 0.0 0.0
0 0.0 %
Dirty Read Behavior
Page Requests 0.0 0.0 0 n/
a
===============================================================================
Procedure Cache Management per sec per xact count %
of total
--------------------------- ------------ ------------ ----------
----------
Procedure Requests 0.4 0.2
221 n/a
Procedure Reads from Disk 0.2 0.1
103 46.6 %
Procedure Writes to Disk 0.0 0.0
0 0.0 %
Procedure Removals 0.3 0.2
197 n/a
Procedure Recompilations 0.0 0.0
0 n/a
SQL Statement Cache:
Statements Cached 0.0 0.0
0 n/a
Statements Found in Cache 0.0 0.0
0 n/a
Statements Not Found 0.0 0.0
0 n/a
Statements Dropped 0.0 0.0
0 n/a
Statements Restored 0.0 0.0
0 n/a
Statements Not Cached 0.0 0.0
23 n/a
Tuning Recommendations for Procedure cache
management
-----------------------------------------------------
- Consider increasing the 'procedure cache size'
configuration parameter.
===============================================================================
Memory Management per sec per xact count %
of total
--------------------------- ------------ ------------ ----------
----------
Pages Allocated 0.4 0.2
261 n/a
Pages Released 0.4 0.2
253 n/a
===============================================================================
Recovery Management
-------------------
Checkpoints per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
# of Normal Checkpoints 0.0 0.0
29 100.0 %
# of Free Checkpoints 0.0 0.0
0 0.0 %
------------------------- ------------ ------------
----------
Total Checkpoints 0.0 0.0
29
Avg Time per Normal Chkpt 0.24138
seconds
===============================================================================
Disk I/O Management
-------------------
Max Outstanding I/Os per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Server n/a n/a
14 n/a
Engine 0 n/a n/a
14 n/a
I/Os Delayed by
Disk I/O Structures n/a n/a
0 n/a
Server Config Limit n/a n/a
0 n/a
Engine Config Limit n/a n/a
0 n/a
Operating System Limit n/a n/a
0 n/a
Total Requested Disk I/Os 5.8 2.8
3466
Completed Disk I/O's
Engine 0 5.8 2.8
3465 100.0 %
------------------------- ------------ ------------
----------
Total Completed I/Os 5.8 2.8
3465
Device Activity Detail
----------------------
Device:
/dev/vx/rdsk/dscd04vg/
s02scd3data1
s02scd3data1 per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
11 100.0 %
Writes 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
----------
Total I/Os 0.0 0.0
11 0.3 %
-----------------------------------------------------------------------------
Device:
/dev/vx/rdsk/dscd04vg/
s02scd3data10
s02scd3data10 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:
/dev/vx/rdsk/dscd04vg/
s02scd3data11
s02scd3data11 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:
/dev/vx/rdsk/dscd04vg/
s02scd3data12
s02scd3data12 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:
/dev/vx/rdsk/dscd04vg/
s02scd3data13
s02scd3data13 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:
/dev/vx/rdsk/dscd04vg/
s02scd3data14
s02scd3data14 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:
/dev/vx/rdsk/dscd04vg/
s02scd3data15
s02scd3data15 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:
/dev/vx/rdsk/dscd04vg/
s02scd3data16
s02scd3data16 per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.1 0.1
62 96.9 %
Writes 0.0 0.0
2 3.1 %
------------------------- ------------ ------------ ----------
----------
Total I/Os 0.1 0.1
64 1.8 %
-----------------------------------------------------------------------------
Device:
/dev/vx/rdsk/dscd04vg/
s02scd3data2
s02scd3data2 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:
/dev/vx/rdsk/dscd04vg/
s02scd3data3
s02scd3data3 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:
/dev/vx/rdsk/dscd04vg/
s02scd3data4
s02scd3data4 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:
/dev/vx/rdsk/dscd04vg/
s02scd3data5
s02scd3data5 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:
/dev/vx/rdsk/dscd04vg/
s02scd3data6
s02scd3data6 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:
/dev/vx/rdsk/dscd04vg/
s02scd3data7
s02scd3data7 per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.2 0.1
127 90.1 %
Writes 0.0 0.0
14 9.9 %
------------------------- ------------ ------------ ----------
----------
Total I/Os 0.2 0.1
141 4.1 %
-----------------------------------------------------------------------------
Device:
/dev/vx/rdsk/dscd04vg/
s02scd3data8
s02scd3data8 per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.3 0.2
186 96.9 %
Writes 0.0 0.0
6 3.1 %
------------------------- ------------ ------------ ----------
----------
Total I/Os 0.3 0.2
192 5.5 %
-----------------------------------------------------------------------------
Device:
/dev/vx/rdsk/dscd04vg/
s02scd3data9
s02scd3data9 per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.2 0.1
124 96.9 %
Writes 0.0 0.0
4 3.1 %
------------------------- ------------ ------------ ----------
----------
Total I/Os 0.2 0.1
128 3.7 %
-----------------------------------------------------------------------------
Device:
/dev/vx/rdsk/dscd04vg/
s02scd3dbcc_data
s02scd3dbcc_data 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:
/dev/vx/rdsk/dscd04vg/
s02scd3dbcc_log
s02scd3dbcc_log 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:
/dev/vx/rdsk/dscd04vg/
s02scd3log1
s02scd3log1 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
13 100.0 %
------------------------- ------------ ------------ ----------
----------
Total I/Os 0.0 0.0
13 0.4 %
-----------------------------------------------------------------------------
Device:
/dev/vx/rdsk/dscd04vg/
s02scd3log2
s02scd3log2 per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
0 0.0 %
Writes 0.0 0.0
2 100.0 %
------------------------- ------------ ------------ ----------
----------
Total I/Os 0.0 0.0
2 0.1 %
-----------------------------------------------------------------------------
Device:
/dev/vx/rdsk/dscd04vg/
s02scd3master
master per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.2 0.1
131 42.4 %
Writes 0.3 0.1
178 57.6 %
------------------------- ------------ ------------ ----------
----------
Total I/Os 0.5 0.2
309 8.9 %
-----------------------------------------------------------------------------
Device:
/dev/vx/rdsk/dscd04vg/
s02scd3sybarchdata
s02scd3sybarchdata 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:
/dev/vx/rdsk/dscd04vg/
s02scd3sybarchlog
s02scd3sybarchlog 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:
/dev/vx/rdsk/dscd04vg/
s02scd3sybsecdata
s02scd3sybsecdata 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 1.4 0.7
846 100.0 %
------------------------- ------------ ------------ ----------
----------
Total I/Os 1.4 0.7
846 24.4 %
-----------------------------------------------------------------------------
Device:
/dev/vx/rdsk/dscd04vg/
s02scd3sybseclog
s02scd3sybseclog 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 2.2 1.0
1291 100.0 %
------------------------- ------------ ------------ ----------
----------
Total I/Os 2.2 1.0
1291 37.2 %
-----------------------------------------------------------------------------
Device:
/dev/vx/rdsk/dscd04vg/
s02scd3sybsysdata
s02scd3sybsysdata 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:
/dev/vx/rdsk/dscd04vg/
s02scd3sybsyslog
s02scd3sybsyslog 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:
/dev/vx/rdsk/dscd04vg/
s02scd3sybsysprocs
sysprocsdev per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.2 0.1
121 100.0 %
Writes 0.0 0.0
0 0.0 %
------------------------- ------------ ------------ ----------
----------
Total I/Os 0.2 0.1
121 3.5 %
-----------------------------------------------------------------------------
Device:
/dscd04/scd/s02scd3tempdbdata/
tempdb_data.DONT_TOUCH
s02scd3tempdbdata per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
0 0.0 %
Writes 0.2 0.1
110 100.0 %
------------------------- ------------ ------------ ----------
----------
Total I/Os 0.2 0.1
110 3.2 %
-----------------------------------------------------------------------------
Device:
/dscd04/scd/s02scd3tempdblog/
tempdb_log.DONT_TOUCH
s02scd3tempdblog per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Reads
APF 0.0 0.0
0 0.0 %
Non-APF 0.0 0.0
1 0.4 %
Writes 0.4 0.2
237 99.6 %
------------------------- ------------ ------------ ----------
----------
Total I/Os 0.4 0.2
238 6.9 %
-----------------------------------------------------------------------------
===============================================================================
Network I/O Management
----------------------
Total Network I/O Requests 5.5 2.7
3301 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 4.3 2.1
2567 100.0 %
------------------------- ------------ ------------
----------
Total TDS Packets Rec'd 4.3 2.1
2567
Total Bytes Received per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Engine 0 420.5 203.6
252294 100.0 %
------------------------- ------------ ------------
----------
Total Bytes Rec'd 420.5 203.6
252294
Avg Bytes Rec'd per Packet n/a n/a
98 n/a
-----------------------------------------------------------------------------
Total TDS Packets Sent per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Engine 0 4.1 2.0
2480 100.0 %
------------------------- ------------ ------------
----------
Total TDS Packets Sent 4.1 2.0
2480
Total Bytes Sent per sec per xact count %
of total
------------------------- ------------ ------------ ----------
----------
Engine 0 802.4 388.6
481452 100.0 %
------------------------- ------------ ------------
----------
Total Bytes Sent 802.4 388.6
481452
Avg Bytes Sent per Packet n/a n/a
194 n/a
=============================== End of Report
=================================
(return status = 0)