Questions tagged [extended-events]

SQL Server Extended Events (Extended Events) is a general event-handling system for server systems.

Filter by
Sorted by
Tagged with
0
votes
0answers
15 views

What is the best way to audit database in azure SQL managed instace? [on hold]

I have a requirement to audit Azure SQL managed instace db. I need to log all logins, time of login and queries fired by the user. What is the best practice to get this done? Explored and found ...
1
vote
2answers
36 views

Trying to trace error in Stored Procedure using XEvents

Here is the situation: I have a SQL server ETL application with a stored procedure that is inserting/updating some data into a table. The table has 1 INT column (it is an identity column and there ...
1
vote
0answers
16 views

Read all Captured Extended Events for a Given Extended Event Session Name

I want to be able to read all XE files for a dynamic XE session name. My XE session stores files to disk. I have the query below DECLARE @XeName SYSNAME = 'MyXE' DECLARE @Path NVARCHAR(255) SELECT @...
1
vote
2answers
56 views

Trying to identify what process is making a connection to a specific DB in SQL Server

I am attempting to track down... something... that is making a connection to a specific database without (apparently) doing anything with the connection. However, so far I have had no luck. The data ...
1
vote
1answer
44 views

Can Extended Events used instead of Auditing?

In BOL it is mentioned does this mean Extended Events can capture all the events that are traced by auditing? Can we get all the functionalities of auditing just by using XEvents? thanks
1
vote
0answers
19 views

How to convert Extended Event action mdmget_TimeStampUTC to datetime?

SQL Server Extended Events can include an action of mdmtargetpkg.mdmget_TimeStampUTC. It returns a value such as 132085458320550473. How can that be converted to an actual date? It doesn't appear to ...
4
votes
2answers
272 views

Way to find when system health file is rolling over

Is there a way to find the events when system health extended event files are rolling over rather than manually monitoring for the events? For my medium load server they stay upto 2-3 days. But for ...
3
votes
1answer
294 views

What is the proper event in Extended Events to track stored procedure executions?

My goal is to track executions of a single stored procedure using Extended Events In the event selection list, I can find following: sql_statement_completed sql_batch_completed ...
0
votes
0answers
28 views

How to know the size of data returned from a select statement using extended event in azure sql MI?

When a select statement is issued I would like to know the the query issued by the user and the number of rows returned along with the bytes/MB of data returned using extended events. With event ...
12
votes
1answer
187 views

SQL Extended Events Session for deadlock detection

Is there a way to increase the size of the <inputbuf> element in the deadlock XML captured by the deadlock extended events session? We want to see the complete query to help pinpoint the issue ...
2
votes
0answers
28 views

Why execution plan could be skipped from XE session?

Got an issue, similar to this one: Why does SQL Server Profiler trace not capture SELECT operator in execution plans?. There was an advice to use XE instead of Trace, but it does not help. Thing is, ...
0
votes
1answer
24 views

Resources used by ExtendedEvents

Does anyone know how to tell how many resources (CPU/MEM/Reads etc) have been used by SQL Server Extended Events? I've went through the available DMVs here But I dont see where this is tracked ...
0
votes
1answer
46 views

Need Help in extended events SQL Server

I have created an extended event as below. I want to know how to query the historical data using T-SQL to see the issues at particular timestamps. The trace is running as of now CREATE EVENT SESSION [...
10
votes
1answer
199 views

Incorrect process utilization from System health extended events?

I have been recently working on understanding the data or metrics being stored in system health extended events event file. We are trying to implement the data collection of performance metrics using ...
0
votes
1answer
104 views

File growth and location change for system health extended events

I am continuing the questions over system health extended event from my previous question How are the system health extended events files rolling over? I see system health file location by default ...
5
votes
1answer
271 views

How are the system health extended events files rolling over?

I see the default system health session events within SQL Server are 5 MB each with 4 files in total. We are trying to fetch data from the system health in historical events but for some critical ...
4
votes
1answer
77 views

SQL Server 2016 still uses mixed_extent_allocation in TempDB

Today I was troubleshooting a problem on TempDB on SQL Server 2016 SP2 using extended events and added the mixed_extent_allocation and transaction_log event to my trace. I expected ...
-2
votes
1answer
110 views

Centralized Logs (error, deadlocks, slow queries) For SQL Servers

I want to establish a centralized log for many SQL Servers, similar to the products Graylog or elk stack. What is the best and performant way to send these kind of logs to a log collector? I ...
1
vote
1answer
19 views

Capture Extended Events Histogram only during time window

We have a problematic time window during night on the weekends. I want to set up multiple Extended Events sessions to capture some data and get insight. Most of them will target a file, which I can ...
0
votes
2answers
683 views

How to view xEvent event_file data

I have a small xEvent that is sending the results as .xel to an event_file in G:\XEvents and I want to explore the data with SSMS. I have been looking for a solution and found several posts about ...
4
votes
0answers
52 views

Authoritative Extend Event object list?

I am looking for an authoritative list of objects for extended events, I want to know what version an object becomes available and some clues about what the value really represents. I have googled ...
3
votes
0answers
144 views

Difference between sqlserver.nt_username & sqlserver.username

I am just learning about SQL Extended Events. I have a small event and for actions I have selected both sqlserver.nt_username & sqlserver.username When I test connect with a NT account the ...
9
votes
1answer
100 views

What does it means when you have “sql_exit_invoked” in System Health?

I'm having problems with one of my SQL Server 2016 Standard servers. I have 8 production servers and this one is the only one who crashes randomly without having any trace in the log. I have ...
2
votes
1answer
240 views

database_xml_deadlock_report or xml_deadlock_report

Is [database_xml_deadlock_report] the same as [xml_deadlock_report] just with extra fields? I'm creating a basic deadlock and blocking capture and see both. Most examples online show [...
1
vote
1answer
43 views

Why does a query on a local instance with local database files cause NETWORK_IO waits?

I have followed this tutorial to get the wait stats of a particular query while it is 'in flight' using extended events. Whilst the tutorial refers to an index rebuild, I just did a select statement ...
1
vote
1answer
44 views

How to index of filter extended event files in Sql Server

I am collecting errors data using the error_reported event and saving the data on XEL files. The problem is that there are hundreds of thousands of errors over there and querying them can take a lot ...
1
vote
1answer
134 views

how to add an extended events tracking session to SSAS?

I would prefer to have a script to achieve this, but as I am not so familiar with SSAS I am using the wizard to create an extended events session in SSAS. The way I am doing it is right clicking on ...
2
votes
1answer
209 views

Extended Event Session Keeps Stopping

A few months ago I added an extended event to track blocked processes and deadlocks, with a file output to track occurrences. Every now and again, I check the log file, but find that the extended ...
3
votes
1answer
178 views

SQL Query logging in extended events deadlock xml report is too short

How can I tell the sql server to log the whole query in the xml, and not truncate it? example: <inputbuf> (@0 nvarchar(20),@1 nvarchar(10),@2 decimal(38,20),@3 int,@4 datetime,@5 nvarchar(...
5
votes
1answer
68 views

Precision for average_disk_seconds_per_read?

In SQL Server Extended Events, event = perfobject_logicaldisk, what is the actual unit of time for average_disk_seconds_per_read and average_disk_seconds_per_write? All of the documentation I've ...
1
vote
0answers
78 views

Testing Data Compression

We have a 1TB table that gets queried a lot. I have suggested we use Data Compression to save on space as well as help put more in memory. Because of the concern of CPU overhead, I have been tasked ...
-2
votes
1answer
228 views

RID and Key lock on same object by a Select and Delete query

To be specific how did the select query (spid 128, on the left) is able to acquire a S (shared) lock on Index but not on the row? Also, how did Delete query (SPID 121, on the right) is able to get X ...
1
vote
1answer
179 views

How do I access ETW Traces on SQL Server for linux?

I have SQL Server running in a docker image. I have an extended event session running on it. I can connect to it fine and view live data with SSMS. I can use T-SQL to view the histogram target. If ...
1
vote
0answers
248 views

SQL Server Trace Stopped Messages Displaying Random Login Name

When traces are started and stopped we get messages similar to the following in the SQL Server error log: SQL Trace ID 2 was started by login "DOMAIN\loginA". and SQL Trace stopped. Trace ID = ...
1
vote
0answers
95 views

Cost / Capacity Planning: Quantify Data Ingress / Egress

To evaluate the migration of an on-prem SQL Server to a cloud-hosted VM, I want two fundamental pieces of information: The list of clients that access the on-prem DB Server. I'd like to know: client ...
1
vote
1answer
548 views

How to interpret AlwaysOn event hadr_db_partner_set_sync_state

We have a program that listens to the SQL Server AlwaysOn_health event session for state changes. When we simulate a secondary server going offline or online, we get the ...
6
votes
2answers
2k views

What is the right tool to process big .xel files (SQL Server Extended Events logs)?

My aim is to audit all queries on an instance, who's running them and from where, how many reads, in order to consolidate/migrate on another instance. Figured out the best way is via Extended Events ...
2
votes
1answer
54 views

Explanation of Extended Events xml

I queried an Extended Events session and returned the XML. I am confused on what frame level 1, 2, 3 mean. As well as line, offsetStart and offsetEnd? I am however able to convert the sql handle to ...
2
votes
1answer
298 views

Query plan do not get invalidated after update statistics

I'm running some tests to find out when query plans get invalidated after an update statistics. The machine I'm using for testing is a SQL Server Developer 2016 SP1 CU7. I found an article on ...
1
vote
1answer
329 views

Determine which SQL drivers an application uses to connect to SQL server

I want to find out what SQL driver a third-party application (or any application for that matter) uses to connect to a SQL Server instance in production. It can be tough to get a fast answer from a ...
0
votes
0answers
1k views

Extended Event Reported Error Login Timeout

While poking around for a specific event I found myself discovering an error happening every second. At the moment I cannot find any more information about the error as it only gets displayed in the ...
1
vote
1answer
151 views

Extended Events: Specify Session Data Storage left blank

What happens if the Data Storage is never configured?
2
votes
1answer
77 views

SQL 2008/R2 Extended Events - Row Count

I need to setup a sql audit to capture all queries running on a server from any unauthorized locations, and one of the columns that is required is Row Count. In sql trace, this is possible. But I can'...
1
vote
1answer
311 views

Is there a service broker target for an extended event session

We use Service Broker heavily for asynchronous background processing. Additionally we want to use it for extended event processing. Is it possible to use Service Broker listener as target for an ...
1
vote
1answer
72 views

Extended Events replacement for Virtual file stats

Is there a way to monitor virtual filestats data with Extended Events, instead of doing (select * from sys.dm_io_virtual_file_stats) in SSMS?
1
vote
0answers
328 views

Track all changes to table with Extended Event Session

I am using the sql_statement_completed Event in SQL Server 2016 to track all SQL executed on a certain table. I have a Filter on sqlserver.sql_text like %tablename%. This captures any SQL I execute ...
2
votes
0answers
378 views

StartTime and EndTime for the Attention Extended Event

The documentation says that the "Attention" extended event class has StartTime and EndTime as part of it. But I can't seem to figure out how to get at it or record it... Here is what I am using to ...
0
votes
1answer
159 views

When using XE Profiler in SSMS 17.3, the 'Database Name' column shows as either NULL or an empty string

I'm just starting to use SSMS 17.3 - and one of the main things I was looking forward to trialing was XE Profiler. However, when you start a session (either Standard or TSQ) and add the Database Name ...
1
vote
1answer
252 views

Extended Events session file truncated on server restart

I have created an extended events session to capture login and logout information. The session is setup to store events to a file. I understood that one of the advantages of using an event file (...
2
votes
2answers
454 views

Monitoring deadlocks in SQL Server 2014

We are experiencing deadlocks on SQL Server 2014 and I am trying to capture as much information about them as I can. There is already Extended Events Session that captures xml_deadlock_report events ...