YoVDO

A Beginner's Guide to Becoming a Performance Tuner

Offered By: PASS Data Community Summit via YouTube

Tags

PASS Data Community Summit Courses Database Administration Courses Performance Tuning Courses Server Configuration Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Discover essential performance tuning techniques for SQL Server in this comprehensive conference talk from PASS Data Community Summit. Explore common worst practices that hinder SQL Server performance, covering both administrative and T-SQL development aspects. Gain insights into server configuration mistakes, T-SQL parallelism, and TempDB challenges through numerous demonstrations. Learn valuable tools and knowledge to kickstart your journey as a performance tuning specialist, whether you're a DBA or developer. Delve into topics such as power management, default settings, AutoGrowth, Cost Threshold for Parallelism, query optimization, procedural vs. declarative programming, key lookups, indexing strategies, and TempDB spills. Equip yourself with practical skills to identify and resolve hidden performance killers in SQL Server environments.

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

Related Courses

The Docker for DevOps course: From development to production
Udemy
Microsoft Exchange Server 2016 - 3: Mailbox Databases
Microsoft via edX
System Administration and IT Infrastructure Services
Google via Coursera
Administração de Sistemas e Serviços de Infraestrutura de TI
Cresça com o Google via Coursera
AWS: Publish a NodeJS Website from Scratch
Coursera Project Network via Coursera