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
187
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
1
vote
1
answer
216
views
How to convert single column with XML data into multiple columns, while querying Extended Events XEL file
We have created an Extended Events session to capture errors with severity 16 or higher:
CREATE EVENT SESSION [Error_Reporting] ON SERVER
ADD EVENT sqlserver.error_reported(
ACTION(sqlserver....
- 6,225
0
votes
1
answer
127
views
Reading / understanding the context of query_abort extended events trace with SQL CallStackResolver
We've decided to test and perhaps implement the new query_abort extended events trace on all our database servers to learn more about our timeout queries. Currently, we use the rpc_completed event ...
- 325
4
votes
1
answer
1k
views
How can I prevent SQL Server from logging the starting and stopping of XE sessions to the server log files?
I have a process which starts and stops Extended Event sessions in order to transfer data from event files into SQL tables. On a SQL Server 2022 RTM server, I see many lines written to the log files ...
- 33.2k
0
votes
0
answers
281
views
TraceFlag 15097
I wanna use traceflag 15097 and benefit from AVX-512 on SQL Server 2022. I saw some videos where they demonstrated the feature, however I didn’t find out how to use the extended events to monitor ...
- 2,927
1
vote
2
answers
147
views
Is there any way to link "starting" and "completed" events?
In SQL Server Extended Events, is there any way of linking a "starting" event, such as rpc_starting, with a "completed" event, such as rpc_completed? For example, is there ...
- 295
1
vote
2
answers
749
views
SQL Server Extended Event Session for Attention is missing field sql_text
I have an extended event session set up to track Attention events, to monitor procedures that timed out. This is the create script:
CREATE EVENT SESSION [ApplicationTimeout3] ON SERVER
ADD EVENT ...
- 223
-2
votes
1
answer
120
views
Why force plan is not working with failure "NO_PLAN"?
We have query which is inserting data to heap:
INSERT INTO [heap]
(
80 COLUMNS...
)
SELECT
14 columns
65 NULL VALUES
, '...
- 487
0
votes
2
answers
570
views
Use extended events to track autoupdate statistics on a specific table
I'm trying to find a way to track a table that has auto update statistics on, I'm trying to track how often it auto updates and at what intervals.
The table in question is used quite often and because ...
0
votes
0
answers
43
views
Extended Events - is that a proof that the issue is not at the SQL Server side?
I have a problem with one PowerBI dashboard and I would like to ask for your advise if my logic is correct.
We are migrating a few databases from one server (Server1) to the another one (Server2). At ...
- 192
2
votes
3
answers
926
views
Trace what is calling a trigger? Extended Events Question
Good morning all - I have a monitoring software that is showing one of my audit triggers is firing 1+ million times an hour, when I look at the audit tables there are about 3000 records entered - The ...
- 447
0
votes
1
answer
64
views
Differences between sys.server_event_* and sys.dm_xe_* when querying SQL Server extended event meta data?
I'm querying SQL Server extended event meta data and I noticed that there are two sets of sources: sys.server_event_* and sys.dm_xe_*. What are the differences between these two sources? Which one ...
- 1,239
15
votes
2
answers
907
views
Why does sys.fn_xe_file_target_read_file require an explicit cast on datetime2 column?
According to the documentation the returned column timestamp_utc should be of type datetime2(7)
But when I query like this
SELECT
*
FROM sys.fn_xe_file_target_read_file('system_health*.xel', null,...
- 5,724
0
votes
1
answer
212
views
Extended Events for Enable Disable Trigger
We have a table that has a trigger defined on it
Sometimes, some application runs disable trigger command, then does something, then runs enable trigger to enable it back
Scanning the GIT, developers ...
- 6,225
6
votes
1
answer
2k
views
Identifying wait_resource for wait_info Extended Events
Is there a way to identify what type/name of resource that is being waited on?
- 315
0
votes
0
answers
53
views
Monitoring MS Dynamics 365 with Extended Events
I know that SQL Server and Azure SQL support "Extended Events" as a means of profiling execution. I also know that MS Dynamics 365 is built with Azure SQL. What I'd like to accomplish is ...
- 191
2
votes
1
answer
350
views
A way to filter out parseonly statements from extended events?
I'm currently using extended events to capture query statements executed in a production environment. But the actual session is also capturing the activity of 'query parsing' done by operators to ...
- 5,171
-2
votes
1
answer
244
views
Why only few SQL Server Extended event plan handle 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
We have created an extended event to capture long running queries , the objective is to get execution plan by joining on plan handle column
some event data has a plan handle with id value however some ...
