Programm
- Overview of Performance Monitoring & Tuning
- SQL Server Architecture
- Methodology & Life Cycle
- Tasks
- List of Top Performance Killers
- Overview of Tools & Resources
- Tracing
- Reliability & Performance Monitor
- Dynamic Management Views & Functions
- SQL Server Extended Events & Event Notifications
- Query Plans
- Continuous Data Collection
- Creating a Baseline Data Collection
- Memory
- SQL Server Memory Architecture
- Monitoring & Analyzing Memory Usage
- Factors influencing memory usage
- CPU
- SQL Server and CPU
- Monitoring & Analyzing CPU Usage
- Factors influencing CPU Usage
- IO
- SQL Server IO Architecture
- Monitoring & Analyzing IO
- Factors influencing IO
- Physical Database and Data Layout
- Locking
- Transactions
- Isolation Levels and Implications
- tempdb and Version Based Isolation
- Monitoring & Analyzing Locking
- Indexing
- Index Architecture
- Statistics
- Indexing for XML
- Using Fulltext Indexes
- Indexing for Hierarchical and Spatial Data
- Index Benefits vs. Cost
- Index Usage, Fragmentation & Maintenace
- Detecting Missing Indexes and Statistics
- Columnstore Indexes
- Query Analysis
- Query Processing Overview
- Cost Based Optimization
- Query Plans in Depth
- Identifying Expensive Queries
- Query Tuning
- Set Based vs. Procedural logic
- Query Design Analysis
- Efficient indexing (Clustered Indexes, Indexed Views, Filtered Indexes, Covering Indexes)
- Transaction & Locking Design
- Using Cursors
- Using CLR (.net)
- Denormalization
- Query hints
- Efficient Error Handling
- Using Resource Governor
- Database Engine Tuning Advisor
- New Windowing Functions
- Überblick Data Replay
Ziele
Zielgruppe
Datenbankentwickler und Administratore
Voraussetzungen
Vorkenntnisse
SSQLAG - smart SQL Server 2014/2012/2008R2: Administration und SSQLAP - smart SQL Server 2014/2012/2008R2: Abfragen und Modifizieren von Daten mittels T-SQL oder adäquate Kenntnisse