Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TransactionScope and SQL Server Locks
Message
From
11/04/2012 01:01:54
 
 
To
10/04/2012 16:33:32
Al Doman (Online)
M3 Enterprises Inc.
North Vancouver, British Columbia, Canada
General information
Forum:
ASP.NET
Category:
Databases
Miscellaneous
Thread ID:
01540816
Message ID:
01540985
Views:
29
>If it's for reporting or similar purposes, is there any chance they would let you create and drop database snapshots?

Probably not worth the effort ... in our scenario we're pulling the data every 30 seconds, so a dirty read is really not a big deal. It's not actually "reporting", but we're providing data to another app that constantly displays information on a map. What may have been dirty 30 seconds ago will probably be fine the next time it's pulled ... I don't think a user's going to notice that on their map. <g>

Thanks for the suggestion though ... I've decided to go with IsolationLevel.ReadUncommitted. It doesn't do any locking, and that was my ultimate goal.

And the TransactionScopeOption.RequiresNew means that the new Transaction doesn't get enlisted in the existing Distributed Transactions either (which I verified with some testing), so I'm good to go now.
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Previous
Reply
Map
View

Click here to load this message in the networking platform