if object_id('tempdb..#dbToDelete') is not null
drop table #dbToDelete
if object_id('tempdb..#databaseName') is not null
drop table #databaseName
declare @dbToDelete table(name varchar(500))
declare @eventname varchar(500)
--find out all disabled extended events
insert into @dbToDelete select name from sys.server_event_sessions
where name not in (select name from sys.dm_xe_sessions)
--match my own event session
--and name like '%vivi%'
while exists(select name from @dbToDelete)
begin
select top 1 @eventname=name from @dbToDelete
if exists(select * from sys.server_event_sessions where name = @eventname)
begin
print 'dropping event sessions: '+@eventname
--delete disabled event sessions
exec('DROP EVENT SESSION ['+ @eventname +'] ON SERVER')
end
delete from @dbToDelete where name = @eventname
end
删除不活动的event sessions
最新推荐文章于 2020-06-14 12:30:51 发布