Questions tagged [extended-events]
SQL Server Extended Events (Extended Events) is a general event-handling system for server systems.
234 questions
0 votes
1 answer
69 views
How can I find the source (hostname, etc.) of one Azure SQL Database query using Extended Events without having to capture every statement?
I want to do this, but there doesn't seem to be a supported way to do it. What is a version that would work? CREATE EVENT SESSION [MySession] ON DATABASE ADD EVENT sqlserver.sql_statement_completed( ...
- 2,295
0 votes
1 answer
47 views
XE:query_trace_column_values
according to this acticle: https://www.sqlshack.com/query-trace-column-values/ try to setup XE session which captures query_trace_column_values but it's does not work anymore on Microsoft SQL Server ...
0 votes
1 answer
93 views
SQL Server Extended Events - collecting SP Object_name
I'm going round in circles trying to work out how to collect the object_name in extended events, I can use it to filter like in the session definition below CREATE EVENT SESSION [xetest] ON SERVER ...
- 4,676
2 votes
1 answer
153 views
Does the auto_stats Extended Event misreport the sample percentage from temporal tables or columnstore?
Start up the auto_stats Extended Event, filter out some noise, and prepare yourself to monitor it. CREATE EVENT SESSION [AutoStatsTest] ON SERVER ADD EVENT sqlserver.auto_stats( WHERE ([duration]&...
- 1,322
3 votes
1 answer
188 views
Is there a direct way to know if a merry-go-round scan happened?
In the docs it says we can share index scans (Advanced Scanning). Now here they used wait stats and statistics and i did not find an extended events session that could directly identify it. The ...
- 167
0 votes
0 answers
59 views
Issues converting an XEL (Extended events file) to XML with the help of PowerShell in Azure automation Runbook
I need some advice to convert the XEL file to XML. I am executing a PowerShell script in Azure Automation runbook in Azure portal to store the XEL file from BLOB storage to my local machine, ...
2 votes
1 answer
247 views
Sql Server Extened Events lock_acquired and lock_released - The meaning of resource_0, resource_1 and resource_2
The lock_acquired and lock_released events have the resource_0, resource_1, resource_2 properties and their content and meaning depends on the resource_type, but their meaning is not always clear to ...
3 votes
1 answer
143 views
Extended Events - Not all selected global fields appear in Watch Live Data
Following is the setup in wizard - where global fields to capture are listed, But why not appearing for selection in Watch Live Data? Is there anything to be done in addition? Adding script of the ...
- 81