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 am from an IT Support background but Daniel did an excellent job explaining Database concepts in detail. He was very good in accommodating individual needs in the class. I definitely recommend his training class and I am looking forward to taking his BI class. Thanks again
    Manish Shrestha
    DENVER, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Simply the best training I have ever received.
    Mausami Patel
    BROOMFIELD, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel - The course training material and overview provided by Daniel is very good. He makes difficult material easy to understand. He is knowledgable and provides explanation with good examples. His class has a lot to offer. Thanks Vinay
    Vinay
    SOUTHFIELD, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is an excellent teacher and knows his subject very well. He takes time to answer questions that students ask and make sure they understand the material. The set up of the class is very convenient for working professionals and is equipped with reading materials, lab exercises and archived classes. I would highly recommend Daniel's class for any SQL Server related training!!!!!
    UDAYA SUSARLA
    ATLANTA, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I have over 13 years of experience in working with core development projects in large organizations. Most of my experience is in Java, NoSQL databases and I had to use an RDBMS backend for one of the new projects. I had no SQL background other than writing some simple select statements. This course helped me in designing an MS SQL Database from ground up and use all SQL features like Views, Functions, Stored Procedures, Triggers etc. With the help of Daniel, I was able to follow the best practices while developing for SQL Server and to be sure that I get the best performance. Daniel really knows the stuff he teaches and you can clearly see his real life experience in play in every single class. He is well prepared and always on time for the class. If you are looking for serious TSQL training, this is the course you need to attend.
    Baiju Thomas
    VA, USA
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I work as a Software QA Engineer. SQL is very useful in my job. I took this course to enhance my skills and to prepare me to take the MS SQL DBA certification. I was skeptical when I heard about the course. But after directly talking to Daniel and attending the first two classes, I was impressed. I have worked in IT for more than 20 years. It is very apparent that Daniel knows his stuff. I was able to use what Daniel taught right away in my job. Daniel is very dedicated to making sure that we understand the material presented in the course. Because of what I learned from this course, I was able to obtain an increase in pay. I am currently studying to pass the MS certification and am very confident that the material and instruction that I received from taking this class will give me everything I need to pass the certification with confidence. I also plan on taking the SQL Server 2012 BI Training from EmpireData. I would recommend Daniels courses to anyone looking to further your knowledge with current technologies. Thank you Daniel!"
    Cynthia P. Harrell
    Lumber City,GA, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel Ag
    Daniel is one of the most inspiring and motivating instructor I know, he is very organized with deep knowledge of sql server, and helpful and available to his students regardless of his busy schedule, I would recommend him to anyone interested in compressive sql server training , thank you Daniel !
    Tigist Argaw
    COLUMBUS, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel is one of the most passionate instructors and has extensive knowledge of SQL Server. His course is organized very professional and comfortable for the students. He breaks complex query and present them in a very simple manner which student can understand easily. His presentation is amazing. He answers the student questions with examples so that students can understand the concept clearly. I love his interactive style in class. His communication skills as well as his presentation skills are amazing. He delivers exceptional support and guidance even after class hours. If you are looking for a professional SQL Server class , I highly recommend Daniel AG SQL Server 2012 DBA at Empire Data Systems LLC
    Ebenezer Olu
    STERLING, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Really love this course, excellent DBA trainer, got indepth knowledge. Intend to attend Oracle and Informatica course too.
    Thiti yu
    HICKSVILLE, USA
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    One of the best MS SQL Server DBA trainer having great knowledge about the on the subject with real time experience and having great quality of teaching.Other than that I found him, he is also friendly with students and helpful as well. He has a passion of teaching , unlike other teachers. He is extremely dedicated to his students. He has a lot of patience, you can ask him to explain a things over and over until you understand, and he will ensure to make sure you got it! I highly recommend everyone who is looking best training for Microsoft SQL Sever.
    Pankaj Patel
    ALLENTOWN,
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is a hard working, dedicated and passionate teacher. I searched through lot of courses before I found Daniel's. When I came across Daniel's I immediately realised that I don't have to search any more. Daniel has exceeded my expectations for the support he offers to his students. He means it when he says 'My students are THE BEST!'. I took SQL Server 2008 course more than an year ago. Recently I wanted to brush up my skills on the admin portion of it. But I lost the videos when I needed them the most. I reached out to Daniel and much to my surprise he made time to do the needful so I can get the videos back. I am very thankful to him for this. If I ever do any other SQL server course again, I will join Daniel's and I highly recommend his course to any body, any time!less
    Akhila Vithala
    ,
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I met Daniel through his SQL Server 2008 R2 DBA & TSQL Programming Training Course. Anyone wanting to learn SQL Server 2008 R2 DBA & TSQL should select Daniel's class without hesitation. I don't believe you can find another class of this quality. Individual attention is always available and the price can't be beat. I recommend Daniel's training to anyone.
    Scott Minard
    ,
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is an excellent DBA and trainer and a great person to work with.
    Indrashish Saha
    ,
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel's dedication to impart the teachings and the subject matter is commendable. His course work and lectures were very intense and worth the time and the money. He is very conversant and erudite about SQL Server 2008; the lectures are comprehensible and precise. His presentation style is excellent and makes the class very interactive and easy to follow. He helps in preparing for the interview and goes to great extents to clear your doubts. I would highly recommend this course to those who wants to enter into database administration and also those who wants to enhance their skills. The course materials provided were up-to-date and very informative.
    Lakshmi Raghu
    ,
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is one of the most passionate instructors. If you are looking for a professional SQL Server class , I highly recommend Daniel AG SQL Server 2008 R2 DBA at Empire Data Systems LLC. He breaks complex query and present them in a simple manner.His presentation is amazing. He answers the student questions with examples so that students can understand the concept completely. I highly recommand his class.
    Meenu Arora Kaushal
    ,
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is one of the most passionate instructors. If you are looking for a professional SQL Server class , I highly recommend Daniel AG SQL Server 2008 R2 DBA at Empire Data Systems LLC. He breaks complex query and present them in a simple manner.His presentation is amazing. He answers the student questions with examples so that students can understand the concept completely. I highly recommand his class.
    Hema Mistry
    ,
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is one of the most passionate instructors. If you are looking for a professional SQL Server class , I highly recommend Daniel AG SQL Server 2008 R2 DBA at Empire Data Systems LLC. He breaks complex query and present them in a simple manner.His presentation is amazing. He answers the student questions with examples so that students can understand the concept completely. I highly recommand his class.
    Hema Mistry
    ,
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I know Daniel AG as SQL Server professional I'm taking his course online SQL Server 2008 R2 DBA. In the last month I have dealing with Daniel AG , I have learned that his course is organized very professional and comfortable for the students. If you are looking for a professional online SQL Server class with professional and educated teachers and manager, I highly recommend Daniel AG SQL Server 2008 R2 DBA at Empire Data Systems LLC.
    Mila Budzinsky
    ,
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is one of the most thoughtful and passionate instructors. He breaks down complex material and is able to present them in a simple manner. I love his interactive style in class. His communication skills as well as his presentation skills are amazing. He delivers exceptional support and guidance even after class hours. I am very fortunate to have him for my instructor for the SQL server course. I higly recommend him.
    Sheena Alexander
    ,
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is an outstanding and dedicated instructor with an excellent teaching style. He is very knowledgeable in SQL Server 2008. He also has a great positive personality that quickly establishes a trusting relationship with the students. He answers student questions with numerous examples to make sure students understood the concepts completely and has a genuine interest in achieving success for all of his students. Very Good Class!!!!! I would highly recommend Daniel's class for any SQL Server related training.
    Smruti Barot
    ,
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I highly recommend Empire Data Systems' Business Intelligence class. The instructor, Raj, is very knowledgeable and has a way of conveying database and BI concepts that makes it very easy to understand. He really gave us our money's worth -- and more!
    Michelle Rosenaur
    ,
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Awsome GURU! I can't even express how much impressed I was with his knowledge, teaching pattern & eperience. What He gave his student during the class of SQL DBA is not even compareble to any other class out in the teaching field. Thank you Daniel.
    Amrita U
    ,
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is easily one of the best in the business of Microsoft SQL Training. His teachings provide a great mixture of up-to-date academics with real-life experience, allowing his students to comprehend and understand difficult concepts. I cannot thank Denial enough for his knowledge, his passion and his patience. Daniel offers solutions for very competitive SQL DBA issues with imagination and unrelenting study, and his excellent reputation in the industry is well-deserved. I am honored to have had him as my SQL DBA instructor.? Top qualities: Great Results, Personable, Expert I strongly recommend everyone who is looking best training for Microsoft SQL Sever. Thank you again! Very enjoyable experience. Syed Shaji Progress DBA Husky Energy Inc. Calgary, AB
    Balu Ragoonathan
    ,
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is easily one of the best in the business of Microsoft SQL Training. His teachings provide a great mixture of up-to-date academics with real-life experience, allowing his students to comprehend and understand difficult concepts. I cannot thank Denial enough for his knowledge, his passion and his patience. Daniel offers solutions for very competitive SQL DBA issues with imagination and unrelenting study, and his excellent reputation in the industry is well-deserved. I am honored to have had him as my SQL DBA instructor.? Top qualities: Great Results, Personable, Expert I strongly recommend everyone who is looking best training for Microsoft SQL Sever. Thank you again! Very enjoyable experience. Syed Shaji Progress DBA Husky Energy Inc. Calgary, AB
    SYED SHAJI
    ,
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    After taking a class with Daniel , I could say he has a teaching passionate with real time experience. I enjoyed very much it wasn't boring at all. This was the first time that i took online classes . I did not find any differnce taking a class online or classroom. The good advantage of taking classes online was recorded each any every section. Even you missed it you could catch it later. Other than that I found him, he is also friendly with students and helpful as well. I am looking forward taking another course of Business Integration soon. God Bless him.
    Curt Thiel
    ,

Empire Data Systems

Social Links