SQL Server Admin Best Practices with DMVs at GroupBy Americas 2021

On Tuesday I'm looking forward to presenting again at GroupBy Americas on a topic that was voted on by the attending public. This presentation "SQL Server Admin Best Practices with DMVs" is a talk that I've been giving for more than a decade and been tweaking and tuning ever since. 

This talk covers basic roll-your-own maintenance strategies using data inside SQL Server including wait stats, query stats and the Query Store, fragmentation and index maint, index DMVs for new/existing indexes, and a ton more helpful DMVs introduced in SQL 2017 and 2019. 

You can register for this talk here: groupby.org.

You can download my presentation here, and the toolbox of sample scripts referenced throughout can be found in here.

#GroupBy Americas: #DBA Track starts soon!
Here's our lineup of speakers:@gfritchey@hellosqlkitty@solarwinds with @SQLBek and Devon Wilson@PureStorage with @DBArgenis@Aschenbrenner@william_a_dba@Dallas_DBAs with Jeff Moden@dbanuggets

Register: https://t.co/1ss3ldVAwQ pic.twitter.com/3LjrMDzDye

— GroupBy (@GroupByConf) May 25, 2021