SQL Server 环形缓冲区（Ring Buffer） -- RING_BUFFER_SECURITY_ERROR 诊断安全相

q789321

SELECT CONVERT (varchar(30), GETDATE(), 121) as runtime,　　
DATEADD (ms, -1 * ((sys.cpu_ticks / sys.cpu_ticks_in_ms) - a.[Record Time]), GETDATE()) AS Notification_time,
　　
a.* , sys.ms_ticks AS [Current Time]
　　
FROM
　　
(SELECT
　　
x.value('(//Record/Error/ErrorCode)[1]', 'varchar(30)') AS [ErrorCode],
　　
x.value('(//Record/Error/CallingAPIName)[1]', 'varchar(255)') AS [CallingAPIName],
　　
x.value('(//Record/Error/APIName)[1]', 'varchar(255)') AS [APIName],
　　
x.value('(//Record/Error/SPID)[1]', 'int') AS [SPID],
　　
x.value('(//Record/@id)[1]', 'bigint') AS [Record Id],
　　
x.value('(//Record/@type)[1]', 'varchar(30)') AS [Type],
　　
x.value('(//Record/@time)[1]', 'bigint') AS [Record Time]
　　
FROM (SELECT CAST (record as xml) FROM sys.dm_os_ring_buffers
　　
WHERE ring_buffer_type = 'RING_BUFFER_SECURITY_ERROR') AS R(x)) a
　　
CROSS JOIN sys.dm_os_sys_info sys
　　
ORDER BY a.[Record Time] ASC