Redgate Monitor 14

Help for older versions available.

SQL Server session hangs when you try to enable snapshot isolation in SQL Server

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. Seehttps://support.microsoft.com/en-gb/help/4090966/sql-server-session-hangs-when-you-try-to-enable-snapshot-isolation for further information.



Didn't find what you were looking for?