SCCM MECM MCM Configuration Manager Taking a Long Time to Update Collections

 When Configuration Manager takes a long time to update device collections, there are several possible causes to evaluate.

First, go to Monitoring - Collection Evaluation Queue and review Full Evaluation Queue and Manual Evaluation Queue

Any evaluation exceeding 2 minutes is suspect. If it is a handful of collections, carefully evaluation the collection selection criteria.

If there a numerous collections exceeding 2 minutes (in our case we found numerous exceeding 20 minutes), evaluation of the SQL database performance tuning is recommended as Configuration Manager may run better when the site database is configured at a different SQL Server CE compatibility level. 

Refer to the following Microsoft Article:

https://learn.microsoft.com/en-us/troubleshoot/mem/configmgr/alerts-reports-queries/sql-query-times-out-or-console-slow-performance

Configuration Manager installs utilizing SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Server 2019, and SQL Server 2022 experiencing slower than normal collection evaluations can be improved when the site database is configured at a SQL Server CE compatibility level of 110.

Compatibility level can be set by running the following SQL Query:

ALTER DATABASE <ConfigurationManager_DataBase Name>

SET COMPATIBILITY_LEVEL = 110;

GO