These pages cover SQL Monitor 11, which is not the latest version. Help for other versions is also available.
SQL Server session hangs when you try to enable snapshot isolation in SQL Server
Published 07 October 2020
You may see the install or upgrade get stuck on the following SQL:
ALTER DATABASE [RedGateMonitor] SET RECOVERY SIMPLE WITH NO_WAIT
ALTER DATABASE [RedGateMonitor] SET ALLOW_SNAPSHOT_ISOLATION ON
ALTER DATABASE [RedGateMonitor] SET READ_COMMITTED_SNAPSHOT ON WITH ROLLBACK IMMEDIATE
This can be due to a problem with SQL Auditing. See: https://support.microsoft.com/en-gb/help/4090966/sql-server-session-hangs-when-you-try-to-enable-snapshot-isolation for further information.
