question

ShumailKhalid-0693 avatar image
0 Votes"
ShumailKhalid-0693 asked AndreasBaumgarten commented

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

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

msc-service-manager
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ShumailKhalid-0693 ,

did the answer work for you? Are there any additional questions to this topic?

If you found the answer helpful, it would be great if you please mark it "Accept as answer". This will help others to find answers in Q&A

----------
Regards
Andreas Baumgarten

0 Votes 0 ·

1 Answer

AndreasBaumgarten avatar image
0 Votes"
AndreasBaumgarten answered

Hi. @ShumailKhalid-0693 ,

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.