yes Lot of insert\update\deletes are happening at this time and looks like none of them is system SPIDs.The thing is deadlock is getting resolved automatically but its rolling back that...