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 really impressed and excited by the teaching approach of Daniel AG on Comprehensive SQL server/TSQL 2019. I would like everyone to get a chance of becoming an expert in e field shortly in a detailed and depth understanding.
    Lamessa Guyassa
    Philadelphia, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Awesome Trainer and in-depth course content.
    Moe Chowdhury
    Cherry Hill, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Excellent/interactive course with the perfect evening schedule for busy individuals.
    Yewondwossen Hailu (Wondu)
    Washington, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    This is an excellent course delivered by an excellent, knowledgeable and energetic trainer. It is a great addition that the trainer makes the recorded version of the live training available for later review. In short, excellent content, delivered with passion.
    Isaias Tesfalidet
    Hilliard, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Good training program, the instructor is also good
    Charles chibuike obioha
    Greenbelt, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    It loved it learnt alot from him
    Shiela Nyake Metuge
    Mableton, US
  • Course: SQL Server DBA/TSQL
    Trainer: daneil
    i really excited to be in your class very energitic and great teaching ireally like it . thanks
    kedardar kefle
    Washington, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Thank you so much Daniel for your dedication to give us each SQL DBA /Tsql knowledge. You are the best. Again Thank you very much
    Meseret Melka
    Chesterfield, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel Ag
    Excellent organization of course content, presentation, and communication with students. All questions are answered well and with the exemplary patience of Daniel responding to repeated requests with passion and enthusiasm. Well Done.
    Samuel A. Habteselassie
    Washington, US
  • Course: SQL Server DBA/TSQL
    Trainer: DANIEL
    I really want to appreciate and thank you for being such a wonderful teacher....the way you were interacting with students, way of teaching, making learning so interesting and explaining everything was outstanding..... I wanted to thank you for being such an amazing teacher.
    MAEREG GEBREMESKEL
    Baltimore, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is an excellent instructor. He is very knowledgeable, highly qualified and very passionate teacher. His classes are very interactive and patiently answers questions. He is very thorough in his lectures and detail oriented. I am looking forward to register in Azure Admin and also SQL Server BI courses in the near future. If you miss a session, you can always catch up with the recorded sessions. I am extremely satisfied with this course.
    Srikanth Balaga
    Sandy Springs, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Great SQL Server DBA/TSQL training course from Daniel AG…. The course in fact is highly organized and well thought with abundant materials. I recommend Daniel’s SQL Server DBA/TSQL training course for anyone seeking knowledge in SQL Database for Daniel’s profound database mastery and his excellent teaching acumen.
    Tete Lawson
    Seattle, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel, is the best online IT trainer I’ve seen so far. For a Microsoft SQL Server Database Administration course he gives a complete SQL training for free. He persistently encourages his students to ask questions and gives them satisfactory answers. I’m amazed by his tremendous patience and courtesy when he answers all kinds of questions from his students. I’ve experienced a couple other online trainers who would tell you to watch their video again, get agitated or brush you aside when you ask them questions but Daniel is completely the opposite. He maintains an excellently organized cloud drive to share records of the training session videos, scripts and other several resources to help you get the best training experience and knowledge. Daniel has genuine deep knowledge and experience and really is a master of the subject and I recommend him to anyone who wishes to get training on Microsoft SQL Server Database Administration.
    Khalid Yusuf
    Atlanta, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is very knowledgeable on the course and explains very well so non-IT background person can easily understand. I highly recommend him for this course.
    Paulomi T. Patel
    Centreville, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Excellent Trainer with Awesome SQL Experience!
    Dyson Daniel
    Bensalem, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is an excellent trainer, I come from a completely non-technical background but he simplified the course and explained concepts in an easy to understand manner. The research papers and labs where a great way for me to practice what I was learning. I didn't know what to expect in the beginning but as time went by, I began enjoying the classes and was always looking forward to the next one. Thank you so much for this course Daniel. I'm looking forward to attending the next program.
    Olanrewaju Esther Itabiyi
    Irving, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    The training was well structured. All the topic mentioned are covered. No questions were ever rejected or not answered. The ability to have the class videos and review them at your own time was great. Daniel is full of knowledge; there is no doubt about that. I was skeptical about online class but Daniel won me over. It was a great experience. i will take a time to review all the videos and others materials and for sure i will be signing up for more training. and i will definitely refer friends to take the training with Daniel
    KOKOU AMAGLO
    Germantown, US
  • Course: SQL Server DBA/TSQL
    Trainer: A G Daniel
    Daniel is an excellent trainer. He explained concepts very clearly and started from basics. I recommend Daniel to learn SQL server.
    Harika Valluru
    Tādepallegūdem, IN
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel is a passionate, knowledgeable and hands-on SQL Server DBA instructor. His expertise in teaching has put my minds at ease. The pacing of the training was appropriate and I loved how he established a positive environment for intellectual engagement and culture for learning. Like me, many students were active participants throughout the training and the activity provided most folks an opportunity to be challenged. I am so grateful to have him as my instructor. Thank you from the bottom of my hearts!
    Hari
    Centreville, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is well experienced in DBA/TSQL and he is an excellent trainer
    KAYODE ABDULLAHI
    Chicago, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is very knowledgeable Trainer, well organized and very helpful. I definetly recommend others to take SQL server and other courses. Thank you Daniel,
    Alem Berhe
    Philadelphia, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is an excellent teacher. He has in-depth knowledge about the subject. Would definitely recommend to anyone who wants to learn SQL Server DBA.
    Sifat Singh
    Youngstown, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I like you course and the teachings style, I will definitely recommend other to take this class.
    Mohiudin Ahmed
    New York City, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel, You are really nice and awesome and good trainer. I learned a lot of things from you, and I will update myself every time. I will recommend you to everybody those who want to learn SQL Server. Thank You !!!
    Hadas Tekleab
    Olivette, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel is an excellent trainer . He made the course easy and very detail. He is best trainer for SQL Server DBA. Thank you Daniel
    Neha Singh
    Seattle, US

Empire Data Systems

Social Links