SQL Server 2017 AlwaysOn AG 自动初始化（八）
IF OBJECT_ID('tempdb..#DirectSeed') IS NOT NULLDROP TABLE [#DirectSeed];
CREATE TABLE [#DirectSeed]
(
INT IDENTITY(1, 1)
NOT NULL ,
XML ,
CONSTRAINT PRIMARY KEY CLUSTERED ( )
);
INSERT[#DirectSeed]
( )
SELECTCONVERT(XML, ) AS
FROM .('C:\XE\DirectSeed*.xel', NULL, NULL, NULL)
CREATE PRIMARY XML INDEX ON [#DirectSeed]();
CREATE XML INDEX ON [#DirectSeed]()
USING XML INDEX FOR VALUE;
SELECT
..('(/event/@name)', 'VARCHAR(MAX)') AS ,
..('(/event/@timestamp)', 'DATETIME2(7)') AS ,
..('(/event/data[@name="debug_message"]/value)', 'VARCHAR(8000)') AS ,
/*hadr_automatic_seeding_state_transition*/
..('(/event/data[@name="previous_state"]/value)', 'VARCHAR(8000)') AS ,
..('(/event/data[@name="current_state"]/value)', 'VARCHAR(8000)') AS ,
/*hadr_automatic_seeding_start*/
..('(/event/data[@name="operation_attempt_number"]/value)', 'BIGINT') as ,
..('(/event/data[@name="ag_id"]/value)', 'VARCHAR(8000)') AS ,
..('(/event/data[@name="ag_db_id"]/value)', 'VARCHAR(8000)') AS ,
..('(/event/data[@name="ag_remote_replica_id"]/value)', 'VARCHAR(8000)') AS ,
/*hadr_automatic_seeding_success*/
..('(/event/data[@name="required_seeding"]/value)', 'VARCHAR(8000)') AS ,
/*hadr_automatic_seeding_timeout*/
..('(/event/data[@name="timeout_ms"]/value)', 'BIGINT') as ,
/*hadr_automatic_seeding_failure*/
..('(/event/data[@name="failure_state"]/value)', 'BIGINT') as ,
..('(/event/data[@name="failure_state_desc"]/value)', 'VARCHAR(8000)') AS
FROM [#DirectSeed] AS
ORDER BY ..('(/event/@timestamp)', 'DATETIME2(7)') DESC
页:
[1]