Dynamics hanging when deleting workflows

Rickert, Sandi 1 Reputation point
2020-11-20T21:39:42.96+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,654 questions
{count} votes

2 answers

Sort by: Most helpful
  1. m 4,271 Reputation points
    2020-11-23T02:54:33.36+00:00

    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.

    0 comments No comments

  2. m 4,271 Reputation points
    2020-11-24T01:46:02.563+00:00

    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.

    0 comments No comments