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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
It's mentioned in MSDN but don't know why – gbn Sep 17 '11 at 11:40
up vote 3 down vote accepted

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.