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
    Daniel has very indepth knowledge in SQL Server and has explained every topic in detail. He is very patient to explain the doubts multiple times.
    Swetha Mainampati
    Edison, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel, the trainer, has a deep knowledge of the course, excellent teaching ability, and is a friendly person. The fact that he provides resources such as e-book, certification exams, exercise questions, research papers and recorded class video was so helpful to learn and understand the course even if you miss some of the classes due to work load. I recommend any one who is looking to learn Sql database admin to take the course with Daniel.
    Yosief Segid
    Beaumont, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Excellent Trainer
    Sittu Shakya Nakarmi
    Elk Grove, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    The Training is good. I had an exposure towards some new terminology of database world. Daniel is a patient instructor and of course straight forward in his response, he doesnt dawdle on saying things that he doesnt know or doesnt fake it...Meticulous about time...Thanks!
    mukta tiwari
    Marietta, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    One of the best trainers in SQL Administration.
    Divya Kondoor
    Hicksville, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    The teaching methodology and materials are acceptable. Keep it up with it!
    Berihun Belay
    Reynoldsburg, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    The class was easy to follow and very convenient with my schedule. I was able to follow at my own pace which is nice.
    Sivani Parbadia
    Alexandria, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    It has been a great opportunity to participate in your SQL Server 2014 DBA & TSQL Programming classes and gain out of the knowledge you tirelessly shared with us. The allocated time was properly utilized, trainees given all the chances for questions, explanations given to all points raised, etc. I don't know how long you have been as a trainer but you still are energetic with full potential. I really appreciate it and wish you all the best in your future plans.
    Aradaw Demberu
    New Britain, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    This training is very useful to me and learned many concepts. Daniel is very good trainer!!!
    VIJAY BANGARRAJU DANTHULURI
    Boulder, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Comprehensive course coverage.Delivered lectures are quite coherent, and easy to understand.
    Bibha
    San Jose, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is very professional trainer and i am glad i was a part of his DBA class.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 teacher.
    Ishrat Unissa Begum
    Chicago, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Very good trainer
    Tapan Parekh
    Mount Laurel, United States
  • Course: SQL Server DBA/TSQL
    Trainer: DANIEL
    Daniel did an excellent job at teaching the subjects.He has depth knowledge in TSQL and his teaching style is effective and the scenarios he provided were relevant. Overall I am happy with my experience . Thank you
    Tilahun
    Overland Park, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Great Class, Straight to the point. Prepares you for interviews very well! Thank you, Daniel!
    Igor Jacob Bugrovsky
    Decatur, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    I had a long hiatus since SQL 2000 and needed a refresh course and I couldn’t find a better teacher then Daniel. With his well-structured lectures and certification material which he provides, I think I be ready to take the certification exam shortly. If anyone is serious about learning SQL server in one and a half month then he is the right person to guide you.
    Deepak
    Pottstown, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I am writing to let you know how very pleased I am with the training I am receiving from Daniel AG at Empire Data system. Daniel is very knowledgeable trainer and he provides excellent study materials which helps me to understand the concept of the program. I recommend Daniel to anyone who is looking for SQL DBA Training. Thank you
    Tigist Abebe
    Orlovista, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is an excellent trainer with deep knowledge of the subject matter and vast experience. I am privileged to attend Microsoft SQL Server 2014 course conducted by Daniel.I have gained knowledge, tapped from his wide experience and become acquainted with the additional feature/capability Microsoft SQL Server 2014 bring to the world of SQL server administration. I appreciate Daniel for his unreserved effort for sharing his vast knowledge and wide experience. Keep up the good work.
    Nebiyat Desta
    Teaneck, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel A G
    Excellent training. It is really very hard to talk about any lacking regarding training. My heartily thanks to Daniel; because of his continuous lecture and frequently answer lots of questions to get clear to students. This is beyond my imagination. Thanks again.
    Jakario Gonsalves
    Elkhart, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    It was a pretty good training session. Intially I didnot have any knowledge about SQL but now I am pretty much perfect in it.
    Kishore reddy lingareddy gari Venkata
    West Haven, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Training was very helpful.
    Vaishali Aggarwal
    Somerset, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Initially I was bit reluctant to online training. Its my first online tanning and I must admit its one of the best and better then classroom training in many prospective like convenient timings, recorded sessions etc. Daniel is a gem. His knowledge and training skills is undoubtedly amazing and he is always approachable even after the class. Keep it up Dan. I would defiantly recommend this to DBA aspirants and defiantly like to join other related programs like BI in coming future. Great work EmireData systems team. Thanks Daniel.
    sanjeev vermaa
    Lucknow, India
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    The best training for 80 HOURS, and the best part is the training is excellent communication between the student and the trainer. Answering all the questions from the students help me more understand. I would recommend for student need clarity in SQL ADMIN. The hours is great. If there is any questions after the class, the response is quick.
    Rahel Belete
    Falls Church, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Michael
    Provide clear concept of DBA knowledge and hands one experience .
    Michael
    Syosset, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Akalu
    Daniel is a great instructor I ever had. He has a very good patient to answer and explain every questions in detail. All I can say is just keep it up! Thank you for everything you have done for us.
    Melaku
    Shawnee, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    The instructor has in-depth knowledge in that field and he always willing to spend extra time to help, very friendly understanding and professional. I had Excellent experience. sincerely, Tek
    Teklemarkos Teferra
    Washington, United States

Empire Data Systems

Social Links