Last few days I had major problems with my production site, turns out deadlock occurred, every half an hour maybe 50-60 of them. To do a quick fix in order to keep the site running I set :
I believe my log file will grow faster than before now?
Are there different types of isolation and is it possible to set the isolation to just 2 tables which causes the deadlock?
::2013-03-21 15:09:: ![xml graph image]http://i.imgur.com/KfXDf3k.png
Can I query the process ID's involved in the deadlock?select object_name() returns null always