The SQL Server 2016 Query Store: Analyzing Query Store Performance
Posted by: Simple Talk,
on 13 Apr 2016 |
View original | Bookmarked: 0 time(s)
There are some obvious advantages to having the Query Store, but what is the performance impact that it is likely to have on a busy OLTP database server? It is early days, of course and until we get more experience we have to rely on Microsoft's estimate of a performance impact of 3-5% on average. However, this will depend on a number of factors such as usage an the way it is configured. Enrico explores some of these factors in order to give a clearer picture of what you should expect....