Problem

You can rely on SQL Server and Windows Server to choose the right backup configuration, or alternatively, you can do it yourself.

Solution

Calculate custom backup configuration values based on a full copy-only backup of the MSDB database to make backup runs faster

MAXTRANSFER is calculated based on the run time of a full copy-only backup of the MSDB database

BackupBufferCount is calculated based on available RAM

BackupBlockSize is hardcoded to 65536

https://github.com/steverezhener/DBA/blob/master/Procedures/bestpractices.usp_find_server_optimal_backup_configs.sql

https://github.com/steverezhener/DBA/blob/master/Procedures/bestpractices.usp_optimize_server_database_backups.sql

Example:

Disclaimer