Deadlocks again - Bring2mind - Bring2mind Forums

Site
Web

Bring2mind Forums

Forums
Search Forum
Advanced SearchTopicsPosts

Forums > Document Exchange > Storage and Security

Deadlocks again

Last Post 02/18/2011 4:55 PM by Peter Donker. 5 Replies.

Sort:

	Prev Next
You are not authorized to post a reply.

Author

Messages

New Member
Posts:40

02/17/2011 8:48 PM
Hi Peter, We are aggain seeing deadlocks in the database and they all seem to occur because the stored proc DMX_RemoveOldUserNotifications is running simultaneously. We are trying to find out where this stored proc is called from, or what triggers it. Can you please help and let me know what causes this stored proc to run. Thanks, Anitha

Peter Donker

Veteran Member
Posts:4536

02/18/2011 3:05 PM
Hi Anitha, Can you tell me which version of DMX you are on? Peter

New Member
Posts:40

02/18/2011 3:36 PM
5.2.8

Peter Donker

Veteran Member
Posts:4536

02/18/2011 4:01 PM
Hi Anitha, We did a lot of SQL tuning since that version. Can you upgrade to the latest version and report back if you still see the same issue? Peter

New Member
Posts:40

02/18/2011 4:28 PM
Unfortunately, upgrading is not an option now, one of the reasons being that we have a lot of customisations. Any pointers as to where the stored proc is called from and when would help. We could at least see if we can minimise the deadlocks.

Peter Donker

Veteran Member
Posts:4536

02/18/2011 4:55 PM
No. What you can do is install the latest version on another DNN installation and run Red Gate to do a difference. It is not a simple matter of a changes SPROC. All triggers and related SPROCs were revised. Peter

You are not authorized to post a reply.

Forums > Document Exchange > Storage and Security

About Bring2mind

Bring2mind is the company of Peter Donker, a DotNetNuke enthusiast who has been involved with the platform from the very beginning. At the same time as the market for modules emerged, he realized there was no good document management solution for the platform yet and he set about creating this. In part he based the module on his experience with other document management systems he used while working as a researcher. His module, Document Exchange, was an instant success and has since become the premier document management solution for DotNetNuke. In 2004 he created Bring2mind as a vehicle for the module and is one of the few successful businesses solely based on a DotNetNuke product.

Contact Info

Please note we are located in Europe. Business hours are weekdays between 9 AM and 6 PM local time (Central European Time) which corresponds to 3 AM and noon EST.