Issue
During database upgrade Console freezes with no action or progress
Cause
SQL 2016 CU6 and CU7 cause failure in Template Database creation that is needed during Database upgrade.
Upon searching, a Microsoft Support article was given, the CU6/7 disallow a single line of the ALTER DATABASE DatabaseName SET ALLOW_SNAPSHOT_ISOLATION ON
This can be explained in: https://support.microsoft.com/en-us/help/4090966/sql-server-session-hangs-when-you-try-to-enable-snapshot-isolation
Solution
-- Stop the audit:
ALTER SERVER AUDIT AuditName WITH (STATE = OFF) GO
-- Change the database isolation level:
ALTER DATABASE WMTemplate SET ALLOW_SNAPSHOT_ISOLATION ON
-- Turn the audit back on:
ALTER SERVER AUDIT AuditName WITH (STATE = ON) GO
Internal Reference
SD-25840