SQL Server Performance Tuning Training Course

SQL Server Performance Tuning Training Course

Learn how to investigate SQL Server performance issues on this SQL Server Performance Tuning Training Course, starting from a high level and drilling down into potential performance culprits. This is based on years of real-world tuning databases in the Enterprise.

Learning Outcomes 

A methodical and repeatable approach to tuning SQL Server configuration and queries.

Course Requirements

Developers and DBAs

Course Length

3-days

SQL Server Performance Tuning Training Course Agenda

SQL Server Architecture Overview
  • Client Server Applications
  • 90% Application/10% Hardware or vice-versa?
  • SQL Server Installation
  • SQL Server Upgrading
Disk IO & Benchmarking – What are we looking for?
  • Fragmentation, external and internal
  • Throughput
  • Batch Requests/Second
Windows & SQL Server Configuration
  • Windows Settings
  • Windows & SQL Server Memory
  • Parallelism
  • Optimize for Ad-Hoc Queries
  • Forced Parameterization
System Database Optimisation – why it’s important
  • TempDB Optimisation
  • UserDB Optimisation
Database Files – there can only be one?
  • Er, no, that’s wrong and here’s why
  • File placement
  • Interesting Database Properties
Indexes & Statistics plus Maintenance
  • Indexes are critical for performance
  • Indexing in Depth
  • Statistics are also critical for performance
  • Keeping these up-to-date with minimum impact using Scripts and Maintenance Plans
  • Rebuild & Reorging Tables
  • Clustered, Non-clustered Indexes and Heaps
Native Monitoring Tools
  • What are we looking to measure and why?
  • Task Manager/Resource Manager/Performance Monitor & Counters
  • Activity Monitor, the good and the bad
  • SQL Server Profiler & Extended Events
  • Query Store & Live Query Statistics
  • DMVs – what is going on?
(Dead)-Locking & Blocking
  • Locking Optimisation
  • Transactions
  • Isolation levels
  • Row-Versioning
  • Locking Hints
  • Blocking
  • Deadlocking
New Features of SQL Server
  • SQL 2016 SP1 is Amazing!
  • Compression
  • Columnstore Indexes
  • in-Memory OLTP Tables
  • Adaptive Query Processing
  • Automatic Database Tuning
  • In-Memory improvements in SQL Server 2017
Logical Query Processing
  • Logical Query Processing and how it can help
  • The real Order By
  • B-Trees
Queries & Application Performance Issues
  • Is it the database or is it the app?
  • UDFs & Windowing Functions, Grouping and Offset
  • Understanding Query Plans

Please note you can add any New Features of SQL Server to compliment this training. You can add or take away any module.

Course Price

This course costs £1500 excluding VAT

How to Book

Call us or email us on the form below, any questions, ask us!

Comments

“we’d thought we’d learn only 1 or 2 new things, but we’ve learned a lot” – Emma

 

You Might Also Like…

New Features of SQL Course
Advanced TSQL Course
Advanced SQL DBA Course
SSRS Training Course
Power BI Training Course

 

4 + 5 =

Summary
SQL Server Performance Tuning Training Course
Service Type
SQL Server Performance Tuning Training Course
Provider Name
Sequallity Ltd,
80-83 Long Lane,London,EC1A 9ET,
Telephone No.020 3507 1989
Area
UK
Description
Learn how to investigate SQL Server performance issues on this SQL Server Performance Tuning Training Course, starting from a high level and drilling down into potential performance culprits. This is based on years of real-world tuning databases in the Enterprise.