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
    I was one of Daniel's' student of SQL DBA/TQL in Empire Data Systems. I feel honor, to give feed back about Mr. Daniel. Daniel is an Excellent trainer with deep knowledge about the course, and the best method of teaching skill, he always goes out of the box to make sure every one in his class follows what he teach and make sure every student understand the concept. He is very organized, professional, good listener and he address each of my questions during the training, took necessary steps to answer any of my question. Mr Daniel is I would say he is an extra ordinary teacher, he knows how to accommodate different student according there scope of understanding and make sure that he address the concern and question of student. He always said that "any one, if you have any question stay after class with me''. He is not rushing the class just to finish the course like other trainer in the state, this is from my honest experience. In general this is the best online class I every had in my life. I strongly suggest that, If any body what in-depth understanding of SQL DBA/TSQL, Daniel Ag is the best. Mebrat Demeke.
    Mebrat
    Richardson, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I was referred to this SQL DBA course from Daniel AG by a good friend of mine who himself has been working as SQL DBA for eight plus years now. He began his career after taking course with Daniel AG and praised a lot. I can say now that Daniel AG is one of the best IT instructors I have the chance of studying under. Initially I was skeptical about taking course online but it was a marvelous experience; I really like the idea of recording the sessions as reviewing the lecture helped me a lot. But most importantly, Daniel has a very helping and graceful approach as an IT instructor. Many times I found myself or other students asking really simple or unrelated questions and sometimes even foolish questions but Daniel always helped us understand the concept without passing any judgments. Highly recommended!
    Haroon Chaudrey
    Mankato, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Course was very informative Thank you for the recordings, as I will need to go through them to complete my understanding of some of the subjects
    Eric Patterson
    Kensington, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel is one of the best trainer for SQL Server. I defiantly definitely recommend my friends for training.
    ANU MATHEW
    Philadelphia, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    I cannot say enough on Daniel. I attended another training program before this one and this one by far is so much better. Daniel is not only an expert in SQL, he knows how to teach it and that's very important as an instructor. The way he articulates and simplifies complex SQL topics is amazing. Anyone from a beginner to an IT professional can follow along and learn. His course is well structured, organized and gives you not just the foundation but in depth understanding of each and every topic. He also makes sure to answer each and every question a student may have and repeat himself as many times needed. This was a terrific course , I can't see another place that can do it better than Daniel. Highly recommended!
    Marjanul Karim
    Lindenhurst, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Mr.Daniel
    It is a Wonderful experience specially the training program. Im satisfied that i chooses the right trainer. Keep it up. Thanks
    Keshav Dhutti
    Princeton, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I have learned a lot from this training. Definitely, I would recommend to anybody who would like to take an online course on SQL Server DBA. I also like the way Daniel teaches the course. Becuase he always take his tme to respond for every question raised from the students; I were able to learn more from every student's quesions and the answers given by Daniel.
    Haftom Araya
    Elkridge, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Training was a good learning experience.Thanks Daniel.
    Jwala Bhimireddy
    Arlington, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Training was really good, covered every small detail. my sql fundamental get really strong. I have one subjection Daniel need to start week end batch, that can really help to balance work and training
    Jaykumar Goswami
    Hoboken, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel is THE BEST trainer. Thank you Daniel for your wonderful training. I really enjoyed your class along with your strong voice.
    Nishant Shrestha
    Santa Clara, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    I really appreciate Daniels 90 days training program and he has good patience with the student doubts, And every class is interesting . I felt glad to be a part of his student . Such a nice proficiency he has . Thank you Mr.Daniel .
    Naga padmini Vallabhuni
    Coppell, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Great course outline, pace and overall experience. Trainer is patient and easy to understand.
    Thelma Nora
    Atlanta, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Awesome training.., Daniel is very excellent trainer with lot of patience, He covered all the topics from the basics. Before class he said “you will not disappointed”- that’s true. I will recommend to everyone who want to learn this course…Thanks Daniel 👍
    Avinash Vazenepalli
    Rockwall, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Excellent training , Me as a beginner was able to understand and gain a lot about the subject. Thank you Daniel.
    Gopi
    Mount Laurel, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is very knowledgeable and an excellent trainer. He covers all the topics very thoroughly and tries to keep things easy to understand. I would definitely recommend this course.
    Shailja
    Newark, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Danie AG
    One word "PERFECT"
    Parmeet Tuteja
    Las Vegas, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    It was a very good training. I was not from IT or computer background but then also I was able to understand each and every topics from the course.
    Amit Mangroliya
    Cliffside Park, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I was referred to Daniel by a friend. He told me that I would not regret enrolling for this class. I have taken a lot of online courses but nothing compares to this . Daniel has deep a understanding of SQL and the ability to teach as well, he simplifies complicated concepts in a way that makes the course easy to understand and enjoyable. Always looked forward to every class. Thank you Daniel.
    Clive Matiku
    Louisiana, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is very interactive and always open to students questions. The interactive nature encouraged honest and open communication among everyone which really helped clarify suggestions.Great course all together.
    Suzukina pravasi
    Vadodara, India
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Empire data system is the right place to learn DBA & Daniel is the best teacher i ever had in my last DBA related courses learning process .For any one who wants to master DBA SHALL LEARN IT FROM MASTER, NO ONE BUT DANIEL.
    Endalkachew Gebremichael
    Rockville, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Thanks Daniel for this wonderful Traning.The explanation was really great.I appreciate all the help you have given me before and after the class.
    Radhika Muthineni
    San Diego, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    As per the info am gating so far all the road a head of me looks good and well organized,I am confident that through the completion of the entire program,my hard work and Mr Daniel's advise will shape me in to a great DBA man. God bless you Daniel
    Homayoun Dorkhosh
    Richardson, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    This was a very good and helpful training for beginners like me. The content was well explained and the instructor is really good at explaining things along with examples and analogies to help you understand the concepts better. I would recommend this online training to my friends for sure. Dan is a very reliable, consistent and experience instructor.
    FRANKLIN AYUK AKO
    Naperville, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    He is very knowledgeable and he is able to explain & break down complex concepts to the point where you can understand. Thank you Daniel.
    Andrew Musonza
    NewYork, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Mr. A. G. Daniel
    I was very skeptical about online training but Mr. Daniel made my learning experience very pleasant and thorough. I absolutely enjoyed the training. The resources that he has shared are very apt and useful plus the structure of the training has a progressive flow. Thank you Mr. Daniel.
    Smita Maskar
    Orlando,FL, United States

Empire Data Systems

Social Links