SQL Server TrackCourse 4 of 7

Microsoft SQL Server Database Performance Tuning

This comprehensive course equips database professionals with the skills needed to optimise query and system performance effectively. Covering essential topics from identifying performance bottlenecks and analysing costly queries to advanced indexing strategies and execution plan management, participants will learn how to enhance SQL Server responsiveness and efficiency. The course also delves into critical areas such as blocking and deadlock resolution, cursor cost analysis, and workload optimisation.

39 hours · 26 sessionsCAD $595Beginner to AdvancedHands-On Learning
Enrol in This Course

What you'll learn

  • Identify system performance bottlenecks and top performance killers in SQL Server
  • Analyse, design, and deploy indexes to support multiple queries within the database workload
  • Analyse and resolve bookmark lookup and statistics-related issues in execution plans
  • Understand performance tuning exceptions and tricks within the SQL Server environment
  • Analyse and resolve fragmentation, transaction blocking, and deadlocks

Prerequisites

SQL Server Database Administration or solid DBA experience.

Part of the SQL Server Track

Master Microsoft's enterprise database platform.

7 courses · approx. 20–28 weeksBeginner to Advanced
View full track

Course Modules

15 modules · instructor-led, hands-on delivery

01SQL Query Performance Tuning
02System Performance Analysis
03SQL Server Performance Analysis
04Index Analysis
05Database Engine Tuning Advisor
06Bookmark Lookup Analysis
07Database Engine Tuning Advisor
08Fragmentation Analysis
09Execution Plan Cache Analysis
10Stored Procedure Recompilation
11Query Design Analysis
12Blocking Analysis
13Deadlock Analysis
14Cursor Cost Analysis
15Database Workload Optimisation

Other courses in this track

01
Microsoft SQL Server Querying Data16 hours · 11 sessionsCAD $275
02
Microsoft SQL Server Database Development34 hours · 22 sessionsCAD $519
03
Microsoft SQL Server Database Administration28 hours · 19 sessionsCAD $427
04

Microsoft SQL Server Database Performance Tuning(current)

39 hours · 26 sessionsCAD $595
05
Microsoft SQL Server Security and Protection13 hours · 9 sessionsCAD $325

Ready to Enrol?

CAD $595 · Get in touch and we'll get you started in Microsoft SQL Server Database Performance Tuning.

Send an Enquiry