MOC 10987
Performance Tuning and Optimizing SQL Databases

da
600.00 €

4 giornate

COD: N/A Categoria:

Descrizione

Questo corso si rivolge a professionisti che si occupano di gestire e manutenere database SQL Server ed ha lo’obiettivo di trasmettere le conoscenze e le competenze adeguate ad affrontare problematiche di ottimizzazione e di tuning delle performance.

Contenuti del corso

SQL Server Architecture, Scheduling, and Waits

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

SQL Server I/O

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

Database Structures

  • Database Structure Internals
  • Data File Internals
  • Temp DB Internals

SQL Server Memory

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

Concurrency and Transactions

  • Concurrency and Transactions
  • Locking Internals

Statistics and Index Internals

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

Query Execution and Query Plan Analysis

  • Query execution and optimizer internals
  • Analyzing query plans

Plan Caching and Recompilation

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

Extended Events

  • Extended events core concepts
  • Implementing extended events

Monitoring, Tracing, and Baselining

  • Monitoring and tracing
  • Baselining and benchmarking

Troubleshooting Common Performance Issues

  • Troubleshoot CPU performance
  • Troubleshoot memory performance
  • Troubleshoot I/O performance
  • Troubleshoot Concurrency performance
  • Troubleshoot Temp DB performance

Partecipanti

Amministratori di database o sviluppatori di applicazioni basate su dabase Sql Server.

Prerequisiti

Per partecipare con profitto a questo corso è necessario che gli allievi:

  • abbiano una conoscenza approfondita dei sistemi Windows e delle loro funzionalità core;
  • abbiano esperienza lavorativa nella gestione e nella manutenzione di database SQL Server;
  • abbiano esperienza di lavoro con il linguaggio Transact-SQL.

Obiettivi

Al termine del corso gli allievi saranno in grado di:

  • 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 Temp DB.
  • 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.
Cancella