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
In questa pagina del sito puoi guardare il video online Test SQL Server Backup Performance For Free della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Erik Darling (Erik Darling Data) 31 marzo 2026, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 621 volte e gli è piaciuto 32 spettatori. Buona visione!
