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
    The information presented was current and helpful. I really enjoyed the fact that I was able to access the trainings anytime with ease. You will not regret it and I will be looking to sit for the exam shortly.
    Yurina Page
    Altoona, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Due to change of my work schedule I didn’t attend most of the classes but video and materials he provided were enough to understand concepts. I would recommend his all classes. His efforts and willingness towards students are great. Great teacher!!!
    Mitul Patel
    Trenton, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel Ag
    The class is fast and intense but Daniel makes it so easy by how he explains everything and answers the students questions.He's very patient and understanding.I highly recommend him. Look no further ,get trained by the master Daniel.
    Serah Mathis
    Dallas, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I would recommend Daniel AG’s SQL Server DBA/TSQL course. Daniel takes the time to explain the concepts until they are clearly understood and provides additional material that can be used for review after the classes. He also makes himself available to students for questions and is very informative. I highly recommend this class.
    Christine Mwangi Butt
    McKinney, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Hello, Thank you Daniel for creating this course. It was a good resource. The course material is very dense and there is so much material to cover. I enjoyed the course. You were very helpful and are a good teacher. Thank you, Patricia
    Patricia Sula
    Rockville, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Very detailed lectures. Great value for the money I spent on training.
    Jamal Mathis
    Dallas, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Excellent way of teaching and Daniel has really good knowledge in SQL Server.
    Nasrin Frough
    Lewisville, United States
  • Course: SQL Server DBA/TSQL
    Trainer: DANIEL
    Fantastic SQL Server 2017 DBA training by Daniel !!!!
    OLUWASEUN TOPE OYERO
    Atlanta, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel G
    Daniel is knowledgeable and gives a lot of insight in the working field.
    Ty Hak
    Jacksonville, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel has Expertise knowledge in SQL Server in both T-SQL Querying and DBA as well. Teaches what are the necessary topics for beginners and clarifies the doubts very well when a student raise a question. Very experienced DBA and Trainer. I refer all my friends who arr looking for DBA as career to take course with Daniel.
    Akshay Kumar Punna
    Las Vegas, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Mr. Daniel is a very exceptional instructor. I didn't know much about DB at first so when I went on with the course, I was able to understand it well. He supports us, encourages us to ask questions and explain what the answer is so that we can understand it. I would definitely recommend this course with him since he is very patient when he teaches.
    Mahlet Keraga
    Charlotte, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I really enjoyed this course even though I did not have any knowledge of SQL Server Database. Daniel was knowledgeable of the material and was willing to help his students. I would strongly recommend Daniel as an instructor to those who want to take this course.
    Chantal Tewo-Nsombo
    Temple, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel Ag
    This class is great! Very in depth training and the videos and other class documentation are great tools to use during and after class.
    Ashlee Gonzalez
    Fremont, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    The training was very helpful. Daniel has very good knowledge of the subject matters. As per training I will give him 5 Star.
    Syed Ali
    New York City, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    It was very nice class, its my first online class experience I didn't expect this much beautiful, I gate a lot knowledge and experience. Daniel is a great teacher and nice person too, generally this online course changed my personal lass expectation about online class to positively. I am happy thanks more.
    Nebiyu G Kifle
    Boise, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is a great Instructor. I realized that he has all the required knowledge of the field. More importantly, he has a great personality & heart to help all his students. Very courageous & patient. One can easily tell he has a high level of professional commitment on top of his knowledge. I thoroughly enjoyed the entire training. I highly recommend him to anyone interested, whether new to the field or had some past experience & wanted to further broaden their knowledge.
    Baheru Muluneh
    Seattle, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel is a great instructor and very knowledgeable in SQL Server
    Marvin Mensah
    Manassas, United States
  • Course: SQL Server DBA/TSQL
    Trainer: DANIEL AG
    Daniel is a great instructor. He takes his time to teach, he makes sure everyone is following and he answers any questions you may have to satisfaction. At the beginning of class, I remembered he said any question is a good question, and he sure did prove it by answering all questions asked . Thanks Daniel. I enjoyed every bit of your class.
    OMOBOLAJI 0. ONONUGA
    Charlotte, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    The topics covered where relevant to me.The training materials provided was very helpful.The trainer was knowledgeable and highly skilled. I highly recommend this training.
    Temesgen L Abalti
    Arlington, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    I really enjoyed the training. He is very patient and always encourages his students to ask questions. I would recommend anyone who wants to become a DBA.
    Bruck Assefa
    Long Beach, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    It has been a great opportunity to get knowledge even for someone who had no previous experience on the field. I highly recommend it.
    Meheret Keraga
    Tupelo, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniell
    I like the way to explain! Very good SQL Server 2017 DBA training.
    Tameru Kejela
    Columbus, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel A G
    Excellent coaching... student discussions, the class materials are really helpful. Thank you Daniel for your training and all your help.
    Siby Toy
    Cerritos, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Thank you so much for making my experience on SQL SERVER DBA wonderful!!! You are a great instructor and I’m going to miss your class. Thank you again for interacting the class and explain all the material/topics really well. You always make sure we understood your explanation. I will definitely continue recommending your class for others with out any doubt. Excellent, keep up the good work!!
    Konget Mengistu
    Cambridge, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Excellent training!
    Biniyam
    Burbank, United States

Empire Data Systems

Social Links