ssss

Module 1: The 'Basics'

Single Threaded Optimisation
Workload Classification
Join algorithms (re)visited
Query pattern and expected behaviours
The Batch Engine

Module 2: CPU Considerations

CPU Architecture and the Cache Out Curve
Large page support, how it works
Hyper-threading, how it works and when to use it
Lervarging The CPU Cache with Batch Mode "Sorted Hash" Aggregate
Measuring CPU time and basic Xperf skills

Module 3: Walking The Database Engine Call Stack

Understanding How The Database Engine Is 'Layered'
Stack walking and symbol resolution
Classifying time outside the database (.NET and other code)
Digging into strange wait types

Module 4: Getting Networking Right

Network Driver Considerations
Packet Size Considerations
Understanding ASYNCH_NETWORK_IO
Affinitizing CPU cores to NICs
Diagnosing Network issues with Xperf

Module 5: Getting IO Right

Understanding The SQL Server/Windows IO Stack
Diagnosing IO Issues With Windows Performance Tool Kit
SAN architecture
Introduction to Flash
Flash and conventional DBA wisdom
	- IO sizes and read aheads
        - Scalable keys
        - Compression (both conventional and column store)
        - Database file and log seggregation

Module 6: Transaction Logging

Allocations and transaction log file optimisation
The basics
SAN architectures and latency
Optimizing access to LOGCACHE_ACCESS spinlock
The LOGCACHE_ACCESS and NUMA
Deferred logging
Investigating log write performance using WPT

Module 7: Multi Threading

Multi threaded Optimisation
Thread Bottlenecks and shared context
Allocations and transaction log file optimisation
Spinlocks and classification
Optimizing Access to the LOGCACHE_ACCESS spinlock
What is CXPACKET? When should you worry?
Avoiding shared context in SQL Server

Module 8: Advanced Xperf Configuration

Advanced Xperf Configuration
Bad Drivers: Troubleshooting DPC/ISR issues
Diagnosing hard problems, error 833
Affinity masks and cache coherency
NUMA optimisations