Query Store in action

In this section, you will see how Query Store collects information about queries and query plans and how it can identify and fix regressed queries. It will be demonstrated how Query Store supports and facilitates an upgrade to SQL Server 2016.

First, you will create a new database with a single table and populate it with two million rows. This database will simulate a database that is created and used in SQL Server 2012 and that you restored in SQL Server 2016 but left in the old compatibility mode. Use the following code to accomplish this task:

IF DB_ID('Mila') IS NULL CREATE DATABASE Mila; GO USE Mila; GO --help function GetNums created by Itzik Ben-Gan (http://tsql.solidq.com) CREATE OR ALTER FUNCTION dbo.GetNums(@n AS ...

Get SQL Server 2016 Developer's Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.