zabbix的监控有一个报错:
1 |
The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart. |
经检查,这个报错,调用的是下面的一个监控:
1 2 3 4 |
select count(*) as cnt from sys.sysprocesses where DateDiff(ss,last_batch,getDate())>=10 and lastwaittype Like 'PAGE%LATCH_%' And waitresource Like '2:%' |
这个监控脚本,是用来监控发生在temp上的pagelatch_up的争用。监控脚本中,包含了 […]