Test SQL Server Backup Performance For Free
Summary
In this video, I delve into a stored procedure I developed to help test and optimize backup performance for SQL Server databases. I share this tool freely, as is my custom, and you can find it on my GitHub repository at code.erikdarling.com. This procedure allows you to experiment with various backup configurations, such as compression, file striping, and buffer counts, to see which settings yield the best performance. I walk through the code, explaining how it parses and cross-joins multiple parameters to generate a comprehensive set of test combinations, and how it logs and analyzes the results to provide actionable insights. Whether you're looking to fine-tune your backup strategy or simply want to understand how different settings impact performance, this stored procedure offers a powerful and flexible solution.
Chapters
*00:00:00* - Introduction
*00:00:30* - Free Stuff on GitHub
*00:01:00* - Stored Procedure Overview
*00:01:27* - Backup Performance Factors
*00:01:57* - Testing and Iterations
*00:02:12* - Stored Procedure Functionality
*00:02:34* - Parameter Parsing
*00:03:10* - Cross Join and Temp Tables
*00:03:34* - Logging and Progress
*00:04:09* - Backup Command Construction
*00:04:24* - Reporting Results
*00:04:35* - Throughput Ranking
*00:04:52* - Compression Settings Report
*00:04:57* - Impact Analysis
*00:05:11* - RAM Usage Report
*00:05:30* - Consistency Report
*00:05:59* - Example Run
*00:07:06* - Cleanup Process
*00:08:09* - Results Display
*00:08:30* - Small Database Test
*00:08:46* - Larger Database Considerations
*00:09:02* - Usage and Testing
*00:09:13* - GitHub Repository
*00:09:20* - Open Source Contribution
*00:09:32* - Script Naming
*00:09:45* - GitHub Issue Guidance
*00:10:12* - Conclusion
━━━━━━━━━━━━━━━━━━━━━━━━━━
🕵️♂️ FREE SQL SERVER MONITORING & Plan Analysis
━━━━━━━━━━━━━━━━━━━━━━━━━━
https://github.com/erikdarlingdata/Pe...
https://github.com/erikdarlingdata/Pe...
━━━━━━━━━━━━━━━━━━━━━━━━━━
📚 TRAINING & COURSES
━━━━━━━━━━━━━━━━━━━━━━━━━━
Get AI-Ready With Erik
https://training.erikdarling.com/get-...
SQL Server Performance Engineering Course
https://training.erikdarling.com/sql-...
Learn T-SQL with Erik
https://training.erikdarling.com/lear...
Everything Bundle:
https://training.erikdarling.com/?cou...
━━━━━━━━━━━━━━━━━━━━━━━━━━
🛠️ CONSULTING & SERVICES
━━━━━━━━━━━━━━━━━━━━━━━━━━
Need SQL Server performance help?
https://training.erikdarling.com/sqlc...
━━━━━━━━━━━━━━━━━━━━━━━━━━
💬 CONNECT
━━━━━━━━━━━━━━━━━━━━━━━━━━
Ask questions at Office Hours
https://erikdarling.com/officehours/
Become a channel member
/ @erikdarlingdata
Nesta página do site você pode assistir ao vídeo on-line Test SQL Server Backup Performance For Free duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Erik Darling (Erik Darling Data) 31 Março 2026, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 621 vezes e gostou 32 espectadores. Boa visualização!
