Deadlock in OLAP

• Ronnie_Doggart

  SSC Veteran

  Points: 299

  More actions

  December 9, 2009 at 1:29 am

  #140597

  All,

  We are occasionally getting the following error from the SSAS service in the event logs:

  OLE DB error: OLE DB or ODBC error: Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.; 40001.

  Is there anyway other than using SQL Profiler to get the deadlock trace. I know that in the OLTP environment I can use DBCC TRACEON (1222, -1) but is there an equivalent for SSAS.

  Thanks

  Ronnie