SQL Server Performance Tuning Training (Online)

By Daniel AG, Microsoft Certified Trainer

Course Description

Our SQL Server Performance Tuning and Optimization course teaches practical optimization techniques you can put into production. We ensure you understand WHY and HOW a technique works rather than just what the technique is all about.

As well as optimization techniques, this course will also help with design and architecture so you can prevent performance and scalability problems from happening. All the modules will be addressed on multiple fronts: how SQL Server works, implementation considerations and techniques, common problems, troubleshooting, and resolutions.

This course is essential for all SQL Server Developers, DBAs, Data Engineers, and Architects.

For course details and registration, please get in touch with Daniel at +1 267 718 1533 (Mobile & Whatsapp). We are based in Philadelphia, USA, and host affordable and comprehensive SQL Server/Azure/AWS/DevOps training programs for students around the globe.

Student Demographic

Course Introduction Video

Watch the SQL Server Performance Tuning course introduction

Course Information

Comprehensive SQL Server Performance Tuning Training Covering Following Topics:
Database Structures
Data File Internals and Maintenance
Transactions and Locking
Row Versioning and Isolation
Optimizing Logging and Recovery
Index Internals, Analysis, Fragmentation and Strategies
Statistics: Internals and Updates
Cardinality Estimation Issues
SQL Server I/O
SQLOS Scheduling
CPU Performance Tuning
Extended Events
Wait and Latch Statistics
Query Plan Analysis
Changes in Query Performance
Statement Execution, Stored Procedures, and the Plan Cache
SQLOS Memory Management and Memory Performance Tuning
Deadlock Analysis
Performance Issue Patterns and Baseline Analysis
Total duration of the course is 50 hours
Course Fee is $750 per student
Course schedule is Monday to Friday 9:00 PM to 11:00 PM US Eastern Time
With the Course Students Get:
Comprehensive Course Materials
Recorded Videos of Each Class
Reading Materials
Lab Exercises
Research Papers
Microsoft Certification Materials
Interview Questions
Resume Preparation
Placement Assistance
On the Job Support Assistance

Daniel's Profile - #1 Database Trainer in USA!!!

Daniel brings over 16 years of experience in SQL Server Administration (on-premises and Azure), SQL Programming, business intelligence development (SSAS, SSIS, SSRS, Azure Fabric, Data Factory), data visualization (Power BI), and performance tuning. His cross-industry background gives him a unique perspective on how data design, data architecture, data management, security, and system architecture come together to deliver robust enterprise solutions.

He currently serves as a Data Architect in the healthcare industry near Philadelphia, USA, while also training and mentoring database professionals worldwide. Over the years, he has earned a reputation as one of the most trusted trainers in SQL Server, Azure Fabric, Data Engineering, Power BI, Microsoft AI, and related technologies.

Microsoft recognizes Daniel’s expertise with the following certifications:
  • Microsoft Certified SQL Server DBA
  • Microsoft Certified Azure Solutions Architect Expert
  • Microsoft Certified Azure Data Engineer
  • Microsoft Certified Trainer (MCT)
  • MCSE in Data Management and Analytics

As a trainer, Daniel has mentored more than 3,000 students across the United States, Canada, and globally, helping professionals advance their careers in SQL Server, Azure, AWS, and AI. His teaching style blends real-world project experience with a structured, hands-on approach, making complex concepts easy to understand and immediately applicable.

Connect with Daniel at +1 267 718 1533 (Mobile & Whatsapp)

.

Daniel's Technical Blog: https://empiredatasystems.com/blogs


Daniel's Certifications

Talk to Daniel

SQL Server Performance Tuning Course Content

Module 1: Database Structures

  • Records, record structure, and optimizations
  • Pages and page structure
  • Allocation bitmaps
  • IAM chains and allocation units

Module 2: Data File Internals and Maintenance

  • Physical layout considerations
  • Allocation algorithms and optimizations
  • Instant initialization
  • Growth, shrink, and their problems
  • Data compression
  • Tempdb configuration and performance

Module 3: Transactions and Locking

  • The anatomy of a data modification
  • Locking and blocking
  • Granularity
  • Escalation
  • Duration
  • Troubleshooting locking behavior
  • Blocking situations
  • Deadlock situations

Module 4: Row Versioning and Isolation

  • Understanding isolation levels
  • Isolation in SQL Server
  • Controlling isolation levels
  • Statement-level read consistency
  • Transaction-level read consistency
  • Overhead/monitoring

Module 5: Optimizing Logging and Recovery

  • Transaction log architecture
  • Log records
  • Checkpoints and recovery
  • Transaction log operations
  • Recovery models
  • Log file provisioning and maintenance

Module 6: Index Internals and Data Access

  • Index concepts
  • Table structure
  • Index internals
  • Heaps vs. clustered indexes
  • Table usage
  • Clustering key choice and performance implications
  • Data access patterns
  • Understanding selectivity
  • Understanding the ‘tipping point’

Module 7: Index Fragmentation

  • Data access methods
  • Fragmentation and its effect on performance
  • How does fragmentation happen?
  • Optimizing indexes to remove and prevent fragmentation

Module 8: Internals and Covering

  • What methods exist for covering?
  • Nonclustered indexes
  • Using indexed views
  • Using INCLUDE
  • Using filtered indexes
  • Using filtered statistics
  • Practical index consolidation

Module 9: Statistics: Internals and Updates

  • How the Optimizer uses statistics
  • Statistics from A-to-Z
  • What they look like
  • What they are telling us
  • How to see them
  • When/how they get created
  • When/how they get updated

Module 10: Cardinality Estimation Issues

  • Problems/solutions with statistics
  • Steps in histogram
  • Filtered statistics
  • Uneven distribution
  • SQL Server 2014 cardinality estimation changes

Module 11: Indexing Strategies

  • Indexing for performance
  • Indexing for AND (highly-selective queries, index intersection, covering
  • Indexing for OR (tuning, re-writing)
  • Indexing for joins (join types, which strategies use what types of indexes, 3 phases of tuning)
  • Indexing for aggregates (hash aggregates, stream aggregates, indexed views)

Module 12: SQL Server I/O

  • Data and log reading and writing
  • Tempdb contention and space usage
  • Basic monitoring

Module 13: I/O Concepts for DBAs

  • Defining storage terminology
  • IOPS, MB/sec, Latency
  • Magnetic vs. Solid-State Drives (SSDs)
  • RAID configurations
  • Mount points
  • Partition alignment problems
  • Testing with SQLIO and IOMeter
  • Direct-attached storage
  • Traditional vs. PCI-Express drives

Module 14: I/O – Storage Area Networks for DBAs

  • SAN components
  • Multipathing
  • iSCSI vs. fiber channel (FC)
  • Shared vs. dedicated arrays
  • Cache (on the drives, SAN controller, RAID controller, and Windows)
  • Clustering
  • Appendix: snapshot backups (SAN, not SQL)

Module 15: SQLOS Scheduling and CPU Performance Tuning

  • Understanding Windows scheduling
  • Server hardware and NUMA
  • CPU scheduling under SQLOS
  • DMV monitoring
  • Troubleshooting CPU performance issues
  • Using Resource Governor to limit CPU usage

Module 16: Extended Events

  • Profiler vs. Extended Events
  • Extended Events core concepts
  • Event session basics
  • Event execution lifecycle
  • Event targets
  • Extended Events UI

Module 17: Wait and Latch Statistics

  • Thread lifecycle
  • Waits, latches, spinlocks
  • DMVs
  • Common wait types

Module 18: Query Plan Analysis

  • Why look at query plans?
  • Capturing and analyzing plans
  • Essential information in a query plan
  • Understanding common operators
  • Identifying typical plan patterns and steps for further investigation

Module 19: Changes in Query Performance

  • Using Distributed Replay to examine hardware, software, and workload changes
  • Using the Query Store to examine workload and query plan changes
  • Using plan guides and Query Store to force specific query plans
  • Using In-Memory OLTP to change query performance

Module 20: Statement Execution, Stored Procedures, and the Plan Cache

  • Understanding/analyzing plan cache
  • What’s in the plan cache?
  • Understanding/optimizing stored procedures
  • A cautionary tale about scalar functions

Module 21: Index Analysis

  • Index cleanup
  • Index health
  • Missing indexes

Module 22: SQLOS Memory Management and Memory Performance Tuning

  • SQLOS Memory Manager
  • SQLOS memory components
  • Configuration options for SQL Server
  • How to identify memory issues
  • Internal memory pressure
  • External memory pressure
  • Virtual address space issues
  • Resource semaphores
  • DBCC commands

Module 23: Deadlock Analysis

  • Review of locking in SQL Server
  • What is a deadlock
  • Collecting deadlock graphs
  • Anatomy of a deadlock
  • Reading deadlock graphs
  • Resolving deadlocks

Module 24: Performance Issue Patterns

  • Benchmark vs. baseline
  • Data collection methods and tools
  • Performance Monitor and Collector Sets
  • PAL tool (Performance Analysis of Logs)
  • SQL Trace
  • Analyzing Trace data
  • SQLDiag
  • SQLNexus

Course Statistics

16

Years of Experience

3671

Gratified Students

112

Training Batches

9634

Training Hours

Gratified Student Feedback - From Year 2000

  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Detailed training on SQL Server 2025, and trainer name is Daniel. Greatly appriciated for your time and effort.
    Aminata Diouf
    Pennsylvania, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I recently completed Daniel AG’s SQL Server DBA and T-SQL training, and it was an excellent learning experience. The course is very comprehensive and hands-on, covering both on-perm and Azure SQL and SQL programming. Daniel is patient, knowledgeable, and always willing to answer questions in detail. I would highly recommend his SQL Server training to anyone strengthen their existing SQL Server skills. Thanks Danie for your hardwork !
    ASEFA CHALA DEBEL
    Georgia, United States
  • Course: SQL Server DBA/TSQL
    Trainer: DANIEL AG
    SQL Server was well worth the money spend. Ganiel's years of experience as DBA really shows how he deliver the topics.
    AMANUEL MEBRATE
    Maryland, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    A fantastic instructor delivered a thorough and outstanding lesson in great depth. I heartily suggest it to anyone looking to get started with SQL Server and Azure.
    Md Nasir Uddin
    Texas, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Just finished Daniel's SQL Server DBA training — honestly, it was really good. Everything from basics to advanced topics like performance tuning and HA/DR was covered in a simple, easy-to-understand way. The hands-on demos and real-world examples made a big difference, and the instructor (Daniel) made sure no question was left unanswered. Definitely recommend this to anyone looking to get into SQL Server DBA or level up their skills.
    Arega K. Eniyew
    Maryland, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Comprehensive and amazing course taught in detail by a great trainer Definitely recommend to anyone who wants to hit the ground running on sql server and azure
    Muhammad Faizan Khan
    Texas, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    This SQL Server training is easily one of the best I’ve taken. Daniel is incredibly friendly and made sure everything was set up smoothly even before the training began. The course is fully hands-on, which made a huge difference in understanding real-world DBA tasks. If you're looking to move into a DBA role or sharpen your current skills, this training is absolutely worth it. Its money and time well spend.
    Jelili Mustapha
    Alberta, Canada
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Excellent course!
    Anand Tiwari
    Tracy, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    It was the best SQL Server and Azure SQL course and the trainer
    Yusra alsharif
    Euless, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel's course was helpful indeed!! Very good course content and excellent course delivery.
    Mearg Gidey
    Bloomington, US
  • Course: SQL Server DBA/TSQL
    Trainer: Kingsley Onyejide
    The SQL Server course was well-detailed, with a lot of information shared. Coverage of Azure SQL topics was also very helpful.
    Kingsley Onyejide
    Houston, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    This course was comprehensive and clearly presented. The ability to revisit class recordings has allowed me to deepen my understanding of the subject matter. Daniel is a great trainer and a subject matter expert in SQL Server.
    Sheena A. Jean-Baptiste
    Atlanta, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel Ag's Comprehensive SQL Server 2022 DBA + SQL Programming Training is an excellent course that blends in-depth database administration with practical SQL programming skills, making it highly suitable for both beginners and intermediate learners. His teaching style is clear, structured, and methodical, with real-world examples that simplify complex concepts like recovery models, indexing strategies, and performance tuning. What stands out is the balance between theory and hands-on exercises, allowing students to not just understand but also practice SQL Server administration and programming in real scenarios. Overall, Daniel's expertise and approachable delivery make this course a valuable investment for anyone aiming to build strong foundation in SQL Server 2022.
    Vairavasamy Arumugam
    Auburn, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I want to thank U for the excellent teaching of SQL SERVER DBA.
    SREENIVASA R. NATLA
    Roseville, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Great course! The instructor, Daniel AG, is great at explaining concepts and goes in depth of them. Very receptive to any questions and clarifications. Would highly recommend this course.
    Shaun Fernandes
    College Park, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel Ag
    Daniel is really dedicated and thorough instructor! I look forward to taking more of his courses. He is there in real-time answering questions so for someone like me, I am an older learner and it just makes it easier when its live.
    Michelle Hinds
    Pahrump, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel is the best trainer for SQL Server programming. I learned a lot from attending his training session.
    Suhashini Saamin
    Frederick, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I recently completed the SQL Server 2022 DBA/TSQL training led by Daniel AG, and it was an excellent learning experience from start to finish. Daniel’s expertise and real-world knowledge were evident throughout the sessions, making complex topics easy to understand. The course was well-structured, with a perfect balance of theory, hands-on labs, and practical troubleshooting tips. Daniel’s teaching style is engaging, patient, and interactive—he always encouraged questions and took the time to explain concepts in detail. I particularly appreciated the real-world scenarios, best practices, and the extra support offered outside class hours. After this training, I feel much more confident in my DBA skills and T-SQL scripting abilities. I would highly recommend Daniel’s course to anyone looking to build a strong foundation in SQL Server administration and development. Thank you, Daniel, for your dedication and for delivering such high-quality training! — Pankaj Kumar
    Pankaj Kumar
    Tallahassee, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Thank you Daniel, you have a great course. I will be taking it again so I can get more from it. There was a great deal to learn, and I need to put more effort forward next time. My Best, -Tom
    Thomas Zeler
    Rosemount, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Great class! Daniel is an exceptionally knowledgeable SQL instructor who guided the class through both theoretical concepts and hands-on exercises with clarity. He effectively connected the training to real-world applications, making the learning experience even more valuable. Thank you, Daniel, for sharing your expertise, insights, and practical instruction.
    Christopher Banks
    Winchester, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I wanted to express my sincere appreciation for your SQL Server DBA/T-SQL course. The teaching style is both engaging and practical, making complex database administration topics approachable and easy to understand. The real-world scenarios you incorporated, along with hands-on labs and clear explanations, have significantly boosted my confidence in both day-to-day DBA tasks and advanced T-SQL concepts. I especially appreciated your patience in answering questions, your depth of technical knowledge, and your ability to connect theory with practical solutions. The course content was well-structured, covering key topics like backups, disaster recovery, performance tuning, and security—each presented with clarity and real-life relevance. Overall, this course has equipped me with essential skills and best practices for managing SQL Server environments efficiently. Thank you for your dedication and support throughout the training. Looking forward to attending more sessions with you in the future!
    John Jacob
    New York City, US
  • Course: SQL Server DBA/TSQL
    Trainer: Danial AG
    Danial, thank you for delivering a well-structured and insightful course on SQL, DBA, and T-SQL. Your expertise, clear explanations, and practical teaching approach greatly enhanced my understanding of the subject. The course was highly informative and professionally conducted. Thank you for your valuable guidance and dedication.
    Rubas Zafar
    Sahiwal, PK
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    The course was great; you could tell Daniel knew what he was discussing.
    Helen Solomon
    Wilmington, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Great course. Daniel is very supportive and a great mentor.
    Ade Agabalogun
    South Old Bridge, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    The course was well organized and covered all essential topics very clearly. Examples provided were important and those where one encounters in real work environment. I personally gained the skills and know how relevant for becoming SQL developer and/or MSSql server DBA. Finally, I highly recommend this course for anyone who is interested in learning MS SQL server from the well experienced trainer Daniel AG.
    Hailemichael Ganania
    Durham, US

Empire Data Systems

Social Links