Optimizing SQL Server Backup Performance: Using Data Science Techniques to Solve a Classic DBA Dilemma

Learn how to optimize the performance of your SQL Server backups using data science techniques. Microsoft provides default backup settings which work but which are decidedly sub-optimal against large databases. This video shows what these settings are, explains their defaults, and educates you on the available values that provide you room in which to optimize your backup times. The end game is that you’ll be able to optimize your backups and be confident that you’ve optimized to the extent that’s possible given your specific environment. 

After an introduction to the available settings, you’ll learn a method built for tuning your backup settings to provide faster backups and shorter maintenance windows in your own environment. That method includes knowing how to sample timing data and other statistics, and how to apply data science techniques by which to understand your findings and to implement your findings in two of the most popular, community-based backup tools: MinionWare's Minion Backup and Ola Hallengren's SQL Server Maintenance Solution. You’ll be able to confidently schedule maintenance windows and to defend those schedules to management using the data that this video helps you to collect.