kick start! sql server 2016 / 2017 performance …... automatic tuning = automatic plan correction...

Kick Start! SQL Server 2016 / 2017 Performance Tips and Tricks

PINAL DAVEhttp://blog.SQLauthority.com

Adaptive Joins / Memory

This is Fast Paced SessionAll scripts are available at - https://go.sqlauthority.com

http://blog.sqlauthority.com

You NEVERmake the

same mistake twice.

You ALWAYS come up

with a new one.

Live PlanDemohttps://go.sqlauthority.com

http://blog.sqlauthority.com

Higher Compatibility Level

+

Latest Cardinality Estimation

=

Better Performance

Cardinality Estimation vs

Compatibility LevelDemohttps://go.sqlauthority.com

https://go.sqlauthority.comDownload the Scripts

http://blog.sqlauthority.com

Automatic Tuning

=

Automatic Plan Correction(SQL Server 2017 & Azure)

+

Automatic Index Management (Azure Only)

Adaptive Joins / Memory GrantDemohttps://go.sqlauthority.com

Interleaved ExecutionsDemohttps://go.sqlauthority.com

Automatic TuningDemohttps://go.sqlauthority.com

Columnstore Index and In-

In-Memory OLTPDemohttps://go.sqlauthority.com

SQL Server Performance Demohttps://go.sqlauthority.com

http://blog.sqlauthority.com

Summary

Let’s fix your SQL Server performance

http://blog.sqlauthority.com

Questions - Thank You!

SQL Server performance Tuning is Easy

Image Courtesy: Pinal Dave (http://blog.sqlauthority.com)

http://blog.sqlauthority.com

FREE3 Performance Tuning Scripts:

https://go.sqlauthority.com

Talk to me

pinal@sqlauthority.com