Foglight for Sybase 5.7.5.40 - User and Reference Guide

MDA Shared Memory Metrics

MDA Shared Memory Metrics

 

Table 7. MDA Shared Memory Metrics

Name	Description
Data Caches
Named Caches	The number of named caches. This field displays color-coded real-time behavior for severity.
Total Size	The total size of the data cache in megabytes. This field displays color-coded real-time behavior for severity.
Hit Rate	The percentage of times a requested page occurred in the named cache. This field displays color-coded real-time behavior for severity.
Procedure Cache
Size	The total size of the procedure cache in megabytes.
Hit Rate	The percentage of times a requested page occurred in the procedure cache. This field displays color-coded real-time behavior for severity.
Physical Memory
Physical Memory	The size of the used and total available physical memory in megabytes. This is shown in the percentage bar and as numbers: • The size of the used physical memory is shown on the left. • The size of the total available physical memory is shown on the right. This field displays color-coded real-time behavior for severity.

MDA Host Metrics

MDA Host Metrics

 

Table 8. MDA Host Metrics

Name	Description
CPU Usage	The amount of CPU resources being consumed by the database host.
Memory Usage	The amount of memory being consumed by the database host.

MDA Devices Metrics

MDA Devices Metrics

 

Table 9. MDA Devices Metrics

Name	Description
Number of Devices	The number of devices in this database. This field displays color-coded real-time behavior for severity. You can drill down by clicking on the number. A popup appears showing the Disk I/O Summary chart. It provides further drill downs. Click: • Show Me the “Disk I/O” Drilldown—a Disk I/O Dashboard appears.
Number of Databases	The number of databases in this instance. This field displays color-coded real-time behavior for severity.
Avg. Disk I/O (ms)	The average disk input/output time, in milliseconds.
IO/sec	The number of inputs/outputs per second.
Transaction Log
Total ULC Flushes	The total number of User Log Cache flushes.
ULC Flushes by Full	The percentage of User Log Cache flushes resulting from the cache becoming full.
TEMP DB
Used	The amount of memory (in megabytes) in the temp database currently in use.
Total	The total amount of memory (in megabytes) in the temp database that is available for use.

MDA Input/Output Metrics

MDA Input/Output Metrics

 

Table 10. MDA Input/Output Metrics

Name	Description
Packets Received/s	The number of message packets received per second. You can drill down by clicking on the number. A popup appears showing the Packet Received chart.
Packets Sent/s	The number of message packets sent per second. You can drill down by clicking on the number. A popup appears showing the Packet Sent chart.
Cache Hits/s	The number of cache hits per second. You can drill down by clicking on the number. A popup appears showing the Cache Hits chart.
Cache Miss/s	The number of cache misses per second. You can drill down by clicking on the number. A popup appears showing the Cache Misses chart.
Procedure Requests/s	The number of procedure requests per second. You can drill down by clicking on the number. A popup appears showing the Procedure Cache chart.
Physical Reads/s	The number of physical reads per second. You can drill down by clicking on the number. A popup appears showing the Physical I/O Reads chart.
APF Reads/s	The number of APF (Asynchronous Prefetch Activity) reads per second. You can drill down by clicking on the number. A popup appears showing the APF Reads chart.
Physical Writes/s	The number of physical writes per second. You can drill down by clicking on the number. A popup appears showing the Disk I/O chart.
Procedure Loads	The number of procedure loads. You can drill down by clicking on the number. A popup appears showing the Procedure Loads chart.
Procedure Writes	The number of procedure writes. You can drill down by clicking on the number. A popup appears showing the Procedure Writes chart.