Definitions More Info.
Definition ID	736
Title	SQL
Category	NOTES
Definition	system_health SQL Management Extended events system_health
Definition Description	http://dba.stackexchange.com/questions/61320/sql-server-2012-security-error-ring-buffer-recorded-impersonatesecuritycontext --Hatalari bulup tablonun icine atariz. INSERT INTO [dbo].[ERROR] SELECT CONVERT (varchar(30), GETDATE(), 121) as runtime, dateadd (ms, (a.[Record Time] - sys.ms_ticks), 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 -- Hatarın hangisinden kaçtane var buluruz SELECT COUNT(SPID) ,SPID FROM dbo.ERROR GROUP BY SPID HAVING COUNT(SPID)>1 -- Bu hatalara sahip olan işlemler hangileri görürüz. exec sp_who2 665 Tabloyu oluştur CREATE TABLE [dbo].[ERROR]( [runtime] [varchar](30) NULL, [Notification_Time] [datetime] NULL, [ErrorCode] [varchar](30) NULL, [CallingAPIName] [varchar](255) NULL, [APIName] [varchar](255) NULL, [SPID] [int] NULL, [Record Id] [bigint] NULL, [Type] [varchar](30) NULL, [Record Time] [bigint] NULL, [Current Time] [bigint] NOT NULL ) ON [PRIMARY]
RecordBy	cunay
Record Date	29-04-2016 14:42:56
Düzenle
Kopyala
Sil