Opt-out of Query Performance Insight and drop Query Store data
Make it possible to completely opt-out from Query Performance Insight and drop Query Store data.
Simon Weaver commented
this should be automatically done after I import a new BACPAC
it's a joke when it tells me my top queries are BULK INSERTs from my initial import!
Borko Novakovic (MSFT) commented
In order to control how much data Query Store adds to your database, consider setting time-based retention to a lower value. Check out Best Practices article for that: https://msdn.microsoft.com/en-us/library/mt604821.aspx
You can always clear Query Store Data with the following Transact SQL statement (run it from SQL Server Management Studio, SQL Server Data Tools or any other application that can connect to Azure SQL DB):
ALTER DATABASE CURRENT SET QUERY_STORE CLEAR;
SQL Server Management Studio 2016 (SSMS) offers a UI form for Query Store configuration, enablement and disablement. In order to use it, open Properties form for your database and navigate to Query Store tab on the left-hand side.
If you want to opt-out of Query performance just disable Query Store:
ALTER DATABASE CURRENT SET QUERY_STORE = OFF;
Again, this can be done from SSMS UI form.
This is a classic case of a really dangerous and performance-hungry feature that can be enabled but not disabled in the portal.
Andreas Bohn commented
Make it possible to drop Query Performance Insight's Query Data Store. It adds a considerable amount of data to the database and we want get rid of it after we don't need it anymore.