question

karthikpalani-9530 avatar image
0 Votes"
karthikpalani-9530 asked Amandayou-MSFT commented

SCCM - Collection Slowness

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

mem-cm-generalmem-cm-site-deployment
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.

Garth avatar image
0 Votes"
Garth answered

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

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.

karthikpalani-9530 avatar image
0 Votes"
karthikpalani-9530 answered karthikpalani-9530 edited

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



collection.jpg (90.5 KiB)
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.

Garth avatar image
0 Votes"
Garth answered

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?

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.

Amandayou-MSFT avatar image
0 Votes"
Amandayou-MSFT answered Amandayou-MSFT commented

Hi @karthikpalani-9530,

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.


· 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,

May we know the current status of the question? If there is any other assistance we can provide, please feel free to let us know, we will do our best to help you.

Thanks and regards,
Amanda

0 Votes 0 ·