Home Explore Help
Register Sign In
Apq
/
tigertoolbox
mirror of https://github.com/microsoft/tigertoolbox.git
1
0
Fork 0
Files Issues 0 Wiki
Tree: dd41d84308
Branches Tags
tigertoolbox
/
Sessions
/
Geeks-DPS2017
/
Automatic-tuning
Pedro Lopes 4a95470acb Added PASS Summit 2017 content 8 years ago
..
README.md 4a95470acb Added PASS Summit 2017 content 8 years ago
demo-full.sql 4a95470acb Added PASS Summit 2017 content 8 years ago
query_store_waits.sql 4a95470acb Added PASS Summit 2017 content 8 years ago
restore_wwi.sql 4a95470acb Added PASS Summit 2017 content 8 years ago
setup.sql 4a95470acb Added PASS Summit 2017 content 8 years ago

README.md

This demo assumes SQL Server 2017. It has been tested on SQL Server 2017 RC1

  1. If you have not already done so, restore the WideWorldImporters database backup which can be found on https://github.com/Microsoft/sql-server-samples/releases/download/wide-world-importers-v1.0/WideWorldImporters-Full.bak

  2. Run the setup.sql script to setup the repro

  3. Follow the steps in demo-full.sql to show how automatic tuning and auto plan correction works