SQL Server Performance Tuning and Optimization

SQW06 Cardinality Estimates in Microsoft SQL Server

11/15/2017

9:30am - 10:45am

Level: Intermediate

Thomas LaRock

Head Geek

SolarWinds

SQL Server 2014 introduced a new cardinality estimator. This feature allows for statistics to be calculated differently than previous versions of SQL Server, often (but not always) resulting in better query performance. Attend this session and understand how, why, and when SQL Server uses statistics and how this new feature will help improve performance.

You will learn:

  • The differences between old and new cardinality estimator
  • How to know if the new version is causing performance issues
  • How to revert back to the old version if needed