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
1
vote
2 answers

Is there any event in Event Library by which we can identify Fragmented Index using Extended Events?

I am new to extended events however, I got to know about the same by reading some articles like this one My question: Is there any event in Event Library by which we can identify Fragmented Index ? Because I got only I am using SQL Server…
priyanka.sarkar
  • 25,766
  • 43
  • 127
  • 173
1
vote
2 answers

Extended Events - rpc_completed

I still new to extended events, but thought I need to get into it, seeing as it is a lot more detailed. I am trying to setup a extended event, on the rpc_completed event, tracking proc calls that have a duration of 5 seconds or longer. I setup the…
Olaf Dedig
  • 11
  • 1
  • 4
1
vote
2 answers

QueryableXEventData and "Watch Live Data" one event behind

Why QueryableXEventData when configured to read live Extended Events stream is always one event behind? Same true for "Watch Live Data" window because it's based on QueryableXEventData (event_stream target) too. Just in case below my create event…
Dmitry Morozov
  • 170
  • 6
1
vote
1 answer

SQL Server : How to display all extended event tables

When I run my query SELECT * FROM sys.sysobjects WHERE xtype = 'U' I find there are 2 more tables added trace_xe_action_map and trace_xe_event_map, I realize then that these two siblings come from extended events but I remember inserting them into…
user1453256
  • 49
  • 1
  • 3
1
vote
1 answer

How can I schedule an extended event to run at a specific time

Basically I have created a new extended event session, and I want to schedule this to run for a specific time lets say 2:00 AM. Usually I would of written a script to create a trace and then been able to schedule it using SQL Agent as a job, but I'm…
ZeRaTuL_jF
  • 582
  • 2
  • 4
  • 20
1
vote
1 answer

How can I replicate the functionality of sp_trace with extended events from C#?

I am working on a C# application which uses the various sp_trace procedures to view events from a remote SQL Server database. The particular events I'm most interested in are when queries and stored procedures start and finish. I need data for each…
ChaseMedallion
  • 20,860
  • 17
  • 88
  • 152
1
vote
1 answer

How does Tableau connect to SQL Server?

I'm trying to get a better understanding of how various third party applications reach into a Microsoft SQL Server data warehouse and gather data before allowing report writers to work with it. I'm working with a SQL 2008 R2 instance and ultimately…
Sean Long
  • 2,163
  • 9
  • 30
  • 49
1
vote
1 answer

Extended Events - building a histogram of servers that connect with a particular Application Name?

I'm trying to build an XE in order to find out which of our internal apps (that don't have app names and thus show up as .Net SQLClient Data Provider) are hitting particular servers. Ideally, I'd like to get the name of the Client and Database ,…
mbourgon
  • 1,286
  • 2
  • 17
  • 35
1
vote
2 answers

Where are the session definitions of extended events stored?

Is it msdb, resource, master or local? If I back up my local database against which I run the XEs, would I have backed up my sessions as well? Are there any metadata stored in the system tables too? Thank you all.
user2155565
  • 317
  • 3
  • 5
  • 11
0
votes
1 answer

Unable to start deadlock Extendeds events on Azure SQL Database

whenever i create deadlock Extendeds events with storage as eventfile as below,Extendeds events gets created in stopped state.When i start the extended event with below command its giving the followig error: ALTER EVENT SESSION [dba_deadlocks] ON…
sandeep Kumar
  • 1
0
votes
0 answers

My managed instance's Extended Event stopped logging new events - what am I missing?

I have an extended event running on a GP managed instance. This is the same one I'm using on-prem - it captures error_reported with severity > 10, keeps 10mb of history. Been using it for a year+ without problems on prem. In Azure, this week it…
mbourgon
  • 1,286
  • 2
  • 17
  • 35
0
votes
0 answers

SSAS Trace Logs TextData Parsing

I logged Analysis Services trace with Extended Events. I want to summarize this data, which columns and measures are used in Tabular cube? I have TextData column, Is there any way to parse and get this information?
Tracedy
  • 11
  • 1
0
votes
1 answer

Not able to get Azure SQL Server Extended Events to work when Blob Storage is set to Enabled from selected virtual networks and IP addresses

So I have an Azure Database and want to test extended events with the database. I was able to set up my Blob Storage container and was able to get Extended Events via Azure Database to work as long as the Blob Storage network setting Public network…
null_pointer
  • 1,779
  • 4
  • 19
  • 38
0
votes
0 answers

Export updates of analysis services extendent events at table

I create extended event and save result at file. then i export it into table , but new events never logged automatically at this table. any way to do this ? or to export xel file to table by command by scheduler?
Aser
  • 27
  • 4
0
votes
0 answers

Android Studio Emulator doesn't work with Extended controls Changes

The "extended controls" of my Android Studio Studio emulator don't do anything and there aren't any any response in the emulator such as changing the battery charge level or charger connection . Has anyone else ran into this issue and any help…
Hossam El Sharabasy
  • 1
  • 1
1 2 3
4
5 6 7 8