All Content tagged with Performance Insights

Amazon RDS 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.

Content language: English

Select up to 5 tags to filter
Sort by most recent
I’ve been running a large insert query on my SQL Server database (around 15 columns, ~3 million rows). While I expected some delay, the insertion has stopped making progress. The query is still...
0
answers
0
votes
6
views
Eloy
asked a day ago
I have seen intermittent issues with the Performance of the Select Queries where the same query randomly takes 8-10s. I have enabled Slow query logs and randomly some queries that are simple and use...
1
answers
0
votes
38
views
asked 20 days ago
Hi I am following steps mentioned here -https://docs.aws.amazon.com/documentdb/latest/developerguide/performance-insights-enabling.html to enable performance insights Documentation mentions that,...
1
answers
0
votes
50
views
dev
asked 23 days ago
The AWS documentation says that Performance Insight does not use instance storage, but we've noticed something different. We activated it into a reader instance (MySQL Aurora 3.06.0 - r6g.2xlarge)....
0
answers
0
votes
310
views
dirk39
asked a month ago
We have enable the Performance Insights, but we can't show the call/sec..etc in each query. ![Enter image description here](/media/postImages/original/IMkasMYu4AQoui3bo2H0pT8A) We don't really know...
1
answers
0
votes
292
views
Tomas
asked 2 months ago
![![Enter image description here](/media/postImages/original/IMFS53IpuyTse4k_w1s4c1Fw) ![Enter image description here](/media/postImages/original/IMB8CzPhKYRx6-axpyWWeO1Q) There are 3 drops in...
1
answers
0
votes
231
views
Han
asked 3 months ago
![Enter image description here](/media/postImages/original/IMdQlbBkN6TSaKxgrd6S8AmQ) Both queries are the same except WHERE entity in (different identifier) as the first step in a CTE. The entity in...
2
answers
0
votes
218
views
Han
asked 3 months ago
Hello, I am using performance insights to troubleshoot high CPU(98%) issue on PostgreSQL RDS. RDS -> Writer Instance -> sessions (Current activity) -> Dimensions -> Top hosts There I can see Unknown...
1
answers
0
votes
852
views
rgri
asked 4 months ago
If an RDS has a writer and a reader instance. If I then want to complete Analytics work by connecting to the Reader instance. Given that both instances connect to the same DB. Is there a potential to...
2
answers
0
votes
390
views
asked 6 months ago
We were originally using a db.r5.8xlarge as our write instance, and Performance Insights was displaying the DB load queries properly. However, after updating to a db.r5.16xlarge more than a week ago,...
1
answers
0
votes
357
views
Hoon
asked 6 months ago
I'm running RDS for SQL Server 2017+2019 Standard Edition Instances. Performance Insights shows this message: "If the SQL statement exceeds 4096 characters, it is truncated. To view the full SQL...
2
answers
1
votes
505
views
profile picture
asked 7 months ago