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 a great SQL Server learning experience with a hands-on labs and very knowledgeable instructor.
    Laihaidoum Elkhadim
    Tysons Corner, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    A remarkable program guided by a committed instructor. I wholeheartedly support and enthusiastically recommend it to others.
    Moruf Yusuf
    Calgary, CA
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Great training program!!! The course covers both SQL programming and DBA in detail. Thank you Daniel for being available all the time to answer all of my questions. The recorded Class videos help a lot.
    Vishakha Patil
    Parsippany, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    The trainer is excellent, and the course is worth the money.
    Eugene U. Udensi
    Grand Canyon Village, US
  • Course: SQL Server DBA/TSQL
    Trainer: Mr. Daniel AG
    Thank you so much Mr. Daniel for your help throughout the process! Great course on SQL Server 2022.
    Abel Elias
    Rockville, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Thank you for being available to answer all of my questions. The recorded Class videos are detailed and helped me understand the course more during my revision. I can't wait to start my next class, which is MSBI!
    Solen Geleta
    Columbus, US
  • Course: SQL Server DBA/TSQL
    Trainer: DANIEL
    It was a great course and I am planning to come back and take more courses like SQL Server BI and Power BI
    HENOCK NIDAW
    Las Vegas, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    One of the best training programs I have ever attended. Daniel is an awesome trainer with great communication skills and knows how to explain complex SQL queries in very simple terms. The course fee is affordable, and I look forward to attending his Power BI, SSIS, SSAS, and SSRS training soon.
    Oumar DOUMBOUYA
    Vertou, FR
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I love your class, because you have loaded materials. I appreciate you for everything you do to help me. I will definitely recommend you to families and friends.
    Olubunmi C Olabosinde
    Atlanta, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel - I thank you very much for providing excellent SQL Server DBA/TSQL training for the last two months. The two months went so fast. You went above and beyond in answering students questions and providing examples. Your lessons were clear to me, and I believe they were clear to most students. As you may recall, I started learning SQL Server DBA/TSQL from scratch, but now I am ready to look for a job in this field. I have strong confidence that the knowledge and skills that I acquired during your course will be greatly valuable in my future workplace. You were punctual and thorough in your explanations. I without any reservations can recommend your courses to my friends and others. Your guidance during my job search is greatly appreciated. Thank you Genet Desta
    Genet W Desta
    Lorton, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    The training was exciting and understandable. More interesting is the fact that Daniel is always available outside the class; call him anytime any day, he makes himself available and answers your questions with understandable explanations. Though this is my first shot at IT training, I have gained so much knowledge and not regretting my investment in it.
    Chidiebere Harry Ogbamgba
    Louisville, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    The course was very detailed and interactive. I learned so much about the TSql programming, with the labs given at the end of each topic also allowing me to write scripts and carry out some TSQL on my own. Daniel was able to cover all the topics and was committed to answering all our questions. I enjoyed the course very much, and having the necessary training will enable me to start a career in Database Administration.
    Oluchi Blessing Dami-Olagoke
    Philadelphia, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    It was a very detailed course on SQL Server 2022. The training sessions were very interactive, and Daniel answered all questions in detail. He is one of the best trainers I ever had.
    Tewodros A Tadese
    Alexandria, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Thanks, Daniel for your awesome class and all the support you provided to learn SQL Server 2022 in and out. I will be joining your SQL Server Business Intelligence training program soon. I also like the fact that each training is recorded and shared with students. This helped me catch up when I missed some classes. Overall, this course is well worth the money.
    Tizita Belay
    Macon, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I loved the pacing of the course, it helped me gain a thorough understanding of SQL Server 2019 and Daniel was a very good and patient instructor.
    Allen Dolo Jr.
    Melissa, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I enrolled in SQL Server DBA/T-SQL course from empire data systems; it gave me a comprehensive overview of SQL Server management and T-SQL programming, with a focus on practical skills and real-world scenarios. I also work on exercises and assignments to help me apply what I have learned. Thanks to Daniel for his time given to me
    Isiaka Oladapo
    Aylesbury, GB
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Thank you for the class. It was well oriented and detailed SQL class. I got to learn a lot from this class.
    Jyotshna Pokharel
    Minneapolis, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel AG increased my confidence in becoming a SQL DBA. It's a very detailed course covering both database administration and database programming.
    Belayneh Wangore
    Seattle, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel AG increased my confidence in becoming a SQL DBA. Its a very detailed course covering both database administration and database programming.
    Mohammad Yeasin
    New York City, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is an impressive professional with a deep understanding of MS SQL Server. He makes his classes exciting via his engagement skills and has excellent content delivery skills in structuring class progressions in easy-to-follow knowledge building blocks. I sincerely recommend this class to SQL newbies or professionals seeking to bridge their SQL and Database admin knowledge gap. Thank you, Daniel...much respect!
    Chinedu Emeanuwa
    Houston, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Wonderful learning experience. Daniel make sure that we understand and listened to everyone's questions and allow participation.
    Lili McWilliams
    McDonough, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    I really enjoyed my experience with Daniel. His teaching method is clear and percise. His knowledge is above and beyond. I highly recommend for future students. Thank you Daniel.
    Kibrom Ghebremicael
    Houston, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Thank you so much Daniel for your valuable training. The subjects were so detailed and informative. It was an excellent experience, and I'm interested to learn more courses from you.
    Naina Merine John
    Paterson, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    This is the best class I have ever taken. The good thing about this class is you can review the video after you finish the course.
    Eden Gebremaryam
    Atlanta, US
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    It is an exciting class. I need to watch the video again and again for a good grasp of the course. Thanks to Daniel for taking out the time to impart knowledge.
    Olanrewaju Ajewole
    Fairfield Heights, US

Empire Data Systems

Social Links