AZURE: Cannot clear the Query Store-CodePudding

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"

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 error

Please help me, thank you.

CodePudding user response：

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.