ECL table is so huge SCSM 2012 R2 how to reduce it or purge data

Shumail Khalid 1 Reputation point
2021-10-22T19:20:33.93+00:00

ECL table is so huge SCSM 2012 R2 how to reduce it or purge data. This impacts SCSM 2012 R2 performance. I can see block process in SQL SP_WHO2 commnad. Please help

Service Manager
Service Manager
A family of System Center products for managing incidents and problems.
210 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Baumgarten 96,926 Reputation points MVP
    2021-10-22T21:43:54.513+00:00

    Hi. @Shumail Khalid ,

    maybe this is helpful: https://community.cireson.com/discussion/1595/database-blocking-issue-dbo-p-entity-changelog-snapshot-1

    ----------

    (If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

    Regards
    Andreas Baumgarten

    0 comments