December 21, 2012 at 4:05 am
Since 2 days we are facing Deadlock probem in one application.
For years that application woorked well..
I am doing daily Reindexing & Archiving of data .. still no use
Strangely service restart solve the issue on both days :w00t:
How to deal with this... i am not able to track the deadlock reason...
Please Suggest
************************************
Every Dog has a Tail !!!!! :-D
December 21, 2012 at 5:01 am
Deadlocks can occur for many reasons. Without further information it will be impossible to assist you.
What you need is the deadlock graph so it can be analyzed. Enable global Trace Flag 1222 and the next time a deadlock occurs useful information will be entered into the SQL Server Error Log.
Since you are on 2008 you can also try retrieving some of the deadlock graphs from the system_health Extended Events session. See this article: Retrieving Deadlock Graphs with SQL Server 2008 Extended Events By Jonathan Kehayias, 2009/02/23[/url]
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply