MS512

Optimizing SQL Server 2008 / 2012 / 2014 Performance

96%

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
    course
Parcours

Formation path :

Databases Training Paths

View path
SUMMARY
DETAILS

Objectives

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.

Prerequisite

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

Customer Testimonials

Very dynamic, relevant and well-explaned informations.

Anca C. / BI Developer, Université McGill

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

    September 7 to September 8 2017

  • Quebec City

    November 16 to November 17 2017

  • Montreal

    December 13 to December 14 2017

Trainer(s) assigned(s)

Other course(s) in this category