Tuning and Optimizing SQL Queries Using SQL Server 2012

מק"ט: #7083 | משך קורס: 16 שעות אק'

This two day instructor-led course teaches students how to optimize an SQL 2012 Server. The course discusses how to use the SQL Server tools to analyze the performance bottlenecks and how to optimize the queries and processing time, focusing on Indexes and Execution Plans. This is a very practical training with many Hands-On labs.

הקורס פעיל לקבוצות מטעם ארגונים בלבד, ניתן לשלוח פנייה רק אם מדובר בקבוצה
*שדות חובה
PDF version

קהל יעד

Professional database developers or database administrators who have at least one year of on-the-job experience developing database solutions. 


  • Deeply understand how indexes work
  • Analyze an execution plan
  • Suggest efficient troubleshoot methodology
  • Avoid common performance related mistakes

תנאי קדם

Have working knowledge with SQL Server. Such as, tables, stored procedures, views, data types etc.
Have basic monitoring and troubleshooting skills. Have basic knowledge of SQL.


משך הקורס

משך הקורס הינו 16 שעות


Unit 1: Analysis Services 2012 Architecture

This unit explains how the SQL Server utilizes memory, CPU and disks. Understanding the architecture is the key for understanding the root cause of the performance bottleneck.


Unit 2: Troubleshoot Methodology 

This unit provides an opportunity to the student to offer efficient troubleshoot methodology, to systematically solve problems or at least narrowing the potential list of performance bottlenecks.

  • Narrowing Down a Performance Issue to an Environment Area
  • Guidelines for Monitoring Database Servers and Instances by Using Profiler and Sysmon
  • Guidelines for Auditing and Comparing Test Results


Unit 3: Indexes

Deep understanding of indexes, when to use them and when shouldn't you use them.

  • Clustered vs. Non Clustered indexes
  • Indexes guidance
  • Fragmentation
  • XML Indexes
  • Indexed Views


Unit 4: Statistics and Execution Plans

In this unit, students focus on monitoring the actual usage of an index and its impact (if any) on the queries. Reading the execution plan guides the student whether more indexes should be added or maybe indexes are not necessary.

  • Understanding Execution plan
  • Adding missing indexes
  • Deleting unnecessary indexes


Unit 5: Dynamic Management Views and Procedure Cache

In this unit students will learn how to monitor the query execution and overall server performances using Dynamic Management Views. Good usage of the Procedure Cache can also help.

  • DMV overview
  • Query Execution related DMV
  • Caching and re-using execution plan


Unit 6: Programming Efficiency

In this unit students will learn how to avoid common performance related mistakes while writing queries.

  • Writing queries best practices


לפי יצרן: