但是上述时间的信息已经细化到Session级别了，比sys.dm_os_wait_stats 中的等待信息更有参考价值。
对于问题的诊断和分析，也会是更加有效。
上述统计结果的SQL语句
-- Parse the XML to show rpc_completed,sql_batch_completed details
if object_id('tempdb..#t1') is not null
drop table #t1
SELECT
event_xml.value('(./action[@name="session_id"]/value)[1]', 'INT') as session_id,
event_xml.value('(./@timestamp)', 'varchar(1000)') as timestamp,
event_xml.value('(./data[@name="statement"]/value)[1]', 'varchar(max)') as statement,
event_xml.value('(./data[@name="batch_text"]/value)[1]', 'varchar(max)') as batch_text,
event_xml.value('(./@name)', 'varchar(1000)') as Event_Name,
event_xml.value('(./data[@name="duration"]/value)[1]', 'bigint') as Duration,
event_xml.value('(./data[@name="cpu_time"]/value)[1]', 'bigint') as cpu_time,
event_xml.value('(./data[@name="physical_reads"]/value)[1]', 'bigint') as physical_reads,
event_xml.value('(./data[@name="logical_reads"]/value)[1]', 'bigint') as logical_reads,
event_xml.value('(./action[@name="username"]/value)[1]', 'varchar(max)') as username
INTO #t1
FROM (
SELECT CAST(event_data AS XML) xml_event_data
FROM sys.fn_xe_file_target_read_file(N'D:XEventFilesCollectionSessionWaitStats*', NULL, NULL, NULL)
) AS event_table
CROSS APPLY xml_event_data.nodes('//event') n (event_xml)
WHERE event_xml.value('(./@name)', 'varchar(1000)') in ('rpc_completed','sql_batch_completed')
order by Event_Name
-- Parse the XML to show wait_info,wait_info_external details
if object_id('tempdb..#t2') is not null
drop table #t2
SELECT
cast(event_xml.value('(./@timestamp)', 'varchar(1000)') as DATETIME2) as timestamp,
event_xml.value('(./data[@name="duration"]/value)[1]', 'bigint') as duration,
event_xml.value('(./action[@name="session_id"]/value)[1]', 'INT') as session_id,
event_xml.value('(./data[@name="wait_type"]/text)[1]', 'VARCHAR(200)') as wait_type
INTO #t2
FROM (
SELECT CAST(event_data AS XML) xml_event_data
FROM sys.fn_xe_file_target_read_file(N'D:XEventFilesCollectionSessionWaitStats*', NULL, NULL, NULL)
) AS event_table
CROSS APPLY xml_event_data.nodes('//event') n (event_xml)
WHERE event_xml.value('(./@name)', 'varchar(1000)') in ('wait_info','wait_info_external')
if object_id('tempdb..#t3') is not null
drop table #t3
SELECT
a.session_id AS SessionId,
isnull(statement,batch_text) AS SQLTEXT,
a.Duration AS TotalExecuteTime,
CAST(a.timestamp AS DATETIME2) AS CompletedTime,
CAST(b.timestamp AS DATETIME2) AS WaitTypeStartTime,
b.wait_type AS WaitType,
