E-1539782

Performance Tuning and Optimizing SQL Databases • E-learning

Elérhető képzési nyelvek
  • Magyar
Képzési forma
Személyre szabott ajánlatot szeretnél?
Kollégáink készséggel állnak rendelkezésedre, hogy segítsenek a neked megfelelő megoldás kialakításában.
Ajánlatot kérek

Tematika

Module 0: Performance Tuning and Optimizing SQL Databases - Overview
  • Overview: Performance Tuning and Optimizing SQL Databases
Module 1: SQL Server Architecture, Scheduling, and Waits
  • Overview: SQL Server Architecture, Scheduling, and Waits
  • Lesson 1: SQL Server Components and SQLOS
  • Lesson 2: Windows Scheduling vs. SQL Server Scheduling
  • Lesson 3: Waits and Queues
  • Lab 1: SQL Server Architecture, Scheduling, and Waits
Module 2: SQL Server I/O
  • Overview: SQL Server I/O
  • Lesson 1: Core Concepts of I/O
  • Lesson 2: Storage Solutions
  • Lesson 3: I/O Setup and Testing
  • Lab 2: Testing Storage Performance
Module 3: Database Structures
  • Overview: Database Structures
  • Lesson 1: Database Structure Internals
  • Lesson 2: Data File Internals
  • Lesson 3: tempdb Internals
  • Lab 3: Database Structures
Module 4: SQL Server Memory
  • Overview: SQL Server Memory
  • Lesson 2: SQL Server Memory
  • Lesson 1: Windows Memory
  • Lesson 3: In-Memory OLTP
  • Lab 4: SQL Server Memory
Module 5: SQL Server Concurrency
  • Overview: SQL Server Concurrency
  • Lesson 1: Concurrency and Transactions
  • Lesson 2: Locking Internals
  • Lab 5: Concurrency and Transactions
Module 6: Statistics and Index Internals
  • Overview: Statistics and Index Internals
  • Lesson 1: Statistics Internals and Cardinality Estimation
  • Lesson 2: Index Internals
  • Lesson 3: Columnstore Indexes
  • Lab 6: Statistics and Index Internals
Module 7: Query Execution and Query Plan Analysis
  • Overview: Query Execution and Query Plan Analysis
  • Lesson 1: Query Execution and Query Optimizer Internals
  • Lesson 2: Query Execution Plans
  • Lesson 3: Analyzing Query Execution Plans
  • Lab 7: Query Execution and Query Plan Analysis
Module 8: Plan Caching and Recompilation
  • Overview: Plan Caching and Recompilation
  • Lesson 1: Plan Cache Internals
  • Lesson 2: Troubleshooting with the Plan Cache
  • Lesson 3: Query Store
  • Lab 8: Plan Caching and Recompilation
Module 9: Extended Events
  • Overview: Extended Events
  • Lesson 1: Extended Events Core Concepts
  • Lesson 2: Working with Extended Events
  • Lab 9: Extended Events
Module 10: Monitoring, Tracing, and Baselines
  • Overview: Monitoring, Tracing, and Baselines
  • Lesson 1: Monitoring and Tracing
  • Lesson 2: Baselining and Benchmarking
  • Lab 10: Monitoring, Tracing, and Baselining
Tematika (PDF)