Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
To check for time waits you can run:
<%@ Language=VBScript %> <html> <head> </head> <body> <% response.flush set cnn = server.CreateObject("adodb.connection") CNN.cursorlocation=3 cnn.open [YOUR CONNECTION STRING] set rs=server.createobject("adodb.recordset") set rs=cnn.execute("select top 1 * from [YOUR TABLE]") cnn.close set cnn=nothing %> </body> </html>
via the command prompt on the web server. Assuming this is a test system, you should immediately see time_wait connections popup from your web server to your DB server. Remove the flush, and this stops.
netstat -nao | find /i "[YOUR DB IP]"