April 3, 2018 at 8:34 am
Hello.
In an instance i found a database with the next values:
snapshot_isolation_state = 0
is_readcommitted_snapshot_on = 1
It is posible? well, i saw that yes, but i have doubts.
A help please, thank you
April 3, 2018 at 8:58 am
Perfectly acceptable depending on requirements.
Read up on both of the settings as each isolation level does different things
April 3, 2018 at 9:31 am
Anthony Green, now yes, i had a little confusion because, i thought that for to set READ_COMMITTED_SNAPSHOT, there was before that to set ALLOW_SNAPSHOT_ISOLATION
Thank you for the clarification.
April 3, 2018 at 9:34 am
They're separate settings, they do different things and, tbh, when I'm doing audits and I find DBs with both enabled I flag that as a potential problem.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply