{"id":924,"date":"2018-06-14T07:12:16","date_gmt":"2018-06-14T14:12:16","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/erin\/?p=924"},"modified":"2018-06-14T07:12:16","modified_gmt":"2018-06-14T14:12:16","slug":"why-arent-you-using-query-store","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/erin\/why-arent-you-using-query-store\/","title":{"rendered":"Why aren’t you using Query Store?"},"content":{"rendered":"

Way back in 2016 I wrote a post<\/a> trying to find out why people were not using Extended Events.\u00a0 See, I really like Extended Events, and I’d been presenting on the topic for several years, but I kept running into people who wouldn’t even try XE.\u00a0 There were also a lot of individuals who declared they were “Profiler for Life”.\u00a0 Ok, but I wanted to understand why.<\/p>\n

I find myself asking people the same question now about Query Store. I’ve presented a lot of sessions on the topic, with the primary goal of teaching people how to use Query Store.\u00a0 As such, most of the people in my sessions are not<\/em> using Query Store.\u00a0 As an example, if I have 30 people in a session, typically only 25-30% are running SQL Server 2016 or higher.\u00a0 And of those 7 to 10 people, maybe 2 to 5 are using Query Store.\u00a0 Does that mean that only 5%-15% of SQL Server users are using Query Store?\u00a0 No.\u00a0 I have no idea how many people\u00a0who are running SQL Server 2016 or higher<\/em> are using Query Store.\u00a0 I’m pretty sure Microsoft doesn’t have an accurate number either, except for Azure SQL Database.\u00a0 Query Store is turned on for nearly all 2 million user databases on Azure SQL Database.<\/p>\n

So the primary purpose of this post is to provide a place (the comments) for people to share why they are not using Query Store.\u00a0 I’m very interested in hearing this information, so please share!\u00a0 And please comment even if it’s the same as what someone else has written.<\/p>\n

In addition, if you don’t know much about Query Store but want to get started because you’re running SQL Server 2016 or higher (or are looking to upgrade), I’ve\u00a0included some links below to help you get started.\u00a0 Some links are for documentation or blog posts, but if you’re not a believer of RTFM \ud83d\ude42 , there are also links to my Pluralsight courses (requires a subscription) and\u00a0an introductory session I’ve given (free).\u00a0 If you have questions not answered in a post or video, let me know this in the comments as well!<\/p>\n

Lastly, I’ve had multiple questions related to the performance impact of enabling Query Store.\u00a0 This is a great question – look for a post next week that provides more detail.\u00a0 But until then, please let me know why you’re not using Query Store, and thanks for reading!<\/p>\n