Extended Events

SQL Server Extended Events

SQL Server Extended Events were introduced with SQL Server 2008 as a light weight way to create customized monitoring of SQL Server.

Many people view SQL Server Extended Events as a replacement for Profiler/Server Side Trace. Extended Events are a lot more than that. Extended Events provide a set of methods for collecting different events from SQL Server and correlating those different events within a single tool. It’s possible to grab:

  • Deadlocks + waits
  • Waits + lock graph
  • TempDB spill + query plan

For additional information about Extended Events, check out the following blog posts.

1 Comment. Leave new

Menu
{"cart_token":"","hash":"","cart_data":""}