Performance Tuning and Optimizing SQL Databases

Unlock the full potential of your SQL Server databases with our Performance Tuning and Optimizing course, designed for database administrators and developers aiming to enhance execution performance and efficiency.

Course Thumbnail

Essential Skills Gained

Checkmark

Design efficient database architectures and component usage.

Checkmark

Implement performance enhancements using SQL Server scheduling and execution models.

Checkmark

Understand and diagnose SQL Server I/O, memory, and storage structures.

Checkmark

Troubleshoot and optimize query performance and concurrency issues.

Format

  • Instructor-led
  • 4 days with lectures and hands-on labs.

Audience

  • SQL Server Database Administrators
  • SQL Server Developers
  • Database Performance Tuners
  • Application Developers using SQL Server

Description

This four-day instructor-led course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases.  

Calendar icon

Upcoming Course Dates

No upcoming dates. Please check back later.

Course Outline

Download PDF

Module 1: SQL Server Architecture, Scheduling, and Waits

  1. SQL Server Components and SQL OS

  2. Windows Scheduling vs SQL Scheduling

  3. Waits and Queues

Module 2: SQL Server I/O

  1. Core Concepts

  2. Storage Solutions

  3. I/O Setup and Testing

Module 3: Database Structures

  1. Database Structure Internals

  2. Data File Internals

  3. TempDB Internals

Module 4: SQL Server Memory

  1. Windows Memory

  2. SQL Server Memory

  3. In-Memory OLTP

Module 5: Concurrency and Transactions

  1. Concurrency and Transactions

  2. Locking Internals

Module 6: Statistics and Index Internals

  1. Statistics Internals and Cardinality Estimation

  2. Index Internals

  3. Columnstore Indexes

Module 7: Query Execution and Query Plan Analysis

  1. Query execution and optimizer internals

  2. Analyzing query plans

Module 8: Plan Caching and Recompilation

  1. Plan cache internals

  2. Troubleshooting plan cache issues

  3. Query store

Module 9: Extended Events

  1. Extended events core concepts

  2. Implementing extended events

Module 10: Monitoring, Tracing, and Baselining

  1. Monitoring and tracing

  2. Baselining and benchmarking

Module 11: Troubleshooting Common Performance Issues

  1. Troubleshoot CPU performance

  2. Troubleshoot memory performance

  3. Troubleshoot I/O performance

  4. Troubleshoot Concurrency performance

  5. Troubleshoot TempDB performance

Your Team has Unique Training Needs.

Your team deserves training as unique as they are.

Let us tailor the course to your needs at no extra cost.