Sysmon-0.1.1: examples/sysmon_100310_0952.out
===============================================================================
Sybase Adaptive Server Enterprise System Performance Report
===============================================================================
Server Version: Adaptive Server Enterprise/15.0.3/EBF 16548 ESD#1/P/Sun_
Server Name: GPAS_PERF
Run Date: Mar 10, 2010
Sampling Started at: Mar 10, 2010 09:52:37
Sampling Ended at: Mar 10, 2010 09:53:37
Sample Interval: 00:01:00
Sample Mode: No Clear
Counters Last Cleared: Mar 09, 2010 14:34:07
===============================================================================
Kernel Utilization
------------------
Your Runnable Process Search Count is set to 2000
and I/O Polling Process Count is set to 10
Engine Busy Utilization CPU Busy I/O Busy Idle
------------------------ -------- -------- --------
Engine 0 0.0 % 0.0 % 100.0 %
Engine 1 0.0 % 0.0 % 100.0 %
Engine 2 0.0 % 0.0 % 100.0 %
Engine 3 0.0 % 0.0 % 100.0 %
Engine 4 0.0 % 0.0 % 100.0 %
Engine 5 0.0 % 0.0 % 100.0 %
Engine 6 0.0 % 0.0 % 100.0 %
Engine 7 0.0 % 0.0 % 100.0 %
Engine 8 0.3 % 0.2 % 99.5 %
Engine 9 0.0 % 0.0 % 100.0 %
Engine 10 0.0 % 0.0 % 100.0 %
Engine 11 0.0 % 0.0 % 100.0 %
Engine 12 0.0 % 0.0 % 100.0 %
Engine 13 0.0 % 0.0 % 100.0 %
Engine 14 0.0 % 0.0 % 100.0 %
------------------------ -------- -------- --------
Summary Total 0.3 % 0.2 % 1499.5 %
Average 0.0 % 0.0 % 100.0 %
CPU Yields by Engine per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Engine 0 58.6 270.4 3515 6.6 %
Engine 1 59.2 273.1 3550 6.7 %
Engine 2 59.1 272.8 3547 6.7 %
Engine 3 59.1 272.9 3548 6.7 %
Engine 4 59.1 272.8 3547 6.7 %
Engine 5 59.1 272.8 3547 6.7 %
Engine 6 59.1 272.9 3548 6.7 %
Engine 7 59.2 273.2 3551 6.7 %
Engine 8 58.9 272.0 3536 6.6 %
Engine 9 59.2 273.2 3551 6.7 %
Engine 10 59.2 273.2 3551 6.7 %
Engine 11 59.2 273.1 3550 6.7 %
Engine 12 59.2 273.1 3550 6.7 %
Engine 13 59.2 273.2 3551 6.7 %
Engine 14 59.2 273.0 3549 6.7 %
------------------------- ------------ ------------ ----------
Total CPU Yields 886.5 4091.6 53191
Network Checks
Non-Blocking 19724.6 91036.8 1183478 95.7 %
Blocking 885.4 4086.2 53121 4.3 %
------------------------- ------------ ------------ ----------
Total Network I/O Checks 20610.0 95123.0 1236599
Avg Net I/Os per Check n/a n/a 0.00000 n/a
Disk I/O Checks
Total Disk I/O Checks 21218.8 97933.1 1273130 n/a
Checks Returning I/O 1343.3 6199.6 80595 6.3 %
Avg Disk I/Os Returned n/a n/a 0.00293 n/a
Tuning Recommendations for Kernel Utilization
---------------------------------------------
- Consider decreasing the 'runnable process search count'
configuration parameter if you require the CPU's on
the machine to be used for other applications.
===============================================================================
Worker Process Management
-------------------------
per sec per xact count % of total
------------ ------------ ---------- ----------
Worker Process Requests
Total Requests 0.0 0.0 0 n/a
Worker Process Usage
Total Used 0.0 0.0 0 n/a
Max Ever Used During Sample 0.0 0.0 0 n/a
Memory Requests for Worker Processes
Total Requests 0.0 0.0 0 n/a
Tuning Recommendations for Worker Processes
-------------------------------------------
- Consider decreasing the 'number of worker processes'
configuration parameter.
===============================================================================
Parallel Query Management
-------------------------
Parallel Query Usage per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total Parallel Queries 0.0 0.0 0 n/a
Merge Lock Requests per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total # of Requests 0.0 0.0 0 n/a
Sort Buffer Waits per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total # of Waits 0.0 0.0 0 n/a
===============================================================================
Task Management per sec per xact count % of total
--------------------------- ------------ ------------ ---------- ----------
Connections Opened 0.0 0.0 0 n/a
Task Context Switches by Engine
Engine 0 3.7 17.2 223 33.8 %
Engine 1 0.3 1.3 17 2.6 %
Engine 2 0.3 1.3 17 2.6 %
Engine 3 1.9 8.9 116 17.6 %
Engine 4 0.4 1.9 25 3.8 %
Engine 5 0.3 1.3 17 2.6 %
Engine 6 0.3 1.3 17 2.6 %
Engine 7 0.3 1.4 18 2.7 %
Engine 8 1.7 8.0 104 15.8 %
Engine 9 0.3 1.4 18 2.7 %
Engine 10 0.3 1.3 17 2.6 %
Engine 11 0.3 1.3 17 2.6 %
Engine 12 0.3 1.3 17 2.6 %
Engine 13 0.3 1.4 18 2.7 %
Engine 14 0.3 1.4 18 2.7 %
------------------------- ------------ ------------ ----------
Total Task Switches: 11.0 50.7 659
Task Context Switches Due To:
Voluntary Yields 8.2 37.7 490 74.4 %
Cache Search Misses 0.3 1.5 19 2.9 %
Exceeding I/O batch size 0.0 0.0 0 0.0 %
System Disk Writes 0.4 2.0 26 3.9 %
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.5 6 0.9 %
Modify Conflicts 0.0 0.0 0 0.0 %
I/O Device Contention 0.0 0.0 0 0.0 %
Network Packet Received 0.0 0.0 0 0.0 %
Network Packet Sent 0.0 0.0 0 0.0 %
Network services 0.0 0.0 0 0.0 %
Other Causes 2.0 9.1 118 17.9 %
===============================================================================
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.5 2.2 29 50.0 %
To Low Priority 0.5 2.2 29 50.0 %
------------------------- ------------ ------------ ----------
Total Priority Changes 1.0 4.5 58
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 114.1 526.4 6843 99.2 %
Dirty 0.9 4.0 52 0.8 %
------------ ------------ ----------
Total Washes 114.9 530.4 6895
Garbage Collections 3.0 13.8 180 n/a
Pages Processed in GC 0.0 0.0 0 n/a
Statistics Updates 0.5 2.3 30 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)
Tuning Recommendations for Monitor Access to Executing SQL
----------------------------------------------------------
- Consider decreasing the 'max SQL text monitored' parameter
to 4096 (i.e., half way from its current value to Maximum
SQL Text Requested).
===============================================================================
Transaction Profile
-------------------
Transaction Summary per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Committed Xacts 0.2 n/a 13 n/a
Transaction Detail per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Inserts
APL Heap Table 381.1 1758.8 22865 50.7 %
APL Clustered Table 0.0 0.0 0 0.0 %
Data Only Lock Table 370.0 1707.7 22200 49.3 %
Fast Bulk Insert 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total Rows Inserted 751.1 3466.5 45065 100.0 %
Updates
Total Rows Updated 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total Rows Updated 0.0 0.0 0 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
Total Rows Deleted 0.0 0.0 0 n/a
========================= ============ ============ ==========
Total Rows Affected 751.1 3466.5 45065
===============================================================================
Transaction Management
----------------------
ULC Flushes to Xact Log per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
by Full ULC 0.0 0.1 1 7.1 %
by End Transaction 0.1 0.5 7 50.0 %
by Change of Database 0.0 0.2 2 14.3 %
by Single Log Record 0.0 0.2 2 14.3 %
by Unpin 0.0 0.2 2 14.3 %
by Other 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total ULC Flushes 0.2 1.1 14
ULC Flushes Skipped per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
by PLC Discards 0.2 0.7 9 100.0 %
------------------------- ------------ ------------ ----------
Total ULC Discards 0.2 0.7 9
ULC Log Records 1.4 6.3 82 n/a
Max ULC Size During Sample n/a n/a 0 n/a
ULC Semaphore Requests
Granted 2.8 12.8 166 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total ULC Semaphore Req 2.8 12.8 166
Log Semaphore Requests
Granted 0.5 2.2 28 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Log Semaphore Req 0.5 2.2 28
Transaction Log Writes 0.1 0.6 8 n/a
Transaction Log Alloc 0.1 0.2 3 n/a
Avg # Writes per Log Page n/a n/a 2.66667 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 20.9 96.3 1252 90.3 %
DOL Ascending Scans 2.2 10.1 131 9.5 %
Descending Scans 0.1 0.2 3 0.2 %
DOL Descending Scans 0.0 0.0 0 0.0 %
------------ ------------ ----------
Total Scans 23.1 106.6 1386
Msg 11039, Level 16, State 1:
Server 'GPAS_PERF', Procedure 'sp_exec_SQL', Line 49:
Another Execute Immediate statement cannot be executed inside an Execute
Immediate statement.
(0 rows affected)
===============================================================================
Lock Management
---------------
Lock Summary per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total Lock Requests 81.4 375.8 4885 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 2.4 11.0 143 n/a
Avg Chain Length n/a n/a 0.41259 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 0.2 1.0 13 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Intent Requests 0.2 1.0 13 0.3 %
Shared Intent
Granted 2.2 10.0 130 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Intent Requests 2.2 10.0 130 2.7 %
Page & Row Lock HashTable
Lookups 33.1 152.7 1985 n/a
Avg Chain Length n/a n/a 0.00151 n/a
Spinlock Contention n/a n/a n/a 0.0 %
Exclusive Page
Granted 0.2 0.8 10 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Page Requests 0.2 0.8 10 0.2 %
Update Page
Total UP-Page Requests 0.0 0.0 0 n/a
Shared Page
Granted 21.0 97.1 1262 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Page Requests 21.0 97.1 1262 25.8 %
Exclusive Row
Granted 0.0 0.1 1 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Row Requests 0.0 0.1 1 0.0 %
Update Row
Granted 0.1 0.2 3 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total UP-Row Requests 0.1 0.2 3 0.1 %
Shared Row
Granted 11.6 53.3 693 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Row Requests 11.6 53.3 693 14.2 %
Next-Key
Total Next-Key Requests 0.0 0.0 0 n/a
Address Lock Hashtable
Lookups 46.2 213.3 2773 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 12 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total EX-Address Requests 0.2 0.9 12 0.2 %
Shared Address
Granted 46.0 212.4 2761 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total SH-Address Requests 46.0 212.4 2761 56.5 %
Last Page Locks on Heaps
Granted 381.1 1758.8 22865 100.0 %
Waited 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total Last Pg Locks 381.1 1758.8 22865 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 945.7 4364.5 56739 100.0 %
Total Cache Misses 0.3 1.5 20 0.0 %
------------------------- ------------ ------------ ----------
Total Cache Searches 946.0 4366.1 56759
Cache Turnover
Buffers Grabbed 3.4 15.8 206 n/a
Buffers Grabbed Dirty 0.0 0.0 0 0.0 %
Cache Strategy Summary
Cached (LRU) Buffers 975.0 4500.1 58501 100.0 %
Discarded (MRU) Buffers 0.0 0.0 0 0.0 %
Large I/O Usage
Large I/Os Performed 0.9 4.1 53 100.0 %
Large I/Os Denied due to
Pool < Prefetch Size 0.0 0.0 0 0.0 %
Pages Requested
Reside in Another
Buffer Pool 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Large I/O Requests 0.9 4.1 53
Large I/O Effectiveness
Pages by Lrg I/O Cached 7.0 32.2 418 n/a
Pages by Lrg I/O Used 7.0 32.2 418 100.0 %
Asynchronous Prefetch Activity
APFs Issued 2.2 10.2 132 95.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 0.1 0.5 7 5.0 %
------------------------- ------------ ------------ ----------
Total APFs Requested 2.3 10.7 139
Other Asynchronous Prefetch Statistics
APFs Used 2.2 10.2 132 n/a
APF Waits for I/O 0.9 4.0 52 n/a
APF Discards 0.0 0.0 0 n/a
Dirty Read Behavior
Page Requests 0.0 0.0 0 n/a
-------------------------------------------------------------------------------
Cache: dbcc_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.0 %
Cache Searches
Total Cache Searches 0.0 0.0 0 n/a
------------------------- ------------ ------------ ----------
Total Cache Searches 0.0 0.0 0
Pool Turnover 0.0 0.0 0 n/a
Buffer Wash Behavior
Statistics Not Available - No Buffers Entered Wash Section Yet
Cache Strategy
Statistics Not Available - No Buffers Displaced Yet
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
Tuning Recommendations for Data cache : dbcc_cache
-------------------------------------
- Consider removing the 16k pool for this cache.
-------------------------------------------------------------------------------
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 945.7 4364.5 56739 100.0 %
Found in Wash 0.1 0.4 5 0.0 %
Cache Misses 0.3 1.5 20 0.0 %
------------------------- ------------ ------------ ----------
Total Cache Searches 946.0 4366.1 56759
Pool Turnover
2 Kb Pool
LRU Buffer Grab 2.6 11.8 153 74.3 %
Grabbed Dirty 0.0 0.0 0 0.0 %
4 Kb Pool
LRU Buffer Grab 0.0 0.1 1 0.5 %
Grabbed Dirty 0.0 0.0 0 0.0 %
16 Kb Pool
LRU Buffer Grab 0.9 4.0 52 25.2 %
Grabbed Dirty 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Cache Turnover 3.4 15.8 206
Buffer Wash Behavior
Statistics Not Available - No Buffers Entered Wash Section Yet
Cache Strategy
Cached (LRU) Buffers 975.0 4500.1 58501 100.0 %
Discarded (MRU) Buffers 0.0 0.0 0 0.0 %
Large I/O Usage
Large I/Os Performed 0.9 4.1 53 100.0 %
Large I/Os Denied due to
Pool < Prefetch Size 0.0 0.0 0 0.0 %
Pages Requested
Reside in Another
Buffer Pool 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Large I/O Requests 0.9 4.1 53
Large I/O Detail
4 Kb Pool
Pages Cached 0.0 0.2 2 n/a
Pages Used 0.1 0.2 3 150.0 %
16 Kb Pool
Pages Cached 6.9 32.0 416 n/a
Pages Used 6.9 31.9 415 99.8 %
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.
-------------------------------------------------------------------------------
Cache: tempdb_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.0 %
Cache Searches
Total Cache Searches 0.0 0.0 0 n/a
------------------------- ------------ ------------ ----------
Total Cache Searches 0.0 0.0 0
Pool Turnover 0.0 0.0 0 n/a
Buffer Wash Behavior
Statistics Not Available - No Buffers Entered Wash Section Yet
Cache Strategy
Statistics Not Available - No Buffers Displaced Yet
Large I/O Usage
Total Large I/O Requests 0.0 0.0 0 n/a
Large I/O Detail
4 Kb Pool
Pages Cached 0.0 0.0 0 n/a
Pages Used 0.0 0.0 0 n/a
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
Tuning Recommendations for Data cache : tempdb_cache
-------------------------------------
- Consider using 'relaxed LRU replacement policy'
for this cache.
- Consider removing the 4k pool for this cache.
- Consider removing the 16k pool for this cache.
===============================================================================
Procedure Cache Management per sec per xact count % of total
--------------------------- ------------ ------------ ---------- ----------
Procedure Requests 0.0 0.1 1 n/a
Procedure Reads from Disk 0.0 0.1 1 100.0 %
Procedure Writes to Disk 0.0 0.0 0 0.0 %
Procedure Removals 0.0 0.1 1 n/a
Procedure Recompilations 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 0.0 0.0 0 n/a
Tuning Recommendations for Procedure cache management
-----------------------------------------------------
- Consider increasing the 'procedure cache size'
configuration parameter.
===============================================================================
Memory Management per sec per xact count % of total
--------------------------- ------------ ------------ ---------- ----------
Pages Allocated 1.2 5.5 72 n/a
Pages Released 1.2 5.5 72 n/a
===============================================================================
Recovery Management
-------------------
Checkpoints per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
# of Normal Checkpoints 0.0 0.2 2 100.0 %
# of Free Checkpoints 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ----------
Total Checkpoints 0.0 0.2 2
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 30 n/a
Engine 0 n/a n/a 50 n/a
Engine 1 n/a n/a 41 n/a
Engine 2 n/a n/a 34 n/a
Engine 3 n/a n/a 200 n/a
Engine 4 n/a n/a 35 n/a
Engine 5 n/a n/a 59 n/a
Engine 6 n/a n/a 36 n/a
Engine 7 n/a n/a 45 n/a
Engine 8 n/a n/a 39 n/a
Engine 9 n/a n/a 216 n/a
Engine 10 n/a n/a 39 n/a
Engine 11 n/a n/a 39 n/a
Engine 12 n/a n/a 34 n/a
Engine 13 n/a n/a 31 n/a
Engine 14 n/a n/a 27 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 3.9 18.1 235
Completed Disk I/O's
Asynchronous I/O's
Engine 0 0.0 0.0 0 0.0 %
Engine 1 0.0 0.0 0 0.0 %
Engine 2 0.0 0.0 0 0.0 %
Engine 3 1.3 6.2 80 33.9 %
Engine 4 0.1 0.3 4 1.7 %
Engine 5 0.0 0.0 0 0.0 %
Engine 6 0.0 0.0 0 0.0 %
Engine 7 0.0 0.0 0 0.0 %
Engine 8 2.5 11.7 152 64.4 %
Engine 9 0.0 0.0 0 0.0 %
Engine 10 0.0 0.0 0 0.0 %
Engine 11 0.0 0.0 0 0.0 %
Engine 12 0.0 0.0 0 0.0 %
Engine 13 0.0 0.0 0 0.0 %
Engine 14 0.0 0.0 0 0.0 %
Synchronous I/O's
Total Completed I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ----------
Total Completed I/Os 3.9 18.2 236
Device Activity Detail
----------------------
Device:
/sybase/syb-gpas-perf/dbdat01/dbccdb_data_01.dat
dbccdb_data_01 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.1 1 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.1 1 0.4 %
Mirror Semaphore Granted 0.0 0.1 1 100.0 %
Mirror Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/dbdat01/dbccdb_data_02.dat
dbccdb_data_02 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/dbdat01/devdata_01.dat
devdata_01 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.1 1 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.1 1 0.4 %
Mirror Semaphore Granted 0.0 0.1 1 100.0 %
Mirror Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/dbdat01/devdata_02.dat
devdata_02 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.1 1 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.1 1 0.4 %
Mirror Semaphore Granted 0.0 0.1 1 100.0 %
Mirror Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/dbdat01/devdata_03.dat
devdata_03 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.2 3 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.1 0.2 3 1.3 %
Mirror Semaphore Granted 0.1 0.2 3 100.0 %
Mirror Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/dbdat01/master.dat
master per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.0 0.1 1 1.6 %
Writes 1.0 4.6 60 98.4 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 1.0 4.7 61 25.8 %
Mirror Semaphore Granted 1.0 4.7 61 100.0 %
Mirror Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/dbdat01/sybsecurity_data_01.dat
sybsecurity_data_01 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 2.5 %
Mirror Semaphore Granted 0.1 0.5 6 100.0 %
Mirror Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/dbdat01/sybsecurity_data_02.dat
sybsecurity_data_02 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.2 2 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.2 2 0.8 %
Mirror Semaphore Granted 0.0 0.2 2 100.0 %
Mirror Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/dbdat01/sybsecurity_data_03.dat
sybsecurity_data_03 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 8 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.1 0.6 8 3.4 %
Mirror Semaphore Granted 0.1 0.6 8 100.0 %
Mirror Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/dbdat01/sysprocsdev.dat
sysprocsdev per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 2.2 10.2 132 90.4 %
Non-APF 0.2 1.0 13 8.9 %
Writes 0.0 0.1 1 0.7 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 2.4 11.2 146 61.9 %
Mirror Semaphore Granted 2.4 11.2 146 100.0 %
Mirror Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/dblog01/dbccdb_log_01.dat
dbccdb_log_01 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/dblog01/devlog_01.dat
devlog_01 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/dblog01/devlog_02.dat
devlog_02 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/dblog01/devlog_03.dat
devlog_03 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/dblog01/devlog_04.dat
devlog_04 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/dblog01/devlog_05.dat
devlog_05 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/dblog01/devlog_06.dat
devlog_06 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/dblog01/sybsecurity_log_01.dat
sybsecurity_log_01 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/hperfdat01/hperfdata_01.dat
hperfdata_01 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.1 1 100.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.1 1 0.4 %
Mirror Semaphore Granted 0.0 0.1 1 100.0 %
Mirror Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/hperfdat01/hperfdata_02.dat
hperfdata_02 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/hperfdat01/hperfdata_03.dat
hperfdata_03 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/hperfdat01/hperfdata_04.dat
hperfdata_04 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/hperfdat01/hperfdata_05.dat
hperfdata_05 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/hperfdat01/hperfdata_06.dat
hperfdata_06 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/hperfdat01/hperfdata_07.dat
hperfdata_07 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/hperfdat01/hperfdata_08.dat
hperfdata_08 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/hperfdat01/hperfdata_09.dat
hperfdata_09 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/hperfdat01/hperfdata_10.dat
hperfdata_10 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/hperfdat01/hperfdata_11.dat
hperfdata_11 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/hperfdat01/hperfdata_12.dat
hperfdata_12 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/hperfdat01/hperfdata_13.dat
hperfdata_13 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/hperfdat01/hperfdata_14.dat
hperfdata_14 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/hperfdat01/hperfdata_15.dat
hperfdata_15 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/hperfdat01/hperfdata_16.dat
hperfdata_16 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/hperfdat01/hperfdata_17.dat
hperfdata_17 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/hperfdat01/hperfdata_18.dat
hperfdata_18 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/hperflog01/hperflog_01.dat
hperflog_01 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/hperflog01/hperflog_02.dat
hperflog_02 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/hperflog01/hperflog_03.dat
hperflog_03 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/tempdbdat01/tempdbdata_01.dat
tempdbdata_01 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Reads
APF 0.0 0.0 0 0.0 %
Non-APF 0.1 0.5 6 100.0 %
Writes 0.0 0.0 0 0.0 %
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.1 0.5 6 2.5 %
Mirror Semaphore Granted 0.1 0.5 6 100.0 %
Mirror Semaphore Waited 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/tempdbdat01/tempdbdata_02.dat
tempdbdata_02 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/tempdbdat01/tempdbdata_03.dat
tempdbdata_03 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/tempdbdat01/tempdbdbadatm01.dat
tempdbdbadatm01 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/tempdblog01/tempdbdbalogm01.dat
tempdbdbalogm01 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/tempdblog01/tempdblog_01.dat
tempdblog_01 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
Device:
/sybase/syb-gpas-perf/tempdblog01/tempdblog_02.dat
tempdblog_02 per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 n/a
------------------------- ------------ ------------ ---------- ----------
Total I/Os 0.0 0.0 0 0.0 %
-----------------------------------------------------------------------------
===============================================================================
Network I/O Management
----------------------
Total Network I/O Requests 0.0 0.0 0 n/a
Total TDS Packets Received per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total TDS Packets Rec'd 0.0 0.0 0 n/a
Total Bytes Received per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total Bytes Rec'd 0.0 0.0 0 n/a
-----------------------------------------------------------------------------
Total TDS Packets Sent per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total TDS Packets Sent 0.0 0.0 0 n/a
Total Bytes Sent per sec per xact count % of total
------------------------- ------------ ------------ ---------- ----------
Total Bytes Sent 0.0 0.0 0 n/a
===============================================================================
Replication Agent
-----------------
Replication Agent: hperf
Replication Server: REP_GPAS01_PROD
per sec per xact count % of total
------------ ------------ ---------- ----------
Log Scan Summary
Log Records Scanned n/a n/a 0 n/a
Log Records Processed n/a n/a 0 n/a
Number of Log Scans n/a n/a 0 n/a
Amount of Time for Log Scans (ms) n/a n/a 0 n/a
Longest Time for Log Scan (ms) n/a n/a 0 n/a
Average Time per Log Scan (ms) n/a n/a 0.0 n/a
Log Scan Activity
Updates n/a n/a 0 n/a
Inserts n/a n/a 0 n/a
Deletes n/a n/a 0 n/a
Store Procedures n/a n/a 0 n/a
DDL Log Records n/a n/a 0 n/a
Writetext Log Records n/a n/a 0 n/a
Text/Image Log Records n/a n/a 0 n/a
CLRs n/a n/a 0 n/a
Checkpoints Processed n/a n/a 0 n/a
SQL Statements Processed n/a n/a 0 n/a
Transaction Activity
Opened n/a n/a 0 n/a
Commited n/a n/a 0 n/a
Aborted n/a n/a 0 n/a
Prepared n/a n/a 0 n/a
Delayed Commit n/a n/a 0 n/a
Maintenance User n/a n/a 0 n/a
Log Extension Wait
Count n/a n/a 0 n/a
Amount of time (ms) n/a n/a 0 n/a
Longest Wait (ms) n/a n/a 0 n/a
Average Time (ms) n/a n/a 0.0 n/a
Schema Cache
Usage
Msg 249, Level 16, State 1:
Server 'GPAS_PERF', Procedure 'sp_sysmon_repagent', Line 401:
Syntax error during explicit conversion of VARCHAR value 'n/a' to a INT field.
(return status = -6)