Setup: HA connected to SQL Server AWS RDS
I have seen over the last two days that our SQL Server has hit over 100+ connections which has brought down the node, the server and service is still running, but the node in the configuration is offline. This has happened three times over the last two days but hasn’t been seen before this.
I have temporarily resolved the issue by restarting the affected node and just now I have bumped the max connections on each node to 200.
But I’m concerned that this is just a band-aid and there is a more serious underlying issue.
I have looked through the logs at the times the problem occurs, but don’t see anything obvious. I have also looked at what was being deployed at that time to see if there is anything in common, but don’t see anything.
Can I have some pointers on how to track down what is occurring?