Hi Guys,
As a DBA, I have to administrate the SQL instance of our Dynamics CRM.
I see many and many blocked process reports due to long locks, and I would like to enabled the Read Committed Snapshot Isolation on the Dynamics DB to fix them, but i'm not sure it's supported from Dynamics Apps side. Can anybody clarify that bullet please ?
Thx in advance :)
Fred.M.
*This post is locked for comments
Thanks David for your valuable contribution ! ;)
Yes, it is supported, see https://social.technet.microsoft.com/wiki/contents/articles/13661.dynamics-crm-2011-quick-optimization-guide.aspx
However, if you're getting a lot of locks, it's worth checking if there are underlying issues with your workflows or plugins that could cause this. From CRM 2013 onwards the data structure changed in a way that reduced the likelihood of one set of deadlocks
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (