Hi, @Albert Pang
Thank you for posting in Microsoft Q&A forum.
There is a known issues of Configuration Manager 2303 with the latest Hotfix Rollup KB24719670 (KB21010486):
After installing KB 21010486, administrators may notice an overall performance degradation in processing data into the site database. For example, collection evaluation, query processing, and site to site replication may be affected.
We may find more details in this article:
https://learn.microsoft.com/en-us/mem/configmgr/hotfix/2303/21010486#known-issue-august-14-2023
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Add comment".