MS550

Optimizing SQL Server performance: advanced

  • Duration 2 days
  • Regular fee 945
  • Preferential fee 795?
  • Locations
    • Montreal
  • New course
  • Laboratory
    course
SUMMARY
DETAILS

Objectives

To provide the knowledge and skills required to optimize MS SQL Server 2012 / 2014 / 2016 databases when you queries cannot be modified.

Targeted audience

Database developers and administrators.

Prerequisite

Experience in MS SQL Server administration (course MS509) ou (course MS512).

Content

  • How statistics can affect query performance
  • Reading statistics
  • The mathematics behind statistics
  • Understanding how to evaluate your SQL server: metrics to use
  • Understanding the different Waits: ASYNC_NETWORK_IO, CXPACKET, PAGEIOLATCH ,SOS_SCHEDULER_YIELD and WRITELOG
  • Reading execution plans
  • Using Plan Cache for finding problematic queries
  • Analyzing slow queries: missing indexes, implicit conversions, parameter sniffing, predicate issues
  • How SQL Server uses indexes
  • Clustered and Nonclustered indexes
  • When to use inclusive indexes, filtered indexes or calculated indexes to accelerate queries
  • Optimizing indexes using Plan Cache
  • Proving that indexes have improved performance
  • The challenge of missing indexes
  • Partitioning
  • Columnstore indexes

DATES*

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

    June 13 to June 14 2018

Trainer(s) assigned(s)

Other course(s) in this category