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 (12)
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 Live Data viewer
ⓘ
linked to:
SQL Server Management Studio
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 UI in SQL Server Management Studio
ⓘ
linked to:
Extended Events
|
| introducedInVersion |
SQL Server 2008
ⓘ
linked to:
SQL Server
|
| partOf |
Microsoft SQL Server
ⓘ
linked to:
SQL Server
|
| preferredOver |
SQL Server Profiler
ⓘ
SQL Trace ⓘ
linked to:
SQL Server Profiler
|
| 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 Database Engine ⓘ
linked to:
SQL Server
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 (14)
Full triples — surface form annotated when it differs from this entity's canonical label.
linked to: Extended Events
linked to: Extended Events
linked to: Extended Events
linked to: Extended Events
linked to: Extended Events
linked to: Extended Events
linked to: Extended Events
Microsoft Docs for SQL Server Extended Events
→
documents
→
Extended Events UI in SQL Server Management Studio
ⓘ
linked to: Extended Events
Microsoft Docs for SQL Server Extended Events
→
documents
→
Extended Events for SQL Server on Windows
ⓘ
linked to: Extended Events
Microsoft Docs for SQL Server Extended Events
→
documents
→
Extended Events for SQL Server on Linux
ⓘ
linked to: Extended Events
Microsoft Docs for SQL Server Extended Events
→
documents
→
Extended Events for Azure SQL Database
ⓘ
linked to: Extended Events
Microsoft Docs for SQL Server Extended Events
→
documents
→
Extended Events for Azure SQL Managed Instance
ⓘ
linked to: Extended Events