Stack Overflow
Stack Overflow

Questions tagged [extended-events]

SQL Server Extended Events (Extended Events) is a general event-handling system for server systems. The Extended Events infrastructure supports the correlation of data from SQL Server, and under certain conditions, the correlation of data from the operating system and database applications. The SQL Server Extended Events Engine was first introduced in SQL Server 2008 and was greatly enhanced in SQL Server 2012.

111 questions
2
votes
0 answers

Sp_whoisactive equivalent in Extended Events

So I have been using sp_whoisactive to monitor some activity on my SQL servers and I was wondering how to create some thing similar in extended events. I have a basic understanding of events and have created a few but I have no idea what values and…
justinf
  • 1,246
  • 2
  • 19
  • 39
2
votes
2 answers

Extended event file storing in azure blob

I have created Extended event session for azure database from my local sql server management studio and storing resulting file in azure blob storage. but when i start extended event session it giving me an following error : I have follow all the…
Mahesh
  • 567
  • 2
  • 14
2
votes
0 answers

Find Unused Stored Procedures Using Extended Events

One of our databases has over 3400 stored procedures and 400 functions. The system has been around since before 2009 and there are many procs/functions that are no longer used. I was given the task of finding those unused procs so they could be…
J Brun
  • 1,246
  • 1
  • 12
  • 18
2
votes
1 answer

SQL Monitoring and Interjection

From another thread that gave me the information on how to add monitoring to an SQL Server... See SQL From EntityFramework with Collection-like Queries This works well, but I want to take it a step further. I'd like to be able to add comments into…
Ciel
  • 17,312
  • 21
  • 104
  • 199
2
votes
1 answer

Extended event session on SQL Server 2014 to capture stored procedure calls and arguments passed

I have an application which generates certain reports while values are entered and generate button is clicked on an application. I know to which database this application is connecting, but don’t know which stored procedure is getting called. The…
jacob james
  • 21
  • 1
  • 2
2
votes
0 answers

SQL Server Extended Events Querying using SQL

I have created an extended event and I'd like to query data from event file / log. How can I query this to get locks only for a certain table (table name) and a specific database given by name as well. CREATE EVENT SESSION [LocksXE] ON SERVER ADD…
pzaj
  • 1,062
  • 1
  • 17
  • 37
2
votes
1 answer

How to create email alerts for extended events?

I have created extended events in SQL server 2012. Everything is working fine. Now I am looking for if any events occur (example :deadlock), it should send mail to given mail id. Is it possible in extended events?
Vijay Kumar
  • 21
  • 1
  • 2
2
votes
0 answers

SQL Server 2008 R2 (SP2).Extended Events Session do not catch events in the asynchronous_file_target

I'm trying to create historical log for deadlocks with the help of XEvents Session but it doesn't work on the client machine. Xel file is empty, even after I've generated deadlock by myself. But on the another server, deadlocks are successfully…
Olena Smoliak
  • 41
  • 3
2
votes
3 answers

Deadlock graph from XEvents doesn't produce "good" XML

I'm investigating a deadlock and used the following query (which I got from Jonathan Kehayias's Pluralsight course on deadlocks) to extract information from extended events regarding the deadlock: SELECT …
jamiet
  • 10,501
  • 14
  • 80
  • 159
2
votes
1 answer

Retrieve Timestamp of Deadlock in Extended Events Session Ring Buffer

I am trying to query the system_health extended events ring buffer for deadlock events. So far, I have gotten the deadlock graph like below. My apologies for a lack of reference; I have lost the page from which I found this query: SELECT …
Paul Williams
  • 16,585
  • 5
  • 47
  • 82
2
votes
1 answer

SQL Server 2012 Extended Events wait_info vs 2008 R2

Just starting to play with EE in 2012 and was working through a demo that didn't quite work out on 2012 but worked fine on 2008 R2. The demo was on tracing wait stats and it failed due to differences in the data columns that are available between…
mouse
  • 23
  • 4
1
vote
1 answer

How to pass SQL Server Extended Events Activity Id from C#?

I have been looking into using Extended Events in a full end-to-end tracing scenario. I am especially interested in the XEvent's activity id that helps follow event execution sequence for a given activity. You will have guessed, my event session in…
Talisker
  • 177
  • 2
  • 16
1
vote
1 answer

XEvents: what is the purpose of this set statement for an output parameter?

I'm using XEvents to analyze queries from a Spring application to a SqlServer DB (2019). Here's the statement property of an rpc_completed event. I don't understand what the set @p1=67 line does: declare @p1 int set @p1=67 exec sp_prepexec @p1…
l4mpi
  • 5,103
  • 3
  • 34
  • 54
1
vote
1 answer

Extended Events - Not showing log file growth

We have a standard extended event session to collect database and log file growth running on our SQL servers. I was creating an index on a large table, knowing it might fill up the transaction log. It did, however the DBA that went to investigate…
Andrew
  • 11
  • 1
1
vote
0 answers

Does Microsoft.SqlServer.XEvent.XELite.XELiveEventStreamer work with SSAS ring_buffer or event_stream?

I'm trying to extract extended events from a stream on a SSAS server with the following code: Microsoft.SqlServer.XEvent.XELite.XELiveEventStreamer xEvents = new XELiveEventStreamer("Data Source=.;Initial Catalog=master;Integrated…
PCJ
  • 73
  • 9
1
2
3 4 5 6 7 8