专栏名称: 程序员大咖

为程序员提供最优质的博文、最精彩的讨论、最实用的开发资源；提供最新最全的编程学习资料：PHP、Objective-C、Java、Swift、C/C++函数库、.NET Framework类库、J2SE API等等。并不定期奉送各种福利。

如何解决SQL Server占CPU100%？

程序员大咖 · 公众号 · 程序员 · 2017-02-08 18:53

正文

请到「今天看啥」查看全文

f on ag.AddrId = f.Id

where ((MgrObjId in (

select Id from MgrObj

where AddrId in ( '' , '02100000' , '02113000' , '02113001' , '02113002' , '02113003' , '02113004'

, '02113005' , '02113006' , '02113007' , '02113008' , '02113009' , '02113010' , '02113011' , '02113012'

, '02113013' , '02113014' , '02113015' , '02113016' , '02113017' , '02113018' , '02113019' , '02113020'

, '02113021' , '02113022' , '02113023' , '02113024' , '02113025' , '02113026' )))

or (mgrobjid in ( '00000000-0000-0000-0000-000000000000' , '00000000-0000-0000-0000-000000000000'

, '00000000-0000-0000-0000-000000000000' , '11111111-1111-1111-1111-111111111111'

, '11111111-1111-1111-1111-111111111111' ))

)

order by alarmtime DESC

SQL2：获取当前的总报警记录数

select count ( * ) from eventlog as a left join mgrobj as b on a . MgrObjId = b . Id and a . AgentBm = b . AgentBm

left join addrnode as c on b . AddrId = c . Id left join mgrobjtype as d on b . MgrObjTypeId = d . Id

left join eventdir as e on a . EventBm = e . Bm

where MgrObjId in (

select Id from MgrObj where AddrId