[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
How to enable Query Store on SQL Azure

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019
Tips
Troubleshooting
Tuning

How to enable Query Store on SQL Azure


One of the new features that Azure SQL Database V12 offers in terms of troubleshooting query performance is the new Query Store feature, which is part of SQL Server 2016 too.

Let's see how to enable it and how to start using it on this brief article.

For the purpose of this article, we will be using the AdventureWorksLT sample database. Make a click here to know how to install it.

To enable Query Store, first connect to the SQL Azure database using SQL Server Management Studio and the use the ALTER DATABASE statement as shown on below image.





Let's run two queries.











Let's see how the Query Store captured those queries with below query.






As shown on above image, the Query Store captured both queries (rows 6 and 8).

Now on below image, we obtain from the Query Store the top 10 long running queries.





To know more about the Query Store and how to use it for troubleshooting query performance, read below article:

Query Store: A flight data recorder for your database.


 

 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.