Mssqlserver error 80040e31 ([odbc SQL Server Driver] timeout expired

Cause :.

When the database is set, [file growth] increases by percentage. When the database file is large (more than 1 GB), a timeout is reported for the new operation, at this time, the CPU and memory usage are very low. ..

Solution:

Set the above file growth here to a lower percentage or directly specify how many megabytes are added. !

2. SQL Server database timeout settings.

Modify the connection timeout settings of the client. By default, the timeout setting for registering another SQL Server through the Enterprise Manager is 4 seconds, and the query analyzer is 15 seconds. .

Settings in Enterprise Manager :.

A. In Enterprise Manager, select "tools" from the menu, and then select "options ";...

B. In the displayed "SQL Server Enterprise Manager properties" window, click the "Advanced" tab ;.

C. Enter a large number, such as 30, in the "login timeout (seconds)" box on the right under "connection settings. ..

Query settings in Analyzer :.

Click "tools"-> "options"-> "connection"; set logon timeout to a large number, and set connection timeout to 0. For a real winner, no matter what his living conditions are, he will not erase himself.

3. Query statement timeout ..

Cause Analysis :..

Query timeout generally involves finding the cause from the structure of SQL statements and data tables. Optimizing SQL statements and creating indexes for database query fields is the most common method. For a real winner, no matter what his living conditions are, he will not erase himself.

In addition, the database query timeout settings are generally maintained by sqlserver (before you modify the query wait configuration), only when the actual query time exceeds the estimated query time by 25 times, will time out. ..

There are two possible reasons for exceeding the estimated value :.

First, the estimated time is inaccurate ;.

Second, SQL statements involve queries that consume a large amount of memory (such as sorting and hash operations). If the memory is insufficient, you need to wait in queue for resources. .

Solution :.

A. Optimize statements to create and use suitable indexes ;!

B. To solve the first problem, UPDATE the index distribution STATISTICS of the table to be queried to ensure the correctness of the estimated time. UPDATE STATISTICS