Performance Tuning and Optimizing SQL Databases

Datum
07/12/2020 - 11/12/2020
9:00 - 17:00
Kalender-Import: iCal

Veranstaltungsort
ETC Trainingcenter
Modecenterstrasse 22, 1030 - Wien




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.

Wir empfehlen den Besuch unserer smart Seminare:

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.

Vorkenntnisse:
Für dieses Seminar werden folgende Kenntnisse empfohlen:

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

Kurs Inhalte:

  1. SQL Server Architecture, Scheduling, and Waits
    1. SQL Server Components and SQL OS
    2. Windows Scheduling vs SQL Scheduling
    3. Waits and Queues
    4. Lab : SQL Server Architecture, Scheduling, and Waits
  2. SQL Server I/O
    1. Core Concepts
    2. Storage Solutions
    3. I/O Setup and Testing
  3. Database Structures
    1. Database Structure Internals
    2. Data File Internals
    3. TempDB Internals
    4. Lab : Database Structures
  4. SQL Server Memory
    1. Windows Memory
    2. SQL Server Memory
    3. In-Memory OLTP
    4. Lab : SQL Server Memory
  5. Concurrency and Transactions
    1. Concurrency and Transactions
    2. Locking Internals
    3. Lab : Concurrency and Transactions
  6. Statistics and Index Internals
    1. Statistics Internals and Cardinality Estimation
    2. Index Internals
    3. Columnstore Indexes
    4. Lab : Statistics and index Internals
  7. Query Execution and Query Plan Analysis
    1. Query execution and optimizer internals
    2. Analyzing query plans
    3. Lab : Query execution and query plan analysis
  8. Plan Caching and Recompilation
    1. Plan cache internals
    2. Troubleshooting plan cache issues
    3. Query store
    4. Lab : Plan caching and recompilation
  9. Extended Events
    1. Extended events core concepts
    2. Implementing extended events
    3. Lab : Extended events
  10. Monitoring, Tracing, and Baselining
    1. Monitoring and tracing
    2. Baselining and benchmarking
    3. Lab : Monitoring, Tracing and Baselining
  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
    6. Lab : Troubleshooting common performance issues

Anmeldelink: https://www.etc.at/seminare/MOC10987

Preis: 1965

Kategorien


Mehr Artikel