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.
Continue Reading »For T-SQL Tuesday #67, Aaron Bertrand (@AaronBertrand) describes a new way to track backup and restore operations using Extended Events in SQL Server 2016.
Continue Reading »Aaron Bertrand (@AaronBertrand) takes a quick look at a couple of things you should be careful about when calling natively-compiled Hekaton stored procedures in SQL Server 2014.
Continue Reading »Jonathan Kehayias (@SQLPoolBoy) of SQLskills discusses predicates in Extended Events, and demonstrates why you need to list state-related predicates last.
Continue Reading »Aaron Bertrand (@AaronBertrand) of SQL Sentry takes a closer look at the overhead of using Extended Events to track the creation of #temp tables.
Continue Reading »SQL Sentry's Aaron Bertrand (@AaronBertrand) shows how you can use Extended Events to track temp table creation and identify which session created which #temp table.
Continue Reading »Erin Stellato (@erinstellato) of SQLskills walks through three methods of tracking automatic statistics updates: SQL Trace, Extended Events, and dynamic management objects.
Continue Reading »