Course duration
- 4 days
Course Benefits
- Learn to describe the high level architectural overview of SQL Server and its various components.
- Learn to describe the SQL Server execution model, waits and queues.
- Learn to describe core I/O concepts, Storage Area Networks and performance testing.
- Learn to describe architectural concepts and best practices related to data files for user databases and TempDB.
- Learn to describe architectural concepts and best practices related to Concurrency, Transactions, Isolation Levels and Locking.
- Learn to describe architectural concepts of the Optimizer and how to identify and fix query plan issues.
- Learn to describe architectural concepts, troubleshooting scenarios and best practices related to Plan Cache.
- Learn to describe architectural concepts, troubleshooting strategy and usage scenarios for Extended Events.
- Learn to explain data collection strategy and techniques to analyze collected data.
- Learn to understand techniques to identify and diagnose bottlenecks to improve overall performance.
Public expert-led online training from the convenience of your home, office or anywhere with an internet connection. Guaranteed to run .
Private classes are delivered for groups at your offices or a location of your choice.
Webucator is a Microsoft Certified Partner for Learning Solutions (CPLS). This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).
Course Outline
- 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
- Lab: Testing Storage Performance
- 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
Class Materials
Each student will receive a comprehensive set of materials, including course notes and all the class examples.
Experience in the following is required for this SQL Server class:
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of database administration and maintenance.
- Working knowledge of Transact-SQL.
Instructor-led courses are offered via a live Web connection, at client sites throughout Europe, and at our Geneva Training Center.