Getting Deadlock Error During Processing

 

Database Engine
blogs
Analysis services
blogs
Reporting services
blogs
Integration services
blogs
Data access tech     blogs

Database Engine videos Analysis services videos Reporting services videos Integration services videos Data access tech   Videos
Blog - News
All postings are provided AS IS with no warranties, and confer no rights. Additionally, views expressed herein are my own and not those of my employer, Microsoft.

Getting Deadlock Error During Processing

Rate This
  • Comments 1

Issue:

Intermittently Getting below mentioned error during processing
OLE DB error: OLE DB or ODBC error. Transaction (Process ID n) was deadlocked on thread| communication buffer resources with another process and has been chosen as the deadlock victim.

Cause:
A deadlock is a circular blocking chain, where two or more spids are each blocked by the other so that no one can proceed.

You don’t have control over the Select Statement generated by SSAS Processing job (If you are not using Named Query in DSV), in that case you need take care of things from SQL Engine Perspective.

Here are few recommendations, which can reduce deadlock situation:

Leave a Comment
  • Please add 6 and 5 and type the answer here:
  • Post
  • Short article but , after having read your link ( in read more ) , it is clear for me now

    Thanks

Page 1 of 1 (1 items)