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
    SQL Server DBA and SQL class was genuinely nice and easy to understand. Daniel is very helpful.
    Brijesh Patel
    Sydney, Australia
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel is very knowledgeable and passionate about Database. He engaged me throughout the course with his ability to make the course interesting. He is also an inspiration to me because he expresses his passion for Database which makes me want to learn more.
    Senyi Lemesa
    Philadelphia, United States of America
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Thanks Daniel for taking your time to go over the course in detail and answering questions. This is a total new field for me and and I have a learned a lot form your course. You have an excellent mentoring ability. I really appreciate the fact that you have provided all the videos and materials used in the class.
    Randetta N. Cooper
    Elkridge, United States of America
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I also want to thank you very much for being a dedicated instructor. I am very grateful I came across your school when I was desperately looking for a SQL TRAINER . I will always refer students to you because i don't think there is one that can compete with your level of knowledge of SQL Server. You are a very passionate teacher , very patient with students and you don't mind repeating again and again till all questions are answered. I logged in from work almost all the days and though I wasn't able to follow through the class almost all of the time ,the videos are great and am able to follow your teachings without much problems . I wish all the best in life.
    Matias G Tuffa
    Silver Spring, United States of America
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Before joining Daniel AG's training, I was very confused and nervous about SQL Server. Daniel made it so easy to learn SQL Server and understand the bigger concepts behind each component of SQL language. I never thought I could learn SQL in 3 months, but now it feels like a second language! Thanks to Daniel, I can now walk into the corporate world with full confidence and start my career in Database Administration & Reporting.
    Temesgen Fekadu
    Bayport, United States of America
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel Ag
    Daniel is reliable, helpful, and always available to answer questions or needs as they come up. I can highly recommend him no matter what level you are on, he will take your TSQL/DBA understanding to the next level
    ALPESHKUMAR KATHIRIYA
    Newark, United States of America
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I got a good knowledge on this course because Daniel has been given his valuable effort and dedication to teach me from the basics. Thank you so much.You are THE BEST !!!
    BEHAILU YOHANNES KELEMEWORK
    Des Moines, United States of America
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Excellent course! Daniel is reliable, always available to answer questions and help. I can recommend to anyone who is looking to learn SQL.
    Rodrigue Kuitcha
    Norwich, United States of America
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    I would like to thank you, Daniel for the training .The training was well-presented and content was easily understandable. The session was well timely. I will be recommending the training to my friends.
    Benson K Waweru
    Richardson, United States of America
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Even though we are in webinar, I fell I am in class with you, and I enjoyed coming to classes. Thanks for your time and every day hardworking experience, you are great in SQL
    Kibrom Ghebremeskel
    Calgary, Canada
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Excellent SQL Server DBA Training. i would definitely recommend Daniel AG's training.
    Mayur Patel
    Pineville, United States of America
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Before joining the course, I was a light user of SQL Server. This course has provided me with an in depth knowledge of SQL Server and TSQL programming. Special thanks to our teacher, Mr. Danie AG who took us along with dedication and enthusiasm. I now feel having a much better command on SQL Server.
    Tariq Changgez
    Riyadh, Saudi Arabia
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I do not come from an IT background, the trainer - Daniel was very thorough and practical he explained in a manner in which everyone was able to follow. Thank you Daniel - I am looking forward to the next courses.
    Lameck Kaira
    Richardson, United States of America
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is an excellent teacher and trainer. He knows the stuff to his finger tips and teaches with zeal and passion that even a bigginer with no prior knowledge of MS SQL will find it easy to master the concepts and apply them to real world situation with confidence. Daniel is well organized in the presentation the material and explains stuff in the simplest and comprehensible manner. The life training is very interactive. I really enjoyed this training and have learned and benefited a lot from it. Thanks Daniel.
    Dr. Anderson A. Agbor
    Dallas, United States of America
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Thank you for your valuable training. The way you explain and teach shows that how you are an expert in the course. Covering vast topic within a limited time showed your vast knowledge and experience you have in the field. I really appreciate your encouragement to ask questions. I know this course is very important for anyone who want to involve in SQL job market. Thank you so much for all your effort.
    Almaz Amante
    Reading, United States of America
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    The training was top notch. Learned so much in such a short time of Period. Overall It was well organized
    Tope Joshua Ogutuga
    Houston, United States of America
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Mr. Daniel is knowledgeable and very patient instructor; the materials he provided are very helpful. I recommend Daniel AG to learn SQL server DBA.
    Mulu B Beyene
    Rockville, United States of America
  • Course: SQL Server DBA/TSQL
    Trainer: Mr.Daniel
    Great instructor,full of sql knowledge ,takes time to explain questions and will not move forward till students are satisfied.
    Charity kamau
    Dallas, United States of America
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel Ag
    Daniel is an excellent DBA / TSQL trainer. He explained the concepts very clearly. He started the course from the very basics and then went into advanced He is very patient and takes student's questions and answers them until students are satisfied . I highly recommend to any one Daniel is a best trainer. Thank you Daniel.
    TEWODROS BARIAGABER
    Burien, United States of America
  • Course: SQL Server DBA/TSQL
    Trainer: DANIEL AG
    Well planned and executed course. No hesitation in recommending it for those who wish to get a comprehensive understanding or become a DBA. I have learned a lot and really appreciate everything.
    LOCHIN CHARIEV
    Charlotte, United States of America
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is an excellent DBA / TSQL trainer. He explained the concepts very clearly. He started the course from the very basics and then went into advanced topics. I highly recommend to any one who want to learn SQL Server TSQL / DBA. Thank you Daniel.
    Venkateswara Babu Vankineni
    Vero Beach, United States of America
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel is very experienced and has great knowledge about teaching Sql server. He is very patient and takes student's questions and answers them until students are satisfied. I am without an IT background and have learned a lot about SQL Server, Database, and Tsqul as he taught from very basic. I will definitely recommend Daniel
    Hiranji Shakya
    Ashburn, United States of America
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is very thorough and knowledgeable about the materials being taught. He is always available to help and open to answering any questions you may have. I highly recommend him as a trainer!
    Rubina Akter
    Philadelphia, United States of America
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel Ag
    Love your all content so much I feel like finally I understand detail about sql. Thanks Daniel.
    ELIAS WOLDESELASSIE
    Seattle, United States of America
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    The course was highly impactful and educative especially for someone like me without a prior IT knowledge.Daniel is a good instructor and well versed in the teaching of SQL.
    Oluwatoyin J Adekunle
    Lincolnton, United States of America

Empire Data Systems

Social Links