February 19, 2014 at 4:04 am
Hi,
one of client want the below isolation option to be On on new sql server 2008 r2 standalone server.
Set READ_COMMITTED_SNAPSHOT = ON
Set ALLOW_SNAPSHOT_ISOLATION = ON
They want to set this otpion during sql installation.
Is it possible to set the isollation during sql installation.?
is it server level change or databse level change?
thanks
February 19, 2014 at 5:09 am
You can set them after installation, not during. They're both database level settings.
to be honest, I don't see much point in having them both on, usually one would pick one of them and use that, read committed snapshot to change the default isolation level to optimisitic or snapshot for use in places where it's needed, but probably not both and not both by default.
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
February 19, 2014 at 6:22 am
And just using snapshot isolation, as opposed to read committed snapshot, requires changes to the code which people are usually not prepared to make. I'd just recommend using read_committed_snapshot as Gail says.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 19, 2014 at 6:26 am
Though not without analysis first including some work to ensure TempDB can handle the additional load.
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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply