Extended Events
E307901
Extended Events is a lightweight, highly scalable event-handling and monitoring framework in SQL Server used for performance troubleshooting and diagnostics.
All labels observed (2)
| Label | Occurrences |
|---|---|
| Extended Events canonical | 1 |
| Extended Events UI in SQL Server Management Studio | 1 |
How this entity was disambiguated
This entity first appeared as the object of triple T2880560 — resolving that mention is where its identity was fixed. The disambiguator weighed these candidate entities and picked the highlighted one (or “None”, minting a new entity). This is how homonymy is resolved: the same surface form can point to different entities.
NED1
Entity disambiguation (via context triple)
gpt-5-mini-2025-08-07
Target entity: Extended Events Context triple: [SQL Server Profiler, recommendedReplacement, Extended Events]
-
A.
SQL Server Profiler
SQL Server Profiler is a graphical tool for monitoring, tracing, and analyzing SQL Server database engine events in real time to help with performance tuning and troubleshooting.
-
B.
SQL Server Management Data Warehouse
SQL Server Management Data Warehouse is a SQL Server feature that collects, stores, and reports performance and configuration data from managed servers to support monitoring and analysis.
-
C.
Dynamic Management Views (DMVs)
Dynamic Management Views (DMVs) are specialized system views in SQL Server that expose real-time internal state and performance data to help monitor, diagnose, and tune the database engine and its features.
-
D.
Azure Event Hubs
Azure Event Hubs is a fully managed, real-time data ingestion and streaming platform on Microsoft Azure designed to handle millions of events per second for analytics and processing.
-
E.
Database Tuning Advisor
Database Tuning Advisor is a SQL Server tool that analyzes workloads and recommends optimal indexes, indexed views, and partitioning strategies to improve database performance.
- F. None of above. chosen
- G. Unsure - the case is ambiguous/there is not enough information to decide.
NED2
Entity disambiguation (via description)
gpt-5-mini-2025-08-07
Target entity: Extended Events Target entity description: Extended Events is a lightweight, highly scalable event-handling and monitoring framework in SQL Server used for performance troubleshooting and diagnostics.
-
A.
SQL Server Profiler
SQL Server Profiler is a graphical tool for monitoring, tracing, and analyzing SQL Server database engine events in real time to help with performance tuning and troubleshooting.
-
B.
SQL Server Management Data Warehouse
SQL Server Management Data Warehouse is a SQL Server feature that collects, stores, and reports performance and configuration data from managed servers to support monitoring and analysis.
-
C.
Dynamic Management Views (DMVs)
Dynamic Management Views (DMVs) are specialized system views in SQL Server that expose real-time internal state and performance data to help monitor, diagnose, and tune the database engine and its features.
-
D.
Azure Event Hubs
Azure Event Hubs is a fully managed, real-time data ingestion and streaming platform on Microsoft Azure designed to handle millions of events per second for analytics and processing.
-
E.
Database Tuning Advisor
Database Tuning Advisor is a SQL Server tool that analyzes workloads and recommends optimal indexes, indexed views, and partitioning strategies to improve database performance.
- F. None of above. chosen
Statements (71)
| Predicate | Object |
|---|---|
| instanceOf |
SQL Server feature
ⓘ
event-handling framework ⓘ monitoring framework ⓘ |
| canBeExportedTo | XEL file ⓘ |
| canBeReadWith |
SQL Server Management Studio
ⓘ
surface form:
SQL Server Management Studio Live Data viewer
sys.fn_xe_file_target_read_file ⓘ |
| configuredWith |
ALTER EVENT SESSION statement
ⓘ
CREATE EVENT SESSION statement ⓘ DROP EVENT SESSION statement ⓘ |
| developedBy | Microsoft ⓘ |
| documentedIn | Microsoft Docs for SQL Server Extended Events ⓘ |
| hasCatalogView |
sys.server_event_session_actions
ⓘ
sys.server_event_session_events ⓘ sys.server_event_sessions ⓘ |
| hasComponent |
action
ⓘ
event ⓘ predicate ⓘ session ⓘ target ⓘ |
| hasDynamicManagementView |
sys.dm_xe_objects
ⓘ
sys.dm_xe_packages ⓘ sys.dm_xe_session_targets ⓘ sys.dm_xe_sessions ⓘ |
| hasProperty |
asynchronous
ⓘ
highly scalable ⓘ lightweight ⓘ low overhead ⓘ |
| hasTargetType |
asynchronous_bucketizer
ⓘ
asynchronous_file_target ⓘ event_counter ⓘ event_file ⓘ histogram ⓘ pair_matching ⓘ ring_buffer ⓘ |
| hasUserInterface |
Extended Events
self-linksurface differs
ⓘ
surface form:
Extended Events UI in SQL Server Management Studio
|
| introducedInVersion |
SQL Server
ⓘ
surface form:
SQL Server 2008
|
| partOf |
SQL Server
ⓘ
surface form:
Microsoft SQL Server
|
| preferredOver |
SQL Server Profiler
ⓘ
SQL Server Profiler ⓘ
surface form:
SQL Trace
|
| replaces |
SQL Server Profiler
ⓘ
SQL Trace ⓘ |
| supports |
Always On availability group diagnostics
ⓘ
Query Store integration ⓘ asynchronous event dispatch ⓘ session templates ⓘ synchronous event dispatch ⓘ system_health session ⓘ |
| supportsCorrelation | multiple events ⓘ |
| supportsFiltering | event predicates ⓘ |
| supportsProduct |
Azure SQL Database
ⓘ
Azure SQL Managed Instance ⓘ SQL Server Analysis Services ⓘ SQL Server ⓘ
surface form:
SQL Server Database Engine
SQL Server Integration Services ⓘ SQL Server Reporting Services ⓘ |
| usedFor |
I/O troubleshooting
ⓘ
blocking analysis ⓘ capturing error details ⓘ capturing lock activity ⓘ capturing login activity ⓘ capturing long-running queries ⓘ capturing plan regressions ⓘ capturing query execution information ⓘ capturing wait and latch information ⓘ deadlock troubleshooting ⓘ diagnostics ⓘ memory usage analysis ⓘ performance troubleshooting ⓘ query performance analysis ⓘ security auditing ⓘ wait statistics analysis ⓘ |
How these facts were elicited
The pipeline generated the facts above by prompting gpt-5.1 with this entity's name + description and the instruction below.
Instruction
You are a knowledge base construction expert. Given a subject entity and a description of it, return factual statements that you know for the subject as a JSON list of dictionaries(triples), where keys must be "subject", "predicate" and "object". The number of facts may be very high, between 25 to 50 or more, for very popular subjects. For less popular subjects, the number of facts can be very low, like 5 or 10. # Requirements - If you don't know the subject at all, return an empty list. - If the subject is not a named entity, return an empty list. - Include at least one triple where predicate is "instanceOf". - Do not get too wordy. - Separate several objects into multiple triples with one object.
Input
Subject: Extended Events Description of subject: Extended Events is a lightweight, highly scalable event-handling and monitoring framework in SQL Server used for performance troubleshooting and diagnostics.
Referenced by (2)
Full triples — surface form annotated when it differs from this entity's canonical label.
this entity surface form:
Extended Events UI in SQL Server Management Studio