Tuesday, June 14, 2005
Deadlocks in Sybase ASE
However, that may not include enough information for your analysis. You can enable more information to be written to the error log using the "print deadlock information" parameter.
1> sp_configure "print deadlock information" 1
This parameter should be disabled after the detailed information has been collected because this setting degrades Sybase ASE performance.
Please check the Sybase manual for more information on this parameter, and deadlocks in general.
On older versions of Sybase ASE you would get this deadlock information by using certain Trace Flags. Look at 1204 and 3605.
Actually handling deadlocks is a topic for another day. For a potentially quick fix, consider increasing the number of locks.
Or, reduce the locking on index pages by altering affected tables from allpages lock to datapage lock. This rebuilds all the indexes, so it may take awhile.
1> alter table [name] lock [locktype]
I will leave you with the two best links I have on deadlocks:
Peter Sap's Sybase ASE tip: Investigation of deadlocks reported in the errorlog
Todd Boss's technical notes on deadlocks (Edited)
Appreciate the effort you are putting here , this is a great page. This gives us step by step process which really helps me like any other newbies. Please keep up the great work.
My apologies - I was unaware that you did not endorse Black Sheep's use of your article. I will correct this post immediately.