sybase 时快时慢大家帮忙看看sysmon

显示全部楼层 · 2007-10-20 08:38:44

如题
===============================================================================
Sybase Adaptive Server Enterprise System Performance Report
===============================================================================
Server Version:Adaptive Server Enterprise/15.0/EBF 12781 GA/P/HP9000-87
Server Name: DZGD

Run Date:
Dec 24, 2006

Sampling Started at: Dec 24, 2006 13:02:43

Sampling Ended at: Dec 24, 2006 13:12:44

Sample Interval: 00:10:01

Sample Mode: Reset Counters

===============================================================================
Kernel Utilization
------------------
Your Runnable Process Search Count is set to 2000

and I/O Polling Process Count is set to 30

Engine Busy UtilizationCPU Busy I/O Busy Idle

------------------------ -------- -------- --------
Engine 0
75.4 %0.0 % 24.6 %

Engine 1
78.9 %0.1 % 21.0 %

Engine 2
77.3 %0.0 % 22.7 %

------------------------ -------- -------- --------
Summary Total 231.5 %0.1 % 68.3 %

Average
77.2 %0.0 % 22.8 %

CPU Yields by Engine
per secper xact count% of total
---------------------------------------------------------------------
Engine 0
280.5 186.716858870.0 %
Engine 1
36.5
24.3 21944 9.1 %
Engine 2
83.8
55.8 5034620.9 %
-----------------------------------------------------------
Total CPU Yields
400.8 266.8240878

Network Checks
Non-Blocking
10482.66976.8 630003296.3 %
Blocking
400.8 266.8240878 3.7 %
-----------------------------------------------------------
Total Network I/O Checks10883.47243.5 6540910

Avg Net I/Os per Check
n/a n/a 0.00647 n/a
Disk I/O Checks
Total Disk I/O Checks 10910.47261.5 6557175 n/a
Checks Returning I/O
112.7
75.0 67716 1.0 %
Avg Disk I/Os Returned
n/a n/a 0.05291 n/a
Tuning Recommendations for Kernel Utilization

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

- Consider increasing the 'i/o polling process count'
configuration parameter.

===============================================================================
Worker Process Management
-------------------------

per secper 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 Sample0.0 0.0 0 n/a
Memory Requests for Worker Processes
Total Requests
0.0 0.0 0 n/a

===============================================================================
Parallel Query Management
-------------------------
Parallel Query Usage
per secper xact count% of total
---------------------------------------------------------------------
Total Parallel Queries
0.0 0.0 0 n/a
Merge Lock Requests
per secper xact count% of total
---------------------------------------------------------------------
Total # of Requests
0.0 0.0 0 n/a
Sort Buffer Waits
per secper xact count% of total
---------------------------------------------------------------------
Total # of Waits
0.0 0.0 0 n/a
===============================================================================
Task Management
per secper xact count% of total
-----------------------------------------------------------------------
Connections Opened
0.2 0.2 146 n/a
Task Context Switches by Engine
Engine 0
22.9
15.3 1378027.7 %
Engine 1
26.7
17.8 1607332.4 %
Engine 2
33.0
21.9 1981839.9 %
-----------------------------------------------------------
Total Task Switches:
82.6
55.0 49671

Task Context Switches Due To:
Voluntary Yields
13.5 9.0812416.4 %
Cache Search Misses
0.5 0.3 299 0.6 %
System Disk Writes
0.1 0.1
72 0.1 %
I/O Pacing
1.0 0.7 623 1.3 %
Logical Lock Contention 0.0 0.0 7 0.0 %
Address Lock Contention 0.0 0.0 0 0.0 %
Latch Contention
0.0 0.0 0 0.0 %
Log Semaphore Contention
0.0 0.0
11 0.0 %
PLC Lock Contention
0.0 0.0 4 0.0 %
Group Commit Sleeps
0.1 0.1
52 0.1 %
Last Log Page Writes
1.6 1.0 940 1.9 %
Modify Conflicts
0.1 0.0
36 0.1 %
I/O Device Contention
0.0 0.0 0 0.0 %
Network Packet Received
35.0
23.3 2103542.3 %
Network Packet Sent
2.1 1.41248 2.5 %
Other Causes
28.7
19.1 1722034.7 %

===============================================================================
Application Management
----------------------
Application Statistics Summary (All Applications)
-------------------------------------------------
Priority Changes
per secper xact count% of total
---------------------------------------------------------------------
To High Priority
0.0 0.0
23 3.5 %
To Medium Priority
0.7 0.4 40361.1 %
To Low Priority
0.4 0.3 23435.5 %
-----------------------------------------------------------
Total Priority Changes
1.1 0.7 660

Allotted Slices Exhausted per secper xact count% of total
---------------------------------------------------------------------
High Priority
0.0 0.0 0 0.0 %
Medium Priority
5.2 3.53141 100.0 %
Low Priority
0.0 0.0 0 0.0 %
-----------------------------------------------------------
Total Slices Exhausted
5.2 3.53141

Skipped Tasks By Engine per secper 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 secper xact count% of total
-----------------------------------------------------------------------
ESP Requests
0.0 0.0 0 n/a
===============================================================================
Housekeeper Task Activity
-------------------------

per secper xact count% of total

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

Garbage Collections
4.2 2.82548 n/a
Pages Processed in GC
0.0 0.0 0 n/a
Statistics Updates
0.4 0.2 222 n/a
===============================================================================
Monitor Access to Executing SQL
-------------------------------

per secper xact count% of total

--------------------------------------------
Waits on Execution Plans
0.0 0.0 0 n/a
Number of SQL Text Overflows0.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 secper xact count% of total
---------------------------------------------------------------------
Committed Xacts
1.5 n/a 903 n/a
Transaction Detail
per secper xact count% of total
---------------------------------------------------------------------
Inserts
APL Heap Table
0.0 0.0 0 0.0 %
APL Clustered Table
0.0 0.0 0 0.0 %
Data Only Lock Table
1.5 1.0 915 100.0 %
---------------------------------------------------------------------
Total Rows Inserted
1.5 1.0 91539.8 %
Updates
APL Deferred
0.0 0.0 0 0.0 %
APL Direct In-place
0.0 0.0 0 0.0 %
APL Direct Cheap
0.0 0.0 0 0.0 %
APL Direct Expensive
0.0 0.0 0 0.0 %
DOL Deferred
0.0 0.0 0 0.0 %
DOL Direct
2.3 1.51385 100.0 %
---------------------------------------------------------------------
Total Rows Updated
2.3 1.5138560.2 %
Data Only Locked Updates
DOL Replace
0.5 0.3 29621.4 %
DOL Shrink
0.0 0.0 0 0.0 %
DOL Cheap Expand
0.9 0.6 53638.7 %
DOL Expensive Expand
0.9 0.6 52037.5 %
DOL Expand & Forward
0.1 0.0
32 2.3 %
DOL Fwd Row Returned
0.0 0.0 1 0.1 %
---------------------------------------------------------------------
Total DOL Rows Updated
2.3 1.5138560.2 %
Deletes
Total Rows Deleted
0.0 0.0 0 n/a
===========================================================
Total Rows Affected
3.8 2.52300

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

千问 · 2007-10-20 08:38:44

Transaction Management
----------------------
ULC Flushes to Xact Log per secper xact count% of total
---------------------------------------------------------------------
by Full ULC
0.1 0.1
46 1.5 %
by End Transaction
1.6 1.1 96331.2 %
by Change of Database
0.0 0.0
10 0.3 %
by Single Log Record
0.4 0.2 215 7.0 %
by Unpin
0.1 0.1
85 2.8 %
by Other
2.9 2.0176857.3 %
-----------------------------------------------------------
Total ULC Flushes
5.1 3.43087

ULC Log Records
17.3
11.5 10393 n/a
Max ULC Size During Sample
n/a n/a8192 n/a
ULC Semaphore Requests
Granted
44.7
29.8 26889 100.0 %
Waited
0.0 0.0 4 0.0 %
-----------------------------------------------------------
Total ULC Semaphore Req
44.7
29.8 26893

Log Semaphore Requests
Granted
2.5 1.7151699.3 %
Waited
0.0 0.0
11 0.7 %
-----------------------------------------------------------
Total Log Semaphore Req
2.5 1.71527

Transaction Log Writes
1.9 1.31156 n/a
Transaction Log Alloc
0.3 0.2 207 n/a
Avg # Writes per Log Page n/a n/a 5.58454 n/a
===============================================================================
Index Management
----------------
Nonclustered Maintenanceper secper xact count% of total
---------------------------------------------------------------------
Ins/Upd Requiring Maint 0.0 0.0 0 n/a
# of NC Ndx Maint
0.0 0.0 0 n/a
Deletes Requiring Maint 0.0 0.0 0 n/a
# of NC Ndx Maint
0.0 0.0 0 n/a
RID Upd from Clust Split
0.0 0.0 0 n/a
# of NC Ndx Maint
0.0 0.0 0 n/a
Upd/Del DOL Req Maint
2.3 1.51385 n/a
# of DOL Ndx Maint
1.7 1.21045 n/a
Avg DOL Ndx Maint / Op
n/a n/a 0.75451 n/a
Page Splits
0.1 0.1
51 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 secper xact count% of total
---------------------------------------------------------------------
Ascending Scans
1.3 0.8 762 0.9 %
DOL Ascending Scans
147.0
97.8 8834499.1 %
Descending Scans
0.0 0.0
10 0.0 %
DOL Descending Scans
0.0 0.0 0 0.0 %

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

Total Scans
148.3
98.7 89116

===============================================================================
Metadata Cache Management
-------------------------
Metadata Cache Summary per secper xact count% of total
---------------------------------------------------------------------
Open Object Usage

Active
n/a n/a 695 n/a
Max Ever Used Since Boot
n/a n/a 695 n/a
Free
n/a n/a 10000 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/a1250 n/a
Max Ever Used Since Boot
n/a n/a1257 n/a
Free
n/a n/a 10000 n/a
Reuse Requests

Succeeded
n/a n/a 0 n/a
Failed
n/a n/a 0 n/a
Open Partition Usage

Active
n/a n/a1345 n/a
Max Ever Used Since Boot
n/a n/a1352 n/a
Free
n/a n/a 70000 n/a
Reuse Requests

Succeeded
n/a n/a 0 n/a
Failed
n/a n/a 0 n/a
Open Database Usage

Active
n/a n/a
11 n/a
Max Ever Used Since Boot
n/a n/a
11 n/a
Free
n/a n/a
12 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 0.0 %
Object Spinlock Contention
n/a n/a n/a 0.0 %
Index Spinlock Contention n/a n/a n/a 0.0 %
Index Hash Spinlock Contentionn/a n/a n/a 0.0 %
Partition Spinlock Contention n/a n/a n/a 0.0 %
Partition Hash Spinlock Contentionn/a n/a n/a 0.0 %
===============================================================================
Lock Management
---------------
Lock Summary
per secper xact count% of total
---------------------------------------------------------------------
Total Lock Requests
1207.2 803.5725540 n/a
Avg Lock Contention
0.0 0.0 7 0.0 %
Deadlock Percentage
0.0 0.0 0 0.0 %
Lock Detail
per secper xact count% of total
---------------------------------------------------------------------
Table Lock Hashtable
Lookups
76.2
50.7 45820 n/a
Avg Chain Length
n/a n/a 0.00711 n/a
Spinlock Contention
n/a n/a n/a 0.0 %
Exclusive Table
Total EX-Table Requests 0.0 0.0 0 n/a
Shared Table
Total SH-Table Requests 0.0 0.0 0 n/a
Exclusive Intent
Granted
6.5 4.33928 100.0 %
Waited
0.0 0.0 0 0.0 %
---------------------------------------------------------------------
Total EX-Intent Requests
6.5 4.33928 0.5 %
Shared Intent
Granted
67.3
44.8 40440 100.0 %
Waited
0.0 0.0 0 0.0 %
---------------------------------------------------------------------
Total SH-Intent Requests 67.3
44.8 40440 5.6 %
Page & Row Lock HashTable
Lookups
1132.4 753.7680565 n/a
Avg Chain Length
n/a n/a 0.00108 n/a
Spinlock Contention
n/a n/a n/a 0.0 %
Exclusive Page
Granted
0.1 0.1
50 100.0 %
Waited
0.0 0.0 0 0.0 %
---------------------------------------------------------------------
Total EX-Page Requests
0.1 0.1
50 0.0 %
Update Page
Total UP-Page Requests
0.0 0.0 0 n/a
Shared Page
Granted
1.1 0.7 668 100.0 %
Waited
0.0 0.0 0 0.0 %
---------------------------------------------------------------------
Total SH-Page Requests
1.1 0.7 668 0.1 %

Exclusive Row
Granted
4.8 3.22880 100.0 %
Waited
0.0 0.0 0 0.0 %
---------------------------------------------------------------------
Total EX-Row Requests
4.8 3.22880 0.4 %
Update Row
Granted
1.7 1.1 999 100.0 %
Waited
0.0 0.0 0 0.0 %
---------------------------------------------------------------------
Total UP-Row Requests
1.7 1.1 999 0.1 %
Shared Row
Granted
1124.1 748.2675584 100.0 %
Waited
0.0 0.0 7 0.0 %
---------------------------------------------------------------------
Total SH-Row Requests
1124.1 748.267559193.1 %

Next-Key
Total Next-Key Requests 0.0 0.0 0 n/a
Address Lock Hashtable
Lookups
1.6 1.1 984 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
0.2 0.2 142 100.0 %
Waited
0.0 0.0 0 0.0 %
---------------------------------------------------------------------
Total EX-Address Requests 0.2 0.2 142 0.0 %
Shared Address
Granted
1.4 0.9 842 100.0 %
Waited
0.0 0.0 0 0.0 %
---------------------------------------------------------------------
Total SH-Address Requests 1.4 0.9 842 0.1 %

Last Page Locks on Heaps
Total Last Pg Locks
0.0 0.0 0 n/a
Deadlocks by Lock Type
per secper xact count% of total
---------------------------------------------------------------------
Total Deadlocks
0.0 0.0 0 n/a

Deadlock Detection
Deadlock Searches
0.0 0.0 5 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
Total Lock Promotions
0.0 0.0 0 n/a

Lock Timeouts by Lock Typeper secper 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.

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

千问 · 2007-10-20 08:38:44

Data Cache Management
---------------------
Cache Statistics Summary (All Caches)
-------------------------------------

per secper xact count% of total

--------------------------------------------
Cache Search Summary
Total Cache Hits
11696.97785.0 702982499.9 %
Total Cache Misses
14.9 9.98944 0.1 %
-----------------------------------------------------------
Total Cache Searches
11711.87794.9 7038768

Cache Turnover
Buffers Grabbed
24.9
16.6 14980 n/a
Buffers Grabbed Dirty 0.0 0.0 2 0.0 %
Cache Strategy Summary
Cached (LRU) Buffers 7301.34859.5 438809599.7 %
Discarded (MRU) Buffers24.3
16.1 14578 0.3 %
Large I/O Usage
Large I/Os Performed
5.0 3.3301799.6 %
Large I/Os Denied due to

Pool < Prefetch Size
0.0 0.0
13 0.4 %
-----------------------------------------------------------
Total Large I/O Requests
5.0 3.43030

Large I/O Effectiveness
Pages by Lrg I/O Cached40.2
26.7 24136 n/a
Pages by Lrg I/O Used 6.0 4.0358014.8 %
Asynchronous Prefetch Activity
APFs Issued
0.9 0.6 543 0.0 %
APFs Denied Due To

APF I/O Overloads
0.0 0.0 0 0.0 %
APF Limit Overloads 0.0 0.0 0 0.0 %
APF Reused Overloads
0.0 0.0 0 0.0 %
APF Buffers Found in Cache

With Spinlock Held
0.0 0.0 0 0.0 %
W/o Spinlock Held
2148.71430.1 1291359 100.0 %
-----------------------------------------------------------
Total APFs Requested 2149.61430.7 1291902

Other Asynchronous Prefetch Statistics
APFs Used
0.9 0.6 542 n/a
APF Waits for I/O
0.9 0.6 537 n/a
APF Discards
0.0 0.0 0 n/a
Dirty Read Behavior
Page Requests
0.0 0.0 0 n/a
-------------------------------------------------------------------------------
Cache: default data cache

per secper xact count% of total
---------------------------------------------------------------------
Spinlock Contention
n/a n/a n/a 0.0 %
Utilization
n/a n/a n/a 100.0 %
Cache Searches
Cache Hits
11696.97785.0 702982499.9 %
Found in Wash
0.0 0.0 0 0.0 %
Cache Misses
14.9 9.98944 0.1 %
-----------------------------------------------------------
Total Cache Searches
11711.87794.9 7038768
Pool Turnover
8Kb Pool

LRU Buffer Grab
19.9
13.2 1196179.8 %

Grabbed Dirty
0.0 0.0 0 0.0 %
64 Kb Pool

LRU Buffer Grab
5.0 3.3301720.1 %

Grabbed Dirty
0.0 0.0 2 0.1 %
-----------------------------------------------------------
Total Cache Turnover
24.9
16.6 14980
Buffer Wash Behavior
Statistics Not Available - No Buffers Entered Wash Section Yet
Cache Strategy
Cached (LRU) Buffers 7301.34859.5 438809599.7 %
Discarded (MRU) Buffers24.3
16.1 14578 0.3 %
Large I/O Usage
Large I/Os Performed
5.0 3.3301799.6 %
Large I/Os Denied due to
Pool < Prefetch Size
0.0 0.0
13 0.4 %
-----------------------------------------------------------
Total Large I/O Requests
5.0 3.43030
Large I/O Detail
64Kb Pool
Pages Cached
40.2
26.7 24136 n/a
Pages Used
6.0 4.0358014.8 %
Dirty Read Behavior

Page Requests
0.0 0.0 0 n/a
Tuning Recommendations for Data cache : default data cache
-------------------------------------

- Consider increasing the 'wash size' of the 64k pool for this cache.
===============================================================================

千问 · 2007-10-20 08:38:44

Procedure Cache Managementper secper xact count% of total
-----------------------------------------------------------------------
Procedure Requests
0.0 0.0 0 n/a
SQL Statement Cache:
Statements Cached
0.0 0.0 0 n/a
Statements Found in Cache 0.0 0.0 0 n/a
Statements Not Found
0.0 0.0 0 n/a
Statements Dropped
0.0 0.0 0 n/a
Statements Restored
0.0 0.0 0 n/a
Statements Not Cached
15.6
10.49389 n/a

===============================================================================
Memory Management
per secper xact count% of total
-----------------------------------------------------------------------
Pages Allocated
217.5 144.8130735 n/a
Pages Released
217.5 144.8130735 n/a
===============================================================================
Recovery Management
-------------------
Checkpoints
per secper xact count% of total
---------------------------------------------------------------------
# of Normal Checkpoints 0.0 0.0
10 100.0 %
# of Free Checkpoints
0.0 0.0 0 0.0 %
-----------------------------------------------------------

Total Checkpoints
0.0 0.0
10

Avg Time per Normal Chkpt 0.20000 seconds

===============================================================================
Disk I/O Management
-------------------
Max Outstanding I/Os
per secper xact count% of total
---------------------------------------------------------------------
Server
n/a n/a 0 n/a
Engine 0
n/a n/a
20 n/a
Engine 1
n/a n/a
13 n/a
Engine 2
n/a n/a
14 n/a

I/Os Delayed by
Disk I/O Structures
n/a n/a 0 n/a
Server Config Limit
n/a n/a 0 n/a
Engine Config Limit
n/a n/a 0 n/a
Operating System Limit
n/a n/a 0 n/a

Total Requested Disk I/Os 6.0 4.03583

Completed Disk I/O's
Engine 0
1.9 1.2112831.5 %
Engine 1
2.2 1.5133137.1 %
Engine 2
1.9 1.2112431.4 %
-----------------------------------------------------------

Total Completed I/Os
6.0 4.03583

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

/dev/vgdzgd/rdsdzgd_dev1

dsdzgd_dev1
per secper 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/vgdzgd/rdsdzgd_dev2

dsdzgd_dev2
per secper 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/vgdzgd/rdsdzgd_dev3

dsdzgd_dev3
per secper 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/vgdzgd/rdsdzgd_dev4

dsdzgd_dev4
per secper 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/vgdzgd/rdsdzgd_dev5

dsdzgd_dev5
per secper 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/vgdzgd/rdsdzgd_log1

dsdzgd_log1
per secper 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/vgdzgd/rdzgdceshi_dev1

dzgdceshi_dev1
per secper xact count% of total
---------------------------------------------------------------------
Total I/Os
0.0 0.0 0 n/a
---------------------------------------------------------------------
Total I/Os
0.0 0.0 0 0.0 %

千问 · 2007-10-20 08:38:44

Device:

/dev/vgdzgd/rdzgdceshi_log1

dzgdceshi_log1
per secper 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/vgdzgd/rdzgdtest_dev1

dzgdtest_dev1
per secper xact count% of total
---------------------------------------------------------------------
Reads

APF
0.0 0.0 0 0.0 %
Non-APF
0.0 0.0 3 100.0 %
Writes
0.0 0.0 0 0.0 %
---------------------------------------------------------------------
Total I/Os
0.0 0.0 3 0.1 %

-----------------------------------------------------------------------------
Device:

/dev/vgdzgd/rdzgdtest_dev2

dzgdtest_dev2
per secper 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/vgdzgd/rdzgdtest_log1

dzgdtest_log1
per secper 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/vgdzgd/rldzgdtest_dev1

ldzgdtest_dev1
per secper 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/vgdzgd/rldzgdtest_log1

ldzgdtest_log1
per secper 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/vgdzgd/rmaster

master
per secper 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
22 100.0 %
---------------------------------------------------------------------
Total I/Os
0.0 0.0
22 0.6 %

-----------------------------------------------------------------------------
Device:

/dev/vgdzgd/rstdzgd_dev1

stdzgd_dev1
per secper xact count% of total
---------------------------------------------------------------------
Reads

APF
0.0 0.0
13 8.8 %
Non-APF
0.1 0.1
7047.6 %
Writes
0.1 0.1
6443.5 %
---------------------------------------------------------------------
Total I/Os
0.2 0.2 147 4.1 %

-----------------------------------------------------------------------------
Device:

/dev/vgdzgd/rstdzgd_dev2

stdzgd_dev2
per secper 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/vgdzgd/rstdzgd_log1

stdzgd_log1
per secper 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.1
49 100.0 %
---------------------------------------------------------------------
Total I/Os
0.1 0.1
49 1.4 %

-----------------------------------------------------------------------------
Device:

/dev/vgdzgd/rsybsys

systemdbdev
per secper 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/vgdzgd/rsysproc

sysprocsdev
per secper 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/vgdzgd/rtemp_dev1

temp_dev1
per secper xact count% of total
---------------------------------------------------------------------
Reads

APF
0.0 0.0 0 0.0 %
Non-APF
0.1 0.1
4618.0 %
Writes
0.3 0.2 21082.0 %
---------------------------------------------------------------------
Total I/Os
0.4 0.3 256 7.1 %

-----------------------------------------------------------------------------
Device:

/dev/vgdzgd/rxadzgd_dev1

xadzgd_dev1
per secper xact count% of total
---------------------------------------------------------------------
Reads

APF
0.9 0.6 53026.6 %
Non-APF
0.3 0.2 180 9.0 %
Writes
2.1 1.4128264.4 %
---------------------------------------------------------------------
Total I/Os
3.3 2.2199255.6 %

-----------------------------------------------------------------------------
Device:

/dev/vgdzgd/rxadzgd_dev2

xadzgd_dev2
per secper 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/vgdzgd/rxadzgd_dev3

xadzgd_dev3
per secper 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/vgdzgd/rxadzgd_dev4

xadzgd_dev4
per secper 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/vgdzgd/rxadzgd_dev5

xadzgd_dev5
per secper 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/vgdzgd/rxadzgd_dev6

xadzgd_dev6
per secper 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/vgdzgd/rxadzgd_log1

xadzgd_log1
per secper 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/vgdzgd/rxadzgd_log2

xadzgd_log2
per secper xact count% of total
---------------------------------------------------------------------
Reads

APF
0.0 0.0 0 0.0 %
Non-APF
0.0 0.0 0 0.0 %
Writes
1.9 1.21114 100.0 %
---------------------------------------------------------------------
Total I/Os
1.9 1.2111431.1 %

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

千问 · 2007-10-20 08:38:44

Network I/O Management
----------------------
Total Network I/O Requests 37.1
24.7 22283 n/a
Network I/Os Delayed
0.0 0.0 0 0.0 %

Total TDS Packets Receivedper secper xact count% of total
---------------------------------------------------------------------
Engine 0
9.9 6.6597028.4 %
Engine 1
10.8 7.2647330.8 %
Engine 2
14.3 9.5860240.9 %
-----------------------------------------------------------

Total TDS Packets Rec'd
35.0
23.3 21045

Total Bytes Received
per secper xact count% of total
---------------------------------------------------------------------
Engine 0
1483.5 987.489159928.5 %
Engine 1
1517.21009.891185129.1 %
Engine 2
2208.41469.8 132727342.4 %
-----------------------------------------------------------

Total Bytes Rec'd
5209.23467.0 3130723

Avg Bytes Rec'd per Packet
n/a n/a 148 n/a
-----------------------------------------------------------------------------
Total TDS Packets Sent
per secper xact count% of total
---------------------------------------------------------------------
Engine 0
10.0 6.7601028.3 %
Engine 1
10.9 7.2653430.7 %
Engine 2
14.5 9.7871941.0 %
-----------------------------------------------------------

Total TDS Packets Sent
35.4
23.5 21263

Total Bytes Sent
per secper xact count% of total
---------------------------------------------------------------------
Engine 0
6754.54495.5 405942935.7 %
Engine 1
6161.74100.9 370315232.6 %
Engine 2
5992.93988.6 360173731.7 %
-----------------------------------------------------------

Total Bytes Sent
18909.0 12585.111364318

Avg Bytes Sent per Packet n/a n/a 534 n/a
=============================== End of Report =================================

千问 · 2007-10-20 08:38:44

看报告就是这段时间看起来很少任务运行！
i/o polling process count为什么设定到30?IO密集？

千问 · 2007-10-20 08:38:44

我们这个系统正常情况下io非常密集的，因为这是一个准实时的系统（电信行业）。但是我做sysmon是系统比较空闲的时候。现在的情况是正常情况下我入库需要执行一个select count(*) 判断是否对应主键的记录已经存在，然后执行4条insert语句往表里面插入记录。奇怪的是有时候1秒能够入库18笔业务，但是有时候一个insert语句可能就需要长达6秒！！！非常恐怖

千问 · 2007-10-20 08:38:44

判断primary key自己写sql控制,业务没有控制？不知道表有多大，sp_spaceusedtab_name,1看看空间sp_cacheconfig,sp_helpindex tab_name，如果不存在争用或者block，索引覆盖扫描应该是非常快的，特别是cached的情况下,即使数据行特别多，如果索引设计没有问题也不会非常大!
sysmon对于单个sql的简单业务用处不大的，看看查询计划和IO和当时的锁！

千问 · 2007-10-20 08:38:44

昨天晚上我对部分表做了reorg rebuild操作，但是从今天的观察来看似乎没有太大的好转。另外做完后用 sp_spaceused观察发现现在data size 和index size差不多，不象前几天index size是data size的10几倍了，高手还有什么好的建议吗？

sybase 时快时慢 大家帮忙看看sysmon

sybase 时快时慢大家帮忙看看sysmon