I recently logged on to my SQL server and found the CPU was constantly running at ~80-90% on all cores. Looking in task manager and perfmon, I see it is the SQL Instanced used by Configmgr. Periodically, the usage will drop back down to the normal ~0-5% utilization, but then it jumps back up again later.
Is there something I might have mis-configured in SCCM that would cause such high CPU usage?
(As I wrote this post, I watched the CPU Utilization drop off again. It's sitting at about 0.9% now.)
SCCM 2012 SP1
SQL 2008 R2 SP1 CU9
Approx 300 SCCM managed clients
1 Primary site server
2 management points
2 distribution points