Skip to main content Skip to Ask Learn chat experience

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Download Microsoft Edge More info about Internet Explorer and Microsoft Edge
Read in English

Note

Access to this page requires authorization. You can try signing in or changing directories.

Access to this page requires authorization. You can try changing directories.

In this article

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


Additional resources


  • Last updated on 2012-10-04

In this article

en-us
Your Privacy Choices
  • AI Disclaimer
  • Previous Versions
  • Blog
  • Contribute
  • Privacy
  • Consumer Health Privacy
  • Terms of Use
  • Trademarks
  • © Microsoft 2026