Ajuste de rendimiento y optimización en SQL Server 2016

SQL Server Architecture, Scheduling, and Waits

1. SQL Server Components and SQLOS
2. Windows Scheduling vs. SQL Server Scheduling
3. Waits and Queues
4. SQL Server Architecture, Scheduling, and Waits
5. Module Review and Takeaways

SQL Server I/O Module Overview

1. Core Concepts of I/O
2. Storage Solutions
3. I/O Setup and Testing
4. Testing Storage Performance
5. Module Review and Takeaways

Database Structures

1. Database Structure Internals
2. Data File Internals
3. tempdb Internals
4. Database Structures
5. Module Review and Takeaways

SQL Server Memory

1. Windows Memory
2. SQL Server Memory
3. In-Memory OLTP
4. SQL Server Memory
5. Module Review and Takeaways

SQL Server Concurrency Module Overview

1. Concurrency and Transactions
2. Locking Internals
3. Concurrency and Transactions
4. Module Review and Takeaways

Statistics and Index Internals

1. Statistics Internals and Cardinality Estimation
2. Index Internals
3. Columnstore Indexes
4. Statistics and Index Internals
5. Module Review and Takeaways

Query Execution and Query Plan Analysis

1. Query Execution and Query Optimizer Internals
2. Query Execution Plans
3. Analyzing Query Execution Plans
4. Query Execution and Query Plan Analysis
5. Module Review and Takeaways

Plan Caching and Recompilation

1. Plan Cache Internals
2. Troubleshooting with the Plan Cache
3. Query Store
4. Plan Caching and Recompilation
5. Module Review and Takeaways

Extended Events

1. Extended Events Core Concepts
2. Working with Extended Events
3. Extended Events
4. Module Review and Takeaways

Monitoring, Tracing, and Baselines

1. Monitoring and Tracing
2. Baselining and Benchmarking
3. Monitoring, Tracing, and Baselining
4. Module Review and Takeaways