SQL Server 2016 Query Data Store:

There's been some conversation and little misunderstandings over a new function that will provide in SQL Server 2016 known as the "Query Store" which we will be cleaning in this CR Bridge. At first impact, you'd think that Microsoft was providing a Windows-type app store for concerns in SQL Server 2016. This by itself, would be amazing. I can think about SQL directors salivating at the capability to "shop" for checking out its concerns to use in their own surroundings instead of having to constantly make their own. But, unfortunately, this is not what Question Store in SQL Server 2016 is. Not that the new function isn't innovative and greatly useful by any expand.

The complete name, per Microsoft, is Question Information Store, which creates the significance more reasonably easy to understand. Question Information Store in SQL Server 2016 is designed as a support that watches and maximizes query programs with a complete record of query performance. Question Information Store can help identify efficiency issues that are relevant to strategy changes.

What it does:

· Stores the record of query plans

· Captures efficiency data for each query plan

· Identifies the most costly concerns and earmarks, those concerns that have     deteriorated or gotten more slowly over time

· Gives you the capability to power old programs, should a new strategy cause   efficiency issues (almost like a program recovers for Microsoft windows           computers)

· Easily repairs strategy regressions

· Analyzes amount of work patterns

However, according to our CR Bridge evaluations we believe that Microsoft has yet to connect if Question Information Store will be available in the Conventional edition of SQL Server 2016, but will definitely be available as a support for the Business edition.