SQL Server Performance & Tuning Course
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