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
    It was good learning experience, useful for freshers and was course was designed in a way where everyone was comfortable.
    Bhavana
    Fort Collins, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    The instructor was very well prepared, has professional approach, has in depth subject knowledge, has excellent communication skill and also the training is affordable. So I will strongly recommend for everyone. It very nice to learn from home while taking care of family. I am so happy for having Daniel as an instructor. He is very eager to help his students. The instructor is able gave us all the materials we need/ebooks, lab questions, sample exam questions, videos/. I do not have words to say about this course. Daniel I thank you so much for your patience and for being a wonderful instructor. Mintwab Kiflie
    Mintwab Kiflie
    Indianapolis, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel, you have exceeded my expectation! You have deep knowledge and experience in SQL Server . Excellent energy and ability to manage the class interaction. I noticed you were consistently well prepared and you are a good trainer. I am so happy to have you as my SQL Server 2012/2014 trainer. Thanks.
    Ermias
    Germantown, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Thoroughly enjoyed the class. I feel it will help me in my career.
    Douglas Cassin
    Louisville, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    It was fun learning experience. Daniel has a lot of patience, he is very knowledgeable instructor.
    Suja Maskey
    Carmichael, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is the best instructor that I have ever seen.He has wonderful teaching ability and excellent knowledge of SQL server.
    Preeti Patel
    Denver, United States
  • Course: SQL Server DBA/TSQL
    Trainer: DANIEL
    I M glad I joined the program
    JUNAID AHMAD
    Cicero, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel is really good in teaching. the way he explains is really good.
    amruta
    Shrewsbury, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is the best instructor that I have ever seen, I have learned a lot from the class.
    Frank (Zheng) Zhou
    Jersey City, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Excellent and it was very good interactive training... :)
    Nethri Aitha
    Alexandria, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    I do appreciate Daniel's professionalism. He is very patient, and he makes sure that students understand a topic before moving to the next one. I really did enjoy the class
    Urbain
    North Port, United States
  • Course: SQL Server DBA/TSQL
    Trainer: DANIELL A.G
    He is an excellent trainer.You will learn the subject very well, just need to focus on his class work.
    MOHAMMED BABUL
    Stamford, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Excellent tutor !! Teaches in a proper way so that it would be very easy to understand.
    Vijay parvathaneni
    Miami, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Trainer was very knowledgeable about the subject and also very friendly. I was able to reach the trainer almost all the time if I had a question or needed help with something and if I wasn't able to reach him at that time he would return my call sometimes in a matter of minutes! Thank you Daniel, I have learned a lot from your in the past few weeks. You're the best!
    Muktar
    Kenosha, United States
  • Course: SQL Server DBA/TSQL
    Trainer: DANIEL AG
    I have the following feedback on my trainer Daniel AG. • He has wonderful teaching ability and excellent pedagogical (how to teach) knowledge of SQL server. • He started everything from scratch and explain every detail that student need, especially for non- IT background student. • He is punctual and honest • He has sound knowledge of the subject matter and above all things he is very kind. Teaching while working is really very hard! Because when someone working for long time and get tired, he/she need to get rest. However, among many people there are a few strong people who have courage, goal and mission that never get tired while they are sharing their knowledge. Sharing is happiness! If I were Mr. Daniel AG, I would be force myself to bed rather than teaching for two hours. I really acquire a good lesson from you in addition to SQL Server. Thank you very much for all things you have done for me.
    ASRAT KASSAHUN MINASE
    Austin, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel AG has a top quality on training skills with a deep knowledge in the subject matter. He has excellent way of addressing his students needs. I recommend him to anyone who wanted to take this course. Thank you
    Fisseha Eshetu
    Verona, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    A great teacher! He holds the attention of students in all discussions. He is very sincere towards his work I highly recommend him.
    Mukta Tandon
    Brampton, Canada
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Awesome trainer and with lot of patience
    Arjun
    Milwaukee, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel Ag
    very good SQL Knowledgeable trainer. I got the chance to learn SQL Server DBA/TSQL thoroughly with hands on experience.I would like to recommend others to attend his class if they want to broaden their knowledge in SQL Server DBA/TSQL.
    Archana Sapkota
    Overland Park, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Mr. Daniel A.G.
    I knew many professors and trainers when I was undergrad and grad student, but I have never seen a trainer like Mr. Daniel. He is incredibly knowledgeable and very passionate towards the training courses he offered. Whether you are a beginner or already have some knowledge about the SQL server, he will get you there where you needed to be. I have got way deep knowledge than I expected for the price I paid. I am so grateful to my friend who recommended me to be trained by Mr. Daniel. Finally thank you Mr. Daniel for all your effort and willingness to help your students even after we finish the course. Hope I will see you in the BI training some time later!
    Samson
    Charlotte, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Mr. Daniel A.G.
    This class was just what I needed! Mr. Daniel took his time to explain major topics in SQL from the beginner level and also moved at the pace of the students when necessary to make sure no one was lost. We were given all the materials needed to review on our own time as well. Give it your 100% and there is no reason why this won't get you to the next level. In addition to that you will have a great mentor in the field because Mr. Daniel has shown great dedication to make time for any questions a student might have even outside of class hours! Greatly appreciated! I would like to say a huge and sincere thank you for the opportunity to be one of your students Mr. Daniel and for the time, energy and skills you shared by organizing these classes! Will be sure to join the BI course in the near future as well! Can't wait to finish reviewing so I can take the certification exams!:)
    Mahilet
    Washington, United States
  • Course: SQL Server DBA/TSQL
    Trainer: daniel
    Daniel is very passionate teacher.He is very patient in clarifying all the doubts.Any one who are beginners like me,he is best guru we can have.He provided all the resources required.
    lavanya
    Cumming, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is a great trainer. His class worksheets, reading materials and videos are very helpful.
    Jane Williams
    Madison, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel is very knowledgeable and he enjoys teaching. He promptly responds to your queries. He provides all the materials needed. Worth every penny.
    Yamini
    Fords, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    The course is well structured covering a wide range of topics from basic T-SQL to DBA topics and the discussion architecture in detail whenever necessary. I would recommend this course and this instructor to anyone looking to learn T-SQL, SQL Server development and DBA. Daniel is very passionate about teaching students. It is very well organized online training with lot of interaction and good connection which makes you feel like you are in a real class. Daniel is very patient with all the questions you have; whether is during class, after class or any other time. He always responds back and has philosophy of "no question is silly or unimportant" and encourages everyone to ask questions. Daniel adds real work examples to help you understand the process better so you can relate to it. I will be taking more courses with Daniel. An A rated Trainer.
    Don Costello
    Tampa, United States

Empire Data Systems

Social Links