Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

what could be possible reason for this deadlock type? (not deadlock in general)

lock communication buffer resources is this indicated system is low in memory and buffers count ran out of limit?

Detailed Error: Transaction (Process ID 59) was deadlocked on lock communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction

share|improve this question
1  
Have you try MAXDOP 1 in the queries, as suggested in this answer? –  criticalfix Sep 9 '13 at 15:25
    
Is the error message "lock | communication buffer resources" or "lock communication buffer resources"? I was wondering what on earth a lock communication buffer was. –  Martin Smith Sep 9 '13 at 15:38
    
@ criticalfix, I'm using WCF-SQL adapter to send data to SQL Server, so don't have an option to modify SQL Query –  usman shaheen Sep 9 '13 at 15:47
add comment

migrated from stackoverflow.com Sep 9 '13 at 16:23

This question came from our site for professional and enthusiast programmers.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.