- 论坛徽章:
- 0
|
求救:关于sp_reportstats的CPU占用100%,
sp_sysmon 结果:
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.
===============================================================================
Sybase Adaptive Server Enterprise System Performance Report
===============================================================================
Server Version: Adaptive Server Enterprise/12.5.0.1/EBF 10442 GA/P/RS600
Server Name: hncrc
Run Date: Feb 05, 2004
Statistics Cleared at: 17:10:32
Statistics Sampled at: 17:11:32
Sample Interval: 00:01:00
===============================================================================
Kernel Utilization
------------------
Engine Busy Utilization
Engine 0 0.0 %
Engine 1 0.0 %
----------- --------------- ----------------
Summary Total 0.0 % Average 0.0 %
CPU Yields by Engine per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total CPU Yields 0.0 0.0 0 n/a
Network Checks
Non-Blocking 256.9 1284.6 15415 68.1 %
Blocking 120.1 600.6 7207 31.9 %
------------------------- ------------ ------------ ----------
Total Network I/O Checks 377.0 1885.2 22622
Avg Net I/Os per Check n/a n/a 0.00376 n/a
Disk I/O Checks
Total Disk I/O Checks 1885.2 9425.9 113111 n/a
Checks Returning I/O 32.8 164.1 1969 1.7 %
Avg Disk I/Os Returned n/a n/a 0.00660 n/a
===============================================================================
Worker Process Management
-------------------------
per sec per xact count % of total
------------ ------------ ---------- ----------
Worker Process Requests
Total Requests 0.0 0.0 0 n/a
Worker Process Usage
Total Used 0.0 0.0 0 n/a
Max Ever Used During Sample 0.0 0.0 0 n/a
Memory Requests for Worker Processes
Total Requests 0.0 0.0 0 n/a
===============================================================================
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.0 0.0 0 n/a
Task Context Switches by Engine
Engine 0 1.9 9.5 114 96.6 %
Engine 1 0.1 0.3 4 3.4 %
------------------------- ------------ ------------ ----------
Total Task Switches: 2.0 9.8 118
Task Context Switches Due To:
Voluntary Yields 0.2 0.8 10 8.5 %
Cache Search Misses 0.0 0.0 0 0.0 %
System Disk Writes 0.1 0.6 7 5.9 %
I/O Pacing 0.0 0.2 2 1.7 %
Logical Lock Contention 0.0 0.0 0 0.0 %
Address Lock Contention 0.0 0.0 0 0.0 %
Latch Contention 0.0 0.0 0 0.0 %
Log Semaphore Contention 0.0 0.0 0 0.0 %
PLC Lock Contention 0.0 0.0 0 0.0 %
Group Commit Sleeps 0.0 0.0 0 0.0 %
Last Log Page Writes 0.1 0.3 4 3.4 %
Modify Conflicts 0.0 0.0 0 0.0 %
I/O Device Contention 0.0 0.0 0 0.0 %
Network Packet Received 0.6 2.9 35 29.7 %
Network Packet Sent 0.8 4.2 50 42.4 %
Other Causes 0.2 0.8 10 8.5 %
===============================================================================
Application Management
----------------------
Application Statistics Summary (All Applications)
-------------------------------------------------
Priority Changes per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
To High Priority 0.0 0.0 0 0.0 %
To Medium Priority 0.3 1.7 20 50.0 %
To Low Priority 0.3 1.7 20 50.0 %
------------------------- ------------ ------------ ----------
Total Priority Changes 0.7 3.3 40
Allotted Slices Exhausted per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total Slices Exhausted 0.0 0.0 0 n/a
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 5.3 26.7 320 100.0 %
Dirty 0.0 0.0 0 0.0 %
------------ ------------ ----------
Total Washes 5.3 26.7 320
Garbage Collections 0.7 3.7 44 n/a
Pages Processed in GC 0.0 0.0 0 n/a
Statistics Updates 0.7 3.7 44 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 0.2 n/a 12 n/a
Transaction Detail per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total Rows Affected 0.0 0.0 0 n/a
===============================================================================
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 0.0 0.2 2 11.1 %
by Change of Database 0.0 0.1 1 5.6 %
by Single Log Record 0.1 0.3 3 16.7 %
by Other 0.2 1.0 12 66.7 %
------------------------- ------------ ------------ ----------
Total ULC Flushes 0.3 1.5 18
ULC Log Records 0.2 0.9 11 n/a
Max ULC Size During Sample n/a n/a 344 n/a
ULC Semaphore Requests
Granted 1.2 6.1 73 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total ULC Semaphore Req 1.2 6.1 73
Log Semaphore Requests
Granted 0.2 1.2 14 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Log Semaphore Req 0.2 1.2 14
Transaction Log Writes 0.1 0.4 5 n/a
Transaction Log Alloc 0.0 0.0 0 n/a
===============================================================================
Index Management
----------------
Nonclustered Maintenance per sec per 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 0.0 0.0 0 n/a
# of DOL Ndx Maint 0.0 0.0 0 n/a
Page Splits 0.0 0.0 0 n/a
Page Shrinks 0.0 0.0 0 n/a
Index Scans per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Ascending Scans 2.0 9.8 117 66.5 %
DOL Ascending Scans 1.0 4.8 58 33.0 %
Descending Scans 0.0 0.1 1 0.6 %
DOL Descending Scans 0.0 0.0 0 0.0 %
------------ ------------ ----------
Total Scans 2.9 14.7 176
===============================================================================
Lock Management
---------------
Lock Summary per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total Lock Requests 6.3 31.5 378 n/a
Avg Lock Contention 0.0 0.0 0 0.0 %
Deadlock Percentage 0.0 0.0 0 0.0 %
Lock Detail per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Table Lock Hashtable
Lookups 1.6 8.2 98 n/a
Avg Chain Length n/a n/a 0.00000 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
Total EX-Intent Requests 0.0 0.0 0 n/a
Shared Intent
Granted 1.6 8.2 98 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Intent Requests 1.6 8.2 98 25.9 %
Page & Row Lock HashTable
Lookups 3.3 16.3 195 n/a
Avg Chain Length n/a n/a 0.00000 n/a
Spinlock Contention n/a n/a n/a 0.0 %
Exclusive Page
Granted 0.0 0.1 1 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Page Requests 0.0 0.1 1 0.3 %
Update Page
Granted 0.0 0.1 1 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total UP-Page Requests 0.0 0.1 1 0.3 %
Shared Page
Granted 2.4 12.2 146 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Page Requests 2.4 12.2 146 38.6 %
Exclusive Row
Total EX-Row Requests 0.0 0.0 0 n/a
Update Row
Total UP-Row Requests 0.0 0.0 0 n/a
Shared Row
Granted 0.5 2.4 29 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Row Requests 0.5 2.4 29 7.7 %
Next-Key
Total Next-Key Requests 0.0 0.0 0 n/a
Address Lock Hashtable
Lookups 1.7 8.6 103 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.9 11 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Address Requests 0.2 0.9 11 2.9 %
Shared Address
Granted 1.5 7.7 92 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Address Requests 1.5 7.7 92 24.3 %
Last Page Locks on Heaps
Total Last Pg Locks 0.0 0.0 0 n/a
Deadlocks by Lock Type per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total Deadlocks 0.0 0.0 0 n/a
Deadlock Detection
Deadlock Searches 0.0 0.0 0 n/a
Lock Promotions
Total Lock Promotions 0.0 0.0 0 n/a
Lock Timeouts by Lock Type per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total Timeouts 0.0 0.0 0 n/a
Tuning Recommendations for Lock Management
------------------------------------------
===============================================================================
Data Cache Management
---------------------
Cache Statistics Summary (All Caches)
-------------------------------------
per sec per xact count % of total
------------ ------------ ---------- ----------
Cache Search Summary
Total Cache Hits 6.5 32.3 388 100.0 %
Total Cache Misses 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Cache Searches 6.5 32.3 388
Cache Turnover
Buffers Grabbed 0.0 0.0 0 n/a
Cache Strategy Summary
Cached (LRU) Buffers 6.4 31.9 383 100.0 %
Discarded (MRU) Buffers 0.0 0.0 0 0.0 %
Large I/O Usage
0.0 0.0 0 n/a
Large I/O Effectiveness
Pages by Lrg I/O Cached 0.0 0.0 0 n/a
Asynchronous Prefetch Activity
0.0 0.0 0 n/a
Other Asynchronous Prefetch Statistics
APFs Used 0.0 0.0 0 n/a
APF Waits for I/O 0.0 0.0 0 n/a
APF Discards 0.0 0.0 0 n/a
Dirty Read Behavior
Page Requests 0.0 0.0 0 n/a
-------------------------------------------------------------------------------
Cache: default data cache
per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Spinlock Contention n/a n/a n/a 0.0 %
Utilization n/a n/a n/a 100.0 %
Cache Searches
Cache Hits 6.5 32.3 388 100.0 %
Found in Wash 0.0 0.0 0 0.0 %
Cache Misses 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Cache Searches 6.5 32.3 388
Pool Turnover 0.0 0.0 0 n/a
Buffer Wash Behavior
Statistics Not Available - No Buffers Entered Wash Section Yet
Cache Strategy
Cached (LRU) Buffers 6.4 31.9 383 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
No Large Pool(s) In This Cache
Dirty Read Behavior
Page Requests 0.0 0.0 0 n/a
Tuning Recommendations for Data cache : default data cache
-------------------------------------
- Consider using 'relaxed LRU replacement policy'
for this cache.
- Consider adding a large I/O pool for this cache.
===============================================================================
Procedure Cache Management per sec per xact count % of total
--------------------------- ------------ ------------ ---------- ----------
Procedure Requests 0.0 0.0 0 n/a
===============================================================================
Memory Management per sec per xact count % of total
--------------------------- ------------ ------------ ---------- ----------
Pages Allocated 0.1 0.5 6 n/a
Pages Released 0.1 0.5 6 n/a
===============================================================================
Recovery Management
-------------------
Checkpoints per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
# of Normal Checkpoints 0.0 0.1 1 100.0 %
# of Free Checkpoints 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Checkpoints 0.0 0.1 1
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 1 n/a
Engine 1 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 0.2 1.1 13
Completed Disk I/O's
Engine 0 0.2 1.1 13 100.0 %
Engine 1 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Completed I/Os 0.2 1.1 13
Device Activity Detail
----------------------
Device:
/dev/lv_ttidc
bill 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/lv_userdb
ttidc 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/rlv_master
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.6 7 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.1 0.6 7 53.8 %
Device Semaphore Granted 0.1 0.6 7 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/rlv_sysproc
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/rlv_tempdb
tempdbdev 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.5 6 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.1 0.5 6 46.2 %
Device Semaphore Granted 0.1 0.5 6 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
===============================================================================
Network I/O Management
----------------------
Total Network I/O Requests 0.6 2.9 35 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 0.6 2.9 35 100.0 %
Engine 1 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total TDS Packets Rec'd 0.6 2.9 35
Total Bytes Received per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 61.8 309.1 3709 100.0 %
Engine 1 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Bytes Rec'd 61.8 309.1 3709
Avg Bytes Rec'd per Packet n/a n/a 105 n/a
-----------------------------------------------------------------------------
Total TDS Packets Sent per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 0.8 4.2 50 100.0 %
Engine 1 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total TDS Packets Sent 0.8 4.2 50
Total Bytes Sent per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 174.9 874.4 10493 100.0 %
Engine 1 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Bytes Sent 174.9 874.4 10493
Avg Bytes Sent per Packet n/a n/a 209 n/a
=============================== End of Report =================================
(return status = 0)
1>; |
|