QUERY STORE for Azure database performance analysis

Query store can be enabled on Azure SQL Database to analyze any performance issues with SQL Server.

Example: Below image indicates one of the SQL statement was executed about 57,000 times along with Query plan to understand what is consuming maximum CPU. This query alone using at least 60% of the CUP during the given time.

Query_Store-Azure

Query store on a database can be enabled using below SQL Query;

ALTER DATABASE databasename SET QUERY_STORE =ON;
--

I frequently use Regressed and Top Resource Consuming queries to analyze high DTU consumption analysis.

NOTE: Azure Portal can also be used to identify index recommendations to improve performance but Query store can be used for detailed analysis.

Advertisements
This entry was posted in Azure, SQL, Uncategorized and tagged , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s