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
    I really enjoyed your class it is very organized informative and helped me alot in current job. I will definitely recommend it and I will also be taking more classes in the future.
    Meklit. Tekle
    Tucker, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    He is friendly and knowledgeable trainer.and I recommend people to take his course.
    Esubalew
    Lithia Springs, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel is excellent training provider. He has great knowledge of the Subject and on top of that he has Excellent teaching skills that thing keeps students involved in the class. He explains real time scenarios. And the class is most interactive; he answers all the questions from all the students. He is very accurate on timings throughout the classes I never seen him a minute late. He spent extra time after the class to help students. Course covered all the topics you need to know for SQL server. There are so many training houses out there; they are just interested in getting money, after getting money they really don’t have interest in providing training. It is nothing like that in Empire Data System. I strongly recommend Empire Data System if you are looking for training in SQL Server.
    Ankit Patel
    Piscataway, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Danial AG
    Hi Danial. Thanks for SQL Serve DBA/TSQL training. Very good communication and friendly environment. Very calm and deep knowledge. Always ready to help. Thanks, Dipesh
    Dipesh Jasani
    Bethesda, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    I have been looking for a TSQL training for months but could not find one that fits my needs. but when i saw ad on sulekha for the Sql training and got lucky and chance to talk to the trainer, Daniel, I didnt waste any minute to register and get into the training. Thank you Daniel, keep up the good work. This is the best training I have ever got. if I missed my class he uploads 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. Daniel is very punctual and honest in his training.Thank you Daniel, keep up the good work.
    Rajesh
    Franklin, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    It was a good course. Daniel was friendly and engaging.
    Abdul Hafeez
    Fairfax, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Excellent hands on preparation for the job market.
    John Rockson
    East Hartford, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I really enjoyed this course. Daniel is very helpful and knowledgeable. I recommend to everyone.
    Dharmistha Goradia
    Bedminster, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Before taking this training I approached few other trainers, but after looking at detailed course content and experience that Daniel has I was impressed. Daniel is really easy going and knowledgeable trainer. He goes in to detail of every topic and simplify things so anyone can understand. All the tool that he is using are really easy to use and get trained. I would definitely recommend this course and wish you good luck to start your career in SQL!!
    Ankit Patel
    Charlottesville, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Mr. Daniel
    I really enjoyed the training with Mr. Daniel. It was very useful and informative. Although I have joined another training courses in different subjects, This one was the BEST of all. Mr. Daieal is knowledgeable, available most of the time, DB MASTER, and a great trainer. I have learnt a lot from this course. Thanks a lot, Mr. Daniel.
    Khiria Ali
    Longmont, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    There are too many good points to list about the SQL Server DBA/TSQL Training! Before I started with the training I was confused about database standards for a DBA, and criteria for Microsoft examination. Having completed the training I feel more confident. The syllabus was excellently delivered.Training objectives were all clearly explained and achieved. The Daily working sheets with SQL statements are advanced and very good for Practice. The individual working sheet is based on the topics discussed in class, and used in conjunction with good handouts. Class Labs, and Research Papers were very helpful. A very good mixture of theoretical and practical training. The trainer Daniel used many ways to pass on his knowledge to us, sometimes using real time scenario examples. He got the learning message across the class by breaking everything down into simplified sections. The trainer is very experienced and was able to answer all of our queries. He is a friendly guy and conveniently reachable via emails/phone anytime during the day. Enjoyed every single class of the Training and would recommend to anyone looking for a excellent training in DBA/TSQL.
    Rohini Patil
    Fort Oglethorpe, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Great course! excellent materials and presentations.Daniel is a very good teacher. I would highly recommend this course.
    Shilpa Yedla
    San Jose, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    This is a good,comprehensive SQL Server DBA training.Daniel is knowledge and friendly trainer.He shared many real time scenario ,so every student can understand easily.He has good patience to explain the douts of students.
    vandana
    Bellevue, United States
  • Course: SQL Server DBA/TSQL
    Trainer: AG Daniel
    Daniel decodes SQL for everyone to understand right from beginners. Without his training, I would have never gotten motivated to do the Certification. Thanks.
    Shree Raj
    Mooresville, United States
  • Course: SQL Server DBA/TSQL
    Trainer: DANIEL A G
    I am completely new to this kind of training as my degree is in electronics. But Daniel make it very easy to understand and helped all of us to gain knowledge of DBA. He has an extensive experience and that thing is really helpful for all students. I wish him best of luck !! Thanks !!
    NIRAV PATEL
    Horsham, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Worth to get trained here, as Daniel provides solution in depth of query, which cleared all my doubts and there no limitation on asking question regarding your concerns, he is punctual in his work and also help to provide solution besides class timing and finally, I am thankful that I got opportunity to get trained by him. Looking forward to attend SQL BI classes as well.
    Sameer Bhatt
    Weehawken, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    He has good communication skill and very knowledgeable!
    Desta Wako
    Columbus, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel A.G
    Great trainer with exceptional teaching skills. The way of teaching is really commendable because the topics are covered in such a simple manner which everyone can easily understand.
    Shilpa Siby
    Allentown, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel... I would just like to say thank you so much for the effort and expertise that you brought to the SQL DBA training program. I found the entire course a very practical, detail and professional in all respect. Though I missed a couple of classes and was a bit of behind due to my work schedule, I am pretty much sure this course will greatly benefit me in my career. I am now trying to grasp all your lectures following your videos for next few days and I do expect to join your next BI session. Please keep me posted on your forthcoming SQL BI training programs. Again, thanks for a great training experience.
    Haroon Hussain
    Chicago, IL, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Trainer has very open mind. Very punctual specially maintaining time, patient even repeated questions,excellent skill in explaining. overall whole course kept enjoyable. i will recommended any student can take his class with full confident.
    Sajeda yesmin
    Dulles, United States
  • Course: SQL Server DBA/TSQL
    Trainer: DANIEL
    Great training program for beginners and who wants to get certified in SQL server. I liked all sessions.Every session is very informative and in each session there was so much to learn and practice.It is good to have such a great teacher who is always willing to help and has so much command and knowledge of subject. Thanks Daniel.I have learned a lot!!
    JAYASREE
    Perris, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    I found Mr.Daniel very dedicated and Friendly Teacher he never ignored a question raised by any student and addressed and explained it in detail and upto our satisfaction.
    Usman Ahmad
    Fairfax, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Excellent training to be become a real time SQL Server DBA. No regrets. Thanks Daniel
    FrancisChumbow
    Towson, United States
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    very impressive training and trainer is very professional and he definitely have a very deep knowledgeable about SQL. I would recommend him to anyone.
    Sandhu A
    Quesnel, Canada
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Overall I have gained a lot of knowledge..!!
    Sai sharan reddy kandakatla
    New Haven, United States

Empire Data Systems

Social Links