HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Why is 'Allow Snapshot Isolation' set to TRUE on the master and msdb databases?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
whyisolationthemsdbdatabasestrueallowsnapshotmasterand

Problem

Why is the database property Allow Snapshot Isolation set to TRUE on the master and msdb databases, but FALSE on other system databases? The default option for this property is also FALSE when creating user databases.

Solution

I would imagine that it is enabled to minimize blocking in the master and msdb databases of the system processes. It is disabled in user databases because in user databases it can greatly increase the disk IO requirements of the tempdb database.

Context

StackExchange Database Administrators Q#5899, answer score: 3

Revisions (0)

No revisions yet.