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
    No #1 SQL Training School of USA.
    Kiran
    Mount Laurel, United States
  • Course: SQL Server DBA/TSQL
    Trainer: 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. I see that many database architects with over more than 16 years of experience and doesn't have the knowledge that you have.I really enjoyed your classes, definitely look forward to learn more from you in the future. 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
    Gurpreet Kaur
    Clifton, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Very knowledgeable of subject!
    Temi Giwa
    Richardson, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Generally it is an excellent training which i recommend for anyone interested on SQL Server DBA/TSQL carrier.
    Woinshet
    Spring Valley, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Akshay Jain
    Overall the training was great and well worth the money. Akshay did a wonderful job ....
    Danielle Crumpler
    Tonami, Japan
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is a very good professional and friendly trainer. He always ready to give answers of any student's questions. He has positive and good approach with the students. I have learnt a lot from him. He had discussed with us many real environment examples related this DBA course too. Thank You.
    Priyanka Gopal Patel
    Derry, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is a great trainer with depth knowledge. he always confirmed that students getting the right context what he's delivering and always stand for extra help and support. i definitely recommend to folks who really wants to learn.
    Dildar Chowdhury
    Jersey City, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    The class was very much worth it for me and will definitely recommend to anyone interested.
    Cornelius Djameh
    Washington, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    I enjoyed every single bit of the class. He made the concept very practical to understand
    Ernest
    Farmington, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel G
    Daniel is very professional trainer and I am so glad that I was part of his DBA 80 hours training Class in a suitable time schedule .His way of teaching is extraordinary awesome. He teaches in such a way so that every student can understand well. His course content is in a very detailed manner and I would highly recommend Daniel to be your DBA Trainer. If anyone planning to get trained in SQL DBA/TSQL. This is the place and don’t miss the opportunity…
    Alex Symon
    Mercerville, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Very Good Trainer. He tries his level best to make you understand the concept crystal clear. Highly recommended.
    Nisha Jaiminkumar Gorasia
    Raleigh, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel you are truly a great teacher. You possess a great deal of knowledge of the subject you teach and most of all you know how to pass that knowledge on to your students. Thank you so much.
    Hiwot Tilaye
    Kent, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    This is the best training I have ever got. if I missed my class someday he provides us recorded video so I was able to catch up on my classes. I would recommend if anybody wants to take a SQL or database class you should take the class with him. I swear you don't go wrong and you actually learn about the SQL. he is very friendly and helpful. he helped me a lot. Thanx a lot Daniel.
    Bimlesh Karn
    Hudson, United States
  • Course: SQL Server DBA/TSQL
    Trainer: DANIEL
    I would recommend the SQL DBA and TSQL training session to any SQL DBA aspirant as the training material designed and delivered by the trainer Daniel is comprehensive and exhaustive. Daniel not only makes sure that all the students in his class get it right but also extends additional help and support beyond promised to make sure that the topic is understood completely even if the student doesn't have any prior knowledge or experience.That is the beauty of his delivery and in-depth knowledge about the subject. Gopal..
    GOPAL
    Elmhurst, United States
  • Course: SQL Server DBA/TSQL
    Trainer: DANIEL AG
    I have been looking for a DBA & TSQL training for months but could not find one that fits my needs. but when a friend recommended empire data systems for the dba training and got the chance to talk to the trainer, Daniel, I didnt waste any minute to register and get into the training. I found the training and the trainer very engaging and fulfilled my expectation. I recommend empire data systems and Daniel for the DBA & TSQL training for anyone new to the field or someone who wants to refresh their skills. Thank you Daniel, keep up the good work.
    TESFALEM T ARAIA
    Uvalde, United States
  • Course: SQL Server DBA/TSQL
    Trainer: daniel
    good every thing
    ibsa
    Saint Paul, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel Craig
    Its very good.
    Devarapally Ashok Reddy
    Bloomington, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    In such a short interval of time, one can learn a lot in such an efficient way. You are a very dedicated trainer. The only problem I faced is sometimes you speak fast, that it's difficult to match you in that sentence. Except that, you are just brilliant in your teaching, knowledge, the material you provided and you always show supportive hand to your students. Thank you.
    Prabhjot
    ,
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel's comprehensive DBA/TSQL training was very thorough, clear explanations and methodical. I took training from other people before but should say Daniel's is the best. He is very sincere and has tremendous patience in explaining doubts repeatedly. I highly recommend him.
    Sudha S
    Chicago, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is very good trainer and I learn sql course in detail in 2 months with practical examples. I am very great full to you for giving such a great training.I am so happy that I found you.
    Payal Patel
    Monmouth Junction, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Very nice and elaborate training for SQL Server DBA. The best part is that Daniel is very approachable and available to work on students issues.
    TKhan
    Penticton, Canada
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Excellent..
    Vaidehi Patel
    Pompano Beach, United States
  • Course: SQL Server DBA/TSQL
    Trainer: SQL GURU Daniel
    I am not referred by any friends to join this course but I simply observe his first Email containing all weblinks & also feedback on that web links. After talking with him over phone, He gain my trust, there are no second thought & I join course. I don't want to say much whatever said below feed backs is 100% right & Daniel Prove that "The BEST teachers teach from the HEART".
    Jignesh Patel
    Coral Springs, United States
  • Course: SQL Server DBA/TSQL
    Trainer: AG Daniel
    If anybody wants to get right DBA training, Daniel is the best choice. Daniel is very honest in his training.
    Kamran A. Baig
    Newark, United States
  • Course: SQL Server DBA/TSQL
    Trainer: DANIEL
    It was a great experience
    Ramanpreet Singh
    Montreal, Canada

Empire Data Systems

Social Links