Optimizing SQL Server 2014 / 2016 Performance


overall satisfaction for this course

?Average calculated from scores obtained from 280 participants who took this course.
See the training dates
  • Duration 2 days
  • Regular fee 955
  • Preferential fee 860?
  • Locations
    • Virtual Classroom
  • Laboratory


To provide the knowledge and skills required to optimize MS SQL Server 2014 / 2016 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).

Training Details


  • 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

Customer Testimonials

Very good trainer, gives many concrete examples.

Denis P. / Programmeur informatique, Groupe Lacasse

Select the training date*

*Unless stated otherwise, all sessions are in French.
  • Virtual Classroom

    November 9 to November 10 2020

Trainer(s) assigned(s)

Other course(s) in this category