AWS Performance Insights
Amazon Performance Insights is a database performance tuning and monitoring feature that helps you quickly assess the load on your database, and determine when and where to take action. Performance Insights allows non-experts to detect performance problems with an easy-to-understand dashboard that visualizes database load. AWS Performance Insights
Performance Insights uses lightweight data collection methods that don’t impact the performance of your applications, and makes it easy to see which SQL statements are causing the load, and why. It requires no configuration or maintenance, and is currently available for Amazon Aurora (PostgreSQL- and MySQL-compatible editions), Amazon RDS for PostgreSQL, MySQL, MariaDB, SQL Server and Oracle.
With seven days of free performance history retention, it’s easy to track down and solve a wide variety of issues. The Amazon Web Services API and SDK make it easy to integrate Performance Insights into on-premises and third-party monitoring tools. If you need longer-term retention, you can choose to pay for up to two years of performance history retention.
It’s easy to get started: just log into the Amazon RDS Management Console, and enable Performance Insights when creating or modifying an instance of a supported RDS engine. Then go to the Performance Insights dashboard to start monitoring performance.
Below are the cmdlets which are available with AWS Performance Insights
CmdletName | ServiceOperation |
Get-PIDimensionKey | DescribeDimensionKeys |
Get-PIResourceMetric | GetResourceMetrics |
You can also check other AWS Services, and each services cmdlets we are providing.