01 Overview of SQL Server
SQL Server ComponentsComponentsServicesFile LocationsSQL Server ArchitectureRelational EngineStorage EngineSQL OSAnatomy of a monitoring solution
02 SQL Server Performance Tuning Tools SQL Server Reporting and DMV
SQL Trace and ProfilerSystem MonitorExtended EventsRML and PAL Utilities
03 Tuning and Handling CPU issues CPU Architecture and Configurations
SchedulingHyper-Threading and Multi-CoreNUMAParallelismTroubleshooting and TuningResource Governor
04 Troubleshooting and Tuning SQL Server Memory Basic Memory Architecture
SQL Server Memory ConfigurationMemory Monitoring
05 SQL Server IO Physical Database Layout
Files and FilegroupsStorage InternalsTransaction Log and RecoveryBest PracticeData CompressionPartitioned TablesMonitoring IO
06 Query Optimization Statistics
OptimizationRecompilesObject Types and Procedure CacheAnalyzing distributionAd Hoc Queries and Paramterization
07 Execution Plans Execution Plan Basics
Analyzing Query PlansBitmap Filters in SQL Server 2008Plan Guides and Hints
08 SQL Server Indexes Indexing Basics
Index TypesData Access MethodsFiltered IndexesIndexed ViewsIndexes on Computed ColumnsIndex FragmentationIndexing for Performance
09 SQL Server Concurrency Locking
Deadlocks and BlockingTransaction ManagementSnapshot Isolation and Row VersioningLocking Hints
10 Implementing a Monitoring Solution Building a custom solution
Third Party ToolsSQL Server Data Collection
11 Data Corruption (optional in der 4-Tage Version) Backup and Restore Strategies reviewed
Database StatesEmergency ModeHow to find data corruptionRecovering from data corruptionBest Practice