Monitoring

On the Monitoring tab the search bar at the top provides the ability to search a particular monitoring metrics chart. At the right side there is referesh button to refresh the metrics manually. To refresh the metrics at particular intervals there are options like 1h, 3h, 6h, 12h, 24h. By default, it refreshes the metrics at 1h interval. To refresh the metrics as per your requirement, there is Custom option. Using Custom option, you can choose date time as per your requirement and click on Apply button to apply the changes.

Next it shows the Availability graph. The green color represents that your database service is available at that particular time and grey color reprensents the unavailability. The graph represents the data at the interval of every five minutes.

Graphical Metrics

The graphs on this tab provides the latest metrics for your database services categorized logically as OS Metrics and DB Metrics. Each graph has the following capabilities:

• You can zoom in the whole graph using the top right corner expand screen button. A new window pop-ups displaying the enlarged view of the whole graph. It provides the metrics at 5 minutes interval.

• You can zoom in the particular section on the graph using the top right corner magnifying lens button. It will expand only the selected portion on the graph and give you more detailed representation of the metrics.

• You can select and drag particluar portion of the graph using the raise hand button.

• You can view the graph back in its original form by using the top right corner home button. It brings the graph back to its default view.

• You can download the graph in three different formats using the top right corner menu button. It supports svg, png, and csv formats. The svg and png format captures the graph and saves as it is, while in the csv format it creates an excel file with the captured data values of the metrics in the fields.

OS Metrics

The OS Metrics provides the graphical representation of the latest collected operating system metrics:

• CPU Usage — This graph provides the amount of CPU resources used for the database service in percentage at 10 minutes interval by default. To view the CPU resources usage at 5 minutes interval, zoom in the graph using the top right corner expand screen button. It also provides Used (latest) N where N is the latest CPU percentage used in a numeric value at the left side top of the graph.

• System load average — This graph provides the amount of system load average for the database service in count at 10 minutes interval by default. It provides the system load average for every one minute, five minutes, and fifteen minutes using three different colours in the same graph. To view the system load average count at 5 minutes interval, zoom in the graph using the top right corner expand screen button. It also provides 1 min (latest) N, 5 min (latest) N1, and 15 min (latest) N2 where N, N1, and N2 is the system load average counts in numeric value for one minute, five minutes, and fifteen minutes at the top of the graph respectively.

• Memory Usage — This graph provides the details of used and available memory in GB for your database service at 10 minutes interval by default. It provides the used and available memory charts using two different colours in the same graph. To view the memory usage at 5 minutes interval, zoom in the graph using the top right corner expand screen button. It also provides Used (latest) N and Available (latest) N1 where N and N1 are the amount of used and available memory in GB at the top of the graph.

• Swap Usage — This graph provides the details of used and free swap area in GB for your database service at 10 minutes interval by default. It provides the used and free swap area charts using two different colours in the same graph. To view the details of used and free swap area in GB at 5 minutes interval, zoom in the graph using the top right corner expand screen button. It also provides Used (latest) N and Free (latest) N1 where N and N1 are the amount of swap area used and free available in GB at the top of the graph.

• Network Usage — This graph provides the details of sent and received data across network in GB for your database service at 10 minutes interval by default. It provides the sent and received data charts using two different colours in the same graph. To view the network usage details at 5 minutes interval, zoom in the graph using the top right corner expand screen button. It also provides Sent (latest) N and Received (latest) N1 where N and N1 are the amount of sent and received data in GB at the top of the graph.

DB Metrics

The graphs under DB Metrics are:

PostgreSQL

• Connections - This graph provides the details of the connections count for your database service at 10 minutes interval by default. It provides the number of active, idle, and idle in transaction connections using three different colours in the same graph. It also provides Active (latest) N, Idle (latest) N1, and Idle in transaction (latest) N2 where N, N1 and N2 are the number of active, idle and idle in transaction connections count at the top of the graph.

• Memory Buffer Allocations - This graph provides the details of the memory buffer allocation count for your database service at 10 minutes of interval by default. It also provides latest buffer allocation count at the top of the graph.

• Vacuum: Max used transacion IDs - This graph provides the average maximum of used transaction IDs per database. This metrics helps to trigger vacuum and freeze the transaction IDs to avoid wraparound whenever the transaction IDs are about to reach the limiting value. It provides the latest average count of maximum used transaction ID at the top of the graph.

• Connection Utilization - This graph provides the average of the connections count utilized for your database service at 10 minutes of interval by default. It also provides latest average connection utilization count at the top of the graph.

• Tuples: DML (per second) - This graph provides the average count for all the types of DML statements for your database service at 10 minutes of interval by default. It provides the average count of deleted rows, updated rows and inserted rows using three different colours on the same graph. It also provides latest average count of deleted, updated and inserted rows at the top of the graph.

• Tuples: Reads (per second) - This graph provides the average count for the tuples fetched and returned for the running queries for your database service at 10 minutes of interval by default. It provides the average count of fetched and returned tuples for the running queries using two different colours on the same graph. It also provides latest average count of the tuples fetched and returned at the top of the graph.

• Transactions(per second) - This graph provides the average of committed and rollbacked transactions per second for your database service at 10 minutes of interval by default. It provides the average of committed and rollbacked transactions per second using two different colours on the same graph. It also provides latest average count of committed transactions and rollbacked transactions per second at the top of the graph.

• Transactions in progress(per second) - This graph provides the average of blocked and active transactions per second for your database service at 10 minutes of interval by default. It represents these average using two different colours on the same graph. It also provides the latest count of average of blocked and active transactions per second at the top of the graph.

• Deadlocks(per minute) - This graph provides the average number of deadlocks per minute for your database service at 10 minutes of interval by default. It also provides the count of average number of deadlocks per minute at the top of the graph.

• IO Cache vs Disk reads(per second) - This graph provides the average number of blocks read from memory and disk per second at 10 minutes of interval by default. It represents these averages using two different colours on the same graph. It also provides the latest count of average number of block read from memory and disk per second at the top of the graph.

• Transactions utilization(percent) - This graph provides the percentage of total transaction utilization for your database service at 10 minutes of interval by default. It also provides the latest total percentage count of transaction utilization at the top of the graph.

• Filesystem: Root - This graph provides the amount of used and free root filesystem in GiB for your database service at 10 minutes of interval by default. It represents these used and free root filesystem space using two different colours on the same graph. It also provides the latest count of used and free root filesystem in GiB at the top of the graph.

• Filesystem: Data - This graph provides the amount of used and free data filesystem in GiB for your database service at 10 minutes of interval by default. It represents these used and free data filesystem space using two different colours on the same graph. It also provides the latest count of used and free data filesystem in GiB at the top of the graph.

• Filesystem: Archive - This graph provides the amount of used and free archive filesystem in GiB for your database service at 10 minutes of interval by default. It represents these used and free archive filesystem space using two different colours on the same graph. It also provides the latest count of used and free archive filesystem in GiB at the top of the graph.

• Filesystem: DB Software - This graph provides the amount of used and free filesystem for the database software in GiB for your database service at 10 minutes of interval by default. It represents these used and free filesystem for the database software space using two different colours on the same graph. It also provides the latest count of used and free filesystem for the database software in GiB at the top of the graph.

• Transaction Logs Generation - This graph provides the amount of transaction logs generated in bytes per second for your database service at 10 minutes of interval by default. It also provides the latest count of total transaction logs generated in bytes per second at the top of the graph.

Oracle

• Session Stats — This graph provides the count of active users, inactive users, and active background processes for active sessoins of your database service at 10 minutes of interval by default. It also provides the latest count of active and inactive users, and count of active backgroung processes at the top of the graph.

• Disk IO — This graph provides the amount of read operations and write operations per second for your database service at 10 minutes of interval by default. It represents these read and write operations per second using two different colours on the same graph. It also provides the latest count of read operations and write operations per second at the top of the graph.

• PGA Memory Stats — This graph provides the amount of allocated, freeable, maximum available, and used PGA memory in MiB for your database service at 10 minutes of interval by default. It also reprensents all these using four different colours on the same graph. It also provides latest amount of allocate, freeable, maximum available, and used PGA memory in MiB at the top of the graph.

• SGA Stats — This graph provides the amount of used, free, and total available SGA memory in GiB for your database service at 10 minutes of interval by default. It represents these using three different colours on the same graph. It also provides latest count of used, free, and total available SGA memory at the top of the graph.

• Blocking Sessions — This graph provides the number of blocking sessions in your database service at 10 minutes of interval by default. It also gives latest count of blocking sessions at the top of the graph.

• Sessions Utilization — This graph provides count of maximum limit and utilization of sessions for your database service at 10 minutes of interval by default. It also provides the latest count of maximum limit and utilization of sessions at the top of the graph.

• Process Utilization — This graph provides count of maximum limit and utilization of processes for your database service at 10 minutes of interval by default. It also provides the latest count of maximum limit and utilization of processes at the top of the graph.

• Transactions Utilization — This graph provides count of maximum limit and utilization of transactions utilization for your database service at 10 minutes of interval by default. It also provides the latest count of maximum limit and utilization of transacions utilization at the top of the graph.

• Wait times - This graph provides the wait in seconds for administrative tasks, application tasks, for commits, concurrent requests, configuration tasks, network traffic, scheduler jobs, and system tasks for your database service at 10 minutes of interval by default. It represents all these using different colous in the same graph. It also provides latest count for each category at the top of the graph.

• Activity - This graph provides the counts of query execution, query parsing, users commits, and users rollbacks for your database service at 10 minutes of interval by default. It represents all these using different colours on the same graph. It also provides latest counts of query execution, query parsing, users commits, and users rollbacks at the top of the graph.

• Filesystem: Data - This graph provides the amount of used and free data filesystem in GiB for your database service at 10 minutes of interval by default. It represents these used and free data filesystem space using two different colours on the same graph. It also provides the latest count of used and free data filesystem in GiB at the top of the graph.

• Filesystem: Archive - This graph provides the amount of used and free archive filesystem in GiB for your database service at 10 minutes of interval by default. It represents these used and free archive filesystem space using two different colours on the same graph. It also provides the latest count of used and free archive filesystem in GiB at the top of the graph.

• Filesystem: DB Software - This graph provides the amount of used and free filesystem for the database software in GiB for your database service at 10 minutes of interval by default. It represents these used and free filesystem for the database software space using two different colours on the same graph. It also provides the latest count of used and free filesystem for the database software in GiB at the top of the graph.

• Transaction Logs Generation - This graph provides the amount of transaction logs generated in bytes per second for your database service at 10 minutes of interval by default. It also provides the latest count of total transaction logs generated in bytes per second at the top of the graph.

MySQL

• Connections - This graph provides the count of maximum used connections, total connections, and active connections for your database service at 10 minutes of interval by default. It represents these counts using different colours on the same graph. It also provides the latest count of maximum used connections, total connections, and active connections at the top of the graph.

• Quries per second - This graph provides number of executed select statements, insert statements, update statements, and delete statements per second for your database service at 10 minutes of interval by default. It represents all these using different colours on the same graph. It also provides latest count of executed select statements, insert statements, update statements, and delete statements per second at the top of the graph.

• IO - This graph provides buffer pool writes, reads, and disk reads per second for the running queries. It reprensents all these writes and reads using different colours on the same graph. It also provides latest buffer pool writes, buffer pool reads, and disk reads at the top of the graph.

• InnoDB Writes - This graph provides data writes, double writes, and log writes per second for the running queries. It represents all these writes using different colour on the same graph. It also provides the latest count of data writes, double writes, and log writes at the top of the graph.

• Buffer pool utilization - This graph provides the buffer pool utilization percentage for your database service at 10 minutes of interval by default. It also provides the latest percentage of buffer pool utilization at the top of the graph.

• Open Tables - This graph provides the count of open tables for your database service at 10 minutes of interval by default. It also provides latest count of open tables at the top of the graph.

• Temp Tables - This graph provides the temporary tables created per second for your database service at 10 minutes of interval by default. It also provides the latest count of temporary tables created at the top of the graph.

• Average row lock time - This graph provides the average row lock time in minutes for the transactions in your database service at 10 minutes of interval by default. It also provides the latest count of avergage row lock at the top of the graph.

• Aborted clients - This graph provides the count of aborted clients for your database service at 10 minutes of interval by default. It also provides the latest count of aborted clients at the top of the graph.

• Aborted connects - This graph provides the count of aborted connetions for your database service at 10 minutes of interval by default. It also provides the latest count of aborted connections at the top of the graph.

• Filesystem: Data - This graph provides the amount of used and free data filesystem in GiB for your database service at 10 minutes of interval by default. It represents these used and free data filesystem space using two different colours on the same graph. It also provides the latest count of used and free data filesystem in GiB at the top of the graph.

• Filesystem: Archive - This graph provides the amount of used and free archive filesystem in GiB for your database service at 10 minutes of interval by default. It represents these used and free archive filesystem space using two different colours on the same graph. It also provides the latest count of used and free archive filesystem in GiB at the top of the graph.

• Filesystem: DB Software - This graph provides the amount of used and free filesystem for the database software in GiB for your database service at 10 minutes of interval by default. It represents these used and free filesystem for the database software space using two different colours on the same graph. It also provides the latest count of used and free filesystem for the database software in GiB at the top of the graph.

• Transaction Logs Generation - This graph provides the amount of transaction logs generated in bytes per second for your database service at 10 minutes of interval by default. It also provides the latest count of total transaction logs generated in bytes per second at the top of the graph.

SQL Server

• Connections - This graph provides the count of user connections for your database service at 10 minutes of interval by default. It also provides the latest count of user connections at the top of the graph.

• Bacth requests (per second) - This graph provides the number of batch requests per second for your database service at 10 minutes of interval by default. It also provides the latest count of batch requests at the top of the graph.

• Stored procedure compilations (per second) - This graph provides the count of compilations and recompilations per second for your database service. It also provides the latest count of compilations and recompilations at the top of the graph.

• Active transactions - This graph provides the count of total active transactions for your database service at the 10 minutes of interval by default. It also provides the latest count of active transactions at the top of the graph.

• Processes blocked - This graph provides the count of processes blocked due to transactions of your database service at the 10 minutes of interval by default. It also provdes the latest count of processes blocked at the top of the graph.

• Deadlocks per second - This graph provides the count of deadlocks per second for your database service at 10 minutes of interval by default. It also provides the latest count of deadlocks per second at the top of the graph.

• Page File - This graph provides the total page file and available page file in GiB for your database service at 10 minutes of interval by default. It also provides the latest total and available page file in GiB at the top of the graph.

• Buffer database pages - This graph provides the count of target and total buffer database pages for your database service at 10 minutes of interval by default. It also provides the latest count of target and total buffer database pages at the top of the graph.

• Buffer cache hit ratio - This graph provides the count of buffer cache hit ratio for your database service at 10 minutes of interval by default. It also provides the latest count of buffer cache hit ratio at the top of the graph.

• Locked Page Allocation - This graph provides the count of locked pages allocation for your database service at 10 minutes of interval by default. It also provides the latest count of locked pages allocation at the top of the graph.

• Transaction delay - This graph provides the count of transaction delays for your database service at 10 minutes of interval by default. It also provides the latest count of transaction delays at the top of the graph.

• Page stats - This graph provides the page reads, page lookups, and page writes per second for your database service at 10 minutes of interval by default. It also provides the latest count of page reads, page lookups, and page writes at the top of the graph.

• Write transactions per second - This graph provides the number of write transactions per second for your database service at 10 minutes of interval by default. It also provides the latest count of write transactions per second at the top of the graph.

• TempDb Log/Data file size - This graph provides the temporary database log files used, logfiles available and data files available in MiB for your database service at 10 minutes of interval by default. It also provides the latest count of temporary database log files used, logfiles available, and data files available in MiB at the top of the graph.

• Wait times - This graph provides the page IO latch waits and network IO waits in Ms for your database service at 10 minutes of interval by default. It also provides the latest count of page IO latch waits and network IO waits at the top of the graph.

• Log flushes per second - This graph provides log flushes per second for your database service at 10 minutes of interval by default. It also provides the latest count of log flushes per second at the top of the graph.

• Log flush waits per second - This graph provides log flush waits per second for your database service at 10 minutes of interval by default. It also provides the latest count of log flush waits per second at the top of the graph.

• Average latch wait time(ms) - This graph provides the count of average latch wait time in Ms for your database service at 10 minutes of interval by default. It also provides the latest count of average latch wait time in Ms at the top of the graph.

• Memory grants pending - This graph provides the count of memory grants pending for your database service at 10 minutes of interval by default. It also provides the latest count of memory grants pending at the top of the graph.

• Page life expectancy - This graph provides the count of page life expectancy for your database service at 10 minutes of interval by default. It also provides the latest count of page life expectancy at the top of the graph.

• Connection reset(per second) - This graph provides the number of conection reset per second for your database service at 10 minutes of interval by default. It also provides the latest number of connection reset per second at the top of the graph.

• Logins/Logouts(per second) - This graph provides the logins and logouts per second for your database service at 10 minutes of interval by default. It also provides the latest number of logins and logouts per second at the top of the graph.

• Active temp tables - This graph provides the count of active temporary tables for your database service at 10 minutes of interval by default. It also provides the latest count of active temporary tables at the top of the graph.

• Checkpoint pages(per second) - This graph provides the count of checkpoint pages per second for your database service at 10 minutes of interval by default. It also provides the latest count of checkpoint pages at the top of the graph.

• Log send queue - This graph provides the count of log send queue for your database service at 10 minutes of interval by default. It also provides the latest count of log send queue at the top of the graph.

• Tempdb version store (MB) - This graph provides the temporary datbase version storage in MB for your database service at 10 minutes of interval by default. It also provides the latest count of temporary database version storage at the top of the graph.

• Mirrored write transactions (per second) - This graph provides the count of mirrored write transactions per second for your database service at 10 minutes of interval by default. It also provides the latest count of mirrored write transactions per second at the top of the graph.

• Bytes sent to replica (per second) - This graph provides the number of bytes sent to replica per second for your database service at 10 minutes of interval by default. It also provides latest number of bytes sent to replica at the top of the graph.