sql进程检查

select * from (SELECT TEXT as

tt,AA.* FROM sys.sysprocesses

AA CROSS APPLY

sys.dm_exec_sql_text(AA.sql_handle)

) as a

where login_time >

DATEADD(MI,-30,getdate())

and last_batch >

DATEADD(SECOND,2,login_time)

and loginame <> 'sa'

and loginame not like 'tcdb%'

and loginame not like 'VCSdb%'

and loginame not like '##%'

and program_name in(

'.Net SqlClient Data Provider'

,'Internet Information Services')

and cmd in('select','AWAITING COMMAND')

and tt like '%select %'

and status<>'background'

and dbid>4

order by tt