Questions tagged with Performance Insights

We migrated a SQL Server Enterprise 15.00 from **Single AZ** to **Multi AZ** and enabled the default Performance Insights retention period for the instance. The Database Load graph is always showing...

We have recently attempted to implement aws xray in our backend service that uses inversify and inversify express utils in order to implement IoC. But we have been unable to achieve the correct...

I am trying to troubleshoot query performance issues and am seeing the following results out of SYS_QUERY_HISTORY. | query_id | elapsed_time | execution_time | compile_time | planning_time |...

Hi I have an oracle 19c running on RDS in AWS. I need to setup some monitoring alarms in case DB goes down, CPU utilization goes over 80%, RDS deletion, etc. and received an email alert. I noticed...

I have been struggling with the following issue. When using MySQL 8.0.32+ (maybe previous versions as well) and enabling performance insights in RDS, my instances start leaking memory. It is very...

I have an RDS that has Performance insights enabled. I can view the performance from the console. Is there a way to download the various metrics from the Dimensions Tab? I am specifically interested...

I need to fetch the Top sql statements from RDS performance insights based on Avg latency(ms)/call and send it as pdf. While checking the documentation, got the...

**Background**: We have a kinesis Firehose configured to send to encrypted S3, it is converting from JSON to Parquet. The source is Direct PUT. The Buffer hints are set with 64MiB and interval of...

I am currently facing an issue where my TOP SQL stats are displayed as "-" for all my queries. I am using an Aurora Mysql 8.0.mysql_aurora.3.04.0 database. After further investigation I came to the...

I can see "Other 1075 mysqld threads" using 74% CPU of the RDS MySQL instance (v8.0.33) under "Operating system process list" in "Monitoring" tab and also in Performance Insights Metrics Dashboard...

I want to enable Performance Insight in the my 'DB Cluster' which consist of following specifications **Current capacity**: 1 capacity unit, **Role**: Serverless, **Engine**: Aurora MySQL, **Engine...

Hello, On one of my RDS clusters, i got the recommendation to turn on performance insights. When I tried to modify the database with Aurora Mysql 2.06 engine with instance type db.r4.xx , I am not...