SQL Server Extended Events How-to Topics

Using Management Studio or Transact-SQL to execute Transact-SQL Data Definition Language (DDL) statements, dynamic management views and functions, or catalog views, you can create simple or complex SQL Server Extended Events troubleshooting solutions for your SQL Server environment.

In This Section

• How to: Determine Which Queries Are Holding Locks

• How to: Find the Objects That Have the Most Locks Taken on Them

• How to: Configure Parameters for the ADD TARGET Argument

• How to: Get the Fields for All Events

• How to: Monitor System Activity Using Extended Events

• How to: View the Events for Registered Packages

• How to: View the Extended Events Targets for Registered Packages

Reference

CREATE EVENT SESSION (Transact-SQL)

ALTER EVENT SESSION (Transact-SQL)

DROP EVENT SESSION (Transact-SQL)

SQL Server Extended Events Dynamic Management Views

SQL Server Extended Events Catalog Views (Transact-SQL)

Related Sections

Using SQL Server Extended Events

See Also

Other Resources

SQL Server Extended Events