We move! Starting September 1st, our QUEBEC CITY training center will be located at 5400, des Galeries Blvd, Suite 500, 5th Floor, Québec (Quebec) G2K 2B4
MS512

Optimizing SQL Server 2014 / 2016 Performance

97%

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
    • Montreal
    • Quebec City
  • Laboratory
    course

Objectives

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.

Prerequisite

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

Training Details

Content

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

    February 27 to February 28 2020

  • Quebec City

    February 27 to February 28 2020 - Virtual Classroom

  • Montreal

    June 10 to June 11 2020

  • Quebec City

    June 10 to June 11 2020 - Virtual Classroom

Trainer(s) assigned(s)

Other course(s) in this category