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 QUERYSTORE (OPERATIONMODE = READWRITE);
--Create a database using any collation other than your instace default
CREATE DATABASE AM2 COLLATE Latin1General100CIASKS_WS;
Jeroen Mostert commented
Still present as of CU15. This is extra annoying when you're deploying databases through DACPACs, as those embed the collation used in the database (that is, there's no simple way to just deploy the database with the server default collation, unless you arrange for the database to be created first separately).