When our infrastructure is scaled up by adding servers it causes a surge in new connections to the SQL Servers. We can get 5000 or more new connections in seconds. This causes the databases to become unresponsive. Can anyone offer some advice on how to alleviate this problem?
We have alerting, so are warned when the issue arises.
Thanks in advance.