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 ?
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
Last activity: Mar 10, 2020, 12:00 PM