Hi Guys,
Recently we have started facing the transaction blocking issues in the database.
What I mean by transaction blocking is "Transactions remains open from database side though query runs sucessfully from Application". We ahve confirmed the transaction scope also(Open & Close).
Before moving ahead let me explain few enviornment stuff.
1) We are working with LINQ technology.
2) ISOLATION level used == Serializable.
3) Running the services on service Account
We are able to tracked the queries that were causing the transaction issues. But we are not able to figure it out how to resolve it.
Your suggestions are most appreciated.
Abhijit - http://abhijitmore.wordpress.com