How to Be a Ninja - Troubleshooting SQL Performance

Dive into advanced SQL performance troubleshooting techniques in this comprehensive 59-minute conference talk from PASS Data Community Summit. Learn how to become a "ninja" at diagnosing and resolving SQL performance issues, covering topics such as capital expenditure vs operational expenditure, storage tips, best practices, and backup strategies. Explore crucial concepts like instant file initialization and block pages in memory, while gaining insights into cheat sheets and practical results. Perfect for data professionals seeking to enhance their SQL troubleshooting skills and optimize database performance.

Introduction
Questions
Sponsors
Passim
Data Professional
Agenda
Capital Expenditure vs Operational Expenditure
Cheat Sheet
Storage Tips
Best Practices
Results
Backups
Instant File initialization
Block pages in memory
Summary