July 14, 2017 at 6:59 am
Please let me know the impact on Isolation level change from READ_COMMITTED to READ_COMMITTED_ISOLATION in sql server 2014
July 17, 2017 at 12:35 pm
jansub07 - Friday, July 14, 2017 6:59 AMPlease let me know the impact on Isolation level change from READ_COMMITTED to READ_COMMITTED_ISOLATION in sql server 2014
Don't think there is one called read_committed_isolation. There is read_committed or read_committed_snapshot. As well as several others noted here:
SET TRANSACTION ISOLATION LEVEL (Transact-SQL)
Sue
July 18, 2017 at 4:33 am
Please let me know the impact on Isolation level change from READ_COMMITTED to READ_COMMITTED_SNAPSHOT in sql server 2014
July 19, 2017 at 5:01 pm
jansub07 - Tuesday, July 18, 2017 4:33 AMPlease let me know the impact on Isolation level change from READ_COMMITTED to READ_COMMITTED_SNAPSHOT in sql server 2014
In terms of impact for your database, you won't know without testing. But there is a great article Paul White which addresses many things, good and bad, to be aware of:
Read Committed Snapshot Isolation
Sue
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply