Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
niks
Starting Member
9 Posts |
 Posted - 2012-05-02 : 06:39:07
|
| I have application developed with Asp.Net and MSSQL 2008 R2.1) There are three main table handling 80% transactions 2) Insertion and Read both going on at same time for a same project. 3) For the same project multiple user insert the data and view the data.4) While this process going on deadlock taking place and whole application get stuck5) While we re-index it . application works for some minutes and stuck once againI had set SET DEADLOCK_PRIORITY, Isolation Level. but position is very tough.... Pls help,RegdsNiksRegdsNiks |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-05-02 : 11:50:28
|
| 1)Consider the order of the transactions within the code2)Can BEGIN TRANS ...COMMIT TRANS be placed around more sub steps , to release locks?3)A way must be found to release the (probably ) exclusive locks created by the UPDATE,DELETES,INSERTS, without upsetting the data integrity.Speak to the developers , and consider the implications of adjusting transaction management.Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
|
|
|
Due to deadlock , application stuck.