Courses » Database Courses » SQL Server Tuning Online Training

 

SQL Server Tuning Online Training

 

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