For example, if your intent is to Select a single row but you see a scan operator, that is a strong indication that you need to perform index or query tuning or need to update statistics. For a slow-running query, you may want to check the execution plan to verify that the statement is touching the rows which are needed. The BlkBy column will show the SPID of the blocking connection if the query is blocked. A quick way to check for blocking to run sp_who2 while the query is running. Query timeout: The reason a command/query runs longer than expected is commonly due to blocking or the need for query/index tuning or both. The next obvious question is – what should we do if we see such error? Within this time if the connection can’t be made, we would see the error.
The timeout period elapsed prior to the completion of the operation.
Today we are going to learn about how to fix the error: Timeout expired.