Optimizing SQL Server 2008 / 2012 / 2014 Performance


overall satisfaction for this course

?Average calculated from scores obtained from 236 participants who took this course.
  • Duration 2 days
  • Regular fee 895
  • Preferential fee 750?
  • Locations
    • Montreal
    • Quebec City
  • 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

Many useful advices and tricks for effectively optimizing the database performance.

Benoit R. / Chef d'équipe, Systèmes d'information, Addenda Capital Inc.


  • 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.
  • Montreal

    November 23 to November 24 2016

  • Quebec City

    December 12 to December 13 2016

  • Montreal

    March 6 to March 7 2017

  • Quebec City

    March 29 to March 30 2017

  • Montreal

    July 5 to July 6 2017

Trainer(s) assigned(s)

Other course(s) in this category