From the course: SQL Server 2016: Administer a Database Infrastructure
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Manage the Query Store - SQL Server Tutorial
From the course: SQL Server 2016: Administer a Database Infrastructure
Manage the Query Store
- [Instructor] Query Store is a new feature in SQL Server 2016 and it helps database administrators monitor the performance of queries over time. It does this by storing Query performance data and execution information in tables stored in the primary file group of the database being queried. These tables will contain information on query execution plans, memory and CPU resource utilization, execution time, and other execution parameters. By saving this information over time, it can be reviewed in order identify how performance changes over time, and to potentially roll a query back to a more efficient execution plan, should the need arise. When a query is executed, the execution plan is initially stored in memory. By default, after a period of about 15 minutes that collected execution data is flushed to the query store tables on disk, in order to preserve it. The interval is configurable, but storing planned data does come with a performance hit to the system, so a balance needs to be…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.