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 is an excellent instructor, very patient and thorough. I have tried other online classes and his method far exceeds many trainers. The course was clear and detailed.Furthermore, he handled it with a good pace and order. Thank you so much!
    Bezawit Bogale
    Auburn, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    "This course was great, I highly recommend it to everyone . Daniel was super!!!! He made sure we were all at the same place, answered questions, provided super tips and information and got through everything extremely well. It was the best class I have ever taken on any computer program. I definitely will take other classes in the future.
    Sara Boukemara
    Winter Garden, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    The training was very helpful to me. I've learned a lot of things about SQL programming and Admin that will prepare me for my dream job. The method of teaching was very easy to understand. Thank you Daniel.
    Mulatu Megebo
    Columbus, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is an awesome Teacher . He is always willing to help. He will continue to explain things until you understand the information. He makes class interesting and exciting. I enjoy the class’s and I really recommend him to anyone looking for SQl server trainer . Thanks for doing a great job Daniel!
    Yodit Gebreamanuel
    Charlotte, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Course outline and the way of training was excellent. Get more then expected. Thank you for your wisdom, experience and personable presentation. Highly Recommended
    Maruf Raihan
    New York City, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Mr. Daniel is very helpful , his class is very interactive. You can ask question as many time as you can, he'll have patient to answer each time. He provides lots of examples and practice lab. Even after your course completion if you have question, he'll take time to answer your call. Thank you very much for your time and effort to teach us.
    Remika Rai
    Mobile, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel really helped me to make things simple to my understanding. I was amazed by how knowledgeable and informative he is. Exceeded my expectation and really recommend him to anyone looking for a great SQL Server Trainer !
    Betselot T. Gashareba
    Miami, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Was wonderful class and you are helpful and passionated guy. Thank you so much for you efforts!!!
    Amelmal huluka
    Charlotte, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is a awesome instructor he have very good knowledge and ability to give you a answer in a better way which is more understandable, he is a master in SQL Server, TSQL
    Gurpreet Singh Chattha
    Renton, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    The class was very good, the information was easy to understand and well explained.
    Randy K Adom
    Somerville, United States
  • Course: SQL Server DBA/TSQL
    Trainer: DANIEL AG
    I am very satisfy with this course and my tutor Mr. Daniel. He is very kind to students and never hesitate to give answers of any question. He always inspire us to ask questions and make greedy to learn new things.
    NIRALI SHAH
    East Windsor, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I was able to learn lot regarding SQL/Server, TSQL, DBA. Daniel was able to explain all the questions properly and all the material provided was really useful.
    yugal sharma
    Collierville, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    It was a very informative and educative course. Recordings were very helpful, which helped me go through it again to my complete understanding. Daniel answered all our queries, and his teaching techniques were really good. This training is much more than what it cost. I recommend this course.
    Mohammad Zahid Khan
    New York City, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    I really enjoyed the course content. Daniel is well rounded technically and explained well. This was definitely a refresher kind of course for me. I only wish i had one on one in class training and the timing was little earlier say starting at 8 PM. Wish we had a project to work on. Looking forward to more classes from Daniel.
    Pashupathinath Bangalore
    Wyoming, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel IS a SQL Server Guru! You WANT to take this course if you REALLY want to learn SQL Server. Daniel's approach to the course presentation is methodical and foundational in that the current class presentation builds on the previous. He is crystal clear in his presentation, is interactive with his students, and answers all your questions. The training you receive is well worth the price of the course. You will NOT be disappointed! I'm looking forward to taking more courses with Daniel--you will too!
    James Jakubowski
    Randolph, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is a fantastic instructor. His ability to teach complex database concepts in a simplified manner is commendable. I was new to SQL Server. But after attending his classes, I feel confident. I recommend his classed to every serious database learner.
    PIKUN PATTNAIK
    Edmonton, Canada
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    The class was important to me because, it gave me the understanding of how SQL SERVER DBA/TSQL help business operations to function in a way that, I didn't know. Also, the trainer (Mr. Daniel AG) was very knowledgeable, informative, very organized and professional at all time. I thank him for the knowledge he shared with me during the course period and I can't wait to refer student to take this wonderful and demanding career.
    Emmanuel K. Acquah
    Snellville, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Best tutor ever. His teaching techniques are very good. He is very patient and answers to every query. I learned a lot. I will recommend all my friends.
    Anisha Mohanty
    Seattle, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    My First experience in an Online training and it was superb. The fact that we can revisit the lectures through the recordings is an excellent Idea. Daniel's explanations are Organized and well thought, would definitely recommend.
    Brandon Daryl Wanji Wanmeni
    St. Catharines, Canada
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    If you are serious about learning SQL Server DBA/TSQL and looking for a great instructor, I highly recommend you to take this class with Mr. Daniel AG. The Training is worth much more than what it cost.
    Inil Rai
    Denver, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    This is the best SQL training I have had. I watched a couple of tutorials on youtube but Daniel is just the best SQL Server teacher I have listened to. This training is money well spent
    Abdulazeez Adejumo
    Edison, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Excellent Teaching Skills e,g.,The way Daniel expained 'Isloation Levels ',its amazing.
    Sudheer Chinta
    Raleigh, United States
  • Course: SQL Server DBA/TSQL
    Trainer: DANIEL
    Very interactive course.The Instructor is very patient and knowledgeable.The hands on labs are excellent.
    LEELA SATULURI
    Pembroke Pines, United States
  • Course: SQL Server DBA/TSQL
    Trainer: DANIEL AG
    Very informative and educative course.
    GEORGE KELECHI OGWURUMBA
    Dallas, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    It's amazing that even after so many years of teaching SQL Server/DBA, Daniel continues to receive new interest and students wanting to learn SQL Server. Daniel has excellent communication skills, is quite disciplined in how he teaches yet is quite approachable when students have any questions, etc! I have no doubt that Daniel will continue to provide the same level of excellence and care in teaching with his future students!
    Manoj Patel
    Little Rock, United States

Empire Data Systems

Social Links