NEED HELP? TALK TO AN EXPERT (904) 638-5743

SQL Server Performance Tuning

Part Of The On-Demand Courses

WHAT YOU'LL LEARN

  • SQL Server Index Tuning and Query Tuning best practices
  • To use tools such as Profiler, Extended Events and SQLIO
  • To create a plan that will assist the DBA to monitor servers, alert on issues and resolve slowdowns

 

This course includes:
  • Course Description
  • Outline
  • Instructor
  • System Requirements
  • What to Know Before Class

Course Description

SQL Server performance is as much an art form as it is a science. Often, a server will give conflicting information about the state that it is in. The SQL Server Performance Tuning course is designed to provide SQL DBAs with the tools and knowledge that is required to keep their SQL Servers running efficiently and reliably. Additionally, you will experience how to perform advanced performance tuning and optimization in your everyday DBA work.

 

Click here for a downloadable PDF

 

Outline

 

Module 01 | Class Introduction
10m 18s total

 

Module 01A | Class Introduction
10m 18s

 

Module 02 | Understanding Queries in SQL Server
75m 26s total

 

Module 02A | Query Basics
18m 35s

 

Module 02B | Relational Engine Query Process
35m 31s

 

Module 02C | Parallelism
21m 20s

 

Module 03 | Index Tuning
64m 12s total

 

Module 03A | Basic Tuning
38m 42s

 

Module 03B | Columnstore Indexes and Maintenance
34m 56s

 

Module 04 | Locking, Blocking, Deadlocks and Latches
29m 18s total

 

Module 04A | Locking, Blocking, Deadlocks and Latches
29m 18s

 

Module 05 | Waits and Queues Methodology
20m 42s total

 

Module 05A | Waits and Queues Methodology
20m 42s

 

Module 06 | Baselines
19m 13s total

 

Module 06A | Baselines
19m 13s

 

Module 07 | Monitoring & Alerting
12m 15s total

 

Module 07A | Monitoring & Alerting
12m 15s

 

Module 08 | Extended Events
37m 04s total

 

Module 08A | Extended Events
37m 04s

Instructor

MITCHELL PEARSON

Pragmatic Works Trainer
Mitchell Pearson has been with Pragmatic Works for 8 years as a Data Platform Consultant and the Training Content manager. Mitchell has authored books on SQL Server, Power BI and the Power Platform. Data Platform experience includes designing and implementing enterprise level Business Intelligence solutions with the Microsoft SQL Server stack (T-SQL, SSIS, SSAS, SSRS), the Power Platform and Microsoft Azure.

 

System Requirements

  • Microsoft Windows XP Professional, Microsoft Windows Server 2003, Microsoft Vista, Windows 7, Windows 8, or Windows 10
  • 2 GHz or faster CPU
  • 2 GB of available RAM (recommended 4 GB)
  • 20 GB of free hard drive space
  • SQL Server Developer, Standard or Enterprise Edition 2008/2008R2/2012/2014
    • SQL Server Database Engine
    • SQL Server Management Studio
  • AdventureWorks2012 or AdventureWorks2014 databases installed on the instance
  • AdventureWorksDW2012 or AdventureWorksDW2014 databases installed on the instance

What to Know Before Class

The course assumes attendees have a strong understanding of SQL Server fundamentals. For example, knowing and using the SQL Server Management Studio (SSMS) interface and associated toolbox items before attending this class.

REVIEWS

Overall, I enjoyed the class and learned information I can apply to my job.

Anonymous

I was so impressed with the energy and enthusiasm of Manuel Quintana, it motivated me to learn more about ADF. Easy to follow examples, at the same time very practical and relevant to day-to-day use.

Jayasurya P.

I like the way the featured demos incorporated integration, logging patterns, and end-to-end examples, so several things were covered at once.

Anonymous

Start your 7 day free trial

Pragmatic Works On-Demand Learning Platform gives you access to 60+ courses such as Power BI, Azure, SQL Server, Data Science, Business Intelligence Power Apps and more.

Instant Download | No Credit Card Required