Backing Up a 2TB Database in 20 Seconds

This video describes building a workstation called StorageBeast that has 256GB of RAM and 27 M.2 PCIe 4.0 NVMe SSDs. The first test for this monster is running a SQL Server 2022 database backup of a 2TB database in 20 seconds!

The system uses an AMD Ryzen Threadripper PRO 5955WX processor in an ASUS Pro WS WRX80E-SE SAGE WiFi motherboard.

ASUS Pro WS WRX80E-SE SAGE WiFi motherboard (Amazon)
https://amzn.to/3B2SuMB

AMD Ryzen Threadripper PRO 5955WX processor (Amazon)
https://amzn.to/415YUWa


⏱️TIMESTAMPS⏱️
0:00 Intro
0:08 SQL Server 2022 Inte QAT Backup compression
0:40 Describing the StorageBeast
3:00 2TB SQL Server 2022 database with 24 data files
3:19 Four different kinds of SQL Server backup tests
6:02 Measuring memory read bandwidth and sequential storage performance
6:58 Solidigm Synergy Toolkit
8:14 CrystalDiskMark results
9:58 Running a BACKUP to NUL
12:41 Bonus Chorizo footage!
13:07 Outro

🔴 Please subscribe for more content like this


Links to Amazon are typically monetized on my channel (affiliate links) and may return a commission of sales to me from the retailer. This is unrelated to the product manufacturer.

SOCIAL
===============================
📝 - BLOG: https://glennsqlperformance.com/
🐦 - TWITTER:   / glennalanberry  
👥 - FACEBOOK:   / glenn.berry.92  
LinkedIn:   / glberry  

Host, Video: Glenn Berry