NHibernate 3 + Transaction Deadlocks (S#arp Architecture)
I appear to be getting a lot of random deadlocks when reading data from one of my tables. This table contains alot of information and is very frequently read and updated.
I am using S#arp Architechture 1.9 which uses the Transaction attribute on all my data access / update code.
Is there anything special which I need to do to ensure I don't get deadlocks, Should i update / read my data in a certain way.
Not t开发者_如何学编程oo sure where to start on this one.
NHibernate 3 S#arpArchitecture 1.9 SQL Server 2008 R2
Thanks.
Are you getting actual deadlocks or blocked reads? If it is the former, consider rebuilding indexes and statistics.
精彩评论