Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

Query store create database

If you enable Query Store on model, then attempt to create a database, Query Store will be enabled on the new database.

However, if you attempt to create a database using a non-default collation, the CREATE database fails with a deadlock on sys.sysschobj, in the middle of a DQS transaction. (I'm using 2017 CU4)

I should be able to specify a non-default collation when creating a database, and not have DQS cause a failure.

--Enable Query Store on model
ALTER DATABASE model SET QUERY_STORE (OPERATION_MODE = READ_WRITE);
GO
--Create a database using any collation other than your instace default
CREATE DATABASE AM2 COLLATE Latin1_General_100_CI_AS_KS_WS;
GO

7 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Andy Mallon shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base