My Experience with Query Store
I am writing this blog to share my experience with query store. I have used Query store couple of years ago. However, I didn’t explore much in that. But recently I completed Migration of SQL Server 2008 to SQL Server 2019 and there I dig more in query store. So basically, Query store is the SQL server feature which has been introduced in SQL Server 2016 and use for capturing and storing Query plans for further analysis. Working with Query store is an easy task. To enable query store, go to database property--> click on Query Store--> Change Operation Mode to Read Write . On the same window, we can configure other settings as per our requirement. Once query store enabled, we can monitor below queries. Please check below Microsoft doc for best practices of query store. Best practices with Query Store - SQL Server | Microsoft Docs I found query store useful for Query plan monitoring and comparing plans. However, I faced interesting issues as well. That I woul...