Why is the database property
Allow Snapshot Isolation set to
TRUE on the
msdb databases, but
FALSE on other system databases? The default option for this property is also
FALSE when creating user databases.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
Here's how it works:
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
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.