Optimizing SQL Server 2008 / 2012 / 2014 Performance


overall satisfaction for this course

?Average calculated from scores obtained from 254 participants who took this course.
  • Duration 2 DAYS
  • Regular fee 945
  • Preferential fee 795?
  • Locations
    • Quebec City
    • Montreal
  • Laboratory

Formation path :

Databases Training Paths

View path


To provide the knowledge and skills required to optimize MS SQL Server 2008 / 2012 / 2014 to get the highest possible performance for complex and/or high-volume applications.

Targeted audience

Database administrators and developers.


Experience with MS SQL Server 2008 R2 administration (Courses MS509).

Customer Testimonials

Excellent training. A lot of information and examples relevant to my work.

Stéphane S. / Analyste, Comm. scolaire de la Seigneurie des Mille-Iles


  • Introduction to performance optimization: physical design, load analysis
  • MS SQL Server storage mechanisms: files, FILEGROUPS, extensions and pages
  • Indexes: creation, options, structure, parameterization
  • Indexed views, partitioned views and partitioned tables
  • The role of the optimizer: how it works, query optimization
  • Refining queries: the query execution plan and execution statistics
  • SQL Server and VMs
  • MS SQL Server with Windows: CPU utilization, virtual memory management, RAID disks
  • Transactions and locks: exclusive and shared, range, page and table locks, isolation levels, hints
  • Performance monitoring, stored procedures, perfmon, alerts, MS SQL Profiler
  • Using the Database Engine Tuning Advisor
  • Maintaining indexes (defragmentation) and statistics


*Unless stated otherwise, all sessions are in French.
  • Quebec City

    July 3 to July 4 2018

  • Montreal

    October 9 to October 10 2018

  • Quebec City

    November 7 to November 8 2018

Trainer(s) assigned(s)

Other course(s) in this category