Extended Events

E307901

SQL Server feature event-handling framework monitoring framework

Extended Events is a lightweight, highly scalable event-handling and monitoring framework in SQL Server used for performance troubleshooting and diagnostics.

Try in SPARQL Jump to: Surface forms Statements Referenced by

All labels observed (2)

Label	Occurrences
Extended Events canonical	1
Extended Events UI in SQL Server Management Studio	1

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 ⓘ

Referenced by (2)

Full triples — surface form annotated when it differs from this entity's canonical label.

SQL Server Profiler → recommendedReplacement → Extended Events ⓘ

Extended Events → hasUserInterface → Extended Events self-linksurface differs ⓘ

this entity surface form: Extended Events UI in SQL Server Management Studio