Performance Tuning and Optimizing SQL Databases (SQL Server 2017)
Details
This course is based on the objectives of the course version 10987C.
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
- SQL Server Concurrency
- Concurrency and Transactions
- Locking Internals
- Lab : SQL Server Concurrency
- 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
- Query execution plans
- Analyzing query execution 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
- Working with extended events
- Lab : Extended events
- Monitoring, Tracing, and Baselining
- Monitoring and tracing
- Baselining and benchmarking
- Lab : Monitoring, Tracing and Baselining
Special Offer
NetCom Learning helps build innovative learning organizations in the workplace by structuring a smarter workforce, supporting learning changes, and driving learning growth. Since 1998 we have been empowering organizations to reach optimal performance results and address challenges by managing all aspects of organizational learning.
NetCom Learning is honored to be recognized as Microsoft's Worldwide Training Partner of the Year by Microsoft and as a Top 20 IT Training Company by TrainingIndustry.com for three years. We offer over 1,500 courses available to organizations around the world, encompassing all your technology and business training needs. From authorized or foundational training to specialized certifications, we empower organizations to achieve a competitive advantage. In addition, we provide customers with a choice of customized private programs, convenient scheduling options, flexible delivery formats, and continuous learning support, all tailored towards minimizing the skills gap and gaining maximum business impact for your organization. ...