- 论坛徽章:
- 0
|
硬件配置:sun fire880;8cpu,900m;16g内存;独立的数据库服务器.
软件配置:solaris8;sybase12.5
一直有点慢,3号在没有关sybase的情况下直接关了服务器,重启后暴慢.我贴了sp_sysmon,sp_configure,sp_helpdevice,sp_cacheconfig的log!在下现在是焦头烂额啊!哪位大虾帮忙诊断一下,救命救命!
1>; sp_sysmon "00:16:00"
2>; go
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/SWR 9610 GA/P/Sun_svr4/O
Server Name: zjdb
Run Date: Sep 06, 2004
Statistics Cleared at: 17:18:10
Statistics Sampled at: 17:34:10
Sample Interval: 00:16:00
===============================================================================
Kernel Utilization
------------------
Engine Busy Utilization
Engine 0 9.0 %
Engine 1 31.2 %
Engine 2 1.4 %
Engine 3 1.8 %
Engine 4 1.3 %
Engine 5 1.7 %
Engine 6 32.1 %
Engine 7 9.7 %
----------- --------------- ----------------
Summary Total 88.3 % Average 11.0 %
CPU Yields by Engine per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 13.7 1.1 13161 13.0 %
Engine 1 8.0 0.6 7724 7.7 %
Engine 2 15.4 1.2 14800 14.7 %
Engine 3 15.1 1.2 14524 14.4 %
Engine 4 15.4 1.2 14778 14.7 %
Engine 5 15.3 1.2 14651 14.5 %
Engine 6 8.7 0.7 8308 8.2 %
Engine 7 13.5 1.0 12926 12.8 %
------------------------- ------------ ------------ ----------
Total CPU Yields 105.1 8.1 100872
Network Checks
Non-Blocking 13917.9 1077.3 13361163 99.8 %
Blocking 30.3 2.3 29084 0.2 %
------------------------- ------------ ------------ ----------
Total Network I/O Checks 13948.2 1079.6 13390247
Avg Net I/Os per Check n/a n/a 0.00726 n/a
Disk I/O Checks
Total Disk I/O Checks 69813.7 5403.6 67021186 n/a
Checks Returning I/O 43062.4 3333.1 41339941 61.7 %
Avg Disk I/Os Returned n/a n/a 0.00238 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 1 n/a
Task Context Switches by Engine
Engine 0 20.5 1.6 19706 7.5 %
Engine 1 108.3 8.4 103920 39.5 %
Engine 2 4.2 0.3 4015 1.5 %
Engine 3 7.4 0.6 7078 2.7 %
Engine 4 3.1 0.2 2958 1.1 %
Engine 5 5.5 0.4 5236 2.0 %
Engine 6 98.2 7.6 94309 35.8 %
Engine 7 27.3 2.1 26168 9.9 %
------------------------- ------------ ------------ ----------
Total Task Switches: 274.4 21.2 263390
Task Context Switches Due To:
Voluntary Yields 31.0 2.4 29753 11.3 %
Cache Search Misses 0.1 0.0 80 0.0 %
System Disk Writes 19.0 1.5 18244 6.9 %
I/O Pacing 10.4 0.8 10015 3.8 %
Logical Lock Contention 0.0 0.0 0 0.0 %
Address Lock Contention 0.0 0.0 0 0.0 %
Latch Contention 0.0 0.0 5 0.0 %
Log Semaphore Contention 0.5 0.0 440 0.2 %
PLC Lock Contention 0.0 0.0 37 0.0 %
Group Commit Sleeps 3.2 0.2 3061 1.2 %
Last Log Page Writes 30.7 2.4 29478 11.2 %
Modify Conflicts 10.1 0.8 9677 3.7 %
I/O Device Contention 0.0 0.0 14 0.0 %
Network Packet Received 73.5 5.7 70588 26.8 %
Network Packet Sent 27.7 2.1 26610 10.1 %
Other Causes 68.1 5.3 65388 24.8 %
===============================================================================
Application Management
----------------------
Application Statistics Summary (All Applications)
-------------------------------------------------
Priority Changes per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
To High Priority 0.5 0.0 450 10.3 %
To Medium Priority 2.3 0.2 2186 50.0 %
To Low Priority 1.8 0.1 1735 39.7 %
------------------------- ------------ ------------ ----------
Total Priority Changes 4.6 0.4 4371
Allotted Slices Exhausted per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
High Priority 0.0 0.0 0 0.0 %
Medium Priority 0.0 0.0 1 50.0 %
Low Priority 0.0 0.0 1 50.0 %
------------------------- ------------ ------------ ----------
Total Slices Exhausted 0.0 0.0 2
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 29.4 2.3 28266 92.0 %
Dirty 2.6 0.2 2451 8.0 %
------------ ------------ ----------
Total Washes 32.0 2.5 30717
Garbage Collections 1.4 0.1 1387 n/a
Pages Processed in GC 0.0 0.0 0 n/a
Statistics Updates 1.4 0.1 1387 n/a
===============================================================================
Monitor Access to Executing SQL
-------------------------------
per sec per xact count % of total
------------ ------------ ---------- ----------
Waits on Execution Plans 0.0 0.0 0 n/a
Number of SQL Text Overflows 0.0 0.0 0 n/a
Maximum SQL Text Requested n/a n/a 0 n/a
(since beginning of sample)
===============================================================================
Transaction Profile
-------------------
Transaction Summary per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Committed Xacts 12.9 n/a 12403 n/a
Transaction Detail per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Inserts
APL Heap Table 277.7 21.5 266623 100.0 %
APL Clustered Table 0.0 0.0 40 0.0 %
Data Only Lock Table 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Inserted 277.8 21.5 266663 99.9 %
Updates
APL Deferred 0.0 0.0 0 0.0 %
APL Direct In-place 0.0 0.0 3 100.0 %
APL Direct Cheap 0.0 0.0 0 0.0 %
APL Direct Expensive 0.0 0.0 0 0.0 %
DOL Deferred 0.0 0.0 0 0.0 %
DOL Direct 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Updated 0.0 0.0 3 0.0 %
Data Only Locked Updates
Total Rows Updated 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total DOL Rows Updated 0.0 0.0 0 0.0 %
Deletes
APL Deferred 0.0 0.0 0 0.0 %
APL Direct 0.3 0.0 280 100.0 %
DOL 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Deleted 0.3 0.0 280 0.1 %
========================= ============ ============ ==========ure
Total Rows Affected 278.1 21.5 266946
===============================================================================
Transaction Management
----------------------
ULC Flushes to Xact Log per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
by Full ULC 16.8 1.3 16114 33.9 %
by End Transaction 13.5 1.0 12939 27.2 %
by Change of Database 0.0 0.0 29 0.1 %
by System Log Record 12.3 1.0 11846 24.9 %
by Other 6.9 0.5 6651 14.0 %
------------------------- ------------ ------------ ----------
Total ULC Flushes 49.6 3.8 47579
ULC Log Records 660.8 51.1 634334 n/a
Max ULC Size During Sample n/a n/a 16384 n/a
ULC Semaphore Requests
Granted 1374.8 106.4 1319815 100.0 %
Waited 0.0 0.0 37 0.0 %
------------------------- ------------ ------------ ----------
Total ULC Semaphore Req 1374.8 106.4 1319852
Log Semaphore Requests
Granted 56.6 4.4 54288 99.2 %
Waited 0.5 0.0 440 0.8 %
------------------------- ------------ ------------ ----------
Total Log Semaphore Req 57.0 4.4 54728
Transaction Log Writes 36.1 2.8 34648 n/a
Transaction Log Alloc 35.8 2.8 34337 n/a
Avg # Writes per Log Page n/a n/a 1.00906 n/a
===============================================================================
Index Management
----------------
Nonclustered Maintenance per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Ins/Upd Requiring Maint 277.7 21.5 266546 n/a
# of NC Ndx Maint 277.7 21.5 266593 n/a
Avg NC Ndx Maint / Op n/a n/a 1.00018 n/a
Deletes Requiring Maint 0.2 0.0 203 n/a
# of NC Ndx Maint 0.2 0.0 200 n/a
Avg NC Ndx Maint / Op n/a n/a 0.98522 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 6.7 0.5 6455 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 6 n/a
Index Scans per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Ascending Scans 51.9 4.0 49847 92.0 %
DOL Ascending Scans 0.7 0.1 640 1.2 %
Descending Scans 3.9 0.3 3712 6.8 %
DOL Descending Scans 0.0 0.0 0 0.0 %
------------ ------------ ----------
Total Scans 56.5 4.4 54199
===============================================================================
Metadata Cache Management
-------------------------
Metadata Cache Summary per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Open Object Usage
Active n/a n/a 300 n/a
Max Ever Used Since Boot n/a n/a 306 n/a
Free n/a n/a 4700 n/a
Reuse Requests
Succeeded n/a n/a 0 n/a
Failed n/a n/a 0 n/a
Open Index Usage
Active n/a n/a 351 n/a
Max Ever Used Since Boot n/a n/a 357 n/a
Free n/a n/a 4649 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 8 n/a
Max Ever Used Since Boot n/a n/a 8 n/a
Free n/a n/a 4 n/a
Reuse Requests
Succeeded n/a n/a 0 n/a
Failed n/a n/a 0 n/a
Object Spinlock Contention n/a n/a n/a 0.0 %
Index Spinlock Contention n/a n/a n/a 0.0 %
Hash Spinlock Contention n/a n/a n/a 0.0 %
===============================================================================
Lock Management
---------------
Lock Summary per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total Lock Requests 1705.7 132.0 1637484 n/a
Avg Lock Contention 0.0 0.0 0 0.0 %
Deadlock Percentage 0.0 0.0 0 0.0 %
Lock Hashtable Lookups 2130.5 164.9 2045273 n/a
Avg Hash Chain Length n/a n/a 0.00453 n/a
Lock Detail per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Exclusive Table
Granted 0.0 0.0 35 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Table Requests 0.0 0.0 35 0.0 %
Shared Table
Total SH-Table Requests 0.0 0.0 0 n/a
Exclusive Intent
Granted 13.1 1.0 12569 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Intent Requests 13.1 1.0 12569 0.8 %
Shared Intent
Granted 34.2 2.7 32869 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Intent Requests 34.2 2.7 32869 2.0 %
Exclusive Page
Granted 173.0 13.4 166083 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Page Requests 173.0 13.4 166083 10.1 %
Update Page
Granted 4.3 0.3 4117 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total UP-Page Requests 4.3 0.3 4117 0.3 %
Shared Page
Granted 90.3 7.0 86715 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Page Requests 90.3 7.0 86715 5.3 %
Exclusive Row
Granted 0.6 0.0 538 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Row Requests 0.6 0.0 538 0.0 %
Update Row
Total UP-Row Requests 0.0 0.0 0 n/a
Shared Row
Granted 0.5 0.0 525 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Row Requests 0.5 0.0 525 0.0 %
Next-Key
Total Next-Key Requests 0.0 0.0 0 n/a
Exclusive Address
Granted 1289.9 99.8 1238338 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Address Requests 1289.9 99.8 1238338 75.6 %
Shared Address
Granted 99.7 7.7 95695 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Address Requests 99.7 7.7 95695 5.8 %
Last Page Locks on Heaps
Granted 277.7 21.5 266633 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total Last Pg Locks 277.7 21.5 266633 100.0 %
Deadlocks by Lock Type per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total Deadlocks 0.0 0.0 0 n/a
Deadlock Detection
Deadlock Searches 0.0 0.0 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 Type per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total Timeouts 0.0 0.0 0 n/a
===============================================================================
Data Cache Management
---------------------
Cache Statistics Summary (All Caches)
-------------------------------------
per sec per xact count % of total
------------ ------------ ---------- ----------
Cache Search Summary
Total Cache Hits 2141.0 165.7 2055359 89.6 %
Total Cache Misses 247.4 19.1 237488 10.4 %
------------------------- ------------ ------------ ----------
Total Cache Searches 2388.4 184.9 2292847
Cache Turnover
Buffers Grabbed 6.8 0.5 6559 n/a
Buffers Grabbed Dirty 0.0 0.0 0 0.0 %
Cache Strategy Summary
Cached (LRU) Buffers 2100.4 162.6 2016340 100.0 %
Discarded (MRU) Buffers 0.0 0.0 0 0.0 %
Large I/O Usage
Large I/Os Performed 5.8 0.4 5541 85.5 %
Large I/Os Denied 1.0 0.1 938 14.5 %
------------------------- ------------ ------------ ----------
Total Large I/O Requests 6.7 0.5 6479
Large I/O Effectiveness
Pages by Lrg I/O Cached 46.2 3.6 44328 n/a
Pages by Lrg I/O Used 11.5 0.9 11024 24.9 %
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: c7dbcache
per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Spinlock Contention n/a n/a n/a 0.0 %
Utilization n/a n/a n/a 95.2 %
Cache Searches
Cache Hits 2030.8 157.2 1949575 89.4 %
Found in Wash 7.2 0.6 6915 0.4 %
Cache Misses 241.9 18.7 232214 10.6 %
------------------------- ------------ ------------ ----------
Total Cache Searches 2272.7 175.9 2181789
Pool Turnover
2 Kb Pool
LRU Buffer Grab 0.1 0.0 80 5.5 %
Grabbed Dirty 0.0 0.0 0 0.0 %
16 Kb Pool
LRU Buffer Grab 1.4 0.1 1368 94.5 %
Grabbed Dirty 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Cache Turnover 1.5 0.1 1448
Buffer Wash Behavior
Statistics Not Available - No Buffers Entered Wash Section Yet
Cache Strategy
Cached (LRU) Buffers 2029.5 157.1 1948302 100.0 %
Discarded (MRU) Buffers 0.0 0.0 0 0.0 %
Large I/O Usage
Large I/Os Performed 1.4 0.1 1368 100.0 %
Large I/Os Denied 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Large I/O Requests 1.4 0.1 1368
Large I/O Detail
16 Kb Pool
Pages Cached 11.4 0.9 10944 n/a
Pages Used 11.4 0.9 10944 100.0 %
Dirty Read Behavior
Page Requests 0.0 0.0 0 n/a
-------------------------------------------------------------------------------
Cache: c7dblogcache
per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Spinlock Contention n/a n/a n/a 0.0 %
Utilization n/a n/a n/a 4.7 %
Cache Searches
Cache Hits 107.2 8.3 102959 95.3 %
Found in Wash 0.0 0.0 0 0.0 %
Cache Misses 5.3 0.4 5109 4.7 %
------------------------- ------------ ------------ ----------
Total Cache Searches 112.6 8.7 108068
Pool Turnover
2 Kb Pool
LRU Buffer Grab 1.0 0.1 938 18.4 %
Grabbed Dirty 0.0 0.0 0 0.0 %
16 Kb Pool
LRU Buffer Grab 4.3 0.3 4171 81.6 %
Grabbed Dirty 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Cache Turnover 5.3 0.4 5109
Buffer Wash Behavior
Statistics Not Available - No Buffers Entered Wash Section Yet
Cache Strategy
Cached (LRU) Buffers 68.0 5.3 65292 100.0 %
Discarded (MRU) Buffers 0.0 0.0 0 0.0 %
Large I/O Usage
Large I/Os Performed 4.3 0.3 4171 81.6 %
Large I/Os Denied 1.0 0.1 938 18.4 %
------------------------- ------------ ------------ ----------
Total Large I/O Requests 5.3 0.4 5109
Large I/O Detail
16 Kb Pool
Pages Cached 34.8 2.7 33368 n/a
Pages Used 0.0 0.0 0 0.0 %
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 0.1 %
Cache Searches
Cache Hits 1.9 0.1 1832 91.7 %
Found in Wash 0.7 0.1 642 35.0 %
Cache Misses 0.2 0.0 165 8.3 %
------------------------- ------------ ------------ ----------
Total Cache Searches 2.1 0.2 1997
Pool Turnover
16 Kb Pool
LRU Buffer Grab 0.0 0.0 2 100.0 %
Grabbed Dirty 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Cache Turnover 0.0 0.0 2
Buffer Wash Behavior
Statistics Not Available - No Buffers Entered Wash Section Yet
Cache Strategy
Cached (LRU) Buffers 1.8 0.1 1753 100.0 %
Discarded (MRU) Buffers 0.0 0.0 0 0.0 %
Large I/O Usage
Large I/Os Performed 0.0 0.0 2 100.0 %
Large I/Os Denied 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Large I/O Requests 0.0 0.0 2
Large I/O Detail
16 Kb Pool
Pages Cached 0.0 0.0 16 n/a
Pages Used 0.0 0.0 0 0.0 %
Dirty Read Behavior
Page Requests 0.0 0.0 0 n/a
-------------------------------------------------------------------------------
Cache: tempdbcache
per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Spinlock Contention n/a n/a n/a 0.0 %
Utilization n/a n/a n/a 0.0 %
Cache Searches
Cache Hits 1.0 0.1 993 100.0 %
Found in Wash 0.1 0.0 75 7.6 %
Cache Misses 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Cache Searches 1.0 0.1 993
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 1.0 0.1 993 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
16 Kb Pool
Pages Cached 0.0 0.0 0 n/a
Pages Used 0.0 0.0 0 n/a
Dirty Read Behavior
Page Requests 0.0 0.0 0 n/a
===============================================================================
Procedure Cache Management per sec per xact count % of total
--------------------------- ------------ ------------ ---------- ----------
Procedure Requests 0.0 0.0 32 n/a
Procedure Reads from Disk 0.0 0.0 0 0.0 %
Procedure Writes to Disk 0.0 0.0 0 0.0 %
Procedure Removals 0.0 0.0 32 n/a
===============================================================================
Memory Management per sec per xact count % of total
--------------------------- ------------ ------------ ---------- ----------
Pages Allocated 0.1 0.0 99 n/a
Pages Released 0.1 0.0 99 n/a
===============================================================================
Recovery Management
-------------------
Checkpoints per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
# of Normal Checkpoints 0.0 0.0 29 100.0 %
# of Free Checkpoints 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Checkpoints 0.0 0.0 29
Avg Time per Normal Chkpt 5.20690 seconds
===============================================================================
Disk I/O Management
-------------------
Max Outstanding I/Os per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Server n/a n/a 30 n/a
Engine 0 n/a n/a 12 n/a
Engine 1 n/a n/a 30 n/a
Engine 2 n/a n/a 6 n/a
Engine 3 n/a n/a 3 n/a
Engine 4 n/a n/a 4 n/a
Engine 5 n/a n/a 5 n/a
Engine 6 n/a n/a 25 n/a
Engine 7 n/a n/a 26 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 102.7 7.9 98584
Completed Disk I/O's
Engine 0 6.7 0.5 6471 6.6 %
Engine 1 43.4 3.4 41707 42.3 %
Engine 2 1.2 0.1 1151 1.2 %
Engine 3 1.7 0.1 1633 1.7 %
Engine 4 0.7 0.1 694 0.7 %
Engine 5 1.1 0.1 1102 1.1 %
Engine 6 31.9 2.5 30614 31.1 %
Engine 7 15.8 1.2 15211 15.4 %
------------------------- ------------ ------------ ----------
Total Completed I/Os 102.7 7.9 98583
Device Activity Detail
----------------------
Device:
/dev/rdsk/c1t0d0s7
c7temp2 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/rdsk/c1t1d0s3
master per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 0 0.0 %
Writes 0.1 0.0 106 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.1 0.0 106 0.1 %
Device Semaphore Granted 0.1 0.0 106 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/rdsk/c1t1d0s4
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/rdsk/c1t1d0s5
c7dev1 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.1 0.0 75 0.1 %
Writes 58.1 4.5 55753 99.9 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 58.2 4.5 55828 56.6 %
Device Semaphore Granted 58.2 4.5 55824 100.0 %
Device Semaphore Waited 0.0 0.0 8 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/rdsk/c1t1d0s6
c7dev3 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 7.1 0.5 6807 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 7.1 0.5 6807 6.9 %
Device Semaphore Granted 7.1 0.5 6807 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/rdsk/c1t1d0s7
c7log 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 36.3 2.8 34800 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 36.3 2.8 34800 35.3 %
Device Semaphore Granted 36.2 2.8 34797 100.0 %
Device Semaphore Waited 0.0 0.0 6 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/rdsk/c1t2d0s3
c7temp 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/rdsk/c1t2d0s4
c7dev4 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 16 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 16 0.0 %
Device Semaphore Granted 0.0 0.0 16 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/rdsk/c1t2d0s5
c7dev5 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 68 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.1 0.0 68 0.1 %
Device Semaphore Granted 0.1 0.0 68 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/rdsk/c1t3d0s3
c7dev6 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 0 0.0 %
Writes 0.2 0.0 179 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.2 0.0 179 0.2 %
Device Semaphore Granted 0.2 0.0 179 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/rdsk/c1t3d0s4
c7dev7 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 16 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 16 0.0 %
Device Semaphore Granted 0.0 0.0 16 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/rdsk/c1t3d0s5
c7dev8 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.3 0.0 263 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.3 0.0 263 0.3 %
Device Semaphore Granted 0.3 0.0 263 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/rdsk/c1t4d0s3
c7dev9 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/rdsk/c1t4d0s4
c7dev10 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/rdsk/c1t4d0s5
c7dev11 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.0 5 26.3 %
Writes 0.0 0.0 14 73.7 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 19 0.0 %
Device Semaphore Granted 0.0 0.0 19 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/dev/rdsk/c1t5d0s3
c7dev12 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/rdsk/c1t5d0s4
c7dev13 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/rdsk/c1t5d0s5
c7dev14 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:
/export/home/sybase/grus
grusdev 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.5 0.0 482 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.5 0.0 482 0.5 %
Device Semaphore Granted 0.5 0.0 482 100.0 %
Device Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
===============================================================================
Network I/O Management
----------------------
Total Network I/O Requests 84.6 6.5 81195 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.0 0.0 0 0.0 %
Engine 1 36.4 2.8 34900 49.4 %
Engine 2 0.9 0.1 854 1.2 %
Engine 3 2.1 0.2 1969 2.8 %
Engine 4 0.2 0.0 210 0.3 %
Engine 5 0.9 0.1 850 1.2 %
Engine 6 27.6 2.1 26456 37.5 %
Engine 7 5.6 0.4 5349 7.6 %
------------------------- ------------ ------------ ----------
Total TDS Packets Rec'd 73.5 5.7 70588
Total Bytes Received per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 0.0 0.0 0 0.0 %
Engine 1 10185.3 788.4 9777926 40.4 %
Engine 2 398.7 30.9 382792 1.6 %
Engine 3 603.1 46.7 578973 2.4 %
Engine 4 32.2 2.5 30869 0.1 %
Engine 5 358.4 27.7 344111 1.4 %
Engine 6 12393.9 959.3 11898177 49.2 %
Engine 7 1218.7 94.3 1169944 4.8 %
------------------------- ------------ ------------ ----------
Total Bytes Rec'd 25190.4 1949.8 24182792
Avg Bytes Rec'd per Packet n/a n/a 342 n/a
-----------------------------------------------------------------------------
Total TDS Packets Sent per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 0.0 0.0 0 0.0 %
Engine 1 21.0 1.6 20137 75.7 %
Engine 2 0.1 0.0 92 0.3 %
Engine 3 0.7 0.1 698 2.6 %
Engine 4 0.1 0.0 130 0.5 %
Engine 5 0.2 0.0 146 0.5 %
Engine 6 3.1 0.2 3019 11.3 %
Engine 7 2.5 0.2 2388 9.0 %
------------------------- ------------ ------------ ----------
Total TDS Packets Sent 27.7 2.1 26610
Total Bytes Sent per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 0.0 0.0 0 0.0 %
Engine 1 457.2 35.4 438908 68.3 %
Engine 2 1.6 0.1 1564 0.2 %
Engine 3 12.4 1.0 11866 1.8 %
Engine 4 2.3 0.2 2210 0.3 %
Engine 5 2.6 0.2 2482 0.4 %
Engine 6 150.6 11.7 144590 22.5 %
Engine 7 42.3 3.3 40596 6.3 %
------------------------- ------------ ------------ ----------
Total Bytes Sent 669.0 51.8 642216
Avg Bytes Sent per Packet n/a n/a 24 n/a
=============================== End of Report =================================
(return status = 0)
1>;sp_configure
2>; go
Group: Configuration Options
Group: Backup/Recovery
Parameter Name Default Memory Used Config Value Run Value Unit Type
------------------------------ ----------- ----------- ------------ ----------- -------------------- ----------
allow remote access 1 0 1 1 switch dynamic
print recovery information 0 0 0 0 switch dynamic
recovery interval in minutes 5 0 5 5 minutes dynamic
tape retention in days 0 0 0 0 days dynamic
(1 row affected)
Group: Cache Manager
Parameter Name Default Memory Used Config Value Run Value Unit Type
------------------------------ ----------- ----------- ------------ ----------- -------------------- ----------
global async prefetch limit 10 0 10 10 percent dynamic
global cache partition number 1 0 1 1 number static
memory alignment boundary 2048 0 2048 2048 bytes static
number of index trips 0 0 0 0 number dynamic
number of oam trips 0 0 0 0 number dynamic
total data cache size 0 4516908 0 4516908 kilobytes NULL
Group: Component Integration Services
Parameter Name Default Memory Used Config Value Run Value Unit Type
------------------------------ ----------- ----------- ------------ ----------- -------------------- ----------
cis bulk insert array size 50 0 200 200 rows |
|