SQL Server 2016 for Performance Tuning Lovers
Last week I presented my session, SQL Server 2016 for Performance Tuning Lovers at the GroupBy conference. That was tons of fun and actually felt more like a bunch of guys hanging out and drinking a beer than a training event.
I talked about live SQL Server 2016 gems like Live Query Statistics and how to enable lightweight profiling, the new sys.dm_exec_session_wait_stats, execution plan comparison, and more. The recording is already up and you can watch it below. The scripts can be downloaded from here.