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
    Very nice trainer ,friendly and in depth knowledge but litile expensive course and lengthy training period.
    nikhila
    CARLISLE, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: DANIEL
    "Daniel is the best trainer I ever had. He knows what his students want. I strongly recommend somebody who is looking for SQL DBA."
    RAJU BK
    GWYNN OAK, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Excellent Training and very knowledgeable on the subject.
    Sudheer
    HOMEWOOD, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel A G
    Great trainer kudos !!!
    eliud maina
    CHARLOTTE, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Watched some you tube material for the trainer ,Having Little Knowledge about SQL Server the trainer gave that confidence and explained vividly hence eliminated the fear of unknown in SQL BDA World
    Eliud Maina
    CHARLOTTE, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Baiju
    No doubt he is #1 trainer in USA. I thoroughly enjoyed as well as learned a lot.
    Sunita
    DALLAS, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel A.G
    I believe that Daniel is one of the most reliable asset for the students as well as the best resources in the working environment. He is very organized and inspired students by applying his amazing skills and experiences.He has extensive knowledge of SQL Server. He has the ability to break a complex idea and present them in a very simple manner which student can easily understand. His presentation is amazing. He answers the students' questions with examples so that students can understand the concept clearly. I love his interactive style in class. His communication skills as well as his presentation skills are amazing. He delivers exceptional support and guidance even after class hours. If anyone needs to find a job or to have knowledge in the working environment, or company to train employee in the database system, I am truly and highly recommended Daniel AG is the right and powerful professors to teach Server 2012 DBA at Empire Data Systems LLC”
    Getieneh Workneh
    PITTSBURGH, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel A.G
    Very good teacher, I was nervous at first but, I am very glad I took the course and I plan on taking more in the future.. Thanks Daniel.
    Reshma Syed
    PLANO, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: DANIEL AG
    Daniel is very knowledgeable & well experienced with very good approach. He is a great mentor & like what he is doing. I am planning to take SQL/BI course very soon ... thank you again
    MESFIN MENGISTU
    WALLINGFORD, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Danial AG
    A no-nonsense, cut to the chase, comprehensive SQL server DBA course that will fill your appetite.
    Atiqul Islam
    ELMHURST, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    I was skeptical when I signed up for the course but i was wrong.. I am so glad I found Daniel for SQL training. He is very knowledgeable,excellent communication skills, repeat the concepts few times in different ways and takes time to make sure you understand the concepts. He has no issues in staying after the class to answer your questions or concerns. I am planning to take another course and hope i have the experience there
    Anuradha Shrivastava
    SAINT LOUIS, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel is very knowledgable ,sincere ,step by step approach trainer who makes the students to understand the concept of SQL server /T-SQL very easily even if the student doesn't come from the computer background.I like to refer for the future students who wants to update the skills or learn from the scratch.
    Sharmila
    KNOX, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel is a great instructor! You need his style and breadth of knowledge.
    Elizabeth
    BALTIMORE, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: John
    Undoubtedly, the best trainer you could get in the SQL Server World. If serious about learning or in enhancing your SQL Server skills, I urge everyone to get trained from this architect.
    Bency
    SUGAR LAND, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: DANIEL
    The best trainer ever with good knowledge about sql/dba. planning to take the business intelligent class soon.
    EDDIE EFFIONG
    PHOENIX, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel... I took your SQL Server 2012 DBA class and now I am taking your BI class. I doing an internship as database developer and I took your classes to develop myself. I got an interview to attend a full time job as junior database developer. The day before my interview i just went through all your videos, in the interview i was asked questions from joins,index etc and I answered the way you taught in the class especially the Venn diagram example for joins and they were impressed with my answers. I got the job!!!!!!!!!!!! Infact it was my first interview in U.S Daniel, I just attended it for experience purpose and I got the job. Your classes helped me a lot in my career. Thank you so much for your classes. Thank you ........
    Sabitha Balaraman
    NewYork, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel is well organized and has commendable professional approach. He is a good resource person in his field of specialty (SQL DBA). With no hesitation I recommend him for any one interested to share his rich experiences. Thank you Daniel
    Zinabu
    SIOUX FALLS, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    I have really enjoyed the class and have learned a lot from Daniel's courses. He delivers on his promise. His teaching style and technique makes even the complicated topics easier to understand. He really is very knowledgeable and always very open to any concerns. He provides as much material as possible, which was really appreciated. He creates a very friendly and professional environment. He is a true academic who really cares about his students learning. I would recommend Daniel and his courses to anyone who really wants to learn. Thank you Daniel! Looking forward to taking another class!
    Monna
    LEESBURG, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel is very good Trainer.I would highly recommend Daniel's classes to anyone who wants to get an in-depth understanding of concepts in SQL Server. Best Training I have ever received.
    Senthil
    WEST MILFORD, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel has great knowledge on MS-SQL Server/T-SQL.I would highly recommend Daniel's classes to anyone who wants to get an in-depth understanding of concepts in SQL Server. He is an excellent teacher who always goes out of the box to make sure everyone in his class follows what he teaches. I have learned a lot from his classes.
    Mini Gupta
    WATERFORD, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel A G
    Daniel is a true professional. He is Excellent, vast knowledge in subject, good interpersonal skills. His approach towards training session is very sharp with a friendly mind. I highly recommend attending Daniel’s class is worth to lead your professional carrier. Once again thank you DANIEL.
    Abey Abraham
    STATEN ISLAND, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel is very knowledgeable and seasoned DBA who has lot of skills that he shares during his class. I had several other training in different fields from different instructors but so far there is no one as good as Daniel. The price is also very competitive and training is top notch. I am glad I took training with Daniel.
    Dhananjay
    LAWRENCEVILLE, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    Daniel made me a SQL Server Administrator. It was when I was working as Oracle DBA in philadelphia that I was thinking of getting knowledge on SQL Server administration along with that. Since I had some bad experiences with the online classes I was very skeptical about choosing one. After talking to a previous student of Daniel I decided to join in his SQL server DBA class. I have completed the class and is already practicing SQL Server and getting offers from market as Hybrid DBA. This was the best online class I have ever taken in my life. He had made it so clear and simple with lot of opportunities for interaction. He is a great teacher who is not just concerned about finishing the topic but also gives a lot of guidance and his expert opinion on various avenues and job opportunities. It was a real pleasure to be in his class. He is a blessing for people like me who is working in IT and looking for further improvement and who wants to get updated with their technical skills. I am looking forward to join with him on other classes like informatica and sharepoint.
    Jacob Konginiparambil
    LAS VEGAS, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel AG
    Daniel is an Outstanding Trainer, 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 for the value he provides and he is worth it.
    Moses Kota
    Houston, Texas, UNITED STATES
  • Course: SQL Server DBA/TSQL
    Trainer: Daniel
    the best training i ever had..., i liked the Trainer approach, his knowledge of the subject and friendliness made the training interesting. surely i will be back for more topics in SQL server. Thank you Daniel
    Yohannes T Anbese
    CAPITOL HEIGHTS, UNITED STATES

Empire Data Systems

Social Links