Главная
Study mode:
on
1
Introduction
2
Questions
3
Sponsors
4
Passim
5
Data Professional
6
Agenda
7
Capital Expenditure vs Operational Expenditure
8
Cheat Sheet
9
Storage Tips
10
Best Practices
11
Results
12
Backups
13
Instant File initialization
14
Block pages in memory
15
Summary
Description:
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.

How to Be a Ninja - Troubleshooting SQL Performance

PASS Data Community Summit
Add to list
0:00 / 0:00