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