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
    Great course and excellent teacher
    ZAKARIA BURHAN SHAIKH
    Frederick, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Akhsey/Honey's
    The course was SSIS,SSAS,SSRS, and PowerBI. The trainers were out standing. They were easy to follow along and communicated well. I learned more than I expected, and if I have to take it again I will definitely take it with them. Overall, I am very satisfied. Thank you so much for your time Akhsey and Honey and Best of luck on your future endeavors
    Natenael Belay
    Tukwila, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Trainer is Amazing and motivates you that is the point. I proudly would like to recommend Mr. Daniel AG. to those who are planning to take SQL Server DBA training.
    Helen M Daniel
    Roswell, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Indrashish
    Thank you so much for a wonderful knowledge. It really helped
    Danial najmee
    Chicago, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I want to thank Mr.Daniel AG, (Founder of Empire Data Systems LLC) for taking care of SQL Server DBA/TSL class. Mr.Daniel has always been an amazing and knowledgeable teacher,a kind person. It's a good place to learn SQL Server DBA/TSL/BI.
    AYAN ABDUR RASHID
    Washington, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I really appreciate your help and guidance throughout the past two months. You are a great and professional teacher who is always willing to help and encourage his student.
    Ashenafi Abera Tsaudu
    Matthews, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel Ag
    Thank you for your best way of teaching. You bring down the ideas into easiest and understandable way to us which makes us to follow and enjoy the teaching session. Thank you so much. God bless you.
    Biniam Aregay
    Orlando, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    It was a very informative classes on SQL Server DBA and SQL Programming. Thank you
    Tabin Chowdhury
    Virginia Beach, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is an excellent SQL Server trainer. He is very professional, passionate and organized. He is in-depth and knowledgeable in subject matter. Sessions are interactive and students are encouraged to ask questions. He provides video recording and materials of each classes. i really satisfied with this class, also, recommend to everyone who wants to learn SQL.Thank you Daniel.
    Ishwori Shrestha
    Concord, United States
  • Course: SQL Server DBA/TSQL
    Trainer: DANIEL
    Daniel is a very good trainer, very knowledgeable, well experienced, good method of teaching and knows how to express a point in detail of SQL server DBA. He is always available for any questions at any time, responding promptly. Thank you
    NAGARATHNA RAVI
    Piscataway, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Danial AG
    Daniel is very honest teacher. His teaching skills very unique. Any students who learned from him never get unsuccessful. I am from non IT background and did not have any knowledge about computer science , now I know lot of things about database,SQL. His online classes are live and after the class he provide class record video , class notes .If anyone want to learn database , SQL , MSBI dont go anywhere, He is the best teacher. Thank you Danial.
    Laxman Timalsina
    Richardson, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel AG. is the best teacher, he was always there when needed and willing to cooperate at any time. Thank you.
    Elsabet Nigussie
    Rancho Cordova, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I really got a lot of new information and knowlege . Thank you
    Martha Tassew
    Orlando, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Very clearly explained class about sql
    Bhakti Patel
    Parsippany, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel is very good in teaching,he will teach you and you will understand the course.Always willing and ready to assist his students at any point in time.I will recommend him to anyone that wants to take the course.
    Olumide Majiyagbe
    Louisville, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Very Good Trainer. Excellent dedication. Great course all together.
    Tochukwu Odogwu
    Manchester, United Kingdom
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Overall, the class was great. It was worth every penny.Usually batches like this cost around 2000 dollars. The class was easy to follow along and if you feel lost you can always go to the one drive and watch it again. Also, Daniel was available and ready to answer if we had any questions. I learned more than I expected. With that being said, Thank you Daniel for your time and always willing to help others
    Natenael Belay
    Albany, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel AG is very knowledgable and delivers all lessons in detailed.
    Mozammel Hossain
    Arlington, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Great class and great material. The instructor was helpful and I learnt a lot from the class.
    Darleen B. Ademba
    Kirkland, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Class was great and very helpful.
    Abraham Teo
    Burlington, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Loving The Class. Intense For A Beginner. But Practice Makes It Perfect.
    Noah S. George
    West Nyack, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I am one of those people who wanted to change a carrier for better. Coming from medical field and also have no IT background makes it a little harder to understand the course but with the help of Mr. Daniel I am able to have a good understanding of SQL Server. Mr. Daniel is very humble, patient and organized. He is able to help students like me who has no knowledge of SQL server to students who are actively working as a DBA. I strongly recommend to others and looking forward to take other courses at this institute. Thank you so much for every thing.
    Roza Nuru
    Wilmington, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Very informative and insightful. Will definitely recommend and hope to start my BI class soon
    Kwesi Eyiah
    Accra, Ghana
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    The course delivery was very good. The instructor was very patient with student and always listen to students and answered their questions. The course was very detailed and required more time to understand as some students were new to course. I personally really appreciate the fact that the classes are saved on the one drive so you can always go back and retake the class.
    Claude Kiteh
    Pflugerville, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Great Training. I am working with SQL Server for over 7 years now. The training was really good so i could learn a lot of the ins and outs on how SQL Engine works. Daniel has a great way of teaching with real-world examples. Always ready to start before and/or stay after the training to work on specific questions. I would recommend and do other training as well. Actually looking for the BI Class next. Thank you Daniel and team.
    Enielson DaSilva
    Trenton, United States

Empire Data Systems

Social Links