Checking the real-time database performance metrics
After installing the WhaTap agent, log in WhaTap Monitoring Service. The initial screen is Project List. In Project List, you can see the installed project. If a project is selected from the Project List, you can enter Instance List.
In the WhaTap database monitoring service, the dashboard allows you to see the overall status of the project at a glance. You can check the total resource size for monitoring and filter the resources to be monitored on the real-time dashboard.
-
It is configured to show key performance metrics and status. The performance metrics are updated every 5 seconds.
-
You can check the active sessions (including queries), lock information, and process information. To apply both the public cloud and private cloud, the products are configured for query-based monitoring.
-
In a single instance, multiple databases are filtered.
-
Based on the collected data, it provides the function to analyze the overall trend for a specific day. You can analyze slow queries after identifying active sessions at a specific time point.
Instance List
You can see the list of database servers in which the agent has been installed. It is configured to display key performance metrics and status. The performance metrics are updated every 5 seconds, and the columns in the list can be arranged through settings. For more information, see the following.
Monitoring a Database Instance
-
Multiple instances are grouped and monitored simultaneously on a screen. You can monitor the overall system status by selecting desired key metrics.
-
The real-time monitoring checks the performance metrics at an interval of 5 seconds. You can check the Active sessions, Lock tree, and Process Info.
For more information, see the following.
Using the Monitoring CloudWatch
In case of Amazon RDS, you can see the information provided by AWS through the CloudWatch API. The collection cycle is at least 1 minute.