2008 xe parse

2008 xe parse.sql

			SELECT 
				td.r.value('@name','sysname') event_name,
				td.r.value('@timestamp','datetime2(7)') event_timestamp, 
				td.r.value('(data[@name="wait_type"]/text)[1]','sysname') wait_type,
				td.r.value('(data[@name="duration"]/value)[1]','bigint') wait_duration,
				td.r.value('(action[@name="sql_text"]/value)[1]','nvarchar(max)') sql_text,
				td.r.query('.') event_data
			into #xe
			FROM (
						SELECT
						CAST(target_data AS XML) target_data
						FROM sys.dm_xe_sessions s
						JOIN sys.dm_xe_session_targets t
							ON s.address = t.event_session_address
				
						WHERE s.name = N'system_health'
							and target_name = 'ring_buffer'
						) base
			CROSS APPLY target_data.nodes('/RingBufferTarget/*') td(r);
			GO
			
			select 
				event_name, 
				dateadd(HOUR,-5,event_timestamp) event_timestamp, 
				wait_type, 
				wait_duration, 
				sql_text, 
				event_data					
				from #xe
				order by event_timestamp desc
			GO
			DROP TABLE #xe;