June 2021
Intermediate
1h 7m
English
on-demand course
Optimizing SQL Server Backup Performance: Using Data Science Techniques to Solve a Classic DBA Dilemma
with Kevin Feasel
Closed Captioning available in English
Overview
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.
What You Will Learn
- Know the key settings that control SQL Server backup performance
- Create database backup statements using these key settings
- Use sampling within PowerShell to test performance of different settings
- Create models using algorithms such as random forest for statistical learning
- Analyze the results of these models using evolutionary programming techniques
- Implement the results using free, community-based backup solutions
Who This Video Is For
Database administrators who wish to minimize the size of their backup windows and those wanting to get their backups done in the least-possible time. Viewers should be familiar with SQL Server and the T-SQL language. The video will also include PowerShell and R, so familiarity with either of these languages is nice but not required.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Watch now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.