Sample Header Ad - 728x90

Tracking Down Application Timeout Errors in SQL Server

13 votes
3 answers
30115 views
SQL Server 2008 SP3 How do I track down these timeout errors ? enter image description here The errors are displayed on an intranet dashboard used specifically for error reporting in IIS. My suspicion is that there is a default timeout of 30 seconds in the web application and if a query takes more than thirty seconds, an exception is thrown. As there are many queries that take longer than 30 seconds on these SQL servers, I can't just filter in profiler based on duration. Serving up the website being monitored by this dashboard are two IIS servers retrieving data from seven SQL Server instances. Could I use the **"User Error Message Event"** and the **"OLEDB Errors Event"** to track these errors in SQL Server Profiler?
Asked by user4659
Oct 14, 2014, 03:51 PM
Last activity: Mar 10, 2020, 12:00 PM