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
    Very interesting programs and will recommend this course to other students
    Salome Peace Micheal
    Kendall, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I find the course and the way you teach very interesting and helpful . I really appreciate your commitment to help students, even after the class hours. Honestly speaking you are the best teacher to refer to my friends and I will. Thanks you
    Muluken Z Bogale
    Minneapolis, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I thank you for being such an amazing teacher and for all your great lessons. You have amazed and inspired me daily and for that I am thankful because you are truly a wonderful teacher. As a teacher you gave me the tools I need to face my future.
    Haregewoin Gebra
    Washington, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel is key to learn SQL SERVER DBA/TSQL in depth and in short time. After getting classes from him to do not need to go anywhere else. Glad to join him as a student.
    Harpreet Kaur
    Queens, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    The best course for any student who wants to learn SQL Server DBA. Daniel is a very good and talented instructor, knows how to explain. I strongly recommend to join empire data systems. Thanks Daniel.
    Aziz Mencou
    Washington, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is a very good teacher . I strongly recommend this SQL Server 2019 training to everyone.
    selamawit hadera
    Philadelphia, US
  • Course: SQL Server DBA/TSQL
    Trainer: Akshay Jain
    This is a wonderful experience of learning and development, I always recommend someone who is interested in developing career in database world. In terms of improvement, I think it should include some projects, with industry based and some more hours for that. Overall, it is great content and extraordinary tutor. Thanks
    Rahulkumar R Patel
    Melbourne, AU
  • Course: SQL Server DBA/TSQL
    Trainer: Akshay Jain
    Thanks for giving a time for excellent MSSQL BI Course
    Sujan
    Minneapolis, US
  • Course: SQL Server DBA/TSQL
    Trainer: Ashish Raj
    I have taken same classes by different instructor(s) but Ashish Raj is outstanding. He never gets tired answering. Instructions were very much well planned and layer out. I'm very impressed on his teaching capabilities and would definitely recommend my collogues and friends.
    Reba Rani
    Dale City, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel is an excellent and knowledgeable instructor. He made the course easy and very detail. Daniel knows how to explain. He is best instructor ever! I am going to take another course , business Intelligence BI with him and I strongly recommend to join empire data systems. Thank you Daniel.
    Assia Lechkar
    Lewisville, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel Ag
    Daniel is an amazing and knowledgeable instructor. He made the course easy and very detail. It is more than I expected. Daniel AG knows how to explain and address important features of SQL Server DBA and TSQL. He used examples, practice to illustrate his explanation. He is best instructor ever! Also added extra hours to cover more topics! I am going to take another course , business Intelligence (BI)with him and I strongly recommend to join empire data systems. Thank you!
    Adjoa Amaglo
    Hagerstown, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I really admire your patience and the dedication to make student learn. You created and promoted the environment for open discussion in the class, which indeed helped students to learn more. I started as a blank sheet and feel some what accomplished now. Thank you for everything. Pros: Hands on learning, opportunity to ask questions, availability of resources including videos on share drive which gives opportunity to go back and watch again if any confusion, affordable cost and convenient schedule.
    Lex Subedi
    Houston, US
  • Course: SQL Server DBA/TSQL
    Trainer: DANIEL AG
    This is a great course for any student who wants to learn data base. Daniel definitely is a good teacher and has vast knowledge of this subject. I'll recommend any one to take this course.
    TALUKDER KAIKOBAD
    Ronkonkoma, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    The Best SQL Server training! Thanks Daniel AG!
    Maunak Talati
    Schaumburg, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Your expertise in teaching has put my mind at ease.With your guidance, I understood SQL Server DBA/TSQL and it has become my expertise
    Okechukwu Onyeizugbe
    Ontario, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Well organized and clearly presented training. Thank you Daniel you are knowledgeable, passionate and dedicated instructor. Keep up the good work.
    Berhane Wondafrash
    Washington, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I have never imagined myself being a DBA as a career when I enrolled for this 90 hours DBA/TSQ training. First, I took it just for the sake of filling my time with something taking up my time. However, it turned to be my favorite subject area to deal with. Daniel, the trainer is a person who has a gut to deliver everything he can offer consistently on daily basis for the entire class, much more than what we paid for. Well prepared, tested experience, and theoretically backed hands on training, which changed my experience and inclination towards the subject area. The course covered everything from basic to advanced concepts and hands on training which suits to individuals like me with no experience and like those who are in the industry needing in depth understanding of advanced concepts in DBA/TSQ. The class was interactive and interesting. The trainer tried everything to make ideas simple, clear and understandable with real life examples taking much time. Generally, this is just a semester course with in depth study and hands on training. Now, I got my thing in DBA, after I have been through this course. I registered for the next SQL Server BI class as a testimony for my continuing interest in advancing my career in the sector. Thank you Tatek Girma
    Dese, Tatek Girma
    Brooklyn Park, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel AG, Thank you for a great SQL Server course. Great presentation style with lots of opportunities to ask questions and talk about real life examples which all made for a really enjoyable and informative course. This has more than met my expectations. A wonderfully practical course - both personally and professionally.
    Kidus T. Assefa
    Annandale, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is an excellent trainer for SQL Server DBA.
    Bersabel Lakew
    Bismarck, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Best place to learn Sqlserver. Thank you Mr Daniel!
    Fasika W Teka
    Washington, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Best training I ever had... I am so glad that I took this training and thankful to Daniel for best experience.
    Rahulkumar Patel
    Melbourne, Australia
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Very impressive training, I learned a lot.
    Mohammed Rashid
    Dubai, UAE
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    It’s more than my expectation! Daniel AG knows how to explain and address important features of SQL Server DBA and TSQL features with adventure works sample database system, best instructor ever! Also added extra hours to cover more topics! I strongly recommend to join empire data systems. Thank you!
    Tewodros Assefa
    Mumabi, India
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    A very interesting class with well explained topics. Thanks Daniel .
    Dereje Argaw
    Huston, USA
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    A very good and talented instructor. Have patient for all the student that come up with whole lot different question. I strongly recommend to take his class to you all.
    selamawit Hadera has
    Los Angeles, USA

Empire Data Systems

Social Links