details for performance insights

0

I have enabled performance insight for my RDS.deadlock error occured in my database.I need to know about the querry which got deadlock.

3 Answers
1

Hello,

Deadlocks are reported in database error log/alert log. You may check full details (sql, sessions, object, etc.) there and then drill down in Performance insight to relate with root cause etc.

Thanks

AWS
answered a year ago
0

The exact resolution for deadlock monitoring varies depending on with DBMS platform you are using. For example, in SQL Server, you must enable the monitoring functionality through a Parameter Group. Details for the step-by-step process are here - https://aws.amazon.com/blogs/database/monitor-deadlocks-in-amazon-rds-for-sql-server-and-set-notifications-using-amazon-cloudwatch/.

profile pictureAWS
kekline
answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions