How to be a Ninja Troubleshooting SQL performance...

on YouTube ↗59m

" summary

Clear, actionable rules: use DS3 or higher for Enterprise (DS2 for Standard), put data and logs on separate disks and prefer P30 premium disks with read cache for data and caching off for logs, use storage spaces/striping and 64 KB allocation units, enable instant file initialization (Perform volume maintenance task) — demos use PowerShell, backups to Azure blob run much faster than to data disks, and a restore without IFI takes ~10× longer.

AI-written summary · about

" chapters (15)

1. 0:00Introduction
2. 1:25Questions
3. 2:10Sponsors
4. 2:50Passim
5. 4:19Data Professional
6. 7:26Agenda
7. 11:10Capital Expenditure vs Operational Expenditure
8. 20:40Cheat Sheet
9. 22:13Storage Tips
10. 32:13Best Practices
11. 35:48Results
12. 38:43Backups
13. 43:33Instant File initialization
14. 51:43Block pages in memory
15. 52:00Summary

" related talks

• 58mTroubleshooting CPU Performance Issue for SQL DevelopersPinal Dave · Great Indian Developer Summit 2015
• 49mSQL Server on Azure VM - Configuring for Price-PerformanceDavid Pless · SQLBits 2024
• 43mPerformance Tuning, Getting the Biggest Bang for Your BuckMonica Rathbun · SQL Server Virtual Conference 2021
• 47mArchitecting for High Performance SQL Server on Virtual MachinesAnthony Nocentino · SQLBits 2019
• 54mAzure Best Practices for Lift and ShiftMichael Wall · Global Azure 2021
• 57mYour Performance Tuning Check ListMonica Rathbun · Women Data Summit 2021
• 54mYour Performance Tuning Check ListMonica Rathbun · SQLBits 2024
• 42mSQL Server on Azure VM - Configuring for price-performanceAditya Badramraju · SQLBits 2023