SQL Server Performance Tuning training course

Maximize performance & minimize downtime of your SQL Server database

JBI training course London UK

"Our tailored course provided a well rounded introduction and also covered some intermediate level topics that we needed to know. Clive gave us some best practice ideas and tips to take away. Fast paced but the instructor never lost any of the delegates"

Brian Leek, Data Analyst, May 2022

Public Courses

17/08/26 - 2 days
£1195 +VAT
Enrol 
28/09/26 - 2 days
£1195 +VAT
Enrol 
09/11/26 - 2 days
£1195 +VAT
Enrol 

Customised Courses

* Train a team
* Tailor content
* Flex dates
From £1200 / day
EDF logo Capita logo Sky logo NHS logo RBS logo BBC logo CISCO logo
JBI training course London UK
  • A theoretical overview to potential performance problems.
  • A hands-on guide to the diagnostic tools available within the core product to identify specific performance-related problems.
  • A thorough grounding in the transact-SQL commands that help you analyse the status of tables and optimiser behaviour.
  • Solid advice on tips and techniques to overcome these problems, keep them at bay and stop them happening in the first place

 

Course Details

Database Performance – What’s ‘Good’ and why?

Relational Database Overview
The Query optimiser, compilation and caching. 
Locking and Logging and how updates happen.
How backups work, how DTS packages work.

Optimal Data Storage

Using File groups to Position Objects 
The affect of normalisation and de-normalisation.
Analysis Services – a reporting solution in waiting?

Diagnostic Tools

Task Manager & Performance Monitor – General counters to look out for, tips and techniques. 
Current Activity Window & SQL Profiler – Zooming in on problem queries
Query Analyser – Decrypting the showplan and trace output. Other set commands.
Transact SQL diagnostic commands. Various DBCC commands, some undocumented.

Index Optimisation

Index selection – How the optimiser decides.
Statistics – Auto and Manual.
Clustered versus Non-Clustered – Pros and Cons
The Fillfactor factor
Index optimiser hints
Index Covering
Index tuning wizard, when to use it.
Index Maintenance. Dangers and pitfalls.
Table defrag with clustered indexes. When and when not to do it.
Indexed Views – Advanced index builds.

Locking Optimisation

The City Analogy & Keeping the traffic flowing
Transaction isolation levels and locking hints
Deadlock resolution
Table restructuring & de-normalisation, replication and data warehousing solutions

Efficient Programming in TSQL

SARGS and the WHERE clause.
Covered indexes from the other side.
Stored procedures: Problems solved and created
Trigger problems and solutions
Cursors and Temporary tables
Tips and tricks.

Efficient Client Programming

Most of this course focuses on the server side application. However there is also a number of potential problems that may occur from the client side too. This section makes no assumption on which client you will be using, except that it will use ActiveX Data objects.

Default recordset options.
Send SQL versus Stored Procedures
Efficient use of recordsets and connections.
Timeout management and giving the user the perception of better performance

JBI training course London UK
Developers and administrators familiar with SQL Server needing to know about troubleshooting techniques and tips to improve database performance.
5 star

4.8 out of 5 average

"Our tailored course provided a well rounded introduction and also covered some intermediate level topics that we needed to know. Clive gave us some best practice ideas and tips to take away. Fast paced but the instructor never lost any of the delegates"

Brian Leek, Data Analyst, May 2022



“JBI  did a great job of customizing their syllabus to suit our business  needs and also bringing our team up to speed on the current best practices. Our teams varied widely in terms of experience and  the Instructor handled this particularly well - very impressive”

Brian F, Team Lead, RBS, Data Analysis Course, 20 April 2022

 

 

JBI training course London UK

Certification


Every delegate will be entitled to a certificate of achievement on completion of the course.

If you are missing your certificate - please use the link below to apply - you can also use this link to sign up for the JBI Training newsletter to receive technology tips directly from our instructors - Analytics, AI, ML, DevOps, Web, Backend and Security.
 



More about this course

Client feedback shows that delegates on our courses will best engage when they can relate course topics to their own day-to-day practices and requirements. Where possible, we  run this course as a consultative, workshop-style event, in which discussion of relevant topics takes place in relation to the delegates' own applications and scenarios.

To facilitate this type of event, a subject matter expert leads the training, hands-on labs and discussions to ensure course topics are covered in a meaningful, relevant and timely manner. Delegates may be able to bring their own practical requirements and work to the course if the subjects and course topics are suitable.  

FAQs

JBI Training offers six courses in this group. SQL is a two-day introduction to structured query language and database design. T-SQL is a three-day course covering Transact-SQL programming for SQL Server developers. Transact-SQL Server Programming is a two-day focused programme for writing stored procedures, functions, and triggers. SQL Server Administration is a five-day comprehensive DBA course. SQL Server Performance Tuning is a two-day course for optimising SQL Server query and database performance. Microsoft Business Intelligence 2016 is a five-day course covering the full SQL Server BI stack — SSIS, SSAS, and SSRS. All are available in London, online, or as customised onsite programmes.
T-SQL (Transact-SQL) is Microsoft's proprietary extension to SQL used for programming within SQL Server. It adds procedural programming capabilities to standard SQL — including variables, control flow, error handling, stored procedures, functions, triggers, and cursors — enabling developers to write complex server-side logic that runs directly within the database. JBI's three-day T-SQL course covers T-SQL syntax and programming constructs, writing and optimising queries, creating stored procedures and user-defined functions, implementing triggers, handling errors, and applying T-SQL best practices for maintainable and performant database code. It is suited to developers and database programmers working with SQL Server.
The five-day SQL Server Administration course is a comprehensive programme for DBAs responsible for deploying and managing Microsoft SQL Server environments. It covers SQL Server architecture and installation, managing databases, tables, and schemas, configuring security and user access, backup and recovery strategies, SQL Server Agent for job scheduling and automation, monitoring SQL Server health and performance using built-in tools, high availability options including Always On Availability Groups and mirroring, and patching and maintenance best practices. It is suited to SQL Server DBAs, IT administrators, and infrastructure professionals who manage SQL Server in production environments.
The two-day SQL Server Performance Tuning course covers the tools and techniques for diagnosing and resolving performance problems in SQL Server. Topics include understanding SQL Server's query execution engine and query plans, using SQL Server Profiler, Extended Events, and DMVs (Dynamic Management Views) to identify bottlenecks, optimising T-SQL queries for better execution plans, index design and maintenance strategies, statistics management, memory and I/O configuration tuning, and identifying and resolving blocking and deadlocking issues. It is suited to SQL Server DBAs, senior developers, and anyone responsible for the performance of SQL Server-based applications.
Microsoft SQL Server is the on-premises database engine that has been the foundation of Microsoft's data platform for decades. Azure SQL Database and Azure SQL Managed Instance are cloud-based services that use the same SQL Server engine, making existing SQL Server skills directly transferable to the cloud. Microsoft Fabric — Microsoft's latest unified analytics platform — includes a SQL-based data warehouse component that also uses T-SQL as its query language, meaning SQL Server and T-SQL skills remain highly relevant as organisations move toward cloud-native and Fabric-based data architectures. JBI's SQL Server training provides a strong foundation that applies across both on-premises and cloud Microsoft data environments.
Yes. All SQL Server courses can be delivered as customised onsite or online programmes for corporate database, development, and IT teams. Content can be tailored to the organisation's SQL Server version, specific administration challenges, application environment, and learning objectives. For example, a development team can receive integrated SQL and T-SQL training using their own schema and queries as the basis for exercises, while a DBA team can receive administration and performance tuning training focused on their specific SQL Server environment and operational challenges. JBI has delivered SQL Server training for teams at organisations including the BBC, NHS, RBS, Sky, EDF, and Cisco.

CONTACT
+44 (0)20 8446 7555

[email protected]

 

Copyright © 2026 JBI Training. All Rights Reserved.
JB International Training Ltd  -  Company Registration Number: 08458005
Registered Address: Wohl Enterprise Hub, 2B Redbourne Avenue, London, N3 2BS

Modern Slavery Statement & Corporate Policies | Terms & Conditions | Contact Us

POPULAR

AI training courses                                                                        CoPilot training course

Threat modelling training course   Python for data analysts training course

Power BI training course                                   Machine Learning training course

Spring Boot Microservices training course              Terraform training course

Data Storytelling training course                                               C++ training course

Power Automate training course                               Clean Code training course