Extended Events (XE)

Using Extended Events to troubleshoot SQL Server issues

  • Article

As a DBA, you'll encounter elusive performance, connectivity and locking problems that you'll need to troubleshoot. There are many tools that you can use such as Profiler. In addition to these tools, SQL Server 2008 offers extended events ("XEvents"), which you can use as a powerful tracing system. By default, the "system_health" extended events session is always on, and can provide you help to locate the source of trouble much faster.

2011-05-31

3,337 reads

Blogs

VMworld 2020 – Top 10 Database Sessions (Part 1)

By

Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...

Daily Coping 24 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

VMworld 2020 SQL Server session preview

By

Join me, David Klee, Microsoft Data Platform MVP and VMware vExpert, for a preview...

Read the latest Blogs

Forums

Where do I start from ?

By Corobori

Following with a user complain about SQL timeout I bumped into one issue with...

Function Code

By sizal0234

Hi, I have a fn with below code I want to understand the highlighted...

Backup size

By caz100

Hi Is it possible to have a database size showing 75 gigs and then...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers