Forums on Intune, SCCM, and Windows 11

Welcome to the forums. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your topics and posts, as well as connect with other members through your own private inbox!

PENDING Console Performance due to SQL Deadlocks

leonardreeves

Member
Messages
21
Reaction score
1
Points
3
We continue to experience slow console performance from time to time where collections display hour glasses for longer times than expected along with overall slowness while in the SCCM console. Each time this occurs I reach out to our SQL team and they usually confirm that there were deadlocks or deadlocks that just ended.

Curious if anyone has any recommendations that would help us identify the root cause or reduce them via indexing, etc. We are at Config Mgr 2409 with the latest rollup. I have a Idera Deadlock Report if someone would like to view some samples.

We have opened a case with Microsoft but are still waiting for initial contact.

Thank you in advance.
 

Forum statistics

Threads
7,130
Messages
27,846
Members
18,145
Latest member
Rothgar
Back
Top