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
    Truly like the training provided by Daniel. He tried to address all the questions and gave individual attention. Great Trainer, Best Trainer to understand SQL DBA, expensive topics were covered during the training. not a short cut trainings i had before. totally worth the cost. thank you Daniel, i will always have your recordings.
    Karuna Patel
    Philipsburg,NJ, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel A.G.
    Daniel it has been fantastic training experience. Being a DBA yourself working through your day to day experience in the field added more value to the training. It was my first experience remotely getting the training and I have to say that you did not disappoint me. Great Job Daniel. Looking forward to other related training from your company. In future if the class work sheets can also be named according to the session covered will help. All in all a great training experience.
    Manoj Mathew
    Atlanta, GA, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    "Daniel... Thank you very much for your awesome training. You are one of the best trainers I have seen in my life. Your SQL Server knowledge is unbelievable and in 90 hours you covered in and out of SQL Server. Two of my coworker would join your next batch training. Please stay connected. "
    Eric Livingston
    Tampa, FL, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel.. I just want to let you know that I passed the 462 exam (850). Thank you so much !!!your class really helped me big time. I was able to understand every topic thoroughly because of you. I really appreciate your way of teaching and the way you build the contents ...your visual explanations before you start each new topic...the examples you give to explain new concepts... and the resources you gave us they were all very helpful and to the point. Once again thank you so much !!!
    Selamawit Melesew
    Scottsdale, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel G
    Thank you Daniel for a wonderful learning experience. I really enjoyed the class and at the same time learned a lot. You are a great teacher, you let everyone participate. You are always willing to listen and answer our questions. I also liked how prepared and organized you were. This class was much more than learning for me. I thank you again and I hope you will help me throughout my journey to a new career.
    Hanna Maru
    Reading, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is a good teacher. He has deep knowledge of the DBA with an excellent communication skill. The course content is very good and comprehensive of both programming and database. Moreover, He is very helpful for his students. I am very happy to be part of this course.
    Yared Beyene
    Ann Arbor, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel is awesome, I was never disappointed for taking this course. Thank you so much Daniel.
    Prakash Tirunampalli
    Gravenhurst, Canada
  • Course: SQL Server DBA/TSQL
    Trainer: AG Daniel
    The classes were so interesting and knowledgable. Specially for the material that we got to keep for future references is going to b very worthy for our future assignments.
    Prachi Sharma
    Fort Worth, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    I have never come across any Trainer as Daniel. I don't think would like other trainers after taking class from Daniel . He has explained and Answered the every question asked .The method and style of explaining is very understandable.
    Imran Hussain
    New York City, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    It was a great training experience with Daniel. This course comprehensive and interactive. Thanks
    Jitender chauhan
    Sacramento, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Mr Daniel
    The training gave in depth knowledge of SQL,T-SQL and database administration concepts.For beginners like my self this course has proven to be a very valuable learning experience. All the Class material, Demos and Labs are quite comprehensive and detailed.Thank you very much for the teachings.
    Tejal Lalsare
    Houston, United States
  • Course: SQL Server DBA/TSQL
    Trainer: mr daniel
    Its methodology of teaching is indeed accurate. I can go to him anytime and he always be there to assist.One of the best teacher forever .May God Almighty continuing to give you wisdom and blessed your family
    jimoh mojeed
    Houston, United States
  • Course: SQL Server DBA/TSQL
    Trainer: AG Daniel
    Excellent Trainer. I never ever found such a trainer which have indepth subject knowledge. I have lot of friends in America. I recommend to every one to you
    Abdul Hannan
    Bronx, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    "You are an awesome teacher, you know how to handle friendly each question from your students. You have really nice approach and deep knowledge of subject matter. Thank you very much, I enjoyed your lectures nicely. I recommend others who wish to study SQL server DBA\/TSQL, to be trained under Daniel AG"
    Gemechis G
    Arlington, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel A G
    This is a good,comprehensive SQL Server DBA training.I am completely new to this kind of training as my degree is in electronics. But Daniel make it very easy to understand and helped me to gain knowledge of DBA. He has an extensive experience and that thing is really helpful for all students. I wish him best of luck !! Thanks Daniel.I have learned a lot!!
    Arpitaben Mehta
    Dearborn, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is very knowledgeable and professional teacher. He knows his stuff and is very detail oriented. I learnt a lot from his class. He is very helpful and thorough. He tries to explain everything in detail so that we can understand the basic concepts of SQL Server commands.
    Syed Muhammad Iqbal
    Naperville, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Mr Daniel
    After completion this course I would say Mr Daniel has very deep knowledge about SQL server. He will answer you your question in just single call. I would recommend you this course.
    Mitul Patel
    Bedminster, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    He is a great trainer to learn from. I would not hesitate to recommend his name for training. I gained a lot of Sql knowledge from this class.
    Shasta
    Council Bluffs, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Well, i would say Daniel as an Instructor is amazing. He is pretty good at breaking complex things to be comprehensible in his own way and i believe thats what sets him apart. Unlike others, he listens issues and tries to address promptly. Last but not least, his given lab works and research papers turn to be very effective to be familiarized with various dba concepts.
    Arshad
    New York City, United States
  • Course: SQL Server DBA/TSQL
    Trainer: DANIEL
    I have gained a lot of information and ideas about SQL Server 2016 DBA/TSQL after attending this class. Thank you so much Daniel. You are such a friendly trainer.
    Sajita
    Charlotte, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Mr.Daniel
    Explain the topic in very clear way.
    Erfaan Mubeen
    Denver, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Great class!! Excellent Trainer!!
    Drona Poudel
    Council Bluffs, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    The training is comprehensive and well-organized. Daniel's expertise on SQL Server DBA/TSQL is outstanding.
    Arati
    Houston, United States
  • Course: SQL Server DBA/TSQL
    Trainer: GABRIEL
    The training was excellent .......
    ADEMOLA ELIJAH ADEWOLE
    Atlanta, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel is a knowledgeable and excellent trainer, who always stays updated with the developments in the upcoming versions of SQL Server. Imparted in depth knowledge and has a great course structure. He is just a phone call away !!!
    Majid Khan
    Dearborn, United States

Empire Data Systems

Social Links