|
|
Vous êtes ici : Forums > Langage SQL > HELP SYBASE
HELP SYBASE
Bonjour à tous je débute l'administration sybase et j'aurais besoins de quelques infos concernant l'interprétation des résultat de la command sp_sysmon ;)
voici mon fichier résultat qq peut il le commenter en parti tout au plus ;)?
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/11.9.2.2/1131/P/SWR 8892 ESD
Server Name: Server is Unnamed
Run Date: Jan 14, 2002
Statistics Cleared at: 14:22:01
Statistics Sampled at: 14:23:04
Sample Interval: 00:01:00
===============================================================================
Kernel Utilization
------------------
Engine Busy Utilization
Engine 0 72.8 %
CPU Yields by Engine per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 9.3 0.3 556 100.0 %
Network Checks
Non-Blocking 1425.0 40.1 85497 99.7 %
Blocking 5.0 0.1 300 0.3 %
------------------------- ------------ ------------ ----------
Total Network I/O Checks 1430.0 40.2 85797
Avg Net I/Os per Check n/a n/a 0.15714 n/a
Disk I/O Checks
Total Disk I/O Checks 4387.2 123.4 263230 n/a
Checks Returning I/O 0.0 0.0 0 0.0 %
===============================================================================
Worker Process Management
-------------------------
per sec per xact count % of total
------------ ------------ ---------- ----------
Worker Process Requests
Total Requests 0.0 0.0 0 n/a
Worker Process Usage
Total Used 0.0 0.0 0 n/a
Max Ever Used During Sample 0.0 0.0 0 n/a
Memory Requests for Worker Processes
Total Requests 0.0 0.0 0 n/a
===============================================================================
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 628.5 17.7 37708 100.0 %
Task Context Switches Due To:
Voluntary Yields 36.5 1.0 2190 5.8 %
Cache Search Misses 70.6 2.0 4237 11.2 %
System Disk Writes 0.7 0.0 41 0.1 %
I/O Pacing 31.1 0.9 1863 4.9 %
Logical Lock Contention 0.0 0.0 0 0.0 %
Address Lock Contention 0.0 0.0 0 0.0 %
Log Semaphore Contention 0.0 0.0 0 0.0 %
Group Commit Sleeps 0.0 0.0 2 0.0 %
Last Log Page Writes 36.3 1.0 2180 5.8 %
Modify Conflicts 0.0 0.0 2 0.0 %
I/O Device Contention 0.0 0.0 0 0.0 %
Network Packet Received 44.1 1.2 2648 7.0 %
Network Packet Sent 180.6 5.1 10834 28.7 %
SYSINDEXES Lookup 0.0 0.0 0 0.0 %
Other Causes 228.5 6.4 13711 36.4 %
===============================================================================
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.7 0.0 43 50.0 %
To Low Priority 0.7 0.0 43 50.0 %
------------------------- ------------ ------------ ----------
Total Priority Changes 1.4 0.0 86
Allotted Slices Exhausted per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
High Priority 0.0 0.0 0 0.0 %
Medium Priority 0.1 0.0 4 100.0 %
Low Priority 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Slices Exhausted 0.1 0.0 4
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 33.1 0.9 1986 98.3 %
Dirty 0.6 0.0 35 1.7 %
------------ ------------ ----------
Total Washes 33.7 0.9 2021
Garbage Collections 1.4 0.0 84 n/a
Pages Processed in GC 0.0 0.0 0 n/a
Statistics Updates 1.4 0.0 84 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 35.6 n/a 2133 n/a
Transaction Detail per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Inserts
APL Heap Table 1263.8 35.5 75825 91.3 %
APL Clustered Table 29.2 0.8 1749 2.1 %
Data Only Lock Table 91.6 2.6 5493 6.6 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Inserted 1384.5 38.9 83067 93.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 8.8 0.2 530 10.2 %
DOL Direct 78.1 2.2 4685 89.8 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Updated 86.9 2.4 5215 5.9 %
Data Only Locked Updates
DOL Replace 86.9 2.4 5214 100.0 %
DOL Shrink 0.0 0.0 1 0.0 %
DOL Cheap Expand 0.0 0.0 0 0.0 %
DOL Expensive Expand 0.0 0.0 0 0.0 %
DOL Expand & Forward 0.0 0.0 0 0.0 %
DOL Fwd Row Returned 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total DOL Rows Updated 86.9 2.4 5215 5.9 %
Deletes
APL Deferred 4.3 0.1 255 85.9 %
APL Direct 0.3 0.0 19 6.4 %
DOL 0.4 0.0 23 7.7 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Deleted 5.0 0.1 297 0.3 %
========================= ============ ============ ==========
Total Rows Affected 1476.3 41.5 88579
===============================================================================
Transaction Management
----------------------
ULC Flushes to Xact Log per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
by Full ULC 3.9 0.1 236 7.8 %
by End Transaction 35.8 1.0 2146 70.6 %
by Change of Database 0.1 0.0 5 0.2 %
by System Log Record 10.1 0.3 607 20.0 %
by Other 0.8 0.0 45 1.5 %
------------------------- ------------ ------------ ----------
Total ULC Flushes 50.7 1.4 3039
ULC Log Records 297.2 8.4 17829 n/a
Max ULC Size During Sample n/a n/a 2048 n/a
ULC Semaphore Requests
Granted 593.2 16.7 35592 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total ULC Semaphore Req 593.2 16.7 35592
Log Semaphore Requests
Granted 52.8 1.5 3166 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Log Semaphore Req 52.8 1.5 3166
Transaction Log Writes 49.6 1.4 2977 n/a
Transaction Log Alloc 12.3 0.3 740 n/a
Avg # Writes per Log Page n/a n/a 4.02297 n/a
===============================================================================
Index Management
----------------
Nonclustered Maintenance per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Ins/Upd Requiring Maint 0.5 0.0 28 n/a
# of NC Ndx Maint 0.5 0.0 28 n/a
Avg NC Ndx Maint / Op n/a n/a 1.00000 n/a
Deletes Requiring Maint 0.3 0.0 19 n/a
# of NC Ndx Maint 0.3 0.0 19 n/a
Avg NC Ndx Maint / Op n/a n/a 1.00000 n/a
RID Upd from Clust Split 0.0 0.0 1 n/a
# of NC Ndx Maint 0.2 0.0 9 n/a
Avg NC Ndx Maint / Op n/a n/a 9.00000 n/a
Upd/Del DOL Req Maint 87.2 2.5 5234 n/a
# of DOL Ndx Maint 0.3 0.0 19 n/a
Avg DOL Ndx Maint / Op n/a n/a 0.00363 n/a
Page Splits 1.3 0.0 78 n/a
Retries 0.0 0.0 0 0.0 %
Deadlocks 0.0 0.0 0 0.0 %
Empty Page Flushes 0.0 0.0 0 0.0 %
Add Index Level 0.0 0.0 0 0.0 %
Page Shrinks 0.0 0.0 0 n/a
Index Scans per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Ascending Scans 760.7 21.4 45642 51.0 %
DOL Ascending Scans 730.8 20.6 43846 49.0 %
Descending Scans 0.5 0.0 32 0.0 %
DOL Descending Scans 0.0 0.0 0 0.0 %
------------ ------------ ----------
Total Scans 1492.0 42.0 89520
===============================================================================
Metadata Cache Management
-------------------------
Metadata Cache Summary per sec per xact count % of total
------------------------ ------------ ------------ ---------- ----------
Open Object Usage
Active 8.9 0.3 534 n/a
Max Ever Used Since Boot 9.0 0.3 539 n/a
Free 824.4 23.2 49466 n/a
Reuse Requests
Succeeded 0.0 0.0 0 n/a
Failed 0.0 0.0 0 n/a
Open Index Usage
Active 8.3 0.2 499 n/a
Max Ever Used Since Boot 8.3 0.2 500 n/a
Free 0.0 0.0 1 n/a
Reuse Requests
Succeeded 4.0 0.1 240 n/a
Failed 0.0 0.0 0 n/a
Open Database Usage
Active 0.1 0.0 6 n/a
Max Ever Used Since Boot 0.1 0.0 6 n/a
Free 0.1 0.0 6 n/a
Reuse Requests
Succeeded 0.0 0.0 0 n/a
Failed 0.0 0.0 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 2193.5 61.7 131611 n/a
Avg Lock Contention 0.0 0.0 0 0.0 %
Deadlock Percentage 0.0 0.0 0 0.0 %
Lock Hashtable Lookups 2206.9 62.1 132416 n/a
Avg Hash Chain Length n/a n/a 0.01087 n/a
Lock Detail per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Exclusive Table
Granted 39.2 1.1 2350 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Table Requests 39.2 1.1 2350 1.8 %
Shared Table
Granted 6.1 0.2 365 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Table Requests 6.1 0.2 365 0.3 %
Exclusive Intent
Granted 2.4 0.1 146 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Intent Requests 2.4 0.1 146 0.1 %
Shared Intent
Granted 49.1 1.4 2943 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Intent Requests 49.1 1.4 2943 2.2 %
Exclusive Page
Granted 3.9 0.1 234 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Page Requests 3.9 0.1 234 0.2 %
Update Page
Granted 2.3 0.1 138 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total UP-Page Requests 2.3 0.1 138 0.1 %
Shared Page
Granted 777.1 21.9 46624 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Page Requests 777.1 21.9 46624 35.4 %
Exclusive Row
Granted 1.5 0.0 91 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Row Requests 1.5 0.0 91 0.1 %
Update Row
Granted 2.5 0.1 148 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total UP-Row Requests 2.5 0.1 148 0.1 %
Shared Row
Granted 374.4 10.5 22464 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Row Requests 374.4 10.5 22464 17.1 %
Next-Key
Total Next-Key Requests 0.0 0.0 0 n/a
Exclusive Address
Granted 45.5 1.3 2731 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Address Requests 45.5 1.3 2731 2.1 %
Shared Address
Granted 889.6 25.0 53377 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Address Requests 889.6 25.0 53377 40.6 %
Last Page Locks on Heaps
Granted 1263.8 35.5 75825 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total Last Pg Locks 1263.8 35.5 75825 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 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
===============================================================================
Data Cache Management
---------------------
Cache Statistics Summary (All Caches)
-------------------------------------
per sec per xact count % of total
------------ ------------ ---------- ----------
Cache Search Summary
Total Cache Hits 6136.0 172.6 368158 96.0 %
Total Cache Misses 253.1 7.1 15184 4.0 %
------------------------- ------------ ------------ ----------
Total Cache Searches 6389.0 179.7 383342
Cache Turnover
Buffers Grabbed 151.6 4.3 9094 n/a
Buffers Grabbed Dirty 0.0 0.0 0 0.0 %
Cache Strategy Summary
Cached (LRU) Buffers 5684.7 159.9 341079 100.0 %
Discarded (MRU) Buffers 0.0 0.0 0 0.0 %
Large I/O Usage
Large I/Os Performed 36.3 1.0 2178 94.2 %
Large I/Os Denied 2.2 0.1 133 5.8 %
------------------------- ------------ ------------ ----------
Total Large I/O Requests 38.5 1.1 2311
Large I/O Effectiveness
Pages by Lrg I/O Cached 290.4 8.2 17424 n/a
Pages by Lrg I/O Used 69.4 2.0 4161 23.9 %
Asynchronous Prefetch Activity
APFs Issued 22.6 0.6 1357 6.1 %
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.1 0.0 3 0.0 %
APF Buffers Found in Cache
With Spinlock Held 0.7 0.0 40 0.2 %
W/o Spinlock Held 348.4 9.8 20902 93.7 %
------------------------- ------------ ------------ ----------
Total APFs Requested 371.7 10.5 22302
Other Asynchronous Prefetch Statistics
APFs Used 21.4 0.6 1282 n/a
APF Waits for I/O 16.5 0.5 987 n/a
APF Discards 0.0 0.0 0 n/a
Dirty Read Behavior
Page Requests 0.0 0.0 0 n/a
-------------------------------------------------------------------------------
Cache: buffer_0
per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Spinlock Contention n/a n/a n/a %
Utilization n/a n/a n/a %
Cache Searches
Cache Hits %
Found in Wash %
Cache Misses %
------------------------- ------------ ------------ ----------
Total Cache Searches
Pool Turnover
2 Kb Pool
LRU Buffer Grab %
Grabbed Dirty %
4 Kb Pool
LRU Buffer Grab %
Grabbed Dirty %
8 Kb Pool
LRU Buffer Grab %
Grabbed Dirty %
16 Kb Pool
LRU Buffer Grab %
Grabbed Dirty %
------------------------- ------------ ------------ ----------
Total Cache Turnover
Buffer Wash Behavior
Buffers Passed Clean %
Buffers Already in I/O %
Buffers Washed Dirty %
Cache Strategy
Cached (LRU) Buffers %
Discarded (MRU) Buffers %
Large I/O Usage
Large I/Os Performed %
Large I/Os Denied %
------------------------- ------------ ------------ ----------
Total Large I/O Requests
Large I/O Detail
No Large Pool(s) In This Cache
Dirty Read Behavior
Page Requests n/a
-------------------------------------------------------------------------------
Cache: buffer_1
per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Spinlock Contention n/a n/a n/a %
Utilization n/a n/a n/a %
Cache Searches
Cache Hits %
Found in Wash %
Cache Misses %
------------------------- ------------ ------------ ----------
Total Cache Searches
Pool Turnover
2 Kb Pool
LRU Buffer Grab %
Grabbed Dirty %
4 Kb Pool
LRU Buffer Grab %
Grabbed Dirty %
8 Kb Pool
LRU Buffer Grab %
Grabbed Dirty %
16 Kb Pool
LRU Buffer Grab %
Grabbed Dirty %
------------------------- ------------ ------------ ----------
Total Cache Turnover
Buffer Wash Behavior
Buffers Passed Clean %
Buffers Already in I/O %
Buffers Washed Dirty %
Cache Strategy
Cached (LRU) Buffers %
Discarded (MRU) Buffers %
Large I/O Usage
Large I/Os Performed %
Large I/Os Denied %
------------------------- ------------ ------------ ----------
Total Large I/O Requests
Large I/O Detail
No Large Pool(s) In This Cache
Dirty Read Behavior
Page Requests n/a
===============================================================================
Procedure Cache Management per sec per xact count % of total
--------------------------- ------------ ------------ ---------- ----------
Procedure Requests 34.2 1.0 2049 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 1 n/a
===============================================================================
Memory Management per sec per xact count % of total
--------------------------- ------------ ------------ ---------- ----------
Pages Allocated 3.9 0.1 231 n/a
Pages Released 3.9 0.1 235 n/a
===============================================================================
Recovery Management
-------------------
Checkpoints per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
# of Normal Checkpoints 0.0 0.0 2 100.0 %
# of Free Checkpoints 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Checkpoints 0.0 0.0 2
Avg Time per Normal Chkpt 2.50000 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
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 338.6 9.5 20315
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:
per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads 338.6 9.5 20315 %
Writes 338.6 9.5 20315 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os %
Device Semaphore Granted 338.6 9.5 20315 %
Device Semaphore Waited 338.6 9.5 20315 %
-----------------------------------------------------------------------------
Device:
per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads 338.6 9.5 20315 %
Writes 338.6 9.5 20315 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os %
Device Semaphore Granted 338.6 9.5 20315 %
Device Semaphore Waited 338.6 9.5 20315 %
-----------------------------------------------------------------------------
Device:
per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads 338.6 9.5 20315 %
Writes 338.6 9.5 20315 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os %
Device Semaphore Granted 338.6 9.5 20315 %
Device Semaphore Waited 338.6 9.5 20315 %
-----------------------------------------------------------------------------
Device:
per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads 338.6 9.5 20315 %
Writes 338.6 9.5 20315 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os %
Device Semaphore Granted 338.6 9.5 20315 %
Device Semaphore Waited 338.6 9.5 20315 %
-----------------------------------------------------------------------------
Device:
per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads 338.6 9.5 20315 %
Writes 338.6 9.5 20315 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os %
Device Semaphore Granted 338.6 9.5 20315 %
Device Semaphore Waited 338.6 9.5 20315 %
-----------------------------------------------------------------------------
Device:
per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads 338.6 9.5 20315 %
Writes 338.6 9.5 20315 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os %
Device Semaphore Granted 338.6 9.5 20315 %
Device Semaphore Waited 338.6 9.5 20315 %
-----------------------------------------------------------------------------
Device:
per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads 338.6 9.5 20315 %
Writes 338.6 9.5 20315 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os %
Device Semaphore Granted 338.6 9.5 20315 %
Device Semaphore Waited 338.6 9.5 20315 %
-----------------------------------------------------------------------------
Device:
per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads 338.6 9.5 20315 %
Writes 338.6 9.5 20315 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os %
Device Semaphore Granted 338.6 9.5 20315 %
Device Semaphore Waited 338.6 9.5 20315 %
-----------------------------------------------------------------------------
Device:
per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads 338.6 9.5 20315 %
Writes 338.6 9.5 20315 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os %
Device Semaphore Granted 338.6 9.5 20315 %
Device Semaphore Waited 338.6 9.5 20315 %
-----------------------------------------------------------------------------
Device:
per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads 338.6 9.5 20315 %
Writes 338.6 9.5 20315 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os %
Device Semaphore Granted 338.6 9.5 20315 %
Device Semaphore Waited 338.6 9.5 20315 %
-----------------------------------------------------------------------------
Device:
per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads 338.6 9.5 20315 %
Writes 338.6 9.5 20315 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os %
Device Semaphore Granted 338.6 9.5 20315 %
Device Semaphore Waited 338.6 9.5 20315 %
-----------------------------------------------------------------------------
Device:
per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads 338.6 9.5 20315 %
Writes 338.6 9.5 20315 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os %
Device Semaphore Granted 338.6 9.5 20315 %
Device Semaphore Waited 338.6 9.5 20315 %
-----------------------------------------------------------------------------
===============================================================================
Network I/O Management
----------------------
Total Network I/O Requests 220.0 6.2 13197 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 44.1 1.2 2648 100.0 %
------------------------- ------------ ------------ ----------
Total TDS Packets Rec'd 44.1 1.2 2648
Total Bytes Received per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 5822.4 163.8 349346 100.0 %
------------------------- ------------ ------------ ----------
Total Bytes Rec'd 5822.4 163.8 349346
Avg Bytes Rec'd per Packet n/a n/a 131 n/a
-----------------------------------------------------------------------------
Total TDS Packets Sent per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 180.6 5.1 10834 100.0 %
------------------------- ------------ ------------ ----------
Total TDS Packets Sent 180.6 5.1 10834
Total Bytes Sent per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 72457.3 2038.2 4347439 100.0 %
------------------------- ------------ ------------ ----------
Total Bytes Sent 72457.3 2038.2 4347439
Avg Bytes Sent per Packet n/a n/a 401 n/a
=============================== End of Report =================================
(1 row affected)
(return status = 0)
Message posté le 15/01/2002
par thunder
Répondre à ce message |
|
|
|
A RETENIR CETTE SEMAINE |
06/01/2009 -
Comment appeler Biztalk via un Web Service ?
Souvent les exemples Biztalk prennent en entrée des fichiers qui sont ensuite consommés avant d’être ...
|
06/01/2009 -
TechDays - Téléchargez les goodies officiels
Si vous ne les avez pas encore téléchargés, il est encore temps : les goodies officiels des TechDays ...
|
06/01/2009 -
TechDays - Venez découvrir la table Surface !
Mitsuru Furuta saura-t-il vous convaincre d'assister à la session "Développer avec Microsoft Surface ...
|
06/01/2009 -
Utilisez log4net pour mettre en place l'audit au sein de vos applications
Les développeurs écrivent très souvent des applications qui nécessitent une fonctionnalité de log. C ...
|
05/01/2009 -
Comment étendre le databinding
Je prends pour exemple la démo fournie avec l’article : je veux attacher une liste de CustomerRow (a ...
|
05/01/2009 -
Mettez en place un serveur asp.net sous Linux avec Apache
La technologie ASP.NET est une technologie bien connue des développeurs .NET, mais malheureusement a ...
|
05/01/2009 -
Internet Explorer de moins en moins populaire
Selon Net Applications, Internet Explorer a perdu des usagers en décembre, au profit de ses concurre ...
|
|
|
