Hi @Rickert, Sandi ,
I recommend you post your issue here: crm
Dynamics Engineers will give you more helpful suggestions.
BR,
Mia
If the answer is helpful, please click "Accept Answer" and upvote it.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Our Dynamics implementation is very slow. Trying to delete workflows almost freezes the system. We cannot bulk delete process sessions. workflowlogbase and processsessionbase tables are over a million records and the known clean-up script doesn't cleanup old records.
When did it begin and how often does it occur? Always.
What errors do you see? SQL Timeout errors on bulk delete - even though it is only trying to remove 1 session and we've extended the timeout on our SQL server to 1800 minutes.
What's the environment and are there recent changes? We recently upgraded to Ellucian Recruit 6.1 version - which requires 9.0.8 Dynamics
What have you tried to troubleshoot this? Cleanup script found on: http://yoderworks.blogspot.com/2011/08/troubleshooting-crm-performance.html
https://www.programmersought.com/article/38261710831/
https://support.microsoft.com/en-sg/help/968520/performance-is-slow-if-the-asyncoperationbase-table-becomes-too-large
Hi @Rickert, Sandi ,
I recommend you post your issue here: crm
Dynamics Engineers will give you more helpful suggestions.
BR,
Mia
If the answer is helpful, please click "Accept Answer" and upvote it.
Hi @Rickert, Sandi ,
Is the reply helpful?
Is your dynamics issue solved?
Do you post in the dynamics forum?
BR,
Mia
If the answer is helpful, please click "Accept Answer" and upvote it.