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 Knowledgeable and informative. One of the best SQL trainers. I Highly recommend Mr.Daniel for T-SQL/DBA training.
    PRIYANKA MADABATULA
    Kuppam, India
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel Ag
    Powerful course, great insight, yet explain in term that complex concepts can be grasp. Thank you for giving me a piece of mind. Thanks Daniel.
    Alywin M Bristol
    Clarksburg, United States of America
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Excellent course!!! I have been misguided by so many people and then I luckily find Daniel. Daniel is the person who guided me properly for climbing the steps of DBA.
    Nurul Huda
    Saint Clair Shores, United States of America
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    The training was very good, informative and helpful. I recommend any one who is interested on the field to take this training with Mr Daniel.
    Semalign B Nuramo
    Duluth, United States of America
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    The is the best training in SQL Server 2017 DBA/TSQL training , highly recommend anyone who really want to learn the material to take only this class.
    Adane Azage
    Rockville, United States of America
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel A G
    Daniel is a very knowledgeable and efficient instructor. I felt the course offered in depth understanding of SQL programming and database administration. The best part is, you will most definitely feel your money's worth at the end of the course. Great program. Thanks
    A M MISHKAT NOOR
    Pittsburgh, United States of America
  • Course: SQL Server DBA/TSQL
    Trainer: Mr: Daniel AG
    Daniel,I am really delighted about the SQL server training course and I am surprised to see the depth of your knowledge in all aspects of the SQL Server. You are always positive and you have a good approach to students. I have learnt a lot from you. I like the way you related each topic to real time environment examples. DBA part of the training was awesome. If anyone planning to get trained in SQL DBA/TSQL. This is the best place for learning SQL DBA/TSQL. Don't miss that opportunity. Thanks again
    worku tamirat eyob
    Atlanta, United States of America
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Very good opportunity to take advantage of it if you are looking for learning the SQL Server's He will answer to your every single question Very easy to learn with him.
    FNU KHYBER
    Ashburn, United States of America
  • Course: SQL Server DBA/TSQL
    Trainer: Danial
    I have enjoyed the class and it was great experience to learn T-sql and HA. Danial was great trainer, easy to learn with Danial.
    Ghanshyambhai Patel
    Elmira, United States of America
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel Ag
    I wish you could be my trainer in every aspect of my life. The way you teach us will make us understand or visualize the course and stay with us forever You are in did number 1 Wow thank you so much. You are born to teach God bless you sir
    Ablene Gebretsadik
    Richmond, United States of America
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Thank you for this life changing course and for the patience
    Naba Mbianje Ulrich Cardin
    Medellin, Colombia
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Great training course I ever had , clear explanation of the topics and always answer for all students questions truly and , he is the best Trainer in the United State , I am highly recommend Mr. Daniel for all my friends. Once again if you want to get Training get all these course with a Master , Thanks Daniel your the best .
    Abdul Tawab
    Las Vegas, United States of America
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I Learn a lot from SQL DBA class I recommend Daniel is Great Teacher. Very helpful and polite Teacher
    Neshit wolde
    Matthews, United States of America
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel Ag
    Daniel is the premier SQL Server DBA/SQL/BI trainer available in US. In fact, his coursework is far better than just about any hands on/in person coursework I have ever attended. I have had the pleasure of training Daniel's two courses and both were exceptional (SQL Development and BI Development). No question was ever left unanswered and he makes himself available to answer emails and offer help in every way. This is not only a great set of initial education courses for those with some experience but also an excellent refresher course (again because you may have questions over the years from your experiences and they will at minimum answer and at times make them part of the night's activities if applicable.) The absolute best.
    Ryan Johnson
    Dallas, United States of America
  • Course: SQL Server DBA/TSQL
    Trainer: Akshay Jain
    The course was very informative and educative. Covers most of the topics on becoming a BI Analyst plus great instructor.
    Eric
    Richardson, United States of America
  • Course: SQL Server DBA/TSQL
    Trainer: Mr: Daniel AG
    Daniel is good intellectual Instructor and really very knowledgeable in SQL Server The SQL Server DBA and T-SQL training class really very informative and each topic explaining in great and details. I really liked the way Daniel taught the class, starting from the very basics and gradually moving on to the complex part. The classes were very interactive . I am very happy that i registered Empire Data Systems.
    Worku Tamirat
    Atlanta, United States
  • Course: SQL Server DBA/TSQL
    Trainer: AG Daniel
    Wonderful course, I feel so fortunate to have had the opportunity to take this class, and even more to have Daniel as my teacher. Daniel is very knowledgeable and patient.
    Sophia Gyles
    Carrollton, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    The SQL Server DBA and T-SQL training class was very informative and each topic was explained in great details. I really liked the way Daniel taught the class, starting from the very basics and gradually moving on to the complex part. The classes were very interactive and Daniel is helpful in addressing all our doubts. I am very happy that I registered for this course and I look forward to attend other courses at Empire Data Systems.
    Zenifa Ali
    Palo Alto, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is great Instructor and very knowledgeable in SQL Server. Daniel take time to explain the concept and answer all questions. I would recommend this program to a friend.
    John W Ndungu
    Richardson, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Very Helpful and Knowledgeable of the subject matter.
    TEWODROS SOLOMON
    Richardson, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I cannot ask for a better training than this. Daniel knows his stuff and his style of presenting the material is awesome. I started the training with zero knowledge of SQL and I am now preparing for the exams.
    Abdul Jaleel Kamara
    Philadelphia, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Well designed course, covers lot of topics and great instructor too!
    Ravi Koti
    Princeton, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    The course is well structured. Lectures are on point and build on each other, which makes it easier to follow along. Daniel is very engaging in his approach and always willing to repeat or give further explanations whenever students have questions; which is why I highly recommend him to anyone who would like to take this course.
    Lucy Gebremariam
    Arlington, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    This Training was very informative and Educative. The Trainer Mr.Daniel actually presented the materials the best way and I learned a lot.
    Titus Cooper
    Charlotte, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Very good course, very good coverage of course content.
    FITSUM GEBREMARIAM
    Seattle, United States

Empire Data Systems

Social Links