MS512

Optimizing SQL Server 2014 / 2016 Performance

96%

overall satisfaction for this course

?Average calculated from scores obtained from 254 participants who took this course.
  • Duration 2 days
  • Regular fee 955
  • Preferential fee 860?
  • Locations
    • Montreal
    • Quebec City
  • Laboratory
    course
SUMMARY
DETAILS

Objectives

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

Customer Testimonials

Very good trainer, gives many concrete examples.

Denis P. / Programmeur informatique, Groupe Lacasse

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

DATES*

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

    February 21 to February 22 2019 - CONFIRMED

  • Quebec City

    February 21 to February 22 2019 - Virtual Classroom

  • Montreal

    June 10 to June 11 2019

  • Quebec City

    June 10 to June 11 2019 - Virtual Classroom

Trainer(s) assigned(s)

Other course(s) in this category