Advertisement
Hello all<\/p>\n
I have an in-house .NET legacy .NET app (new to me) that performs some validation operation on a SQL server database. Now, there seems to be some arbitrary connection timeouts whilst the validation program is running. Notably, the timeout often occurs at a particular table whose design I am in the process of reviewing. What are some known issues (in terms of server environment configuration) to watch out for as the potential causes for the random timeouts, and interim workarounds whilst I sort out the seemingly flawed design that causes elaborated query execution time? Thus far, I have checked the event viewer and I seem not to come by a substantial feedback. Some of the off the hook details regarding the server environment include a Windows Server 2008R running on a 16GB RAM with the relational database edition of SQL Server 2012 enterprise.<\/p>\n
Great thanks<\/p>","upvoteCount":6,"answerCount":3,"datePublished":"2020-12-01T08:23:13.000Z","author":{"@type":"Person","name":"francisochieng","url":"https://community.spiceworks.com/u/francisochieng"},"suggestedAnswer":[{"@type":"Answer","text":"
Hello all<\/p>\n
I have an in-house .NET legacy .NET app (new to me) that performs some validation operation on a SQL server database. Now, there seems to be some arbitrary connection timeouts whilst the validation program is running. Notably, the timeout often occurs at a particular table whose design I am in the process of reviewing. What are some known issues (in terms of server environment configuration) to watch out for as the potential causes for the random timeouts, and interim workarounds whilst I sort out the seemingly flawed design that causes elaborated query execution time? Thus far, I have checked the event viewer and I seem not to come by a substantial feedback. Some of the off the hook details regarding the server environment include a Windows Server 2008R running on a 16GB RAM with the relational database edition of SQL Server 2012 enterprise.<\/p>\n
Great thanks<\/p>","upvoteCount":6,"datePublished":"2020-12-01T08:23:13.000Z","url":"https://community.spiceworks.com/t/arbitrary-timeout-in-connection-to-sql-server/783339/1","author":{"@type":"Person","name":"francisochieng","url":"https://community.spiceworks.com/u/francisochieng"}},{"@type":"Answer","text":"
First, what makes you think there is a timeout? Is there a message? Is it a two minute timeout from a query via IIS? Is there a timeout in the SQLERROR log? Show us the actual error you are receiving since you haven’t isolated it.<\/p>\n
I don’t think there is any reason to suspect an issue with SQL Server without more information. Have you identified the query? How many items in the table(s) that are being queried?<\/p>\n
Your questions are based on assumptions that are too general and do not isolate the issue properly.<\/p>","upvoteCount":1,"datePublished":"2020-12-01T15:28:08.000Z","url":"https://community.spiceworks.com/t/arbitrary-timeout-in-connection-to-sql-server/783339/2","author":{"@type":"Person","name":"brianswales","url":"https://community.spiceworks.com/u/brianswales"}},{"@type":"Answer","text":"
Based on my past experiences, the timeout problems (if they exist) are more to do with the .NET config and not the out-of-box SQL config.<\/p>\n
Try googling ‘.net sql timeout web.config’.<\/p>\n