SCCM Console Performance Issues in MECM 2403

Question

In an environment with MECM 2403, the site console is experiencing slow performance, taking a significant amount of time to open. CPU and memory performance metrics appear to be fine.

What are common causes to investigate for this slow performance, and what steps can be taken to resolve it?

Answer 1

Hi, @Pall Piars

Thank you for posting in Microsoft Q&A forum.

The slow console performance may caused by Database Cardinality Estimation (CE) Issues, changes in SQL Server CE in versions like SQL Server 2014, 2016, and 2017 can lead to performance issues with certain queries. It may be beneficial to check the compatibility level of the site database and adjust it if necessary.

For your reference:

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

---

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".