Question 106016 in Azure Question posted in
The official documentation to get you started can be found here.

AZURE: Cannot clear the Query Store

I am trying to setup the Automatic Tuning for the Azure SQL Database, but I have found out the "Query Store is in read-only state" enter image description here

So I plan to use the command to clear it to make it run "ALTER DATABASE [QueryStoreDB] SET QUERY_STORE CLEAR", but it got the errorenter image description here

Please help me, thank you.

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    Tho the SQL command does not work, I found that there is a button that can help me finish the job -> Purge Query Data button at the right down corner. enter image description here


  2. 0

    To set the query store to read write mode use

    ALTER DATABASE [QueryStoreDB]
SET QUERY_STORE (OPERATION_MODE = READ_WRITE);

    But your error code 615 means that the cache is not in sync with the database, due to connection problems.

    https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-common-errors-issues?view=azuresql

    Check that your SQL Server database is online

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search