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.
Overview
Syllabus
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
Taught by
PASS Data Community Summit
Related Courses
-
Azure SQL Database - Maximizing Cloud Performance and Availability
-
In Memory OLTP Memory Storage Monitoring and Troubleshooting
-
SQL Server & Intel - Unlock Better SQL Performance & Scalability
-
Getting the Most Out of the SQL Server Maintenance Solution
-
Improving Analytics Performance With Columnstore Indexes
