Set SQL Server Isolation Level: Difference between revisions
Jump to navigation
Jump to search
Created page with " '''Set snapshot isolation level on''' <nowiki>Make sure all the connections to the database are closed! ALTER DATABASE MyDB SET ALLOW_SNAPSHOT_ISOLATION ON ALTER DATABASE M..." |
m 1 revision imported |
(No difference)
| |
Latest revision as of 21:44, 25 May 2020
Set snapshot isolation level on Make sure all the connections to the database are closed! ALTER DATABASE MyDB SET ALLOW_SNAPSHOT_ISOLATION ON ALTER DATABASE MyDB SET READ_COMMITTED_SNAPSHOT ON
Check the isolation level dbcc useroptions;
Set snapshot isolation level off (in case you have bad performance when turned on) ALTER DATABASE MyDB SET ALLOW_SNAPSHOT_ISOLATION OFF ALTER DATABASE MyDB SET READ_COMMITTED_SNAPSHOT OFF