microsoft/DacFx

QueryStore option is set to 100MB after every deployment

Opened this issue · 2 comments

  • SqlPackage or DacFx Version: All
  • .NET Framework (Windows-only) or .NET Core: All
  • Environment (local platform and source/target platforms): Any

Steps to Reproduce:

  1. Create a SQL project and deploy it on Azure server
  2. Verify the Query Store Max Storage Size before and after the deployment.
  3. If it is not 100MB and after deployment it is resetting to 100MB

Did this occur in prior versions? If not - which version(s) did it work in?

(DacFx/SqlPackage/SSMS/Azure Data Studio) All

@ssreerama - is this original SQL projects or Microsoft.Build.Sql or both?

This was tested in SDK style SQL project, I believe it will be the same for the VS projects too