November 6, 2003 at 7:18 am
Hello everyone,
does someone knows where I can find detailed documentation on this coming new isolation level for the next SQL Server release.
I have only read few line on this topic at this page: http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/next/SQLYDBA.asp
Thank's
Carl
November 6, 2003 at 9:23 am
Detailed docs have not been released. I will check the Beta and see and you can always request to get on the Beta.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 6, 2003 at 9:29 am
There is some limited information in BOL, but I'm not sure what I can post yet.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 6, 2003 at 10:41 am
The information I have is the following:
=========================================
Snapshot Isolation Level allows users to access the last committed row using a transitionally consistent view of the database. This new isolation level provides the following benefits:
Increased data availability for read-only applications.
Non-blocking read operations are allowed in an OLTP environment.
Automatic mandatory conflict detection for write transactions.
Simplified migration of applications from Oracle to SQL Server.
For example, locking can cause blocks between applications that are reading and writing the same data simultaneously. If a transaction changes a row, then another transaction cannot read the row until the write commits. With SI, the reader can access the previous committed value of the row.
==========================================
It is very general. But at my sense, if it is well inplemented it is a huge improvement in the SQL Server world.
Let me know if you learn more about this one because it will have a big impact on our application and the way we do things.
Regards,
Carl
November 6, 2003 at 7:56 pm
whao, are we talking "rollback segments" here in SQL Server, whoo hooo 🙂 the end of writers blocking readers using the read consistent model of oracle? this would be a huge bonus for sql server if this was the case.
Chris Kempster
Author of "SQL Server 2k for the Oracle DBA"
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply