How to Be a Ninja - Troubleshooting SQL Performance
Offered By: PASS Data Community Summit via YouTube
Course Description
Overview
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.
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
Heterogeneous Parallel ProgrammingUniversity of Illinois at Urbana-Champaign via Coursera Advanced Operating Systems
Georgia Institute of Technology via Udacity 計算機程式設計 (Computer Programming)
National Taiwan University via Coursera Introduction to Operating Systems
Georgia Institute of Technology via Udacity Android Performance
Google via Udacity