SQLserver查询死锁

最新推荐文章于 2024-12-14 02:00:00 发布

叶倾

最新推荐文章于 2024-12-14 02:00:00 发布

阅读量1.7k

点赞数 1

分类专栏：数据库 SQLserver 文章标签：数据库 sqlserver

本文链接：https://blog.csdn.net/u013296960/article/details/110442186

版权

DECLARE @SessionName SysName

SELECT @SessionName = 'system_health'

IF OBJECT_ID('tempdb..#Events') IS NOT NULL BEGIN
DROP TABLE #Events
END

DECLARE @Target_File NVarChar(1000)
, @Target_Dir NVarChar(1000)
, @Target_File_WildCard NVarChar(1000)

SELECT @Target_File = CAST(t.target_data as XML).value('EventFileTarget[1]/File[1]/@name', 'NVARCHAR(256)')
FROM sys.dm_xe_session_targets t
INNER JOIN sys.dm_xe_sessions s ON s.address = t.event_session_address
WHERE s.name = @SessionName
AND t.target_name = 'event_file'

SELECT @Target_Dir = LEFT(@Target_File, Len(@Target_File) - CHARINDEX('\', REVERSE(@Target_File)))

SELECT @Target_File_WildCard = @Target_Dir + '\' + @SessionName &#