SQL Server timeout analysis and summary

From the point of view of the database instance, it will receive access from the web side, direct access from the user, and it may also access other database instances at the same time. Then, connections are divided into incoming connection (Incoming connection) access and outgoing connection (Outgoing connection) access.

First of all, for incoming connections, let's take a look at the access timeout on the web side: ASP.NET request timeout, WebService request timeout, IIS request timeout, database connection timeout, and query timeout.

Reference:

Http://www.cnblogs.com/wuya/archive/2010/08/03/1791167.html

Http://www.cnblogs.com/kingboy2008/p/3711143.html

Http://www.xuebuyuan.com/308400.html

Http://ultrasql.blog.51cto.com/9591438/1864004

Next, for incoming connections, let's take a look at the timeout setting when users access the database through SSMS.

Reference:

Http://ultrasql.blog.51cto.com/9591438/1863961

Finally, for outgoing connections, let's take a look at the timeout setting for remote access to databases across instances.

Reference:

Http://ultrasql.blog.51cto.com/9591438/1863914