none
SCCM collections updating extremely slowly or not at all. RRS feed

  • Question

  • Last couple of days we have been running into an issue with updating memberships of existing collections.  The majority of collections in questions seem to those that were created with direct rule, though not all.  I've checked with Collection Evaluation Viewer and don't see any of the collections we are having issues with appear in the app.  The colleval.log does not show any errors related to the collections, and restarting the CollectionEvaluation services does not help.  However, a complete reboot of the SCCM Primary Site Server does, the SQL database is on separate server.  This does not seem to affect newly created collections.

    Any suggestions on where to look for troubleshooting this?

    Tuesday, July 9, 2019 3:02 PM

All replies

  • Hi,

    You can try to rebuild the index of your SQL database on the maintenance task (Administration=>Site configuration=>Sites=>Site maintenance) or directly with SSMS: https://www.scconfigmgr.com/2017/01/03/configuration-manager-sql-database-maintenance/

    You can check also this thread:

    https://docs.microsoft.com/en-us/sccm/core/clients/manage/collections/best-practices-for-collections

    Regards,

    SAAD Youssef

    _____

    Please remember to mark the replies as an answer if they help, thank you.

    Tuesday, July 9, 2019 3:11 PM
  • Hi,

    You can try to rebuild the index of your SQL database on the maintenance task (Administration=>Site configuration=>Sites=>Site maintenance) or directly with SSMS: https://www.scconfigmgr.com/2017/01/03/configuration-manager-sql-database-maintenance/

    You can check also this thread:

    https://docs.microsoft.com/en-us/sccm/core/clients/manage/collections/best-practices-for-collections

    Regards,

    SAAD Youssef

    _____

    Please remember to mark the replies as an answer if they help, thank you.

    We are using the Indexing script from Ola Hallengren on a nightly basis and we are slightly over the 200 limit of incremental collections according the the CEViewer we are under 5 minutes run time of the re-evaluation of those collections.
    Tuesday, July 9, 2019 3:17 PM
  • " over the 200 limit of incremental collections" and "under 5 minutes run time"

    Just my personal opinion, but we keep our incrementals under 50.  We manage over 380k clients with CM, fyi. You may want to examine what those 200 incremental collections are actually doing.  Do they make sense that they are an incremental collection?  What we find quite often is that people either don't understand what incremental really means, or it was literally a click they didn't mean to do; and it's accidentally an incremental collection, and they never meant it to be one.

    'under 5 minutes'... how much under?  A lot or a little?  that might affect your overall collection updating.

    Otherwise, yes, do look at the link Michael-CM posted.


    Standardize. Simplify. Automate.

    Tuesday, July 9, 2019 3:51 PM
  • The tool in my sig will help you view and change collection refresh times with just a few clicks.


    Richard Knight | Collection Refresh Manager | Automate detection rules for patch \ msp files | Twitter

    Tuesday, July 9, 2019 4:13 PM
  • Take a closer look at:

    https://www.asquaredozen.com/2019/02/21/sccm-collection-evaluation-troubleshooting-incremental-update-issues/



    Thanks looking over it now with our environment, see if we can see any changes.
    Tuesday, July 9, 2019 7:47 PM
  • " over the 200 limit of incremental collections" and "under 5 minutes run time"

    Just my personal opinion, but we keep our incrementals under 50.  We manage over 380k clients with CM, fyi. You may want to examine what those 200 incremental collections are actually doing.  Do they make sense that they are an incremental collection?  What we find quite often is that people either don't understand what incremental really means, or it was literally a click they didn't mean to do; and it's accidentally an incremental collection, and they never meant it to be one.

    'under 5 minutes'... how much under?  A lot or a little?  that might affect your overall collection updating.

    Otherwise, yes, do look at the link Michael-CM posted.


    Standardize. Simplify. Automate.

    We were able to modified a handful of collections to get the total below 200, according to CEViewer, it takes about 3:45 to run thru all the incremental, before it was around 4:05 to 4:15.  We are going to have conversation with the deployment team to see if we can eliminate more of them.   The way they are used is for impromptu software deployment, IE user submits a ticket for Software XYZ, it gets approved, computer\user gets added to an AD group that links into SCCM collections and deployment for software XYZ.  Using the incremental in this situation is eliminate as much time between the request and when the software starts installing.  The team adding to that AD groups is not the same team that manages\use SCCM, not the best solution for software control, but it has worked for us till now.


    • Edited by Evers_mark Tuesday, July 9, 2019 8:03 PM
    Tuesday, July 9, 2019 8:00 PM