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

CmdletNameServiceOperation
Get-PIDimensionKey                                 DescribeDimensionKeys                         
Get-PIResourceMetric                               GetResourceMetrics                            

You can also check other AWS Services, and each services cmdlets we are providing.

Click on this Link for an Single place, where you get all the PowerShell cmdlets sorted based on the modules.

You can also refer other blogs on PowerShell at link

You can also refer other blogs on Microsoft at link

And also if you required any technology you want to learn, let us know below we will publish them in our site http://tossolution.com/

Like our page in Facebook and follow us for New technical information.

References are taken from Microsoft and AWS

Leave a Reply

Your email address will not be published. Required fields are marked *