January 4, 2018 at 5:40 pm
Hard to tell from what you have posted. Can't really tell what was captured, even enlarged to output is hard to read and we can't expand the columns of data that you didn't mark up to see all the data.
I don't have the time today to play with your code, but perhaps tomorrow I squeeze in some time.
January 4, 2018 at 7:02 pm
sp_statement_completed is captured in this case.
Columns are:
c.value('(@name)[1]', 'nvarchar(250)') AS [XEC_EventName],
c.value('(data[@name="duration"]/value)[1]', N'bigint') AS [XEC_Duration],
c.value('(data[@name="cpu_time"]/value)[1]', N'bigint') AS [XEC_CpuTime],
c.value('(data[@name="writes"]/value)[1]', N'bigint') AS [XEC_Writes],
c.value('(data[@name="logical_reads"]/value)[1]', N'bigint') AS [XEC_LogicalReads],
c.value('(data[@name="physical_reads"]/value)[1]', N'bigint') AS [XEC_PhysicalReads],
c.value('(action[@name="server_principal_name"]/value)[1]', N'sysname') AS [XEC_ServerPrincipalName],
isnull(c.value('(action[@name="sql_text"]/value)[1]', N'nvarchar(max)'),c.value('(action[@name="statement"]/value)[1]', N'nvarchar(max)')) AS [XEC_SqlText],
c.value('(action[@name="query_hash"]/value)[1]', N'varchar(32)') AS [XEC_QueryHash],
c.value('(action[@name="query_plan_hash"]/value)[1]', N'varchar(32)') AS [XEC_QueryPlanHash],
c.value('(action[@name="server_instance_name"]/value)[1]', N'sysname') AS [XEC_ServerInstanceName],
c.value('(action[@name="database_name"]/value)[1]', N'sysname') AS [XEC_DatabaseName],
c.value('(action[@name="client_app_name"]/value)[1]', N'sysname') AS [XEC_ClientAppName],
c.value('(action[@name="collect_system_time"]/value)[1]', N'datetime') AS [XEC_CollectSystemTimeUtc],
c.value('(action[@name="task_time"]/value)[1]', N'bigint') AS [XEC_TaskTime]
January 4, 2018 at 11:29 pm
But I can't see what your results are so I have no idea what is being displayed.
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply