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
    It was a very interactive and a great course. Daniel did a great job in teaching and explained all the difficult parts of SQL Server. I intend to take more classes with EmpireDataSystem due to my experiences with Daniel.
    Ikome E.
    Sugar Land, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel ASG
    I enjoyed the course very much and learn a lot and strongly recommend to others
    DIDIMOS BEGASHAW
    Washington, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    The training is a very good and the titles on the course outline are covered which is great and distinguishing from most of the trainers in the market. Daniel knows what he is teaching and he is very respectful for the questions that comes from his students. Thank you!
    Lidiya Birhanu
    Boston, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Tutor was professional, patient and very understanding. The course was very hands-on. Thank you Daniel!
    Franklin Epeme
    New York City, US
  • Course: SQL Server DBA/TSQL
    Trainer: DANIEL AG
    Thank you for a great SQL SERVER DBA/TSQL course. Great presentation with lots of opportunities to ask any course related questions, also found it a really practical, enjoyable and informative course. And that is more than my expectation!!!!
    BEHAILU YARED
    Chicago, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel was very professional, knowledgeable and friendly. The class was very interactive and Daniel made sure to answer all of our questions.
    Vitalis Muma
    Calgary, CA
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    The class was very comprehensive, in depth and hands-on. It provided the perfect balance between theory and practice. From basic programming to more advanced topics , the progression of this course was perfect. I learnt a lot and would recommend anyone looking or learn SQL to take this course.
    Likhith Jagdish Gunjal
    San Fernando, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Thank you for Daniel for helping me while I had questions and got stuck during lab exercises. Thank you again for the opportunity to learn SQL Server in and out. Its truly a great course.
    Ashebir Tuffa
    Silver Spring, US
  • Course: SQL Server DBA/TSQL
    Trainer: DANIEL AG
    Very valuable and interactive training on SQL Server 2019. Daniel is very good Trainer.
    FASIKA GIRMAY
    Hackensack, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Great SQL Server Training. All credits goes to Daniel who is a great trainer, very friendly and a subject matter expert in SQL server.
    Juliet Daniels
    Milwaukee, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is excellent Trainer and he has a great knowledge in SQL Server 2019
    Prashant Balkrishna Rakshe
    Irving, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel A G
    Course is in-depth and great. And thanks for your dedicated service.
    Richard Chamler
    Columbus, US
  • Course: SQL Server DBA/TSQL
    Trainer: AG Daniel
    Very knowledgeable person. Thank you for the awesome SQL Server 2019 training.
    ATM Naimul Islam
    Washington, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    This course was a very informative and interesting course I learn a lot from this course . I really want to appreciate and thank you Mr. Daniel for being such a wonderful teacher the way you interacting with your students and the way of your teaching method was so interesting you were trying to explain each and every question patiently until we understand it you always go beyond and above. Thank you so much for all you have done!!
    Herodawit weldemariam
    Washington, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is an excellent tutor. He has great knowledge of Microsoft SQL Server and explains the topics thoroughly in great details. He also interacts with the students during the classes and answers all their questions and clears their doubts. This course definitely helped me brush my existing SQL knowledge and also learn many new things. I am definitely looking forward to other trainings offered by him.
    Nasifa Ali
    Chelmsford, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    The class is very interesting and explained in a very easy and clear way. I especially like the way you explain relating to the real world examples. It really helps building confidence and have idea how we can use it in my career. And you are so friendly and welcoming, thank you very much. Hope to meet again in another training in the future. Thank you.
    Mahlet K. Woldegiorgis
    Las Vegas, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I had an excellent learning experiences with Daniel AG . Your teaching pedagogy has been wonderful. I got a hands-on practical experiences on both SQL Server T-SQL Programming and DBA. I recommend to everyone who are interested to learn this course.
    Ameha Habtu
    Los Angeles, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel Ag
    Excellent training, very informative with a knowledgeable instructor who is passionate about teaching. Highly recommended. Thank you Mr. Daniel!
    Nardos T.
    Alexandria, US
  • Course: SQL Server DBA/TSQL
    Trainer: DANIEL AG
    Great SQL Server DBA/TSQL training! I have learned a lot and gained enough hands-on SQL Server 2019 DBA and TSQL programming practices throughout these 90 hours highly interactive course. Daniel AG, the instructor, was very knowledgeable of the topics discussed and very willing to share that knowledge with us. I will recommend this course to candidates that are seeking practical SQL DBA/TSQL Programming skills. Thank you Daniel!
    LAURE LAWSON
    Renton, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is an excellent teacher. He is very thoughtful, patient with everyone in the class, he encourages everyone to participate, he never leaves you with any questions and confusion without clarifying, he helped students even before and after class time. If you take his class, you will be thankful and never regret it. I will recommend him to everyone who wants to take his class.
    Yeshi
    Hawthorne, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    The trainer is very intellectual and punctual. Glad to be in your class to take this courses, I'm looking for to take more coursed, thank you for your high professionalism.
    Dagmawi A. Liku
    Los Angeles, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Thank you for delivering a fantastic course. I Highly recommend Mr.Daniel for T-SQL/DBA training.
    Fekadu Ulesido
    Chicago, US
  • Course: SQL Server DBA/TSQL
    Trainer: Tsigereda Kebede Ayano
    Thank you for the training. Great SQL Server DBA training and very affordable pricing.
    Tsigereda Kebede Ayano
    Renton, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniael AG
    Daniel AG is a great trainer even if you are a first timer in IT domain. He gives in depth explanation of the courses and worth it.
    Gaelle Anoumah
    Gaithersburg, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Awesome teaching makes it easier to learn
    John mbah
    Montréal, CA

Empire Data Systems

Social Links