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
72
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
2
answers
103
views
xEvent Not Capturing Events for Large Memory Grants in SQL Server
I want to capture SQL Server queries with a memory grant over 10 GB so those queries and the tables they touch can be tuned to reduce the memory grants. I created an extended events session and a test ...
- 416
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
0
answers
65
views
Extended Events - Login Event - Using Packet_Size to Filter SQL Server Logins
I want to create an Extended Events Session to track SQL Server Logins.
The value for packet_size is 4096 for all of the SQL Server successful logins that the Login Extended Event has recorded.
Is a ...
- 101
0
votes
1
answer
95
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
114
views
How can I determine the state of an Extended Events session (started or stopped) in Azure SQL Database?
How can I determine the state of an Extended Events session (started or stopped) in Azure SQL Database? The DMV sys.dm_xe_database_sessions doesn't have this information, and none of the other sys....
- 2,295
2
votes
1
answer
154
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,362
3
votes
1
answer
115
views
What does it mean if all of my wait_resources in the System Health Extended Event are the same pointer?
It's notoriously impossible to decode what the wait_resource pointer in the System Health Extended Event means. But if all of my long waits in that Extended Event for a certain time period are ...
- 1,362
3
votes
1
answer
189
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
1
answer
111
views
Events of System_health extended event serious or not
I have listed the event names present in my system_health extended event report. Based on these groupings, can I decide whether a group needs to be checked or not? Which ones are serious and must be ...
- 35
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, ...
0
votes
0
answers
115
views
How to record database User permission changes
How can I record changes to a database User permissions?
I have a SQL Server 2019 database user that loses Select permission overnight, but we do not know why. I want to audit or record those changes....
2
votes
1
answer
253
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 ...
0
votes
1
answer
188
views
Why can I not capture dynamic SQL called with EXEC using the sqlserver.sql_batch_completed Extended Event?
It is my understanding that dynamic SQL is part of a batch. Yet, when I listed for sqlserver.sql_batch_completed as follows
CREATE EVENT SESSION [CaptureBatch] ON SERVER
ADD EVENT sqlserver....
- 1,362
3
votes
1
answer
146
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