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
    It is well structured course covering a lot of topics from basic t-sql to DBA topics and the instructor discusses about architecture whenever necessary. I would recommend this course and this instructor to everyone looking to learn basics of T-SQL, SQL Server development and DBA. Daniel is very passionate about teaching, subject and students. It is very well organized online training with lot of interaction and good connection which makes you feel like you are in a real class. Daniel is so patient with all the questions student(s) have; whether is during class, after class or any other time. He always responds back and has philosophy of "no question is silly or unimportant" and encourages everyone to ask questions. I would say this course is a lot more worth than its cost.
    Chandana Mukka
    Brooklyn, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Great SQL Guru. Very passionate at what he is doing. He has covered his syllabus in-depth and always ready to clear any of the doubts. Videos and all materials provided are excellent. I would highly recommend to everyone who is seriously thinking to get trained into SQL DBA and he is right "You will never be disppointed".
    Pinal Shah
    San Jose, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    " Daniel is a strong, dedicated and committed trainer. He is very talented and passionate about his training.He has a lot of patience in explaining for students and also has a strong relationship with his students. I would strongly recommend him for those who wants to take SQL server DBA/TSQL." Thanks Daniel.
    Eshetu
    Portland, United States
  • Course: SQL Server DBA/TSQL
    Trainer: DanielAG
    Daniel is a very professional trainer and I recommend him for any body who interested in SQL DBA\TSQL training.
    Negede
    Reston, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel has an excellent way of explaining database topics. Concepts that I had struggled with for years suddenly became clear to me when I took his training. And he is a model for customer service. He is so patient and even is available before and after the class if people have additional questions and issues. Thank you so much, Daniel!
    Michelle Rosenaur
    Burlingame, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel's training is the best I've ever taken and I've taken over 20 different trainings over the years. His style makes even the most difficult Topics easy to understand and also shares is his industry knowledge. He teaches with a passion and shows interest in every students success. GREAT TRAINER WHO TEACHES EACH TOPIC TILL EVERY STUDENT UNDERSTANDS. NOT TO MENTION THE TUITION IS SO MATCH AFFORDABLE.
    Will Larbi
    Burlington, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel A.G
    Daniel is an excellent trainer/great tutor.He has in- depth knowledge on MS-SQL Server/T-SQL. He is well-organised,patient and very accommodating. I strongly recommend Daniel for students looking out for training in SQL Server.I would highly recommend Daniel's classes to anyone who wants to get an in-depth understanding of concepts in SQL Server.
    AnithaAjith
    Houston, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel is a great trainer with thorough knowledge in the subject. He has lot of patience in explaining students queries during and after the class hours. I would recommend this training for those who are new to SQL like me.Thank you Daniel for wonderful training program.
    Rashmi Nanjundappa
    Huntington Station, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel is an excellent and a wonderful trainer. I strongly recommend Daniel for students looking out for training in SQL Server. He is really patient and explains each concept in detail
    Pratyusha
    RICHMOND, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel A.G.
    Daniel is full of effective teaching skills (Knowledge of the Subject/Passion for teaching/Strong relationship with students/ great listener / open for questions / clear instructions with real time examples). He always committed and dedicated to his work during training sessions. I would like to appreciate his prompt responses to his students via email/text or phone calls. He is really concern about his students and always helpful.
    Thilina Palliyaguruge
    HARTSDALE, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel A.G
    “Daniel is an excellent instructor,he clarifies the queries at any point of time and I have learnt much than I have expected.The training is really useful for students. I would recommend taking this course.”
    KeerthyKousalya Cittineni
    NEWARK, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel is very good at what he does, no doubt he is an Sql server DBA guru.Very patient and he takes time to clear any questions you may have about the subject. Always available and very friendly. Would recommend taking this course.
    Bhagi
    LOS ANGELES, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: DANIEL AG
    Daniel is an excellent instructor no doubt about it. I was referred by one of my friend to take Daniels class, I really learned a lot , and looking forward to take more classes offered by him. I was searching for a good instructor for a long time, finally I found a very good instructor like Daniel! Now a days its hard to find a good teacher but I am proud that I got a chance to take class with Daniel.
    FATEMA ZOHRA
    LITTLE ROCK, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    A friend recommended this class to me, and I am just speechless on how effective, knowledgeable and patient Daniel is. I learned more than I hoped for and I already passed 70-461 Exam and am taking next one at end of this month. His guidance and videos are extremely helpful and I would recommend this class to anyone and everyone wanting to really grasp SQL and SQL Server. I definitely plan on taking more of them myself. Thanks Daniel.
    Aida B.
    CHICAGO, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: A.G.Daniel
    Daniel teaches the subject indepth with real-time examples.He also clarifies the students' queries at any point of time.The training is really useful for students to excel well in real-time work environment.I would recommend Daniel's training program to new aspirants of SQL DBA/T-SQL.
    J.Chandra Shekar Reddy, Doral,Miami,Florida,USA.
    MIAMI, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel A G
    Daniel is an Outstanding Trainer, Sr DBA well versed with deep and extensive SQL SERVER Knowledge + Experience. He makes sure everyone understands the Concepts and is very accommodating. Highly recommend Daniel's classes to anyone who wants to get an in-depth understanding of concepts in SQL Server.
    Aju Johnson
    WEEHAWKEN, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Very good. The subject matter was presented clearly and concisely and held my attention. Mr. Daniel AG was very passionate about his subject, talented, experienced and his approach was very friendly. I defiantly recommend others for this course.
    Suresh Paruchuri
    LONDON, UNITED KINGDOM
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Great Instructor. Daniel had a lot of patience with the student and He was very willing to answer any and all questions. Presentation was clear and concise. Extremely knowledgeable in all topics covered. Material was great. The training was a big success, overall very happy with the class. I learned a lot more than I had hoped for. “Thank you for all your help. Excellent class!!!”
    Assefa Yoseph
    ALEXANDRIA, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel Sql Guru
    Sql Guru Daniel is an excellent trainer with lot of patience and in depth knowledge of SQL. Priceless Class
    Nazir
    COLUMBUS, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    A course which is too affordable not to take and grow in your field. Daniel is just amazing with his knowledge, patience and guidance. Haven't grown alot in terms of DBA and SQL knowledge in the last 2 months - Daniel you are THE BEST. It is amazing how much the TRAINER knows about his field and the guidance he provides to any queries related to Database. A must take course for any one dealing with Database...for the price/knowledge you get it is simply unbelievable.
    Maria Pinto
    DORAL, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Best Trainer..he is extremely good and well experienced mentor
    Nikhila
    ATLANTA, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Excellent training , Me as a beginner was able to understand and gain lot about the subject. Daniel is very professional.
    Satyabhama Pandyaram
    ALPHARETTA, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    If you really want to get what I call the Total Package (i.e. In-depth knowledge and Affordability) then this is the right place to get trained. Daniel knows his stuff like you the back of your hand and he shares that knowledge with the student. Before I took this class, I read some of the testimonies on here and I was a bit skeptical about the high praises being showered but it was only a matter of time to for me to realized that the glowing testimonies are indeed true. Don't hesitate at all to take the class, you will be smiling.
    Richmond
    MINNEAPOLIS, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Excellent in-depth training
    Chintan
    HOUSTON, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel G
    Daniel is an excellent trainer with lot of patience and in depth knowledge of SQL. The course was well planned and great value for money.
    Shahbaz K.
    SWEETWATER, UNITED STATES

Empire Data Systems

Social Links