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 AG
    Course content is interesting. The trainer explains important SQL concepts in ways that I can understand. Appropriate teaching techniques are used by the trainer to enhance my learning. Lecture notes with many useful diagrams, notes and slides which are clear and useful. The trainer is available for consultation (eg email, online, or telephone).
    Kodjo
    Brambleton, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I am very happy with this training. The trainer Daniel is a nice, friendly and very knowledgeable about the course content.
    Jannat Rahman
    Bensonhurst, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel Ag
    As a beginner in DBA/TSQL I felt Daniel left me with a lasting knowledge of the technology, software and principles.
    Eugene Turgil
    Carteret, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I am extremely happy about the way the training is given and the over all qualities Daniel has. I have accumulated knowledge and gained a lot from this training and that is with you I will be contacting if ever I have a plan for another IT training. I do appreciate the dedication, patience, Knowledge, all skills, discipline, memories, etc Daniel has and I hope he will keep it up and pass his knowledge for more others. Regarding the price it is my opinion and this depends on the conditions the trainee might be. All materials are complete and in general the training is well organized and systematic. I kindly request you to keep in touch and build professional attachment. Lots of thanks and warmest regards, Aradaw D. Mulat
    Aradaw D. Mulat
    Naval Anacost Annex, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is a great instructor with a great conceptual knowledge. He makes it so simple for the students to understand. The lab exercises, Research Papers and more importantly his patience while answering questions and in depth knowledge have helped me a lot. Thanks so much Daniel!!!
    Aparna Parimi
    Chantilly, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Great Instructor, Provides all details with good explanation, Friendly and has really best knowledge of SQL. Definitely recommended instructor.
    Sabina Manandhar
    Metuchen, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    This has been an amazing learning experience for me. I am confident that I will be able to apply the skills that I have acquired in this course at my workplace.
    Letish Peter
    Houston, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Malik
    I am new to the IT industry and found Daniel AG's training very helpful so far in order to get my IT carrier started. He has good in depth knowledge, good knowledge.
    Nabil
    Burlington, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Many Thanks Daniel for providing a fresher like me with an in depth knowledge of SQL Server and also for sharing PowerPoint presentation and other word documents related to the course. It says a lot, how much time you spent in preparing those documents and making the students understand even better.I would highly recommend to all my friends those thinking to get trained into SQL DBA. Hats off to you.
    Shweta Suri
    Floris, United States
  • Course: SQL Server DBA/TSQL
    Trainer: daniel
    It was interesting and easily grasp what we need with in a short period of time
    worku
    South River, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel is an excellent and a wonderful trainer. His love to teach is amazing, he makes it so easy even if you have no experience with the course. I will be back for my BI course. Thank you.
    Esther Galloway
    Smyrna, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel is really good instructor, i will refer to my other friends.
    Faisal Parvez
    Lake Ridge, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Good learning experience!!
    Surya Prakash
    Bridgeport, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    The training was interactive and excellent.Mr.Daniel is an excellent and a wonderful trainer with lot of patience and with good communication skills .I do appreciate his professionalism. He makes sure that you understand the concept thoroughly before moving to next concept.He teaches subject from scratch .He always there for students to answer their questions sometimes even weekends.Thank you Mr.Daniel for sharing your knowledge with us.I strongly recommend Mr.Daniel for students looking out for training in SQL Server.
    Madhu Dovala
    Cary, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    I have no words to describe the integrity, the knowledge and professionalism I saw here comparing to others who are in the same business. I wish i knew about him a year earlier. Thank you Daniel.
    Tadios
    Seven Corners, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel is an excellent trainer, he makes sure you understood the concept thoroughly. Always on time and willing to help his students anytime even during weekends. Thanks Daniel.
    Dhruval
    Jacksonville, United States
  • Course: SQL Server DBA/TSQL
    Trainer: DANIEL
    I took Daniel class for SQL about two months. In my opinion, he is one of the best instructor I ever had. He is highly diversed and knowledgeable about the various topics of SQL. During the course period, he covered various topics starting from basics to advanced. He was always available to answer any question that I had while taking his class. I highly recommend Daniel's class for anyone who is naive and interested in learning SQL
    MOUNIKA
    Irving, United States
  • Course: SQL Server DBA/TSQL
    Trainer: sqlserver dba tsql
    Great teacher very patient with students I have so much respect for him.
    muhiden kader
    Annandale, United States
  • Course: SQL Server DBA/TSQL
    Trainer: DANIEL
    I'm very satisfied with this training and would recommend this course.Class starts right on time.Thank you for excellent training.
    SRIDEVI
    Denver, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    He is a very good instructor.I get good understanding of SQL server.
    Dawit
    Indianapolis, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel Ag
    I am satisfied on the training.
    Yohannes A. Yohannes
    Minneapolis, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Excellent training by Daniel
    Ranjith
    Indianapolis, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Danial AG
    This training helps me. So I will recommend to my friends.
    Uzma Amir
    San Gabriel, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Hello Daniel, this is my truly compliment for you. You are the best and thank you for all the effort you have done to shere your knowledge and friendly approach. Best luck
    Daniel Woldemaryam
    Seattle, United States
  • Course: SQL Server DBA/TSQL
    Trainer: AG Daniel
    By far the best trainer I have ever come to know. Daniel approach towards helping students to learn a skills is highly appreciable. Daniel is right on time during training, he really knows the subject matter and communicate well with all the students. Thanks Sachin
    Sachin
    Gretna, United States

Empire Data Systems

Social Links