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.
Questions tagged [extended-events]
111 questions
0
votes
1 answer
SQL Server: reading XML files for extended events
I have set SQL server to report errors in form of XML files, through extended events.
Now, I want to read and display them.
I am doing something wrong, and some data does not display as expected.
I simplified as much as possible, here is what I do:
…
carlo.borreo
- 1,344
- 2
- 18
- 35
0
votes
1 answer
How to filter a table name in Extended Events?
I created an Extended Event Session using a script with a Where clause in order to filter commands which refers to a table whose name is MySchema.MyTable:
WHERE…
Geri Reshef
- 397
- 1
- 6
- 17
0
votes
1 answer
Java + Ms SQL Server 2008 R2 after insert trigger notification
I need to write web application using java webgui Vaadin Framework which will be real-time updated with new records inserted to MsSQL database by MsWin2k8R2 NPS.
Since NPS stores logs to files and/or DB, I prefer DB, but I'd like to know how my java…
termil0r
- 131
- 2
- 14
0
votes
1 answer
Using SQL Server Extended Events to audit table access
Is it possible to monitor table access using SQL Server 2008 R2 Extended Events (EE)? We need to monitor any table reads, updates or inserts for one table. From what I can gather, it should be possible to monitor Selects via table lock events with…
brynn
- 107
- 1
- 2
- 11
0
votes
2 answers
Extended Event force order of sys.fn_xe_file_target_read_file() DMF results
Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012
08:36:30 Copyright (c) Microsoft Corporation Enterprise Edition
(64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1)
Is there a way to guarantee the order of…
Pixelated
- 1,531
- 3
- 15
- 35
-1
votes
1 answer
How to import .XEL files into SQL Server
I need to investigate some events from Azure SQL Database.
The Audit logs were stored on a Storage Account and I have downloaded them on my laptop. They are now all in the same folder.
There are many guides that explains you how to import such files…
Francesco Mantovani
- 10,216
- 13
- 73
- 113