> > > 10987

Performance Tuning and Optimizing SQL Databases (10987)

 

Course Overview

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.

This course replaces !MS-55144.

Who should attend

The primary audience for this course is 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.

The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server 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.

Course Objectives

After completing this course, students will be able to:

  • Describe the high level architectural overview of SQL Server and its various components.
  • Describe the SQL Server execution model, waits and queues.
  • Describe core I/O concepts, Storage Area Networks and performance testing.
  • Describe architectural concepts and best practices related to data files for user databases and TempDB.
  • Describe architectural concepts and best practices related to Concurrency, Transactions, Isolation Levels and Locking.
  • Describe architectural concepts of the Optimizer and how to identify and fix query plan issues.
  • Describe architectural concepts, troubleshooting scenarios and best practices related to Plan Cache.
  • Describe architectural concepts, troubleshooting strategy and usage scenarios for Extended Events.
  • Explain data collection strategy and techniques to analyze collected data.
  • Understand techniques to identify and diagnose bottlenecks to improve overall performance.
Classroom Training

Duration 4 days

Price (excl. VAT)
  • Panama: US$ 850
  • Argentina: US$ 850
  • Brazil: US$ 850
  • Chile: US$ 850
  • Colombia: US$ 850
  • Costa Rica: US$ 850
  • Mexico: US$ 850
  • Peru: US$ 850
  • SA Voucher: 4
    hardcoded default SA
Online Training

Duration 4 days

Price (excl. VAT)
  • Panama: US$ 850
  • Argentina: US$ 850
  • Brazil: US$ 850
  • Chile: US$ 850
  • Colombia: US$ 850
  • Costa Rica: US$ 850
  • Mexico: US$ 850
  • Peru: US$ 850
  • SA Voucher: 4
    hardcoded default SA
E-Learning MOC on Demand

Duration 90 days

Price (excl. VAT)
  • Panama: US$ 350
  • Costa Rica: US$ 350
Buy E-Learning
 
Click City Name To Book Schedule
This green checkmark in the Upcoming Schedule below indicates that this session is Guaranteed to Run.
This is an Instructor-Led Online (ILO) course. These sessions are conducted via WebEx in a VoIP environment and require an Internet Connection and headset with microphone connected to your computer or laptop.
This is a FLEX course, which is delivered simultaneously in two modalities. Choose to attend the Instructor-Led Online (ILO) virtual session or Instructor-Led Classroom (ILT) session.
Latin America

Fast Lane Flex™ Classroom If you can't find a suitable date, don't forget to check our world-wide FLEX™ training schedule.

Europe
Germany
Mar 30, 2020 ― Apr 2, 2020 Guaranteed to Run Online Training Time zone: Europe/Berlin Course language: German Enroll
Jun 29, 2020 ― Jul 2, 2020 Online Training Time zone: Europe/Berlin Course language: German Enroll
France
Apr 14, 2020 ― Apr 17, 2020 Online Training Time zone: Europe/Paris Course language: French * Enroll
Italy
Apr 6, 2020 ― Apr 9, 2020 Guaranteed to Run Online Training Time zone: Europe/Rome Course language: Italian Enroll
Jul 6, 2020 ― Jul 9, 2020 Rome Enroll
Switzerland
Jun 29, 2020 ― Jul 2, 2020 Online Training Time zone: Europe/Zurich Course language: German Enroll
United Kingdom
Mar 30, 2020 ― Apr 2, 2020 This is a FLEX event Manchester * Enroll
Online Training Time zone: Europe/London Enroll
Apr 14, 2020 ― Apr 17, 2020 This is a FLEX event Manchester * Enroll
Online Training Time zone: Europe/London Enroll
May 4, 2020 ― May 7, 2020 Leeds * Enroll
Jun 15, 2020 ― Jun 18, 2020 This is a FLEX event London (Int Hse) * Enroll
Online Training Time zone: Europe/London Enroll
Jul 13, 2020 ― Jul 16, 2020 Leeds * Enroll
North America
United States
Apr 13, 2020 ― Apr 16, 2020 Guaranteed to Run Online Training 08:30 US/Central Course language: English * Enroll
Apr 20, 2020 ― Apr 23, 2020 This is a FLEX event Live Online Training 06:00 US/Pacific * Enroll
Online Training Time zone: US/Pacific Enroll
Apr 27, 2020 ― May 1, 2020 Online Training 09:00 US/Central 5 days Course language: English * Enroll
Middle East
United Arab Emirates
Aug 23, 2020 ― Aug 26, 2020 Dubai Course language: English This course is being delivered by iTLS. Enroll
Africa
Egypt
Jul 5, 2020 ― Jul 8, 2020 Cairo Course language: English Enroll