10987 Performance Tuning and Optimizing SQL Databases

sql_server_logo

10987 Performance Tuning and Optimizing SQL Databases

This 4-day instructor-led course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance and optimize their databases.
Share on facebook
Share on twitter
Share on linkedin

Overview

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

Prerequisites

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality
  • Working knowledge of database administration and maintenance
  • Working knowledge of Transact-SQL

Who Should Attend?

This course is highly recommended for individuals who administer and maintain SQL Server databases and are responsible for optimal performance of SQL Server instances that they manage. These individuals also write queries against data and need to ensure optimal execution performance of the workloads. This course is also recommended for individuals who develop applications that deliver content from SQL Server databases.

Course Outline

  • SQL Server Components and SQL OS
  • Windows Scheduling vs SQL Scheduling
  • Waits and Queues

Lab: SQL Server Architecture, Scheduling, and Waits

  • Core Concepts
  • Storage Solutions
  • I/O Setup and Testing

Lab: Testing Storage Performance

  • Database Structure Internals
  • Data File Internals
  • TempDB Internals

Lab: Database Structures

  • Windows Memory
  • SQL Server Memory
  • In-Memory OLTP

Lab: SQL Server Memory

  • Concurrency and Transactions
  • Locking Internals

Lab: SQL Server Concurrency

  • Statistics Internals and Cardinality
  • Estimation
  • Index Internals
  • Columnstore Indexes

Lab: Statistics and index Internals

  • Query execution and optimizer internals
  • Query execution plans
  • Analyzing query execution plans

Lab: Query execution and query plans

  • Plan cache internals
  • Troubleshooting plan cache issues
  • Query store

Lab: Plan caching and recompilation

  • Extended events core concepts
  • Working with extended events

Lab: Extended events

  • Monitoring and tracing
  • Baselining and benchmarking

Lab: Monitoring, Tracing and Baselining

Get Brochure and Pricing

More Like This

Get the course Brochure & Pricing

Our course consultant will contact you within 1 working day

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Stay-Home-Series-main-header-v2

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Get in touch with our consultant