你的内存是怎么使用的?
建议只把tempdb绑到高速缓冲上,把其余的命名缓冲都去掉,同时加大default cache
max memory=?
感谢您对我问题的答复,对您的帮助表示谢意
在系统运营没有缓慢之前,高速缓存只有电子工单,话务库和临时库
在系统运营变慢之后,增加了告警库的高速缓存,同时加大了默认高速缓存大小。
调整之后,系统速度得到提升,不过昨天系统调整8小时候,共单库出现了阻塞,虽然没有影响其他库
但是工单库已基本无法使用,sp_who,看到一个进程在对该库进行rollback,sp_lock不能出任何结果。
找不到阻塞在那个表上,没有办法,最后重启了server。
去掉其余命令缓存是否会导致系统变慢?
机器为HP9300
CPU 10颗
内存 32G
sybase使用内存16G(本周准备修改机器文件,加大sybase使用内存为24G)
目前datacache分配情况如下:
Cache Name Config Size Run Size Overhead
------------------------ ------------- ---------- ----------
awsdyndb_ews_cache 256.00 Mb 256.00 Mb 6.96 Mb
awsdyndb_ews_task_cache1024.00 Mb 1024.00 Mb 27.39 Mb
default data cache 2048.00 Mb 2048.00 Mb 54.11 Mb
telalm_cache 2048.00 Mb 2048.00 Mb 54.04 Mb
tempdb_cache 2048.00 Mb 2048.00 Mb 54.11 Mb
worktradb_cache 1024.00 Mb 1024.00 Mb 27.11 Mb
Memory Available For Memory Configured
Named Caches To Named Caches
-------------------- ----------------
8447.95 Mb 8448.00 Mb
------------------ Cache Binding Information: ------------------
Cache Name Entity Name Type Index Name Status
---------- ----------- ---- ---------- ------
awsdyndb_ews_cache awsdyndb.dbo.EWS table V
awsdyndb_ews_task_cache awsdyndb.dbo.EWS_TASK table V
tempdb_cache tempdb database V
worktradb_cache worktradb database V
telalm_cache telalmdb database V
(return status = 0)
内存使用情况如下:
Memory Usage:
Meg. 2K Blks Bytes
Configured Memory: 16384.0000 8388608 17179869184
Non Dynamic Structures: 85.1837 43615 89321594
Dynamic Structures: 4335.7285 2219893 4546340864
Cache Memory: 8672.7031 4440424 9093988352
Proc Cache Memory: 102.5879 52525 107571200
Unused Memory: 3192.1699 1634391 3347232768
Buffer Cache Memory, Top 4:
Cache Buf Pool DB Id Object Id Index Id Meg.
default data c 7 8 0 6.7031
8K 7 8 0 1.3438
16K 7 8 0 5.3594
default data c 5 8 0 0.2891
8K 5 8 0 0.0078
16K 5 8 0 0.2812
default data c 31513 8 0 0.0156
16K 31513 8 0 0.0156
default data c 31514 8 0 0.0156
16K 31514 8 0 0.0156
Procedure Cache, Top 20:
Database Id: 31514
Object Id: 1788530374
Object Name: sp_sysmon_locks
Version: 1
Uid: 1
Type: stored procedure
Number of trees: 0
Size of trees: 0.000000 Mb, 0.000000 bytes, 0 pages
Bytes lost for alignment 0 (Percentage of total: 0.000000)
Number of plans: 1
Size of plans: 1.253392 Mb, 1314277.000000 bytes, 645 pages
Bytes lost for alignment 18502 (Percentage of total: 1.407770)
----
Database Id: 31514
Object Id: 1804530431
Object Name: sp_sysmon_dcache_dtl
Version: 1
Uid: 1
Type: stored procedure
Number of trees: 0
Size of trees: 0.000000 Mb, 0.000000 bytes, 0 pages
Bytes lost for alignment 0 (Percentage of total: 0.000000)
Number of plans: 1
Size of plans: 0.633877 Mb, 664668.000000 bytes, 326 pages
Bytes lost for alignment 12316 (Percentage of total: 1.852955)
----
Database Id: 31514
Object Id: 1292528607
Object Name: sp_cacheconfig
Version: 1
Uid: 1
Type: stored procedure
Number of trees: 0
Size of trees: 0.000000 Mb, 0.000000 bytes, 0 pages
Bytes lost for alignment 0 (Percentage of total: 0.000000)
Number of plans: 1
Size of plans: 0.610023 Mb, 639655.000000 bytes, 313 pages
Bytes lost for alignment 9164 (Percentage of total: 1.432647)
----
Database Id: 31514
Object Id: 1776006327
Object Name: sp_helpdb
Version: 1
Uid: 1
Type: stored procedure
Number of trees: 0
Size of trees: 0.000000 Mb, 0.000000 bytes, 0 pages
Bytes lost for alignment 0 (Percentage of total: 0.000000)
Number of plans: 1
Size of plans: 0.550042 Mb, 576761.000000 bytes, 283 pages
Bytes lost for alignment 10483 (Percentage of total: 1.817564)
----
Database Id: 31514
Object Id: 1932530887
Object Name: sp_sysmon_repagent
Version: 1
Uid: 1
Type: stored procedure
Number of trees: 0
Size of trees: 0.000000 Mb, 0.000000 bytes, 0 pages
Bytes lost for alignment 0 (Percentage of total: 0.000000)
Number of plans: 1
Size of plans: 0.501379 Mb, 525734.000000 bytes, 258 pages
Bytes lost for alignment 5846 (Percentage of total: 1.111969)
----
Database Id: 31514
Object Id: 1324528721
Object Name: sp_do_poolconfig
Version: 1
Uid: 1
Type: stored procedure
Number of trees: 0
Size of trees: 0.000000 Mb, 0.000000 bytes, 0 pages
Bytes lost for alignment 0 (Percentage of total: 0.000000)
Number of plans: 1
Size of plans: 0.474176 Mb, 497210.000000 bytes, 244 pages
Bytes lost for alignment 6746 (Percentage of total: 1.356771)
----
Database Id: 31514
Object Id: 1676529975
Object Name: sp_sysmon_appmgmt
Version: 1
Uid: 1
Type: stored procedure
Number of trees: 0
Size of trees: 0.000000 Mb, 0.000000 bytes, 0 pages
Bytes lost for alignment 0 (Percentage of total: 0.000000)
Number of plans: 1
Size of plans: 0.449591 Mb, 471430.000000 bytes, 231 pages
Bytes lost for alignment 6181 (Percentage of total: 1.311117)
----
Database Id: 31514
Object Id: 1820530488
Object Name: sp_sysmon_dcache_sum
Version: 1
Uid: 1
Type: stored procedure
Number of trees: 0
Size of trees: 0.000000 Mb, 0.000000 bytes, 0 pages
Bytes lost for alignment 0 (Percentage of total: 0.000000)
Number of plans: 1
Size of plans: 0.434484 Mb, 455589.000000 bytes, 224 pages
Bytes lost for alignment 7724 (Percentage of total: 1.695388)
----
Database Id: 31514
Object Id: 41048151
Object Name: sp_monitorconfig
Version: 1
Uid: 1
Type: stored procedure
Number of trees: 0
Size of trees: 0.000000 Mb, 0.000000 bytes, 0 pages
Bytes lost for alignment 0 (Percentage of total: 0.000000)
Number of plans: 1
Size of plans: 0.396655 Mb, 415923.000000 bytes, 204 pages
Bytes lost for alignment 4020 (Percentage of total: 0.966525)
----
Database Id: 31514
Object Id: 1660529918
Object Name: sp_sysmon_taskmgmt
Version: 1
Uid: 1
Type: stored procedure
Number of trees: 0
Size of trees: 0.000000 Mb, 0.000000 bytes, 0 pages
Bytes lost for alignment 0 (Percentage of total: 0.000000)
Number of plans: 1
Size of plans: 0.346366 Mb, 363191.000000 bytes, 179 pages
Bytes lost for alignment 4580 (Percentage of total: 1.261044)
----
Database Id: 31514
Object Id: 73048265
Object Name: sp_sysmon_mdcache
Version: 1
Uid: 1
Type: stored procedure
Number of trees: 0
Size of trees: 0.000000 Mb, 0.000000 bytes, 0 pages
Bytes lost for alignment 0 (Percentage of total: 0.000000)
Number of plans: 1
Size of plans: 0.316612 Mb, 331992.000000 bytes, 164 pages
Bytes lost for alignment 3325 (Percentage of total: 1.001530)
----
Database Id: 31514
Object Id: 1900530773
Object Name: sp_sysmon_diskio
Version: 1
Uid: 1
Type: stored procedure
Number of trees: 0
Size of trees: 0.000000 Mb, 0.000000 bytes, 0 pages
Bytes lost for alignment 0 (Percentage of total: 0.000000)
Number of plans: 1
Size of plans: 0.310498 Mb, 325581.000000 bytes, 160 pages
Bytes lost for alignment 3662 (Percentage of total: 1.124759)
----
Database Id: 31514
Object Id: 1740530203
Object Name: sp_sysmon_xactsum
Version: 1
Uid: 1
Type: stored procedure
Number of trees: 0
Size of trees: 0.000000 Mb, 0.000000 bytes, 0 pages
Bytes lost for alignment 0 (Percentage of total: 0.000000)
Number of plans: 1
Size of plans: 0.301847 Mb, 316509.000000 bytes, 156 pages
Bytes lost for alignment 4744 (Percentage of total: 1.498852)
----
Database Id: 31514
Object Id: 105048379
Object Name: sp_sysmon_analyze
Version: 1
Uid: 1
Type: stored procedure
Number of trees: 0
Size of trees: 0.000000 Mb, 0.000000 bytes, 0 pages
Bytes lost for alignment 0 (Percentage of total: 0.000000)
Number of plans: 1
Size of plans: 0.294298 Mb, 308594.000000 bytes, 153 pages
Bytes lost for alignment 2071 (Percentage of total: 0.671108)
----
以下是昨晚调整之后的MON报告
===============================================================================Sybase Adaptive Server Enterprise System Performance Report
===============================================================================
Server Version: Adaptive Server Enterprise/12.5.3/EBF 13329 ESD#7/P/HP90
Server Name: SXJHWG
Run Date: Jun 22, 2008
Statistics Cleared at: Jun 22, 2008 08:13:07
Statistics Sampled at: Jun 22, 2008 08:23:20
Sample Interval: 00:10:00
===============================================================================
Kernel Utilization
------------------
Your Runnable Process Search Count is set to 1000
and I/O Polling Process Count is set to 10
Engine Busy Utilization CPU Busy I/O Busy Idle
------------------------ -------- -------- --------
Engine 0 38.2 % 0.0 % 61.8 %
Engine 1 38.8 % 0.0 % 61.2 %
Engine 2 38.3 % 0.0 % 61.7 %
Engine 3 42.4 % 0.0 % 57.6 %
Engine 4 36.7 % 0.0 % 63.3 %
Engine 5 50.7 % 0.0 % 49.3 %
Engine 6 40.5 % 0.0 % 59.5 %
Engine 7 41.8 % 0.0 % 58.2 %
Engine 8 38.7 % 0.0 % 61.3 %
------------------------ -------- -------- --------
Summary Total 366.1 % 0.0 % 533.9 %
Average 40.7 % 0.0 % 59.3 %
CPU Yields by Engine per sec per xact count% of total
---------------------------------------------------------------------
Engine 0 95.6 0.7 57382 31.8 %
Engine 1 18.9 0.1 11323 6.3 %
Engine 2 54.9 0.4 32951 18.3 %
Engine 3 13.5 0.1 8111 4.5 %
Engine 4 23.5 0.2 14102 7.8 %
Engine 5 10.1 0.1 6040 3.3 %
Engine 6 19.6 0.2 11784 6.5 %
Engine 7 18.3 0.1 10965 6.1 %
Engine 8 46.4 0.4 27853 15.4 %
-----------------------------------------------------------
Total CPU Yields 300.9 2.3 180511
Network Checks
Non-Blocking 126699.5 987.2 76019678 99.8 %
Blocking 300.8 2.3 180487 0.2 %
-----------------------------------------------------------
Total Network I/O Checks 127000.3 989.5 76200165
Avg Net I/Os per Check n/a n/a 0.00391 n/a
Disk I/O Checks
Total Disk I/O Checks 130682.9 1018.2 78409712 n/a
Checks Returning I/O 0.0 0.0 0 0.0 %
===============================================================================
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 2.6 0.0 1561 n/a
Task Context Switches by Engine
Engine 0 483.8 3.8 290250 9.4 %
Engine 1 590.9 4.6 354513 11.5 %
Engine 2 533.5 4.2 320071 10.4 %
Engine 3 761.6 5.9 456935 14.8 %
Engine 4 552.2 4.3 331322 10.7 %
Engine 5 564.2 4.4 338490 11.0 %
Engine 6 554.6 4.3 332769 10.8 %
Engine 7 584.9 4.6 350965 11.4 %
Engine 8 517.9 4.0 310719 10.1 %
-----------------------------------------------------------
Total Task Switches: 5143.4 40.1 3086034
Task Context Switches Due To:
Voluntary Yields 111.2 0.9 66738 2.2 %
Cache Search Misses 502.9 3.9 301739 9.8 %
System Disk Writes 1.8 0.0 1062 0.0 %
I/O Pacing 4.9 0.0 2930 0.1 %
Logical Lock Contention 1.3 0.0 803 0.0 %
Address Lock Contention 0.0 0.0 4 0.0 %
Latch Contention 0.0 0.0 10 0.0 %
Log Semaphore Contention 1.4 0.0 829 0.0 %
PLC Lock Contention 0.1 0.0 32 0.0 %
Group Commit Sleeps 1.9 0.0 1156 0.0 %
Last Log Page Writes 89.9 0.7 53922 1.7 %
Modify Conflicts 3.4 0.0 2057 0.1 %
I/O Device Contention 0.0 0.0 0 0.0 %
Network Packet Received 235.2 1.8 141104 4.6 %
Network Packet Sent 111.7 0.9 67013 2.2 %
Other Causes 4077.7 31.8 2446635 79.3 %
===============================================================================
Application Management
----------------------
Application Statistics Summary (All Applications)
-------------------------------------------------
Priority Changes per sec per xact count% of total
---------------------------------------------------------------------
To High Priority 9.4 0.1 5610 31.6 %
To Medium Priority 16.1 0.1 9643 54.4 %
To Low Priority 4.1 0.0 2473 14.0 %
-----------------------------------------------------------
Total Priority Changes 29.5 0.2 17726
Allotted Slices Exhausted per sec per xact count% of total
---------------------------------------------------------------------
High Priority 0.0 0.0 0 0.0 %
Medium Priority 10.3 0.1 6164 100.0 %
Low Priority 0.0 0.0 0 0.0 %
-----------------------------------------------------------
Total Slices Exhausted 10.3 0.1 6164
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 70.4 0.5 42223 82.1 %
Dirty 15.4 0.1 9213 17.9 %
----------------------------------
Total Washes 85.7 0.7 51436
Garbage Collections 2.8 0.0 1665 n/a
Pages Processed in GC 0.2 0.0 125 n/a
Statistics Updates 1.9 0.0 1161 n/a
Tuning Recommendations for Housekeeper
--------------------------------------
- Consider increasing the 'housekeeper free write percent'
configuration parameter.
===============================================================================
Monitor Access to Executing SQL
-------------------------------
per sec per xact count% of total
--------------------------------------------
Waits on Execution Plans 0.0 0.0 0 n/a
Number of SQL Text Overflows 0.0 0.0 0 n/a
Maximum SQL Text Requested n/a n/a 0 n/a
(since beginning of sample)
报告后续输出
===============================================================================Transaction Profile
-------------------
Transaction Summary per sec per xact count% of total
---------------------------------------------------------------------
Committed Xacts 128.3 n/a 77006 n/a
Transaction Detail per sec per xact count% of total
---------------------------------------------------------------------
Inserts
APL Heap Table 285.0 2.2 171011 83.1 %
APL Clustered Table 16.4 0.1 9859 4.8 %
Data Only Lock Table 41.7 0.3 25025 12.2 %
---------------------------------------------------------------------
Total Rows Inserted 343.2 2.7 205895 92.4 %
Updates
APL Deferred 0.0 0.0 1 0.0 %
APL Direct In-place 0.0 0.0 0 0.0 %
APL Direct Cheap 0.9 0.0 528 3.3 %
APL Direct Expensive 0.2 0.0 90 0.6 %
DOL Deferred 0.0 0.0 0 0.0 %
DOL Direct 25.7 0.2 15415 96.1 %
---------------------------------------------------------------------
Total Rows Updated 26.7 0.2 16034 7.2 %
Data Only Locked Updates
DOL Replace 20.9 0.2 12519 81.2 %
DOL Shrink 0.9 0.0 527 3.4 %
DOL Cheap Expand 1.6 0.0 983 6.4 %
DOL Expensive Expand 1.8 0.0 1072 7.0 %
DOL Expand & Forward 0.3 0.0 202 1.3 %
DOL Fwd Row Returned 0.2 0.0 112 0.7 %
---------------------------------------------------------------------
Total DOL Rows Updated 25.7 0.2 15415 6.9 %
Deletes
APL Deferred 0.0 0.0 1 0.1 %
APL Direct 0.2 0.0 90 9.4 %
DOL 1.5 0.0 871 90.5 %
---------------------------------------------------------------------
Total Rows Deleted 1.6 0.0 962 0.4 %
===========================================================
Total Rows Affected 371.5 2.9 222891
===============================================================================
Transaction Management
----------------------
ULC Flushes to Xact Log per sec per xact count% of total
---------------------------------------------------------------------
by Full ULC 0.0 0.0 5 0.0 %
by End Transaction 91.1 0.7 54687 59.0 %
by Change of Database 3.4 0.0 2038 2.2 %
by Single Log Record 1.7 0.0 1035 1.1 %
by Unpin 0.8 0.0 462 0.5 %
by Other 57.5 0.4 34489 37.2 %
-----------------------------------------------------------
Total ULC Flushes 154.5 1.2 92716
ULC Log Records 410.6 3.2 246368 n/a
Max ULC Size During Sample n/a n/a 81808 n/a
ULC Semaphore Requests
Granted 1670.4 13.0 1002247 100.0 %
Waited 0.1 0.0 32 0.0 %
-----------------------------------------------------------
Total ULC Semaphore Req 1670.5 13.0 1002279
Log Semaphore Requests
Granted 116.0 0.9 69609 98.8 %
Waited 1.4 0.0 829 1.2 %
-----------------------------------------------------------
Total Log Semaphore Req 117.4 0.9 70438
Transaction Log Writes 93.9 0.7 56319 n/a
Transaction Log Alloc 7.9 0.1 4761 n/a
Avg # Writes per Log Page n/a n/a 11.82924 n/a
===============================================================================
Index Management
----------------
Nonclustered Maintenance per sec per xact count% of total
---------------------------------------------------------------------
Ins/Upd Requiring Maint 12.8 0.1 7663 n/a
# of NC Ndx Maint 12.8 0.1 7663 n/a
Avg NC Ndx Maint / Op n/a n/a 1.00000 n/a
Deletes Requiring Maint 0.2 0.0 90 n/a
# of NC Ndx Maint 0.2 0.0 90 n/a
Avg NC Ndx Maint / Op n/a n/a 1.00000 n/a
RID Upd from Clust Split 0.3 0.0 172 n/a
# of NC Ndx Maint 10.0 0.1 5996 n/a
Avg NC Ndx Maint / Op n/a n/a 34.86047 n/a
Upd/Del DOL Req Maint 27.1 0.2 16286 n/a
# of DOL Ndx Maint 1.6 0.0 966 n/a
Avg DOL Ndx Maint / Op n/a n/a 0.05931 n/a
Page Splits 1.4 0.0 856 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 7524.7 58.6 4514802 95.9 %
DOL Ascending Scans 304.9 2.4 182919 3.9 %
Descending Scans 12.9 0.1 7739 0.2 %
DOL Descending Scans 0.0 0.0 0 0.0 %
----------------------------------
Total Scans 7842.4 61.1 4705460
===============================================================================
Metadata Cache Management
-------------------------
Metadata Cache Summary per sec per xact count% of total
---------------------------------------------------------------------
Open Object Usage
Active n/a n/a 2874 n/a
Max Ever Used Since Boot n/a n/a 3337 n/a
Free n/a n/a 10240 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 2434 n/a
Max Ever Used Since Boot n/a n/a 2434 n/a
Free n/a n/a 10240 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 21 n/a
Max Ever Used Since Boot n/a n/a 21 n/a
Free n/a n/a 200 n/a
Reuse Requests
Succeeded n/a n/a 0 n/a
Failed n/a n/a 0 n/a
Object Manager Spinlock Contentionn/a n/a n/a 1.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 56768.8 442.3 34061274 n/a
Avg Lock Contention 1.3 0.0 807 0.0 %
Deadlock Percentage 0.0 0.0 0 0.0 %
Lock Detail per sec per xact count% of total
---------------------------------------------------------------------
Table Lock Hashtable
Lookups 6730.7 52.4 4038441 n/a
Avg Chain Length n/a n/a 0.00812 n/a
Spinlock Contention n/a n/a n/a 0.0 %
Exclusive Table
Granted 1.7 0.0 1008 100.0 %
Waited 0.0 0.0 0 0.0 %
---------------------------------------------------------------------
Total EX-Table Requests 1.7 0.0 1008 0.0 %
Shared Table
Granted 0.0 0.0 3 100.0 %
Waited 0.0 0.0 0 0.0 %
---------------------------------------------------------------------
Total SH-Table Requests 0.0 0.0 3 0.0 %
Exclusive Intent
Granted 129.2 1.0 77544 99.3 %
Waited 1.0 0.0 575 0.7 %
---------------------------------------------------------------------
Total EX-Intent Requests 130.2 1.0 78119 0.2 %
Shared Intent
Granted 794.8 6.2 476874 100.0 %
Waited 0.2 0.0 133 0.0 %
---------------------------------------------------------------------
Total SH-Intent Requests 795.0 6.2 477007 1.4 %
Page & Row Lock HashTable
Lookups 47386.7 369.2 28432000 n/a
Avg Chain Length n/a n/a 0.34786 n/a
Spinlock Contention n/a n/a n/a 0.0 %
Exclusive Page
Granted 134.1 1.0 80430 100.0 %
Waited 0.0 0.0 11 0.0 %
---------------------------------------------------------------------
Total EX-Page Requests 134.1 1.0 80441 0.2 %
Update Page
Granted 6165.7 48.0 3699420 100.0 %
Waited 0.0 0.0 0 0.0 %
---------------------------------------------------------------------
Total UP-Page Requests 6165.7 48.0 3699420 10.9 %
Shared Page
Granted 35836.3 279.2 21501789 100.0 %
Waited 0.0 0.0 0 0.0 %
---------------------------------------------------------------------
Total SH-Page Requests 35836.3 279.2 21501789 63.1 %
Exclusive Row
Granted 34.0 0.3 20373 100.0 %
Waited 0.0 0.0 0 0.0 %
---------------------------------------------------------------------
Total EX-Row Requests 34.0 0.3 20373 0.1 %
Update Row
Granted 0.7 0.0 405 100.0 %
Waited 0.0 0.0 0 0.0 %
---------------------------------------------------------------------
Total UP-Row Requests 0.7 0.0 405 0.0 %
Shared Row
Granted 5182.6 40.4 3109545 100.0 %
Waited 0.1 0.0 84 0.0 %
---------------------------------------------------------------------
Total SH-Row Requests 5182.7 40.4 3109629 9.1 %
Next-Key
Total Next-Key Requests 0.0 0.0 0 n/a
Address Lock Hashtable
Lookups 8488.5 66.1 5093080 n/a
Avg Chain Length n/a n/a 0.00000 n/a
Spinlock Contention n/a n/a n/a 0.0 %
Exclusive Address
Granted 130.5 1.0 78282 100.0 %
Waited 0.0 0.0 0 0.0 %
---------------------------------------------------------------------
Total EX-Address Requests 130.5 1.0 78282 0.2 %
Shared Address
Granted 8358.0 65.1 5014794 100.0 %
Waited 0.0 0.0 4 0.0 %
---------------------------------------------------------------------
Total SH-Address Requests 8358.0 65.1 5014798 14.7 %
Last Page Locks on Heaps
Granted 285.0 2.2 171011 100.0 %
Waited 0.0 0.0 0 0.0 %
---------------------------------------------------------------------
Total Last Pg Locks 285.0 2.2 171011 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 2.8 0.0 1708 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.0 0.0 2 100.0 %
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.0 0.0 2
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.
===============================================================================
DATAchche
Data Cache Management---------------------
Cache Statistics Summary (All Caches)
-------------------------------------
per sec per xact count% of total
--------------------------------------------
Cache Search Summary
Total Cache Hits 379776.6 2959.1 227865967 99.8 %
Total Cache Misses 605.0 4.7 363013 0.2 %
-----------------------------------------------------------
Total Cache Searches 380381.6 2963.8 228228980
Cache Turnover
Buffers Grabbed 637.8 5.0 382666 n/a
Buffers Grabbed Dirty 0.0 0.0 0 0.0 %
Cache Strategy Summary
Cached (LRU) Buffers 367386.2 2862.5 220431697 100.0 %
Discarded (MRU) Buffers 3.0 0.0 1818 0.0 %
Large I/O Usage
Large I/Os Performed 571.5 4.5 342888 93.4 %
Large I/Os Denied due to
Pool < Prefetch Size 40.1 0.3 24063 6.6 %
-----------------------------------------------------------
Total Large I/O Requests 611.6 4.8 366951
Large I/O Effectiveness
Pages by Lrg I/O Cached 1143.0 8.9 685776 n/a
Pages by Lrg I/O Used 1006.8 7.8 604078 88.1 %
Asynchronous Prefetch Activity
APFs Issued 6.3 0.0 3760 0.0 %
APFs Denied Due To
APF I/O Overloads 0.0 0.0 7 0.0 %
APF Limit Overloads 1686.7 13.1 1012040 2.0 %
APF Reused Overloads 0.0 0.0 3 0.0 %
APF Buffers Found in Cache
With Spinlock Held 0.0 0.0 0 0.0 %
W/o Spinlock Held 81716.9 636.7 49030150 98.0 %
-----------------------------------------------------------
Total APFs Requested 83409.9 649.9 50045960
Other Asynchronous Prefetch Statistics
APFs Used 5.9 0.0 3534 n/a
APF Waits for I/O 0.4 0.0 244 n/a
APF Discards 0.0 0.0 0 n/a
Dirty Read Behavior
Page Requests 0.0 0.0 0 n/a
-------------------------------------------------------------------------------
Cache: awsdyndb_ews_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 22.2 %
Cache Searches
Cache Hits 84589.4 659.1 50753621 100.0 %
Found in Wash 0.0 0.0 0 0.0 %
Cache Misses 0.0 0.0 0 0.0 %
-----------------------------------------------------------
Total Cache Searches 84589.4 659.1 50753621
Pool Turnover
8Kb Pool
LRU Buffer Grab 4.0 0.0 2399 100.0 %
Grabbed Dirty 0.0 0.0 0 0.0 %
-----------------------------------------------------------
Total Cache Turnover 4.0 0.0 2399
Buffer Wash Behavior
Statistics Not Available - No Buffers Entered Wash Section Yet
Cache Strategy
Cached (LRU) Buffers 81971.2 638.7 49182744 100.0 %
Discarded (MRU) Buffers 0.0 0.0 0 0.0 %
Large I/O Usage
Total Large I/O Requests 0.0 0.0 0 n/a
Large I/O Detail
16Kb 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
-------------------------------------------------------------------------------
Cache: awsdyndb_ews_task_cache
per sec per xact count% of total
---------------------------------------------------------------------
Spinlock Contention n/a n/a n/a 25.0 %
Utilization n/a n/a n/a 4.5 %
Cache Searches
Cache Hits 16526.5 128.8 9915897 96.6 %
Found in Wash 0.0 0.0 0 0.0 %
Cache Misses 589.5 4.6 353700 3.4 %
-----------------------------------------------------------
Total Cache Searches 17116.0 133.4 10269597
Pool Turnover
8Kb Pool
LRU Buffer Grab 39.0 0.3 23405 6.6 %
Grabbed Dirty 0.0 0.0 0 0.0 %
16 Kb Pool
LRU Buffer Grab 550.5 4.3 330295 93.4 %
Grabbed Dirty 0.0 0.0 0 0.0 %
-----------------------------------------------------------
Total Cache Turnover 589.5 4.6 353700
Buffer Wash Behavior
Statistics Not Available - No Buffers Entered Wash Section Yet
Cache Strategy
Cached (LRU) Buffers 7965.8 62.1 4779508 100.0 %
Discarded (MRU) Buffers 0.0 0.0 0 0.0 %
Large I/O Usage
Large I/Os Performed 550.5 4.3 330295 93.4 %
Large I/Os Denied due to
Pool < Prefetch Size 38.9 0.3 23356 6.6 %
-----------------------------------------------------------
Total Large I/O Requests 589.4 4.6 353651
Large I/O Detail
16Kb Pool
Pages Cached 1101.0 8.6 660590 n/a
Pages Used 962.9 7.5 577728 87.5 %
Dirty Read Behavior
Page Requests 0.0 0.0 0 n/a
Tuning Recommendations for Data cache : awsdyndb_ews_task_cache
-------------------------------------
- Consider using Named Caches or Cache partitions or both.
-------------------------------------------------------------------------------
Cache: default data cache
per sec per xact count% of total
---------------------------------------------------------------------
Spinlock Contention n/a n/a n/a 1.0 %
Utilization n/a n/a n/a 3.7 %
Cache Searches
Cache Hits 13883.1 108.2 8329868 99.9 %
Found in Wash 0.0 0.0 0 0.0 %
Cache Misses 12.8 0.1 7707 0.1 %
-----------------------------------------------------------
Total Cache Searches 13896.0 108.3 8337575
Pool Turnover
8Kb Pool
LRU Buffer Grab 20.2 0.2 12105 55.3 %
Grabbed Dirty 0.0 0.0 0 0.0 %
16 Kb Pool
LRU Buffer Grab 16.3 0.1 9772 44.7 %
Grabbed Dirty 0.0 0.0 0 0.0 %
-----------------------------------------------------------
Total Cache Turnover 36.5 0.3 21877
Buffer Wash Behavior
Statistics Not Available - No Buffers Entered Wash Section Yet
Cache Strategy
Cached (LRU) Buffers 13471.0 105.0 8082570 100.0 %
Discarded (MRU) Buffers 0.0 0.0 0 0.0 %
Large I/O Usage
Large I/Os Performed 16.3 0.1 9772 99.2 %
Large I/Os Denied due to
Pool < Prefetch Size 0.1 0.0 78 0.8 %
-----------------------------------------------------------
Total Large I/O Requests 16.4 0.1 9850
Large I/O Detail
16Kb Pool
Pages Cached 32.6 0.3 19544 n/a
Pages Used 32.5 0.3 19527 99.9 %
Dirty Read Behavior
Page Requests 0.0 0.0 0 n/a
-------------------------------------------------------------------------------
Cache: telalm_cache
per sec per xact count% of total
---------------------------------------------------------------------
Spinlock Contention n/a n/a n/a 6.0 %
Utilization n/a n/a n/a 68.9 %
Cache Searches
Cache Hits 262058.8 2041.9 157235256 100.0 %
Found in Wash 55.2 0.4 33115 0.0 %
Cache Misses 2.3 0.0 1363 0.0 %
-----------------------------------------------------------
Total Cache Searches 262061.0 2041.9 157236619
Pool Turnover
8Kb Pool
LRU Buffer Grab 2.3 0.0 1394 37.4 %
Grabbed Dirty 0.0 0.0 0 0.0 %
16 Kb Pool
LRU Buffer Grab 3.9 0.0 2338 62.6 %
Grabbed Dirty 0.0 0.0 0 0.0 %
-----------------------------------------------------------
Total Cache Turnover 6.2 0.0 3732
datecache
Buffer Wash BehaviorStatistics Not Available - No Buffers Entered Wash Section Yet
Cache Strategy
Cached (LRU) Buffers 261290.6 2035.9 156774387 100.0 %
Discarded (MRU) Buffers 3.0 0.0 1818 0.0 %
Large I/O Usage
Large I/Os Performed 3.9 0.0 2338 78.9 %
Large I/Os Denied due to
Pool < Prefetch Size 1.0 0.0 626 21.1 %
-----------------------------------------------------------
Total Large I/O Requests 4.9 0.0 2964
Large I/O Detail
16Kb Pool
Pages Cached 7.8 0.1 4676 n/a
Pages Used 7.3 0.1 4405 94.2 %
Dirty Read Behavior
Page Requests 0.0 0.0 0 n/a
Tuning Recommendations for Data cache : telalm_cache
-------------------------------------
- Consider using 'relaxed LRU replacement policy'
for this cache.
-------------------------------------------------------------------------------
Cache: tempdb_cache
per sec per xact count% of total
---------------------------------------------------------------------
Spinlock Contention n/a n/a n/a 0.0 %
Utilization n/a n/a n/a 0.6 %
Cache Searches
Cache Hits 2424.6 18.9 1454741 100.0 %
Found in Wash 0.0 0.0 0 0.0 %
Cache Misses 0.3 0.0 204 0.0 %
-----------------------------------------------------------
Total Cache Searches 2424.9 18.9 1454945
Pool Turnover
8Kb Pool
LRU Buffer Grab 0.4 0.0 247 87.9 %
Grabbed Dirty 0.0 0.0 0 0.0 %
16 Kb Pool
LRU Buffer Grab 0.1 0.0 34 12.1 %
Grabbed Dirty 0.0 0.0 0 0.0 %
-----------------------------------------------------------
Total Cache Turnover 0.5 0.0 281
Buffer Wash Behavior
Statistics Not Available - No Buffers Entered Wash Section Yet
Cache Strategy
Cached (LRU) Buffers 2409.9 18.8 1445936 100.0 %
Discarded (MRU) Buffers 0.0 0.0 0 0.0 %
Large I/O Usage
Large I/Os Performed 0.1 0.0 34 100.0 %
Large I/Os Denied due to
Pool < Prefetch Size 0.0 0.0 0 0.0 %
-----------------------------------------------------------
Total Large I/O Requests 0.1 0.0 34
Large I/O Detail
16Kb Pool
Pages Cached 0.1 0.0 68 n/a
Pages Used 0.0 0.0 0 0.0 %
Dirty Read Behavior
Page Requests 0.0 0.0 0 n/a
-------------------------------------------------------------------------------
Cache: worktradb_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.1 %
Cache Searches
Cache Hits 294.3 2.3 176584 100.0 %
Found in Wash 34.9 0.3 20922 11.8 %
Cache Misses 0.1 0.0 39 0.0 %
-----------------------------------------------------------
Total Cache Searches 294.4 2.3 176623
Pool Turnover
8Kb Pool
LRU Buffer Grab 0.4 0.0 228 33.7 %
Grabbed Dirty 0.0 0.0 0 0.0 %
16 Kb Pool
LRU Buffer Grab 0.7 0.0 449 66.3 %
Grabbed Dirty 0.0 0.0 0 0.0 %
-----------------------------------------------------------
Total Cache Turnover 1.1 0.0 677
Buffer Wash Behavior
Statistics Not Available - No Buffers Entered Wash Section Yet
Cache Strategy
Cached (LRU) Buffers 277.6 2.2 166552 100.0 %
Discarded (MRU) Buffers 0.0 0.0 0 0.0 %
Large I/O Usage
Large I/Os Performed 0.7 0.0 449 99.3 %
Large I/Os Denied due to
Pool < Prefetch Size 0.0 0.0 3 0.7 %
-----------------------------------------------------------
Total Large I/O Requests 0.8 0.0 452
Large I/O Detail
16Kb Pool
Pages Cached 1.5 0.0 898 n/a
Pages Used 1.5 0.0 898 100.0 %
Dirty Read Behavior
Page Requests 0.0 0.0 0 n/a
Tuning Recommendations for Data cache : worktradb_cache
-------------------------------------
- Consider using 'relaxed LRU replacement policy'
for this cache.
===============================================================================
Procedure Cache Management per sec per xact count% of total
-----------------------------------------------------------------------
Procedure Requests 124.8 1.0 74898 n/a
Procedure Reads from Disk 0.0 0.0 0 0.0 %
Procedure Writes to Disk 0.0 0.0 0 0.0 %
Procedure Removals 77.8 0.6 46689 n/a
Procedure Recompilations 0.0 0.0 0 n/a
SQL Statement Cache:
Statements Cached 77.8 0.6 46656 n/a
Statements Found in Cache 31.0 0.2 18571 n/a
Statements Not Found 77.8 0.6 46656 n/a
Statements Dropped 155.7 1.2 93402 n/a
Statements Restored 0.1 0.0 33 n/a
Statements Not Cached 0.0 0.0 0 n/a
===============================================================================
Memory Management per sec per xact count% of total
-----------------------------------------------------------------------
Pages Allocated 0.1 0.0 34 n/a
Pages Released 0.1 0.0 34 n/a
===============================================================================
Recovery Management
-------------------
Checkpoints per sec per xact count% of total
---------------------------------------------------------------------
# of Normal Checkpoints 0.0 0.0 13 100.0 %
# of Free Checkpoints 0.0 0.0 0 0.0 %
-----------------------------------------------------------
Total Checkpoints 0.0 0.0 13
Avg Time per Normal Chkpt 0.00000 seconds
===============================================================================
Disk I/O Management
-------------------
Max Outstanding I/Os per sec per xact count% of total
---------------------------------------------------------------------
Server n/a n/a 0 n/a
Engine 0 n/a n/a 0 n/a
Engine 1 n/a n/a 0 n/a
Engine 2 n/a n/a 0 n/a
Engine 3 n/a n/a 0 n/a
Engine 4 n/a n/a 0 n/a
Engine 5 n/a n/a 0 n/a
Engine 6 n/a n/a 0 n/a
Engine 7 n/a n/a 0 n/a
Engine 8 n/a n/a 0 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 629.9 4.9 377967
Completed Disk I/O's
Total Completed I/Os 0.0 0.0 0 n/a
-----------------------------------------------------------
Total Completed I/Os 0.0 0.0 0
diskIO
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 0 n/a
Engine 1 n/a n/a 0 n/a
Engine 2 n/a n/a 0 n/a
Engine 3 n/a n/a 0 n/a
Engine 4 n/a n/a 0 n/a
Engine 5 n/a n/a 0 n/a
Engine 6 n/a n/a 0 n/a
Engine 7 n/a n/a 0 n/a
Engine 8 n/a n/a 0 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 629.9 4.9 377967
Completed Disk I/O's
Total Completed I/Os 0.0 0.0 0 n/a
-----------------------------------------------------------
Total Completed I/Os 0.0 0.0 0
Device Activity Detail
----------------------
Device:
/dev/vg_mng_data/rdata1
staticdb_dev per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 0.0 0.0 26 29.2 %
Non-APF 0.1 0.0 58 65.2 %
Writes 0.0 0.0 5 5.6 %
---------------------------------------------------------------------
Total I/Os 0.1 0.0 89 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata10
imptradb_dev 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/vg_mng_data/rdata11
teltradb_dev1 per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 8 0.9 %
Writes 1.4 0.0 852 99.1 %
---------------------------------------------------------------------
Total I/Os 1.4 0.0 860 0.2 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata12
teltradb_dev2 per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 6 12.0 %
Writes 0.1 0.0 44 88.0 %
---------------------------------------------------------------------
Total I/Os 0.1 0.0 50 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata13
teltradb_dev3 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.0 125 100.0 %
---------------------------------------------------------------------
Total I/Os 0.2 0.0 125 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata14
teltradb_dev4 per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 0 0.0 %
Writes 0.0 0.0 12 100.0 %
---------------------------------------------------------------------
Total I/Os 0.0 0.0 12 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata15
teltradb_dev5 per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.2 0.0 110 7.7 %
Writes 2.2 0.0 1311 92.3 %
---------------------------------------------------------------------
Total I/Os 2.4 0.0 1421 0.4 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata16
teltradb_dev6 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 11 100.0 %
---------------------------------------------------------------------
Total I/Os 0.0 0.0 11 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata17
teltradb_dev7 per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 1 1.9 %
Writes 0.1 0.0 53 98.1 %
---------------------------------------------------------------------
Total I/Os 0.1 0.0 54 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata18
teltradb_dev8 per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 1 100.0 %
Writes 0.0 0.0 0 0.0 %
---------------------------------------------------------------------
Total I/Os 0.0 0.0 1 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata19
awsdyndb_dev2 per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.6 0.0 351 57.3 %
Writes 0.4 0.0 262 42.7 %
---------------------------------------------------------------------
Total I/Os 1.0 0.0 613 0.2 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata2
workdb_dev per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 7 2.9 %
Writes 0.4 0.0 235 97.1 %
---------------------------------------------------------------------
Total I/Os 0.4 0.0 242 0.1 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata20
phsdb01_dev 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/vg_mng_data/rdata21
phsdb02_dev 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/vg_mng_data/rdata22
phsdb03_dev 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/vg_mng_data/rdata23
teltradb_log per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 4.5 0.0 2713 13.4 %
Non-APF 10.1 0.1 6053 30.0 %
Writes 19.1 0.1 11438 56.6 %
---------------------------------------------------------------------
Total I/Os 33.7 0.3 20204 5.3 %
-----------------------------------------------------------------------------
IO
Device:/dev/vg_mng_data/rdata24
tempdb_dev per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.2 0.0 146 19.3 %
Writes 1.0 0.0 610 80.7 %
---------------------------------------------------------------------
Total I/Os 1.3 0.0 756 0.2 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata25
timesynchdb_dev 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/vg_mng_data/rdata26
phsdb04_dev 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/vg_mng_data/rdata27
phsdb05_dev 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/vg_mng_data/rdata28
phsdb06_dev 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/vg_mng_data/rdata3
telalmdb_dev1 per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 1.2 0.0 746 18.4 %
Non-APF 2.1 0.0 1287 31.7 %
Writes 3.4 0.0 2024 49.9 %
---------------------------------------------------------------------
Total I/Os 6.8 0.1 4057 1.1 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata4
telalmdb_dev2 per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 0.2 0.0 94 15.4 %
Non-APF 0.1 0.0 69 11.3 %
Writes 0.7 0.0 446 73.2 %
---------------------------------------------------------------------
Total I/Os 1.0 0.0 609 0.2 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata5
awsdyndb_dev per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 0.3 0.0 181 0.1 %
Non-APF 489.3 3.8 293590 99.4 %
Writes 2.4 0.0 1443 0.5 %
---------------------------------------------------------------------
Total I/Os 492.0 3.8 295214 78.1 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata6
worktradb_dev1 per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 7 0.1 %
Writes 7.8 0.1 4689 99.9 %
---------------------------------------------------------------------
Total I/Os 7.8 0.1 4696 1.2 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata7
worktradb_dev2 per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 1 0.1 %
Writes 1.6 0.0 959 99.9 %
---------------------------------------------------------------------
Total I/Os 1.6 0.0 960 0.3 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata8
worktradb_dev3 per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 28 1.0 %
Writes 4.8 0.0 2889 99.0 %
---------------------------------------------------------------------
Total I/Os 4.9 0.0 2917 0.8 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata9
phsdb07_dev 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/vg_mng_data/rlog1
staticdb_log 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 3.4 0.0 2055 100.0 %
---------------------------------------------------------------------
Total I/Os 3.4 0.0 2055 0.5 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rlog2
workdb_log 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 0.0 1313 100.0 %
---------------------------------------------------------------------
Total I/Os 2.2 0.0 1313 0.3 %
IO
-----------------------------------------------------------------------------Device:
/dev/vg_mng_data/rlog3
telalmdb_log per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 7 0.1 %
Writes 14.2 0.1 8508 99.9 %
---------------------------------------------------------------------
Total I/Os 14.2 0.1 8515 2.3 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rlog4
awsdyndb_log per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 5 0.0 %
Writes 26.5 0.2 15883 100.0 %
---------------------------------------------------------------------
Total I/Os 26.5 0.2 15888 4.2 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rlog5
worktradb_log per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 3 0.0 %
Writes 28.7 0.2 17208 100.0 %
---------------------------------------------------------------------
Total I/Os 28.7 0.2 17211 4.6 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rlog6
imptradb_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/vg_mng_data/rlog7
tempdb_log per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 0 0.0 %
Writes 0.1 0.0 59 100.0 %
---------------------------------------------------------------------
Total I/Os 0.1 0.0 59 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rmaster1
master per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 0 0.0 %
Writes 0.1 0.0 43 100.0 %
---------------------------------------------------------------------
Total I/Os 0.1 0.0 43 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rprcs1
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:
/dev/vg_mng_data/rsystem1
systemdbdev per sec per xact count% of total
---------------------------------------------------------------------
Total I/Os 0.0 0.0 0 n/a
---------------------------------------------------------------------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/test.db
testdb per sec per xact count% of total
---------------------------------------------------------------------
Total I/Os 0.0 0.0 0 n/a
---------------------------------------------------------------------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/test.log
testdblog per sec per xact count% of total
---------------------------------------------------------------------
Total I/Os 0.0 0.0 0 n/a
---------------------------------------------------------------------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/test1.db
testdb1 per sec per xact count% of total
---------------------------------------------------------------------
Total I/Os 0.0 0.0 0 n/a
---------------------------------------------------------------------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/test2.db
testdb2 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 %
-----------------------------------------------------------------------------
目前问题已解决
我会开贴,贴出解决方案。请高人指正
页:
1
[2]