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
    Trainer is very knowledgeable, good method of teaching and knows how to express a point detailly, friendly and always available, responding promptly.
    Bishoptheodore Dogo
    Morristown, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel AG is a very professional Database Administrator. I have learned a lot from his SQL Server DBA/TSQL class. I have enjoyed his class his teaching style and strategy. He is very knowledgeable person, especially in SQL Server Database Administration. I have asked him many difficult questions about SQL Server, which most people could not answer but he answered and explained in a great detail. There are two more classes SSIS and SQL Performance, which I am planning to take in feature. I recommend him for SQL Server DBA class.
    Jamil R Chaudhry
    Chicago, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Thank you for the wonderful training. I learned a lot. Couldn't ask for a better trainer. Daniel is number one out there!
    Raayan Sharma
    Reynoldsburg, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Thanks for this opportunity, the course was very good and I personally learned a lot even though it is new for me, and I hope I want continue participate in other related courses for the next ... I am sure I will recommend someone else to take that course. Thank you very much Daniel AG
    Yosef Belete Tegegn
    Charlotte, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I will place a detailed feedback later. For now, your class is super interactive and detailed. I think, its a excellent class.
    Abraham Endalamaw
    Kennewick, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I would like to say Thank you so much for Daniel AG. The training was very helpful and useful and effectively use his time. I really appreciated him. I defiantly sure I will continue the BI Class as well.
    Hiwot Tessema
    Arlington, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel is an excellent trainer for SQL.
    bipin Shrestha
    Oxnard, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is wonderful instructor. the way he present the matter is so clear and he is interactive with student. He make sure every single time that we understand everything, this is what I like most from him.
    Mulugeta Kebede
    Charlotte, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel was very good with the subject Matter. I did like his training. He explain every information very well and backs them up with real life experience. Will recommend him to everyone ready to learn SQL
    Beatrice Darko
    Charlotte, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Defiantly a place that worth your time and money Thanks/
    Tesfaldet
    Sandy Springs, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    The course met its objective. The content is well designed for aspired DBA’s. I am glad that I took this course. The hands on part is really helped me to build/improve my SQL/DBA Skills. I need to go back to the recorded sessions to revisits some difficult concepts. The training timeline made it possible to understand the course materials in depth. Daniel has clear understanding of the subject and the industry. This is reflected during the training. He patiently answered all my questions even after the class if needed. I am very happy that I took this training. It is totally worth it. I will strongly recommend to all my friends.
    Shabana Hoque
    Walnut, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel is the best trainer I ever seen. I did get training from some where else but it was not good compare to Daniel. I recommend to anyone who want to be SQL server DBA class in future, this is the place where you can take a class.
    Manish dubey
    Philadelphia, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I can say many thing about Mr.Daniel , I would say this , 'He keeps his word'. He has a full passionate, energy and Absolute knowledge. Thank You!
    Abdurezak M Abdelkader
    Richmond, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel A.G
    Daniel is the best trainer .The way of explaining is wonderful. I will recommend who ever interested for SQL server with DBA training join here.Thanks Daniel.
    Pushpa Akula
    Lexington, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Excellent Training, I will definitely come back for more
    Samuel Bekle
    Snellville, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is the best trainer I ever seen. I did get training from some where else but it was not good compare to Daniel. Also, the great thing is you can work on real time database.he is always ready to answer your questions.he explains same topic again and again till you understand it clearly. I would love take teaming from him again in future for advance SQL.
    Miral D Patel
    Chicopee, United States
  • Course: SQL Server DBA/TSQL
    Trainer: DANIEL A.G
    Well i can honestly say I've learnt a lot considering having little knowledge coming into this training.Daniel is amazing, the way he takes time to give step by step explanation and he answers all questions.
    ALIYU KOLAPO ABDULKAREEM
    Elmhurst, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I recommend to anyone who want to be SQL server DBA in his/her future, this is the place where you can take a class. Daniel, the best teacher. He gives equal value to every small question you can raise and provides detailed answer. A lot of class materials including class notes and recorded class vedios.
    Asrat D. Malako
    Los Angeles, United States
  • Course: SQL Server DBA/TSQL
    Trainer: DAniel
    Daniel is good trainer. I like the way he explain all thing in the training.
    Preksha patel
    Columbus, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Great training! Knowledgeable trainer, worth the many I paid and the time I spent. Highly recommend for anyone .
    Zenahibzu T Legesse
    Swansea, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    The course is world class, excellent. For someone who is a Prod SQL DBA, it is very helpful.
    Frank Zhou
    Stamford, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is certainly the best SQL SERVER DBA trainer out there. He use clear and interesting examples to teach his material. The course content is interesting, level and depth of information is just right. I'll be back for more!!
    Ousman Ceesay
    Stillwater, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    I really enjoyed the training, very detailed and depth on the course. I will def recommend to a friend. Thank you
    Amanuel Agared
    Akron, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Awesome teaching. Just right Course Content, terrific explanation of concepts and demonstration. I am an Oracle DBA for life and needed to get familiar with the SQL Server, so took this course. Glad i took this class, Daniel did a great job and exceeded my expectations. He explained in detail every single i question i had, i certainly recommend this course for anyone looking to get into SQL Server. Thanks Daniel !!
    Surya Mandapaka
    Philadelphia, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Very good course. Daniel is always on time and willing to answer any questions
    Omotunde Adeboye Damilola
    North Plainfield, United States

Empire Data Systems

Social Links