There are no items in your cart. Continue shopping on our Course Directory page.
Pay now -or- pay later
Pay by credit card at checkout
-or- pay later by invoice, as always.
This official Microsoft four-day instructor-led SQL Database Performance Tuning & Optimization training course provides students who manage and maintain SQL Server databases with the knowledge and skills to know how to optimize and tune SQL database performance.
LIVE, INSTRUCTOR-LED
TRAINING AT YOUR SITE
Customize Your Team Training Experience
CONTACT USOur FlexVouchers help you lock in your training budgets without having to commit to a traditional 1 voucher = 1 course classroom-only attendance. FlexVouchers expand your purchasing power to modern blended solutions and services that are completely customizable. For details, please call 888-843-8733 or chat live.
Feb 2 - 5
9:00 AM - 4:30 PM EST
Online (AnyWare)
Mar 9 - 12
9:00 AM - 4:30 PM EST
Online (AnyWare)
May 25 - 28
9:00 AM - 4:30 PM EDT
New York / Online (AnyWare)
Sep 7 - 10
9:00 AM - 4:30 PM EDT
Herndon, VA / Online (AnyWare)
Nov 16 - 19
9:00 AM - 4:30 PM EST
New York / Online (AnyWare)
Guaranteed to Run
When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time — will run. Guaranteed.This module covers high level architectural overview of SQL Server and its various components. It dives deep into SQL Server execution model, waits and queues.
Lessons
Lab: SQL Server Architecture, Scheduling, and Waits
After completing this module, you will be able to:
This module covers core I/O concepts, Storage Area Networks and performance testing. It focuses on SQL Server I/O operations and how to test storage performance.
Lessons
Lab: Testing Storage Performance
After completing this module, you will be able to:
This module covers Database Structures, Data File and TempDB Internals. It focuses on architectural concepts and best practices related to data files for user databases and TempDB.
Lessons
Lab: Database Structures
After completing this module, you will be able to:
This module covers Windows and SQL Server Memory internals. It focuses on architectural concepts and best practices related to SQL Server Memory Configuration.
Lessons
Lab: SQL Server Memory
After completing this module, you will be able to:
This module covers Transactions and Locking Internals. It focuses on architectural concepts and best practices related to Concurrency, Transactions, Isolation Levels and Locking.
Lessons
Lab: Concurrency and Transactions
After completing this module, you will be able to:
This module covers Statistics and Index Internals. It focuses on architectural concepts and best practices related to Statistics and Indexes.
Lessons
Lab: Statistics and index Internals
After completing this module, you will be able to:
This module covers Query Execution and Query Plan Analysis. It focuses on architectural concepts of the Optimizer and how to identify and fix query plan issues.
Lessons
Lab: Query execution and query plan analysis
After completing this module, you will be able to:
This module covers Plan Caching and Recompilation. It focuses on architectural concepts, troubleshooting scenarios and best practices related to Plan Cache.
Lessons
Lab: Plan caching and recompilation
After completing this module, you will be able to:
This module covers Extended Events. It focuses on architectural concepts, troubleshooting strategy and usage scenarios for Extended Events.
Lessons
Lab: Extended events
After completing this module, you will be able to:
This module covers tools and techniques to monitor, trace and baseline SQL Server performance data. It focuses on data collection strategy and techniques to analyze collected data.
Lessons
Lab: Monitoring, Tracing and Baselining
After completing this module, you will be able to:
Database optimization in SQL Server allows for performance tune so you can fix query plan issues.
Yes! We know your busy work schedule may prevent you from getting to one of our classrooms which is why we offer convenient online training to meet your needs.
Yes! This course is eligible for Microsoft Software Assurance Training Voucher (SATV) redemption.
Your Training Comes with a 100% Satisfaction Guarantee!*
*Partner-delivered courses may have different terms that apply. Ask for details.