Getting the Most Out of the SQL Server Maintenance Solution

Getting the Most Out of the SQL Server Maintenance Solution

PASS Data Community Summit via YouTube Direct link

Intro

1 of 18

1 of 18

Intro

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Getting the Most Out of the SQL Server Maintenance Solution

Automatically move to the next video in the Classroom when playback concludes

  1. 1 Intro
  2. 2 Session Evaluation
  3. 3 Intro to the SQL Server Maintenance Soluti
  4. 4 Improving backup performance • BUFFERCOUNT and MAXTRANSFERSIZE
  5. 5 Dynamic number of backup files
  6. 6 Smart transaction log backup • Do more frequent log backups when the volume of transactions is high
  7. 7 Backup of availability groups - The basics
  8. 8 The Availability Group Backup Preference
  9. 9 Pros and cons of backups on the secondary
  10. 10 Strategies for backup of availability groups
  11. 11 Checkdb of availability groups - The basics
  12. 12 Backing up databases in parallel • Very large number of databases Backing up databases sequentially takes a very long time
  13. 13 Real-world case: Parallel backup
  14. 14 Checkdb of databases in parallel
  15. 15 Real-world case: Parallel checkdb
  16. 16 Backing up to Azure Blob Storage Legacy Azure Blob Type Page Max size per file 1 TB Max total backup size 1 TB Striping
  17. 17 Backup on SQL Server on Linux • Forward slash instead of backslash in the directory path
  18. 18 Downloads, Documentation and Issues

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.