Came across this very interesting article which talks about connection resiliency logic in the SQL Server management studio. What this basically does is try to re-connect in case of a time out after sleeping for 10 seconds. The default value for retry is 1 and default interval is 10 seconds. This article from Arvind Shyamsundar explains how we reset the value and how in some scenarios this might not have a good impact.

https://blogs.msdn.microsoft.com/sqlcat/2017/04/06/try-and-try-again-not-always-a-good-idea-at-least-not-for-ssms/

White Paper on connection resiliency

https://msdn.microsoft.com/en-us/library/dn632678.aspx

I hope this article was useful. Have a good day ahead.
Bodhisatya

Tagged: SSMS