SQL Server Performance & Tuning Course Content

Performance & Tuning

Sizing & Planning
Monitoring Performance
Analyzing Performance Data
Tuning & Optimising Performance

SQL Server Internals

Windows & SQL Server Architecture
Process & Thread management
Memory Use & Management
I/O Management
Networking

SQL Server Architecture

Data Storage
Transaction Logging
Locking
Indexing
OLTP databases
Data Warehouses

Planning A SQL Server Database Application

Capacity Planning
Sizing Databases
Sizing Servers

System Performance & Tuning

Hardware Resource Tuning
I/O Performance
Database Layout
SQL Server Configuration Options

Monitoring Tools

Performance Monitor
SQL Profiler
DBCC

Optimal Database Design

Database Design
Table Design
Indexes
OLTP databases
Data Warehouses

Index Optimisation

Index Types
Covering Indexes
Index Strategies
Locking

Lock Types
Locking & Granularity
Blocking
Locking & Transactions
Transaction Isolation Levels
Transaction Design
Analysing Locks

Query Optimisation

Query Optimiser
Recompilation
Query Cache
Query Types
Range
Ordering
Grouping
Table joins & Join Algorithms

Analyzing Queries

Query Analyser & Execution Plans
SHOWPLAN
Graphical
Index Statistics
Index Tuning Wizard

Tuning SQL Statements

Comparing Queries
Avoiding Subqueries
Table Hints

Database Application Tuning

Using Stored Procedures & User Defined Functions
Views
Partitioning Data
Derived Data
Minimising Redundant Data With Triggers
Optimising Transactions
Optimising Cursors

Tuning SQL Server Services & Tasks

Replication Services
DTS Packages
Backup & Recovery