SCCM - Collection Slowness

karthik palani 1,016 Reputation points
2021-09-05T11:33:10.153+00:00

Hi All,

I need some advice on SCCM CB 2006, we recently migrated to CB 2006. All service are working fine but i can see when we do collection update membership, it takes 1 hour to complete and i can see a collection ID created under Inbox - colleval

It is getting stuck and the total number of collection we have is 50+ with less incremental collection. Under colleval.log, i dont see any error logs.

Is there any performance issue i need to verify. Please suggest

Microsoft Configuration Manager
0 comments No comments
{count} votes

4 answers

Sort by: Most helpful
  1. Garth 5,801 Reputation points
    2021-09-05T12:19:10.493+00:00

    Have you reviewed the logs to see which collection is taking a long time. Or reviewed the queries used to create the collections?

    0 comments No comments

  2. karthik palani 1,016 Reputation points
    2021-09-06T06:48:42.753+00:00

    There is no specific collection affected, even new collection takes more time to update. Last collection performed updation for almost 45 minutes. I can see no errors in the logs and it says completed in seconds. But is there any specific reason timer or collection takes time to insert the device. Please suggest

    129470-collection.jpg

    0 comments No comments

  3. Garth 5,801 Reputation points
    2021-09-06T14:14:00.3+00:00

    Have you installed ola script? https://www.recastsoftware.com/resources/installation-guide-to-ola-hallengrens-sql-server-maintenance-solution/

    have you check the health of you server and sql?

    0 comments No comments

  4. Amandayou-MSFT 11,056 Reputation points
    2021-09-09T09:09:15.123+00:00

    Hi @karthik palani ,

    Agree with Garth, we could check the health of our server, and how to check server performance, please refer to this article:
    https://onlinehelp.coveo.com/en/ces/7.0/administrator/gathering_windows_server_performance_information.htm
    Note: Non-Microsoft link, just for the reference.


    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.