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
15
views
asked 5 days 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
55
views
asked 19 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
33
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
59
views
asked 3 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
68
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
97
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
101
views
asked 4 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
543
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
282
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
293
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
1.1K
views
asked 7 months ago