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.
Answer by ThomasRushton ·
There is overhead associated with creating a connection on the SQL Server itself, so... more CPUs, more RAM, faster disk, faster network connection between your SQL Server and your domain controller (if you're using AD-authenticated accounts to connect)...
And then there may be some possibilities if you rework your application / system - look up "connection pooling" for example.
Without more detail of your environment and what's going on, though, it's going to be difficult to make specific recommendations.