14,494 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 31%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
Can you post the whole statement? Why you're using select top (100) percent ? What is the commandTimeout property set to (the default is 30 seconds, you may want to increase it)?
Timeout error when generating data in SQL Server 2014
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 33%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Mike Beach
1
Reputation point
Hi
We keep getting a timeout error when generating data in SQL Server 2014. We have tried changing the timeout settings but it doesn't seem to make any changes to the problem. "Error Message: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
Any help getting this resolved will be much appreciated.
Kind regards
SQL Server Other
{count} votes
-
Viorel 122.6K Reputation points2022-05-09T10:33:41.42+00:00 Did you try an experiment: SELECT TOP(100) LM.PedigreeInvoice, ....?
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 2%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESX%3C/text%3E%3C/svg%3E)
Seeya Xi-MSFT 16,586 Reputation points2022-05-11T01:54:11.31+00:00 Hi @Mike Beach ,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Best regards,
Seeya -
Seeya Xi-MSFT 16,586 Reputation points
2022-05-12T09:19:37.247+00:00 Hi @Mike Beach ,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Best regards,
Seeya
Sign in to comment
3 answers
Sort by: Most helpful
-
-
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator2022-05-09T21:27:50.053+00:00 What more exactly do you mean with generating data? It would help to know the exact operation.
It does a little bit that it is a blocking issue. That is, you query is being blocked by an uncommitted transaction that is holding a lock, so maybe you should check for that.
-
Seeya Xi-MSFT 16,586 Reputation points
2022-05-10T02:56:33.677+00:00 Hi @Mike Beach ,
Welcome to Microsoft Q&A!
Regarding if it is a issue about blocking which mentioned by Erland, you can execsp_who2and check if there is content in the blkby colum.
Of course, there are many other ways to see if it is a blocking issue.
There are two ways to capture traces which may include reason about this issue in SQL Server. Extended Events (XEvents) and Profiler Traces. However, SQL traces using the SQL Server Profiler are deprecated. So it is not recommended.
https://learn.microsoft.com/en-us/troubleshoot/sql/performance/troubleshoot-query-timeouts#troubleshooting-stepsBest regards,
Seeya
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.