AWS Database Blog
Tag: Performance Insights
Tune HAQM RDS for Oracle CDBs with HAQM Performance Insights
With Oracle Multitenant, you can consolidate standalone databases by either creating them as PDBs or migrating them to PDBs. Performance Insights has introduced a new PDB dimension to help you visualize and analyze the distribution of the load on individual PDBs within the CDB on a RDS for Oracle instance. Now, you can slice the database load metric by the PDB and SQL dimensions to identify the top queries running on each of the PDBs. In this post, we will discuss how to identify resource-intensive SQL queries at a PDB level on a visual dashboard in Performance Insights.
Tuning HAQM RDS for MySQL with Performance Insights
HAQM RDS Performance Insights brings an intuitive tuning interface to HAQM RDS to help you discover and investigate performance issues on your RDS databases. The look and feel of Performance Insights is the same across all database engine types, such as RDS for MySQL, RDS for PostgreSQL, and HAQM Aurora. However, every engine has a […]
Set alarms on Performance Insights metrics using HAQM CloudWatch
HAQM RDS Performance Insights recently released a feature that sends key performance metrics from Performance Insights to HAQM CloudWatch. Using this feature, you can set alerts on these metrics. When Performance Insights is enabled, it automatically sends the following three metrics to CloudWatch: DBLoad DBLoadCPU DBLoadNonCPU I describe these three metrics following. DBLoad The first […]
Analyze HAQM Aurora MySQL Workloads with Performance Insights
In this blog post, we will take a quick tour of the Performance Insights dashboard for the HAQM Aurora MySQL-Compatible Edition and learn to analyze certain performance issues.
HAQM RDS Performance Insights is now generally available
Today we are pleased to announce general availability of Performance Insights. Already available since October 2017 as an open preview with HAQM Aurora with PostgreSQL compatibility, Performance Insights makes it easy to view the load on an HAQM RDS database. Using Performance Insights, you can more easily identify bottlenecks and discover what to do when […]