Recently I have been getting hangs in the API and checking the logs I am seeing this:

System.Data.SqlClient.SqlException (0x80131904): Connection Timeout
Expired. The timeout period elapsed while attempting to consume the
pre-login handshake acknowledgement

• I have set the connection pool to 3k and timeout to 60s.
• The API is a .Net Core 6 API deployed on Azure
• The database is a MSSQL Server deployed on Azure

Semi regularly the front end hangs and a single call can take a few minutes to return. Upon checking the logs I see the error above.

Note: The database is responsive when this error is thrown from the deployed API and there are not that many connections seen using sp_who2

Anyone have an idea on why this is happening?