The most illustrative case for using EXTENDED EVENTS?

• VoldemarG

  Hall of Fame

  Points: 3883

  More actions

  April 26, 2021 at 4:31 pm

  #3875932

  What would be a couple of things that I can do with Extended Events that I cannot do via Profiler Traces, DMVs, and/or QueryStore?  (Leaving aside the  lower XE's overhead/performance issues compared to svr side traces...).

  ANDOR a rephrased question: what kind of analysis/things to troubleshoot can I do with XE that I cannot do via any other  easily available means?

  Likes to play Chess

• ScottPletcher

  SSC Guru

  Points: 100942

  More actions

  April 26, 2021 at 9:46 pm

  #3876081

  Deadlocks would be one of the main ones, I would think.

  SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.