Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Have you any problems using it on high concurrency environment? It's really works as advertised by MS? I'm using SQL Server 2005 and would like to hear the experiences of those who are/was using it on production.

Snapshot isolation per se is not new for me as I develop/administer Firebird/Interbase as well - where there no explicit locking and all works in row versioning...

share|improve this question
add comment

1 Answer

up vote 0 down vote accepted

Yes it works as advertised. Basically the old page is copied to the tempdb database and everyone that needs the old version of the page will be directed to that page in the tempdb database.

If you don't have very fast disks under the tempdb database your system will slow down when snapshot isolation level is used.

share|improve this answer
add comment

Your Answer

 
discard

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.