Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

A Beginner's Guide to Becoming a Performance Tuner

PASS Data Community Summit via YouTube

Start learning Write review
Coursera Ad

Learn AI, Data Science & Business — Earn Certificates That Get You Hired

Learn More → DataCamp Ad

Power BI Fundamentals - Create visualizations and dashboards from scratch

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This session surveys administrative and T-SQL practices that can hurt SQL Server performance. It uses demonstrations to explore server configuration, parallelism, large queries, key lookups, and TempDB issues.

Syllabus

Intro
PASS Summit 2020 Goes Virtual Be there. Wherever you are.
Andy Yun
Wide World Out There
Today's Agenda Administrative Practices
All The Power
High Performance - Always!
Power to the Shell Learn More
Change Those Defaults
Change Me
Model After Me
AutoGrowth Recap Learn More
How Does It Work?
#3 - Cost Threshold for Parallelism Recap
Large Queries
Languages Matter
Follow The Recipe
Procedural: Follow The Directions
Declarative: Doing It My Way
#4 - Large Query Recap Learn More
Key Lookups (& Indexes)
Look It Up
Key Lookups Recap
TempDB Spills

Taught by

PASS Data Community Summit

Reviews

Start your review of A Beginner's Guide to Becoming a Performance Tuner

Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.