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
    Daniel has excellent knowledge, very well explain on each topic. If any student didn't understand anything he was kind enough to explain it again. All I can say this is the best training I ever attended.
    Hemant Shah
    Naperville, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    U the best Daniel.
    Eyuel
    Warren, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I really loved learning/taking the SQL Server DBA/TSQL course from Daniel. It was a great experience. He's very Thorough, professional, personable and very friendly. He has an Indepth subject knowledge in this field and would answer any question no matter how silly or tough it is...I would sincerely recommend him to anyone who is planning to take SQL Server course and could come back to him again if I need to take any other course in future. Thank you
    Sachindev Janardhan
    Roswell, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel, Thanks for the wonderful training provided.
    Archana Malneni
    Lexington, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    He is good and professional trainer.
    Mussie Berhane
    Dallas, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    I took the training course on tsql + dba from you this summer, started in June and ended on august 30th. Just wanted to inform you that I have passed the exam for MS 70461. Really wanted to thank you for offering such a wonderful training course.
    Rohini Patel
    Quakertown, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Danial
    Daniel continues to be excellent in your online teaching. He is a teacher who devotes a great amount of personal effort and interest to your regular teaching activities. His contributions to the first-time implementation of MSSQLServer 2016 update to this course contributed significantly. Above all, he remain open and receptive to comments and suggestions as to how your teaching can grow and improve. For me, EmpireData Systems provides gateway to make successful path in SQL DBA
    Vik Patel
    Bangalore, India
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    It was an excellent training with great communication skills and comprehensive course material. Very good exercises and assignments. I learned a lot related to SQL Server.
    Neha Jain
    Uniondale, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Will recommend to everyone
    Prakash
    Fort Collins, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Ajagba's
    Good teacher and student relationships. Excellent teacher. Am happy I was in his class. Thanks Daniel
    Chioma
    Buford, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Due to the change on my work schedule I didn't attend some classes But the video records and worksheets which will be emailed for every student after the end of the class is very supportive and make me follow my class when ever its appropriate for me . I consider myself very lucky to be trained by Daniel, he is well educated,professional and patient. He is also perfect on his communication skill this helped to understand each and everything plus makes me more interested every time. I highly recommend Mr. Daniel's classes. thank you
    samrawit Chernet
    Medford, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Great mastery of the curriculum taught. Couldn't ask for more. The one thing I struggled with was the use of acronyms and abbreviations that are very strange to non IT background students. If a handout can be made with common acronyms and abbreviations in the IT field that will make the training perfect for students without an IT background. Nevertheless, f]great job Daniel. Will be referring many others to you. Many thanks.
    Stephan
    Cambridge, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Great Approach and great course
    Kareem Khalil
    Richardson, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Mr. Daniel is a very good teacher. His explanation technique is easy to understand. I wish him best of the luck.
    Raihan Hoque
    Flushing, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    I heard you were the best trainer for SQL/DBA from my friend so i approached you and i completely agree with him and much more. You are the best.
    Praveen Reddy
    Waco, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel Ag
    Awesome Awesome Awesome Experience.I m so happy after attending this course. For Daniel: you are best trainer seriously.
    Sonam Shah
    East Newark, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel is very good trainer. The trainer is very detail oriented. All the questions asked during training and after training are answered in details.
    Bhumi Patel
    High Point, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel Ag
    I wish we didn't get to finish line of the course becouse I have never seen a teacher with Same tone,patient ,friendly,always wanting to explain ,ready to take students question,always willing to explain until students gets the point from start to finish of the course He is the number one teacher in SQL by far God bless you
    Ablene Seyoum Gebretsadik
    Elkridge, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    This is the first time I taking a class online for DBA course on SQL Server 2016 with Daniel AG, EmpireData Systems, the experience of getting training is unique to me. I am very pleased with the comprehensive course content and the way every topic is taught by Daniel AG. The instructor is highly experienced and very knowledgeable, provides training at a good pace, and most importantly, he is very good at communicating and ensuring all questions are answered. I would definitely recommend to others to take this course with Daniel AG and I hope I am going to attend more training classes with EmpireData Systems near future.
    Farzana Nazir
    Bristow, United States
  • Course: SQL Server DBA/TSQL
    Trainer: AG Daniel
    This guy knows his stuff. I appreciate the willingness to spend extra time with students to help them out with their problems. Thank you
    Solomon Okhifoh
    Red Deer, Canada
  • Course: SQL Server DBA/TSQL
    Trainer: Mr.Daniel Ag.
    I got an incredible knowledge of SQL Server DBA/TSQL with in this short period of time.Thanks my instructor you are gifted and hard worker who can be model for others too.
    Zertihun Wodajo
    Circle Pines, United States
  • Course: SQL Server DBA/TSQL
    Trainer: DANIEL
    .
    DOLAPO ODUSAMI
    Jonesboro, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    It was awesome experience during Daniel's Training. He is very friendly with all students. I was really impress that he was helping us in every tiny problems. He also answer our questions anytime on phone and also extend sessions to explain briefly whenever we needed. He never hesitate to explain any issues repeatedly. He covered every topics for SQL server/DBA training.
    Khushbu Shah
    Sugar Land, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is very good teacher, he is friendly and easy to talk to. He knew what is is teaching and well organized. I am glad I took his class. I just want to say Thank you!
    zelalem Mekonnen
    Fairfax, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel knows his material well and also well organized. He made learning SQL server interesting.
    Devin
    Hicksville, United States

Empire Data Systems

Social Links