User Tools

Site Tools


traxs_error_diagnostics

Traxs Error Diagnostics

declare @range int = 60

drop table #timeout
select 'timeout: ' + substring(data, charindex('_EVENTTARGET:',data)+13, charindex('__EVENTARGUMENT:',data) - charindex('_EVENTTARGET:',data)-15) as timeout_object into #timeout from traxs_errors where context like '%Execution Timeout Expired%' and date_time > getdate()-@range and charindex('_EVENTTARGET:',data) <> 0
select timeout_object, count(*) from #timeout group by timeout_object
union
select context,count(*) from traxs_errors where  date_time > getdate()-@range and context not like '%Execution Timeout Expired%' group by context having count(*) > 2 order by 2 desc
traxs_error_diagnostics.txt · Last modified: 2020/04/24 10:11 by 212.42.166.188