By using AWS re:Post, you agree to the AWS re:Post Terms of Use

Questions 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

Browse through the questions and answers listed below or filter and sort to narrow down your results.

70 results
Hi Team, we recently migrated to RDS SQL server 2022 from SQL server 2019 ( Enterprise to Standard Edition). The application facing some slowness and when i am checking CPU usage and it less then 70%...
2
answers
0
votes
10
views
asked 5 hours ago
![Enter image description here](/media/postImages/original/IMJbeACwkYTYiBDl9KfpgeyQ) ![Enter image description here](/media/postImages/original/IM3nA-TSL7TaOHulN8YoBjFA) Above Shows the cost graph whe...
2
answers
0
votes
47
views
asked 14 days ago
I'm experiencing unexpectedly high CPU usage on my AWS Lightsail instance, with the majority of CPU time categorized as "Other." The attached graph shows a significant portion of CPU usage labeled as ...
1
answers
0
votes
31
views
asked a month ago
I have been seeing this for sometime now, wherein the CPU spent in processing incoming requests from my application is always attributed as 'CPU Nice'. But I believe it should be 'CPU User', given tha...
1
answers
0
votes
54
views
asked 2 months ago
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 activ...
1
answers
0
votes
67
views
asked 3 months 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 p...
1
answers
0
votes
95
views
asked 3 months 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
98
views
asked 3 months 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). T...
0
answers
0
votes
331
views
asked 4 months 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
532
views
asked 5 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 Freea...
1
answers
0
votes
281
views
asked 6 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
283
views
asked 6 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
1K
views
asked 7 months ago