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
1 answer

Stored Procedures completed by me using Extended Events

I use a SQL Server Profiler trace template called "Procs completed by me", that include this text filter: %@UserID=123%. Almost all the stored procedures run by our website include a @UserID parameter, so I can click away and see the effect on the…
Craig
  • 4,111
  • 9
  • 39
  • 49
1
vote
1 answer

SSAS Tabular Extended Events Session Randomly Deleted

SSAS Instance: 1200 Version: 13.2.5830.85 Hi I created an Extended Event on the Instance to minimally capture usage of our Tabular cubes (this blog was my guide…
Danny McGreevy
  • 121
  • 7
1
vote
1 answer

How Do I find the user for an extended event?

For a "simple" Request On a MSSQL Server I get a Column filled with Xmls: SELECT CONVERT(XML, event_data) As event_data_xml FROM sys.fn_xe_file_target_read_file('Test*.xel', NULL, NULL, NULL) The result: one of these in details:
Tagamoga
  • 332
  • 4
  • 18
1
vote
0 answers

Extended Events - read vs read-write apps

As part of extended events I track rpc_completed and sql_batch_completed events. It is to catch all the queries hitting the db so I have a better understanding of the traffic. Based on that I would like to split application into two groups: read and…
Raf_123_
  • 11
  • 3
1
vote
1 answer

Is there an SSIS connector to pick up .xel file (Extended Events)? and methodology correction

I am currently working on a project to analyse the usage of dimension/measures on one of our cubes using extended events. As we are on SQL Server 2012, the extended events GUI is not available. I am using sys.fn_xe_file_target_read_file to return…
Shoaib Maroof
  • 369
  • 1
  • 3
  • 13
1
vote
0 answers

How to find/rip out all dimension/measures on an SSAS cube (Extended Events)

I am using Extended Events to analyse dimension/measure usage in an SSAS cube. I have used xmla template to create the event (from Chris Webb blog). I then have parsed the data into a staging table where I have stripped out the required field from…
Shoaib Maroof
  • 369
  • 1
  • 3
  • 13
1
vote
0 answers

Can I save a trace file/extended events file to another partition other than the C drive on the server? Or another server altogether?

I've recently set some traces and extended events up and running in SQL on our new virtual server to show the access that users have to each database and whether they have logged in recently, and have set the file to save as a physical file on the…
Chris Sumner
  • 11
  • 4
1
vote
3 answers

Extended events in Azure - Object cannot be added to the event session

I am trying to create Extended Events on an Azure SQL DB. I have followed the instructions of the below Azure documents:…
DBdev
  • 53
  • 6
1
vote
2 answers

Azure Extended Event Target File

I'm trying to setup Extended Events session on an Azure SQL DB. I've followed the instructions of the following Azure document: Event File target code for extended events in SQL Database I'm getting the following error message: Msg 25602, Level…
Eyal Zinder
  • 614
  • 1
  • 8
  • 21
1
vote
2 answers

Who created this Extended Events session?

I have been asked to find out who created a certain Extended Events session on an Azure SQL Database. However, looking through the DMVs, there are plenty of attributes, but nothing to indicate when it was created, or by whom. Is there a way to…
Pittsburgh DBA
  • 6,672
  • 2
  • 39
  • 68
1
vote
0 answers

SQL Server extended events: write custom predicates?

We have about 2'000 "old" objects in a sql server database (tables, views etc.) of which we don't really know if they're still in use. I want to create an extended event listener for these objects. I tried to add a giant WHERE clause to the CREATE…
Urs Meili
  • 618
  • 7
  • 19
1
vote
2 answers

Collect all used SQL Server objects

We have a large database with around 5000 objects (tables, views, sql functions, stored procedures etc.). A large portion of those objects are not in use anymore - but no-one exactly knows which ones. So we keep maintaining those old objects without…
Urs Meili
  • 618
  • 7
  • 19
1
vote
0 answers

Extended events, template Count Query Locks: query returns 0 rows

I am learning Extended Events basics from Jonathan Kehayias's course. I have problem with some query. In Microsoft SQL Server Management Studio I created (Extended Events) session. I downloaded database AdventureWorks2012 and script generating…
Marcin
  • 35
  • 1
  • 7
1
vote
1 answer

C# how to get list of XEvent Sessions in a given database

I'm trying to write some simple Extended Events management code in C#, but am fairly new to it. I am able to setup XEvent sessions in SSMS and was able to get the Linq stream from that created session in C# using this example What I would like to…
Danny G
  • 581
  • 4
  • 16
1
vote
1 answer

View extended event file

When i tried to read extended event file for azure database its giving an following error : I am able to download .xel file from blob storage and view it through SSMS. select * from sys.fn_xe_file_target_read_file ( 'http location of .xel file',…
Mahesh
  • 567
  • 2
  • 14
1 2
3
4 5 6 7 8