SentryOne Team Blog (blogs.sentryone.com)

Category: Extended Events

Erin Stellato : Using Track Causality to Understand Query Execution

Erin Stellato : Using Track Causality to Understand Query Execution

Erin Stellato shows us how to use the Track Causality session option for more reliable performance troubleshooting with Extended Events.

The difference a day makes : SSMS 2016, Azure, and Extended Events

Aaron Bertrand (@AaronBertrand) shows why and how you should upgrade your SSMS 2016 client from 13.0.11000.48 to 13.0.11000.78.

Erin Stellato : Capture Execution Plan Warnings using Extended Events

Erin Stellato (@erinstellato) of SQLskills shows how to use Extended Events to monitor for query plans with certain characteristics, such as joins missing predicates, columns missing statistics, and unmatched filtered indexes.

Aaron Bertrand : T-SQL Tuesday #67 : New Backup and Restore Extended Events

Aaron Bertrand (@AaronBertrand) describes a new way to track backup and restore operations using Extended Events in SQL Server 2016.

Jonathan Kehayias : Predicate Order Matters in Extended Events

Jonathan Kehayias (@SQLPoolBoy) of SQLskills discusses predicates in Extended Events, and demonstrates why you need to list state-related predicates last.