sql server xp_readerrorlog引起的CPU爆满100%

【0】问题操作

我做了一个监控，

--监控十分钟内的错误日志信息

监控语句如下：

--监控十分钟内的错误日志信息

declare   @start_time datetime,@end_time datetime
            set @start_time = DATEADD(minute,-10,GETDATE())
            set @end_time = GETDATE()
            if OBJECT_ID('tempdb..#tmp_error_log') is not null
            drop table #tmp_error_log
            create table #tmp_error_log
            (
            logdate      datetime,
            processinfo  varchar(100),
            info         varchar(8000)
            )
            insert into #tmp_error_log
            exec dbo.xp_readerrorlog 0,1,NULL,NULL,@start_time,@end_time,N'desc'
            select COUNT(1) as num, MAX(logdate) as logdate,info
            from #tmp_error_log
            where (info like '%ERROR%'
            or info like '%WARN%'
            or info like '%FAIL%'
            or info like '%STOP%')
            and info not like '%CHECKDB%'
            and info not like '%Registry startup parameters%'
            and info not like '%Logging SQL Server messages in file%'
            and info not like '%previous log for older entries%'
            group by info