This PowerShell script connects to AWS CloudWatch to retrieve log events for a given RDS SQL Server instance. It looks for deadlock-related messages, extracts relevant information like the SPID, and displays them. It also provides a method to convert date-time values into milliseconds, necessary for the AWS CLI query.
To run the script, enter something like the following at the command line:
powershell -command “. .\Get-Database-Deadlock.ps1; Get-Database-Deadlock -dbInstanceId ‘############’ -startTime ‘2025-02-23 03:00:00.00′”
You will need to look up the RDS Database Instance Id in the AWS console.
A few things I noticed while writing this script:
- If your time range is to long, the call to AWS returns nothing. This script accepts a start datetime stamp, and then adds thirty minutes to the start datetime stamp to to generate a end datetime stamp. Feel free to adjust the range in the code.
- I’ve been able to retrieve known deadlock entries up to about five days back. I wasn’t able to retrieve a known deadlock from thirteen days back.
https://github.com/billlange1968/aws-scripts/blob/main/Get-Database-Deadlock.ps1