Test SQL Server Backup Performance For Free

Veröffentlicht am: 31 März 2026
auf dem Kanal: Erik Darling (Erik Darling Data)

621

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

Auf dieser Seite können Sie das Online-Video Test SQL Server Backup Performance For Free mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Erik Darling (Erik Darling Data) 31 März 2026 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 621 Mal angesehen und es wurde von 32 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!

262