数据库cpu引擎一直处于100%附近,求助(已解决)
以下是sp_sysmon 十分钟的记录求高手分析,主要原因在那,谢谢
===============================================================================
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 20, 2008
Statistics Cleared at: Jun 20, 2008 21:06:45
Statistics Sampled at: Jun 20, 2008 21:17:10
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 99.9 % 0.0 % 0.1 %
Engine 1 99.8 % 0.0 % 0.2 %
Engine 2 99.9 % 0.0 % 0.1 %
Engine 3 99.9 % 0.0 % 0.1 %
Engine 4 99.9 % 0.0 % 0.1 %
Engine 5 99.7 % 0.0 % 0.3 %
Engine 6 99.9 % 0.0 % 0.1 %
Engine 7 99.6 % 0.0 % 0.4 %
Engine 8 99.9 % 0.0 % 0.1 %
------------------------ -------- -------- --------
Summary Total 898.4 % 0.0 % 1.6 %
Average 99.8 % 0.0 % 0.2 %
CPU Yields by Engine per sec per xact count% of total
---------------------------------------------------------------------
Engine 0 0.0 0.0 15 9.2 %
Engine 1 0.0 0.0 28 17.2 %
Engine 2 0.0 0.0 20 12.3 %
Engine 3 0.0 0.0 1 0.6 %
Engine 4 0.0 0.0 5 3.1 %
Engine 5 0.0 0.0 20 12.3 %
Engine 6 0.0 0.0 10 6.1 %
Engine 7 0.1 0.0 60 36.8 %
Engine 8 0.0 0.0 4 2.5 %
-----------------------------------------------------------
Total CPU Yields 0.3 0.0 163
Network Checks
Non-Blocking 924.6 9.7 554763 100.0 %
Blocking 0.3 0.0 163 0.0 %
-----------------------------------------------------------
Total Network I/O Checks 924.9 9.7 554926
Avg Net I/Os per Check n/a n/a 0.19234 n/a
Disk I/O Checks
Total Disk I/O Checks 2980.5 31.2 1788299 n/a
Checks Returning I/O 0.0 0.0 0 0.0 %
Tuning Recommendations for Kernel Utilization
---------------------------------------------
- Consider bringing more engines online
===============================================================================
Worker Process Management
-------------------------
per sec per xact count% of total
--------------------------------------------
Worker Process Requests
Total Requests 0.0 0.0 0 n/a
Worker Process Usage
Total Used 0.0 0.0 0 n/a
Max Ever Used During Sample 0.0 0.0 0 n/a
Memory Requests for Worker Processes
Total Requests 0.0 0.0 0 n/a
Tuning Recommendations for Worker Processes
-------------------------------------------
- Consider decreasing the 'number of worker processes'
configuration parameter.
===============================================================================
Parallel Query Management
-------------------------
Parallel Query Usage per sec per xact count% of total
---------------------------------------------------------------------
Total Parallel Queries 0.0 0.0 0 n/a
Merge Lock Requests per sec per xact count% of total
---------------------------------------------------------------------
Total # of Requests 0.0 0.0 0 n/a
Sort Buffer Waits per sec per xact count% of total
---------------------------------------------------------------------
Total # of Waits 0.0 0.0 0 n/a
===============================================================================
Task Management per sec per xact count% of total
-----------------------------------------------------------------------
Connections Opened 0.2 0.0 140 n/a
Task Context Switches by Engine
Engine 0 395.1 4.1 237045 11.3 %
Engine 1 259.1 2.7 155436 7.4 %
Engine 2 347.4 3.6 208442 9.9 %
Engine 3 360.4 3.8 216259 10.3 %
Engine 4 478.0 5.0 286815 13.6 %
Engine 5 500.4 5.2 300211 14.3 %
Engine 6 472.1 4.9 283237 13.5 %
Engine 7 350.4 3.7 210212 10.0 %
Engine 8 346.3 3.6 207789 9.9 %
-----------------------------------------------------------
Total Task Switches: 3509.1 36.7 2105446
Task Context Switches Due To:
Voluntary Yields 114.5 1.2 68693 3.3 %
Cache Search Misses 2271.4 23.8 1362846 64.7 %
System Disk Writes 1.0 0.0 601 0.0 %
I/O Pacing 5.9 0.1 3553 0.2 %
Logical Lock Contention 1.0 0.0 582 0.0 %
Address Lock Contention 0.2 0.0 146 0.0 %
Latch Contention 0.2 0.0 149 0.0 %
Log Semaphore Contention 4.9 0.1 2962 0.1 %
PLC Lock Contention 0.1 0.0 72 0.0 %
Group Commit Sleeps 32.7 0.3 19615 0.9 %
Last Log Page Writes 96.7 1.0 58005 2.8 %
Modify Conflicts 5.2 0.1 3104 0.1 %
I/O Device Contention 0.0 0.0 0 0.0 %
Network Packet Received 85.2 0.9 51128 2.4 %
Network Packet Sent 65.4 0.7 39228 1.9 %
Other Causes 824.6 8.6 494762 23.5 %
Tuning Recommendations for Task Management
------------------------------------------
- Consider tuning your Data Caches.
Look into the Data Cache management section for
more details on this.
===============================================================================
Application Management
----------------------
Application Statistics Summary (All Applications)
-------------------------------------------------
Priority Changes per sec per xact count% of total
---------------------------------------------------------------------
To High Priority 13.2 0.1 7892 38.3 %
To Medium Priority 17.3 0.2 10368 50.3 %
To Low Priority 3.9 0.0 2334 11.3 %
-----------------------------------------------------------
Total Priority Changes 34.3 0.4 20594
Allotted Slices Exhausted per sec per xact count% of total
---------------------------------------------------------------------
High Priority 0.0 0.0 0 0.0 %
Medium Priority 1.2 0.0 702 100.0 %
Low Priority 0.0 0.0 0 0.0 %
-----------------------------------------------------------
Total Slices Exhausted 1.2 0.0 702
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 150.5 1.6 90324 91.3 %
Dirty 14.4 0.2 8656 8.7 %
----------------------------------
Total Washes 165.0 1.7 98980
Garbage Collections 7.6 0.1 4581 n/a
Pages Processed in GC 0.1 0.0 61 n/a
Statistics Updates 3.1 0.0 1854 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 8.0 0.1 4804 n/a
Maximum SQL Text Requested n/a n/a 1035 n/a
(since beginning of sample)
Tuning Recommendations for Monitor Access to Executing SQL
----------------------------------------------------------
- Consider increasing the 'max SQL text monitored' parameter
to at least 645 (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 95.6 n/a 57344 n/a
Transaction Detail per sec per xact count% of total
---------------------------------------------------------------------
Inserts
APL Heap Table 36.6 0.4 21958 30.3 %
APL Clustered Table 27.3 0.3 16356 22.6 %
Data Only Lock Table 56.8 0.6 34071 47.1 %
---------------------------------------------------------------------
Total Rows Inserted 120.6 1.3 72385 92.3 %
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.4 0.0 237 4.5 %
APL Direct Expensive 0.5 0.0 281 5.3 %
DOL Deferred 0.0 0.0 7 0.1 %
DOL Direct 7.9 0.1 4769 90.1 %
---------------------------------------------------------------------
Total Rows Updated 8.8 0.1 5295 6.8 %
Data Only Locked Updates
DOL Replace 6.1 0.1 3676 77.0 %
DOL Shrink 0.5 0.0 310 6.5 %
DOL Cheap Expand 0.4 0.0 213 4.5 %
DOL Expensive Expand 0.9 0.0 519 10.9 %
DOL Expand & Forward 0.0 0.0 29 0.6 %
DOL Fwd Row Returned 0.0 0.0 29 0.6 %
---------------------------------------------------------------------
Total DOL Rows Updated 8.0 0.1 4776 6.1 %
Deletes
APL Deferred 0.2 0.0 141 18.9 %
APL Direct 0.5 0.0 302 40.5 %
DOL 0.5 0.0 303 40.6 %
---------------------------------------------------------------------
Total Rows Deleted 1.2 0.0 746 1.0 %
===========================================================
Total Rows Affected 130.7 1.4 78426
===============================================================================
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 127.1 1.3 76233 89.5 %
by Change of Database 1.1 0.0 662 0.8 %
by Single Log Record 3.0 0.0 1814 2.1 %
by Unpin 2.3 0.0 1402 1.6 %
by Other 8.5 0.1 5077 6.0 %
-----------------------------------------------------------
Total ULC Flushes 142.0 1.5 85188
ULC Log Records 507.2 5.3 304310 n/a
Max ULC Size During Sample n/a n/a 8944 n/a
ULC Semaphore Requests
Granted 1170.1 12.2 702038 100.0 %
Waited 0.1 0.0 72 0.0 %
-----------------------------------------------------------
Total ULC Semaphore Req 1170.2 12.2 702110
Log Semaphore Requests
Granted 167.4 1.8 100456 97.1 %
Waited 4.9 0.1 2962 2.9 %
-----------------------------------------------------------
Total Log Semaphore Req 172.4 1.8 103418
Transaction Log Writes 100.6 1.1 60373 n/a
Transaction Log Alloc 7.8 0.1 4690 n/a
Avg # Writes per Log Page n/a n/a 12.87271 n/a
===============================================================================
[ 本帖最后由 回族四少 于 2008-7-19 00:07 编辑 ]
报告后续输出
Recovery Management-------------------
Checkpoints per sec per xact count% of total
---------------------------------------------------------------------
# of Normal Checkpoints 0.0 0.0 7 20.0 %
# of Free Checkpoints 0.0 0.0 28 80.0 %
-----------------------------------------------------------
Total Checkpoints 0.1 0.0 35
Avg Time per Normal Chkpt 0.00000 seconds
Avg Time per Free Chkpt 0.03571 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 2678.0 28.0 1606821
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.6 0.0 373 17.7 %
Non-APF 2.9 0.0 1723 81.5 %
Writes 0.0 0.0 17 0.8 %
---------------------------------------------------------------------
Total I/Os 3.5 0.0 2113 0.1 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata10
imptradb_dev 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/rdata11
teltradb_dev1 per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 1.6 0.0 951 74.5 %
Writes 0.5 0.0 326 25.5 %
---------------------------------------------------------------------
Total I/Os 2.1 0.0 1277 0.1 %
-----------------------------------------------------------------------------
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.6 0.0 382 87.2 %
Writes 0.1 0.0 56 12.8 %
---------------------------------------------------------------------
Total I/Os 0.7 0.0 438 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 2.0 0.0 1210 81.4 %
Writes 0.5 0.0 277 18.6 %
---------------------------------------------------------------------
Total I/Os 2.5 0.0 1487 0.1 %
-----------------------------------------------------------------------------
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.4 0.0 247 89.5 %
Writes 0.0 0.0 29 10.5 %
---------------------------------------------------------------------
Total I/Os 0.5 0.0 276 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata15
teltradb_dev5 per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 0.1 0.0 54 0.8 %
Non-APF 5.3 0.1 3150 46.7 %
Writes 5.9 0.1 3543 52.5 %
---------------------------------------------------------------------
Total I/Os 11.2 0.1 6747 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.8 0.0 477 95.8 %
Writes 0.0 0.0 21 4.2 %
---------------------------------------------------------------------
Total I/Os 0.8 0.0 498 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.8 0.0 482 75.9 %
Writes 0.3 0.0 153 24.1 %
---------------------------------------------------------------------
Total I/Os 1.1 0.0 635 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.5 0.0 291 100.0 %
Writes 0.0 0.0 0 0.0 %
---------------------------------------------------------------------
Total I/Os 0.5 0.0 291 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata19
awsdyndb_dev2 per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 9.5 0.1 5701 6.3 %
Non-APF 141.3 1.5 84798 93.4 %
Writes 0.5 0.0 272 0.3 %
---------------------------------------------------------------------
Total I/Os 151.3 1.6 90771 5.6 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata2
workdb_dev per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 0.0 0.0 1 0.5 %
Non-APF 0.1 0.0 84 44.4 %
Writes 0.2 0.0 104 55.0 %
---------------------------------------------------------------------
Total I/Os 0.3 0.0 189 0.0 %
-----------------------------------------------------------------------------
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 0.0 0.0 1 0.0 %
Non-APF 0.3 0.0 154 0.8 %
Writes 32.6 0.3 19552 99.2 %
---------------------------------------------------------------------
Total I/Os 32.8 0.3 19707 1.2 %
-----------------------------------------------------------------------------
报告后续输出
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.0 0.0 8 1.9 %
Writes 0.7 0.0 411 98.1 %
---------------------------------------------------------------------
Total I/Os 0.7 0.0 419 0.0 %
-----------------------------------------------------------------------------
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
---------------------------------------------------------------------
Reads
APF 0.4 0.0 246 0.8 %
Non-APF 52.0 0.5 31228 99.2 %
Writes 0.0 0.0 3 0.0 %
---------------------------------------------------------------------
Total I/Os 52.5 0.5 31477 2.0 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata27
phsdb05_dev 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 8 100.0 %
---------------------------------------------------------------------
Total I/Os 0.0 0.0 8 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 248.3 2.6 149001 14.0 %
Non-APF 1521.5 15.9 912894 85.9 %
Writes 1.6 0.0 988 0.1 %
---------------------------------------------------------------------
Total I/Os 1771.5 18.5 1062883 66.1 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata4
telalmdb_dev2 per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 7.7 0.1 4624 2.9 %
Non-APF 253.2 2.6 151947 96.8 %
Writes 0.6 0.0 339 0.2 %
---------------------------------------------------------------------
Total I/Os 261.5 2.7 156910 9.8 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rdata5
awsdyndb_dev per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 9.8 0.1 5860 5.4 %
Non-APF 169.5 1.8 101687 92.9 %
Writes 3.2 0.0 1928 1.8 %
---------------------------------------------------------------------
Total I/Os 182.5 1.9 109475 6.8 %
-----------------------------------------------------------------------------
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.2 0.0 143 2.3 %
Writes 10.3 0.1 6184 97.7 %
---------------------------------------------------------------------
Total I/Os 10.5 0.1 6327 0.4 %
-----------------------------------------------------------------------------
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 5 0.5 %
Writes 1.6 0.0 950 99.5 %
---------------------------------------------------------------------
Total I/Os 1.6 0.0 955 0.1 %
-----------------------------------------------------------------------------
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 117.4 1.2 70417 97.4 %
Writes 3.2 0.0 1901 2.6 %
---------------------------------------------------------------------
Total I/Os 120.5 1.3 72318 4.5 %
-----------------------------------------------------------------------------
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.1 0.0 39 5.6 %
Writes 1.1 0.0 663 94.4 %
---------------------------------------------------------------------
Total I/Os 1.2 0.0 702 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rlog2
workdb_log per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 0.0 0.0 2 0.2 %
Non-APF 0.0 0.0 14 1.5 %
Writes 1.5 0.0 902 98.3 %
---------------------------------------------------------------------
Total I/Os 1.5 0.0 918 0.1 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rlog3
telalmdb_log per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 0.0 0.0 4 0.2 %
Non-APF 0.0 0.0 29 1.5 %
Writes 3.2 0.0 1906 98.3 %
---------------------------------------------------------------------
Total I/Os 3.2 0.0 1939 0.1 %
-----------------------------------------------------------------------------
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.1 %
Writes 8.9 0.1 5322 99.9 %
---------------------------------------------------------------------
Total I/Os 8.9 0.1 5327 0.3 %
-----------------------------------------------------------------------------
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.2 0.0 106 0.3 %
Writes 53.4 0.6 32036 99.7 %
---------------------------------------------------------------------
Total I/Os 53.6 0.6 32142 2.0 %
-----------------------------------------------------------------------------
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 83 100.0 %
---------------------------------------------------------------------
Total I/Os 0.1 0.0 83 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rmaster1
master per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 0.1 0.0 45 9.1 %
Non-APF 0.6 0.0 353 71.5 %
Writes 0.2 0.0 96 19.4 %
---------------------------------------------------------------------
Total I/Os 0.8 0.0 494 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/vg_mng_data/rprcs1
sysprocsdev per sec per xact count% of total
---------------------------------------------------------------------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 14 100.0 %
Writes 0.0 0.0 0 0.0 %
---------------------------------------------------------------------
Total I/Os 0.0 0.0 14 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 %
-----------------------------------------------------------------------------
===============================================================================
Network I/O Management
----------------------
Total Network I/O Requests 150.6 1.6 90356 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 5.0 0.1 3019 5.9 %
Engine 1 2.3 0.0 1371 2.7 %
Engine 2 4.1 0.0 2483 4.9 %
Engine 3 12.6 0.1 7570 14.8 %
Engine 4 12.6 0.1 7532 14.8 %
Engine 5 25.3 0.3 15181 29.7 %
Engine 6 5.9 0.1 3539 6.9 %
Engine 7 12.3 0.1 7354 14.4 %
Engine 8 5.0 0.1 2988 5.9 %
-----------------------------------------------------------
Total TDS Packets Rec'd 85.1 0.9 51037
Total Bytes Received per sec per xact count% of total
---------------------------------------------------------------------
Engine 0 731.2 7.7 438745 5.4 %
Engine 1 330.1 3.5 198038 2.5 %
Engine 2 750.6 7.9 450357 5.6 %
Engine 3 1564.0 16.4 938376 11.6 %
Engine 4 2457.1 25.7 1474234 18.2 %
Engine 5 4720.6 49.4 2832350 35.1 %
Engine 6 882.7 9.2 529605 6.6 %
Engine 7 1326.2 13.9 795701 9.8 %
Engine 8 704.5 7.4 422698 5.2 %
-----------------------------------------------------------
Total Bytes Rec'd 13466.8 140.9 8080104
Avg Bytes Rec'd per Packet n/a n/a 158 n/a
-----------------------------------------------------------------------------
Total TDS Packets Sent per sec per xact count% of total
---------------------------------------------------------------------
Engine 0 5.4 0.1 3224 5.8 %
Engine 1 3.1 0.0 1868 3.4 %
Engine 2 5.3 0.1 3165 5.7 %
Engine 3 12.7 0.1 7611 13.7 %
Engine 4 15.5 0.2 9314 16.7 %
Engine 5 26.7 0.3 16048 28.8 %
Engine 6 6.2 0.1 3713 6.7 %
Engine 7 12.6 0.1 7570 13.6 %
Engine 8 5.3 0.1 3182 5.7 %
-----------------------------------------------------------
Total TDS Packets Sent 92.8 1.0 55695
Total Bytes Sent per sec per xact count% of total
---------------------------------------------------------------------
Engine 0 561.3 5.9 336794 5.3 %
Engine 1 621.6 6.5 372985 5.9 %
Engine 2 921.9 9.6 553169 8.8 %
Engine 3 991.5 10.4 594872 9.4 %
Engine 4 2160.7 22.6 1296414 20.6 %
Engine 5 3604.2 37.7 2162513 34.3 %
Engine 6 495.8 5.2 297502 4.7 %
Engine 7 647.9 6.8 388743 6.2 %
Engine 8 496.8 5.2 298065 4.7 %
-----------------------------------------------------------
Total Bytes Sent 10501.8 109.9 6301057
Avg Bytes Sent per Packet n/a n/a 113 n/a
===============================================================================
Replication Agent
-----------------
Replication Agent:awsdyndb
Replication Server: SXCNCRS
per sec per xact count% of total
--------------------------------------------
Log Scan Summary
Log Records Scanned n/a n/a 0 n/a
Log Records Processed n/a n/a 0 n/a
Log Scan Activity
Updates n/a n/a 0 n/a
Inserts n/a n/a 0 n/a
Deletes n/a n/a 0 n/a
Store Procedures n/a n/a 0 n/a
DDL Log Records n/a n/a 0 n/a
Writetext Log Records n/a n/a 0 n/a
Text/Image Log Records n/a n/a 0 n/a
CLRs n/a n/a 0 n/a
Transaction Activity
Opened n/a n/a 0 n/a
Commited n/a n/a 0 n/a
Aborted n/a n/a 0 n/a
Prepared n/a n/a 0 n/a
Maintenance User n/a n/a 0 n/a
Log Extension Wait
Count n/a n/a 0 n/a
Amount of time (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Time (ms) n/a n/a 0.0 n/a
Schema Cache Lookups
Forward Schema
Count n/a n/a 0 n/a
Total Wait (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Time (ms) n/a n/a 0.0 n/a
Backward Schema
Count n/a n/a 0 n/a
Total Wait (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Time (ms) n/a n/a 0.0 n/a
Truncation Point Movement
Moved n/a n/a 0 n/a
Gotten from RS n/a n/a 0 n/a
Connections to Replication Server
Success n/a n/a 0 n/a
Failed n/a n/a 0 n/a
Network Packet Information
Packets Sent n/a n/a 0 n/a
Full Packets Sent n/a n/a 0 n/a
Largest Packet n/a n/a 0 n/a
Amount of Bytes Sent n/a n/a 0 n/a
Average Packet n/a n/a 0.0 n/a
I/O Wait from RS
Count n/a n/a 0 n/a
Amount of Time (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Wait (ms) n/a n/a 0.0 n/a
--------------------------------------------------------------------------------
Replication Agent:imptradb
Replication Server: SXCNCRS
per sec per xact count% of total
--------------------------------------------
Log Scan Summary
Log Records Scanned n/a n/a 0 n/a
Log Records Processed n/a n/a 0 n/a
Log Scan Activity
Updates n/a n/a 0 n/a
Inserts n/a n/a 0 n/a
Deletes n/a n/a 0 n/a
Store Procedures n/a n/a 0 n/a
DDL Log Records n/a n/a 0 n/a
Writetext Log Records n/a n/a 0 n/a
Text/Image Log Records n/a n/a 0 n/a
CLRs n/a n/a 0 n/a
Transaction Activity
Opened n/a n/a 0 n/a
Commited n/a n/a 0 n/a
Aborted n/a n/a 0 n/a
Prepared n/a n/a 0 n/a
Maintenance User n/a n/a 0 n/a
Log Extension Wait
Count n/a n/a 0 n/a
Amount of time (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Time (ms) n/a n/a 0.0 n/a
Schema Cache Lookups
Forward Schema
Count n/a n/a 0 n/a
Total Wait (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Time (ms) n/a n/a 0.0 n/a
Backward Schema
Count n/a n/a 0 n/a
Total Wait (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Time (ms) n/a n/a 0.0 n/a
Truncation Point Movement
Moved n/a n/a 0 n/a
Gotten from RS n/a n/a 0 n/a
Connections to Replication Server
Success n/a n/a 0 n/a
报告后续输出
Failed n/a n/a 0 n/aNetwork Packet Information
Packets Sent n/a n/a 0 n/a
Full Packets Sent n/a n/a 0 n/a
Largest Packet n/a n/a 0 n/a
Amount of Bytes Sent n/a n/a 0 n/a
Average Packet n/a n/a 0.0 n/a
I/O Wait from RS
Count n/a n/a 0 n/a
Amount of Time (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Wait (ms) n/a n/a 0.0 n/a
--------------------------------------------------------------------------------
Replication Agent:phsexchresdb
Replication Server: SXCNCRS
per sec per xact count% of total
--------------------------------------------
Log Scan Summary
Log Records Scanned n/a n/a 0 n/a
Log Records Processed n/a n/a 0 n/a
Log Scan Activity
Updates n/a n/a 0 n/a
Inserts n/a n/a 0 n/a
Deletes n/a n/a 0 n/a
Store Procedures n/a n/a 0 n/a
DDL Log Records n/a n/a 0 n/a
Writetext Log Records n/a n/a 0 n/a
Text/Image Log Records n/a n/a 0 n/a
CLRs n/a n/a 0 n/a
Transaction Activity
Opened n/a n/a 0 n/a
Commited n/a n/a 0 n/a
Aborted n/a n/a 0 n/a
Prepared n/a n/a 0 n/a
Maintenance User n/a n/a 0 n/a
Log Extension Wait
Count n/a n/a 0 n/a
Amount of time (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Time (ms) n/a n/a 0.0 n/a
Schema Cache Lookups
Forward Schema
Count n/a n/a 0 n/a
Total Wait (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Time (ms) n/a n/a 0.0 n/a
Backward Schema
Count n/a n/a 0 n/a
Total Wait (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Time (ms) n/a n/a 0.0 n/a
Truncation Point Movement
Moved n/a n/a 0 n/a
Gotten from RS n/a n/a 0 n/a
Connections to Replication Server
Success n/a n/a 0 n/a
Failed n/a n/a 0 n/a
Network Packet Information
Packets Sent n/a n/a 0 n/a
Full Packets Sent n/a n/a 0 n/a
Largest Packet n/a n/a 0 n/a
Amount of Bytes Sent n/a n/a 0 n/a
Average Packet n/a n/a 0.0 n/a
I/O Wait from RS
Count n/a n/a 0 n/a
Amount of Time (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Wait (ms) n/a n/a 0.0 n/a
--------------------------------------------------------------------------------
Replication Agent:phsstaticdb
Replication Server: SXCNCRS
per sec per xact count% of total
--------------------------------------------
Log Scan Summary
Log Records Scanned n/a n/a 0 n/a
Log Records Processed n/a n/a 0 n/a
Log Scan Activity
Updates n/a n/a 0 n/a
Inserts n/a n/a 0 n/a
Deletes n/a n/a 0 n/a
Store Procedures n/a n/a 0 n/a
DDL Log Records n/a n/a 0 n/a
Writetext Log Records n/a n/a 0 n/a
Text/Image Log Records n/a n/a 0 n/a
CLRs n/a n/a 0 n/a
Transaction Activity
Opened n/a n/a 0 n/a
Commited n/a n/a 0 n/a
Aborted n/a n/a 0 n/a
Prepared n/a n/a 0 n/a
Maintenance User n/a n/a 0 n/a
Log Extension Wait
Count n/a n/a 0 n/a
Amount of time (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Time (ms) n/a n/a 0.0 n/a
Schema Cache Lookups
Forward Schema
Count n/a n/a 0 n/a
Total Wait (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Time (ms) n/a n/a 0.0 n/a
Backward Schema
Count n/a n/a 0 n/a
Total Wait (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Time (ms) n/a n/a 0.0 n/a
Truncation Point Movement
Moved n/a n/a 0 n/a
Gotten from RS n/a n/a 0 n/a
Connections to Replication Server
Success n/a n/a 0 n/a
Failed n/a n/a 0 n/a
Network Packet Information
Packets Sent n/a n/a 0 n/a
Full Packets Sent n/a n/a 0 n/a
Largest Packet n/a n/a 0 n/a
Amount of Bytes Sent n/a n/a 0 n/a
Average Packet n/a n/a 0.0 n/a
I/O Wait from RS
Count n/a n/a 0 n/a
Amount of Time (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Wait (ms) n/a n/a 0.0 n/a
--------------------------------------------------------------------------------
Replication Agent:phstelalmdb
Replication Server: SXCNCRS
per sec per xact count% of total
--------------------------------------------
Log Scan Summary
Log Records Scanned n/a n/a 0 n/a
Log Records Processed n/a n/a 0 n/a
Log Scan Activity
Updates n/a n/a 0 n/a
Inserts n/a n/a 0 n/a
Deletes n/a n/a 0 n/a
Store Procedures n/a n/a 0 n/a
DDL Log Records n/a n/a 0 n/a
Writetext Log Records n/a n/a 0 n/a
Text/Image Log Records n/a n/a 0 n/a
CLRs n/a n/a 0 n/a
Transaction Activity
Opened n/a n/a 0 n/a
Commited n/a n/a 0 n/a
Aborted n/a n/a 0 n/a
Prepared n/a n/a 0 n/a
Maintenance User n/a n/a 0 n/a
Log Extension Wait
Count n/a n/a 0 n/a
Amount of time (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Time (ms) n/a n/a 0.0 n/a
Schema Cache Lookups
Forward Schema
Count n/a n/a 0 n/a
Total Wait (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Time (ms) n/a n/a 0.0 n/a
Backward Schema
Count n/a n/a 0 n/a
Total Wait (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Time (ms) n/a n/a 0.0 n/a
Truncation Point Movement
Moved n/a n/a 0 n/a
Gotten from RS n/a n/a 0 n/a
Connections to Replication Server
Success n/a n/a 0 n/a
Failed n/a n/a 0 n/a
Network Packet Information
Packets Sent n/a n/a 0 n/a
Full Packets Sent n/a n/a 0 n/a
Largest Packet n/a n/a 0 n/a
Amount of Bytes Sent n/a n/a 0 n/a
Average Packet n/a n/a 0.0 n/a
I/O Wait from RS
Count n/a n/a 0 n/a
Amount of Time (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Wait (ms) n/a n/a 0.0 n/a
--------------------------------------------------------------------------------
Replication Agent:phsteltradb
Replication Server: SXCNCRS
报告后续输出
Replication Agent:phsteltradbReplication Server: SXCNCRS
per sec per xact count% of total
--------------------------------------------
Log Scan Summary
Log Records Scanned n/a n/a 0 n/a
Log Records Processed n/a n/a 0 n/a
Log Scan Activity
Updates n/a n/a 0 n/a
Inserts n/a n/a 0 n/a
Deletes n/a n/a 0 n/a
Store Procedures n/a n/a 0 n/a
DDL Log Records n/a n/a 0 n/a
Writetext Log Records n/a n/a 0 n/a
Text/Image Log Records n/a n/a 0 n/a
CLRs n/a n/a 0 n/a
Transaction Activity
Opened n/a n/a 0 n/a
Commited n/a n/a 0 n/a
Aborted n/a n/a 0 n/a
Prepared n/a n/a 0 n/a
Maintenance User n/a n/a 0 n/a
Log Extension Wait
Count n/a n/a 0 n/a
Amount of time (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Time (ms) n/a n/a 0.0 n/a
Schema Cache Lookups
Forward Schema
Count n/a n/a 0 n/a
Total Wait (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Time (ms) n/a n/a 0.0 n/a
Backward Schema
Count n/a n/a 0 n/a
Total Wait (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Time (ms) n/a n/a 0.0 n/a
Truncation Point Movement
Moved n/a n/a 0 n/a
Gotten from RS n/a n/a 0 n/a
Connections to Replication Server
Success n/a n/a 0 n/a
Failed n/a n/a 0 n/a
Network Packet Information
Packets Sent n/a n/a 0 n/a
Full Packets Sent n/a n/a 0 n/a
Largest Packet n/a n/a 0 n/a
Amount of Bytes Sent n/a n/a 0 n/a
Average Packet n/a n/a 0.0 n/a
I/O Wait from RS
Count n/a n/a 0 n/a
Amount of Time (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Wait (ms) n/a n/a 0.0 n/a
--------------------------------------------------------------------------------
Replication Agent:phsworkdb
Replication Server: SXCNCRS
per sec per xact count% of total
--------------------------------------------
Log Scan Summary
Log Records Scanned n/a n/a 0 n/a
Log Records Processed n/a n/a 0 n/a
Log Scan Activity
Updates n/a n/a 0 n/a
Inserts n/a n/a 0 n/a
Deletes n/a n/a 0 n/a
Store Procedures n/a n/a 0 n/a
DDL Log Records n/a n/a 0 n/a
Writetext Log Records n/a n/a 0 n/a
Text/Image Log Records n/a n/a 0 n/a
CLRs n/a n/a 0 n/a
Transaction Activity
Opened n/a n/a 0 n/a
Commited n/a n/a 0 n/a
Aborted n/a n/a 0 n/a
Prepared n/a n/a 0 n/a
Maintenance User n/a n/a 0 n/a
Log Extension Wait
Count n/a n/a 0 n/a
Amount of time (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Time (ms) n/a n/a 0.0 n/a
Schema Cache Lookups
Forward Schema
Count n/a n/a 0 n/a
Total Wait (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Time (ms) n/a n/a 0.0 n/a
Backward Schema
Count n/a n/a 0 n/a
Total Wait (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Time (ms) n/a n/a 0.0 n/a
Truncation Point Movement
Moved n/a n/a 0 n/a
Gotten from RS n/a n/a 0 n/a
Connections to Replication Server
Success n/a n/a 0 n/a
Failed n/a n/a 0 n/a
Network Packet Information
Packets Sent n/a n/a 0 n/a
Full Packets Sent n/a n/a 0 n/a
Largest Packet n/a n/a 0 n/a
Amount of Bytes Sent n/a n/a 0 n/a
Average Packet n/a n/a 0.0 n/a
I/O Wait from RS
Count n/a n/a 0 n/a
Amount of Time (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Wait (ms) n/a n/a 0.0 n/a
--------------------------------------------------------------------------------
Replication Agent:staticdb
Replication Server: SXCNCRS
per sec per xact count% of total
--------------------------------------------
Log Scan Summary
Log Records Scanned n/a n/a 6924 n/a
Log Records Processed n/a n/a 6924 n/a
Log Scan Activity
Updates n/a n/a 0 n/a
Inserts n/a n/a 0 n/a
Deletes n/a n/a 0 n/a
Store Procedures n/a n/a 0 n/a
DDL Log Records n/a n/a 0 n/a
Writetext Log Records n/a n/a 0 n/a
Text/Image Log Records n/a n/a 0 n/a
CLRs n/a n/a 0 n/a
Transaction Activity
Opened n/a n/a 3461 n/a
Commited n/a n/a 1775 n/a
Aborted n/a n/a 1687 n/a
Prepared n/a n/a 1687 n/a
Maintenance User n/a n/a 0 n/a
Log Extension Wait
Count n/a n/a 0 n/a
Amount of time (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Time (ms) n/a n/a 0.0 n/a
Schema Cache Lookups
Forward Schema
Count n/a n/a 0 n/a
Total Wait (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Time (ms) n/a n/a 0.0 n/a
Backward Schema
Count n/a n/a 0 n/a
Total Wait (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Time (ms) n/a n/a 0.0 n/a
Truncation Point Movement
Moved n/a n/a 7 n/a
Gotten from RS n/a n/a 7 n/a
Connections to Replication Server
Success n/a n/a 0 n/a
Failed n/a n/a 0 n/a
Network Packet Information
Packets Sent n/a n/a 824 n/a
Full Packets Sent n/a n/a 727 n/a
Largest Packet n/a n/a 2048 n/a
Amount of Bytes Sent n/a n/a 1502380 n/a
Average Packet n/a n/a 1823.3 n/a
I/O Wait from RS
Count n/a n/a 831 n/a
Amount of Time (ms) n/a n/a 257250 n/a
Longest Wait (ms) n/a n/a 179026 n/a
Average Wait (ms) n/a n/a 309.6 n/a
--------------------------------------------------------------------------------
报告后续输出
Replication Server: SXCNCRSper sec per xact count% of total
--------------------------------------------
Log Scan Summary
Log Records Scanned n/a n/a 0 n/a
Log Records Processed n/a n/a 0 n/a
Log Scan Activity
Updates n/a n/a 0 n/a
Inserts n/a n/a 0 n/a
Deletes n/a n/a 0 n/a
Store Procedures n/a n/a 0 n/a
DDL Log Records n/a n/a 0 n/a
Writetext Log Records n/a n/a 0 n/a
Text/Image Log Records n/a n/a 0 n/a
CLRs n/a n/a 0 n/a
Transaction Activity
Opened n/a n/a 0 n/a
Commited n/a n/a 0 n/a
Aborted n/a n/a 0 n/a
Prepared n/a n/a 0 n/a
Maintenance User n/a n/a 0 n/a
Log Extension Wait
Count n/a n/a 0 n/a
Amount of time (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Time (ms) n/a n/a 0.0 n/a
Schema Cache Lookups
Forward Schema
Count n/a n/a 0 n/a
Total Wait (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Time (ms) n/a n/a 0.0 n/a
Backward Schema
Count n/a n/a 0 n/a
Total Wait (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Time (ms) n/a n/a 0.0 n/a
Truncation Point Movement
Moved n/a n/a 0 n/a
Gotten from RS n/a n/a 0 n/a
Connections to Replication Server
Success n/a n/a 0 n/a
Failed n/a n/a 0 n/a
Network Packet Information
Packets Sent n/a n/a 0 n/a
Full Packets Sent n/a n/a 0 n/a
Largest Packet n/a n/a 0 n/a
Amount of Bytes Sent n/a n/a 0 n/a
Average Packet n/a n/a 0.0 n/a
I/O Wait from RS
Count n/a n/a 0 n/a
Amount of Time (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Wait (ms) n/a n/a 0.0 n/a
--------------------------------------------------------------------------------
Replication Agent:workdb
Replication Server: SXCNCRS
per sec per xact count% of total
--------------------------------------------
Log Scan Summary
Log Records Scanned n/a n/a 1850 n/a
Log Records Processed n/a n/a 931 n/a
Log Scan Activity
Updates n/a n/a 0 n/a
Inserts n/a n/a 310 n/a
Deletes n/a n/a 0 n/a
Store Procedures n/a n/a 0 n/a
DDL Log Records n/a n/a 0 n/a
Writetext Log Records n/a n/a 0 n/a
Text/Image Log Records n/a n/a 0 n/a
CLRs n/a n/a 0 n/a
Transaction Activity
Opened n/a n/a 310 n/a
Commited n/a n/a 310 n/a
Aborted n/a n/a 0 n/a
Prepared n/a n/a 0 n/a
Maintenance User n/a n/a 0 n/a
Log Extension Wait
Count n/a n/a 19 n/a
Amount of time (ms) n/a n/a 135839 n/a
Longest Wait (ms) n/a n/a 16236 n/a
Average Time (ms) n/a n/a 7149.4 n/a
Schema Cache Lookups
Forward Schema
Count n/a n/a 0 n/a
Total Wait (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Time (ms) n/a n/a 0.0 n/a
Backward Schema
Count n/a n/a 0 n/a
Total Wait (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Time (ms) n/a n/a 0.0 n/a
Truncation Point Movement
Moved n/a n/a 3 n/a
Gotten from RS n/a n/a 4 n/a
Connections to Replication Server
Success n/a n/a 0 n/a
Failed n/a n/a 0 n/a
Network Packet Information
Packets Sent n/a n/a 140 n/a
Full Packets Sent n/a n/a 108 n/a
Largest Packet n/a n/a 2048 n/a
Amount of Bytes Sent n/a n/a 239852 n/a
Average Packet n/a n/a 1713.2 n/a
I/O Wait from RS
Count n/a n/a 145 n/a
Amount of Time (ms) n/a n/a 116840 n/a
Longest Wait (ms) n/a n/a 115046 n/a
Average Wait (ms) n/a n/a 805.8 n/a
--------------------------------------------------------------------------------
Replication Agent:worktradb
Replication Server: SXCNCRS
per sec per xact count% of total
--------------------------------------------
Log Scan Summary
Log Records Scanned n/a n/a 9818 n/a
Log Records Processed n/a n/a 4618 n/a
Log Scan Activity
Updates n/a n/a 0 n/a
Inserts n/a n/a 1539 n/a
Deletes n/a n/a 2 n/a
Store Procedures n/a n/a 0 n/a
DDL Log Records n/a n/a 0 n/a
Writetext Log Records n/a n/a 0 n/a
Text/Image Log Records n/a n/a 0 n/a
CLRs n/a n/a 0 n/a
Transaction Activity
Opened n/a n/a 1539 n/a
Commited n/a n/a 1538 n/a
Aborted n/a n/a 0 n/a
Prepared n/a n/a 0 n/a
Maintenance User n/a n/a 0 n/a
Log Extension Wait
Count n/a n/a 0 n/a
Amount of time (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Time (ms) n/a n/a 0.0 n/a
Schema Cache Lookups
Forward Schema
Count n/a n/a 0 n/a
Total Wait (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Time (ms) n/a n/a 0.0 n/a
Backward Schema
Count n/a n/a 0 n/a
Total Wait (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Time (ms) n/a n/a 0.0 n/a
Truncation Point Movement
Moved n/a n/a 4 n/a
Gotten from RS n/a n/a 4 n/a
Connections to Replication Server
Success n/a n/a 0 n/a
Failed n/a n/a 0 n/a
Network Packet Information
Packets Sent n/a n/a 792 n/a
Full Packets Sent n/a n/a 702 n/a
Largest Packet n/a n/a 2048 n/a
Amount of Bytes Sent n/a n/a 1463460 n/a
Average Packet n/a n/a 1847.8 n/a
I/O Wait from RS
Count n/a n/a 796 n/a
Amount of Time (ms) n/a n/a 258092 n/a
Longest Wait (ms) n/a n/a 179266 n/a
Average Wait (ms) n/a n/a 324.2 n/a
--------------------------------------------------------------------------------
=============================== End of Report ================================= Cache Search Misses 太高了
没有CACHE的报告?
回复 #8 flybean 的帖子
telalm_cache是我昨天白天加的,默认cache我也调高了,下午系统提升明显,晚上9点共单库(awsdyndbg)出现阻塞,不知道怎么会回滚的,进程ID1411不能kill,最后重启了server。但是不知道问题发生了原因,问题出现之前,有个客户对数据库进行了4000行记录的update操作SELECT 0
0 1411 sleeping telstar telstar sxcncwg2 0 awsdyndb
ROLLBACK 0
0 1434 lock sleep telstar telstar sxcncwg2 1411 awsdyndb
SELECT 0
0 1499 recv sleep telstar telstar sxcncwg2 0 staticdb
AWAITING COMMAND 0
0 1517 lock sleep telstar telstar sxcncwg2 1411 awsdyndb
SELECT 0
cache配置
sp_cacheconfig
2> go
Cache Name Status Type Config Value Run Value
------------------------------ --------- -------- ------------ ------------
awsdyndb_ews_cache Active Mixed 256.00 Mb 256.00 Mb
awsdyndb_ews_task_cache Active Mixed 1024.00 Mb 1024.00 Mb
default data cache Active Default 2048.00 Mb 2048.00 Mb
telalm_cache Active Mixed 2048.00 Mb 2048.00 Mb
tempdb_cache Active Mixed 2048.00 Mb 2048.00 Mb
worktradb_cache Active Mixed 1024.00 Mb 1024.00 Mb
------------ ------------
Total 8448.00 Mb 8448.00 Mb
==========================================================================
Cache: awsdyndb_ews_cache, Status: Active, Type: Mixed
Config Size: 256.00 Mb, Run Size: 256.00 Mb
Config Replacement: relaxed LRU, Run Replacement: relaxed LRU
Config Partition: 8, Run Partition: 8
IO SizeWash Size Config SizeRun Size APF Percent
-------- --------- ------------ ------------ -----------
8 Kb26176 Kb 0.00 Mb 128.00 Mb 10
16 Kb26112 Kb 128.00 Mb 128.00 Mb 10
==========================================================================
Cache: awsdyndb_ews_task_cache, Status: Active, Type: Mixed
Config Size: 1024.00 Mb, Run Size: 1024.00 Mb
Config Replacement: relaxed LRU, Run Replacement: relaxed LRU
Config Partition: 16, Run Partition: 16
IO SizeWash Size Config SizeRun Size APF Percent
-------- --------- ------------ ------------ -----------
8 Kb 157184 Kb 0.00 Mb 768.00 Mb 10
16 Kb52224 Kb 256.00 Mb 256.00 Mb 10
==========================================================================
Cache: default data cache, Status: Active, Type: Default
Config Size: 2048.00 Mb, Run Size: 2048.00 Mb
Config Replacement: relaxed LRU, Run Replacement: relaxed LRU
Config Partition: 1, Run Partition: 4
IO SizeWash Size Config SizeRun Size APF Percent
-------- --------- ------------ ------------ -----------
8 Kb 245760 Kb 0.00 Mb 2016.00 Mb 10
16 Kb 6528 Kb 32.00 Mb 32.00 Mb 10
==========================================================================
Cache: telalm_cache, Status: Active, Type: Mixed
Config Size: 2048.00 Mb, Run Size: 2048.00 Mb
Config Replacement: relaxed LRU, Run Replacement: strict LRU
Config Partition: 1, Run Partition: 1
IO SizeWash Size Config SizeRun Size APF Percent
-------- --------- ------------ ------------ -----------
8 Kb61440 Kb 0.00 Mb 1024.00 Mb 10
16 Kb61440 Kb 1024.00 Mb 1024.00 Mb 10
==========================================================================
Cache: tempdb_cache, Status: Active, Type: Mixed
Config Size: 2048.00 Mb, Run Size: 2048.00 Mb
Config Replacement: relaxed LRU, Run Replacement: relaxed LRU
Config Partition: 4, Run Partition: 4
IO SizeWash Size Config SizeRun Size APF Percent
-------- --------- ------------ ------------ -----------
8 Kb 209696 Kb 0.00 Mb 1024.00 Mb 10
16 Kb 209664 Kb 1024.00 Mb 1024.00 Mb 10
==========================================================================
Cache: worktradb_cache, Status: Active, Type: Mixed
Config Size: 1024.00 Mb, Run Size: 1024.00 Mb
Config Replacement: strict LRU, Run Replacement: strict LRU
Config Partition: 4, Run Partition: 4
IO SizeWash Size Config SizeRun Size APF Percent
-------- --------- ------------ ------------ -----------
8 Kb 183488 Kb 0.00 Mb 896.00 Mb 10
16 Kb26176 Kb 128.00 Mb 128.00 Mb 10
(return status = 0) 你的内存是怎么使用的?
建议只把tempdb绑到高速缓冲上,把其余的命名缓冲都去掉,同时加大default cache
max memory=?
页:
[1]
2