This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 83%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
Hi,
Our SQL server has been running at 100% capacity for a few days now. It is installed on the same VM as SCCM.
Many messages appear in the statesys.log every second.
Does anyone have an idea what the problem could be?
How often are you telling you clients to scan for software updates? Are you doing a lot of deployments? Or are you doing a lot of baselines? Have you reviewed your status messages? Is you Sql server under powered?
hey Garth,
thank you very much for your reply.
i hoped it would get better over the weekend. Unfortunately, that was not the case.
We have very few baselines and no new ones have been added in a long time. Software updates are configured in the client settings to once a day.
What do you mean by status messages? you can open the picture in a new tab to make it readable. I'm sorry, it is german.
the CPU load was raising from day to day. It starts around 6 am and lowers at the end of the day around 5-7pm.
at first, i thought it might be requests from PCs. however, it would then have to be considerably less on weekends. However, there is also a high CPU load on the weekend. So, I am not sure and I have no clue :(
There is a lot of errors in that screenshot, You need to fix those.
I'm not surprised that over a weekend your CPU is maxing out. This would suggest that you are doing something like scanning for SU to often or triggering baselines too often or scanning SW/HW inventory too much.
You will need to dig deeper into this to determine what is causing the load and you might want to increase the CPU on you SQL server too.
Start by reviewing how often each item scan is done. Review your inboxes to see where you are getting backlogs as this will point you to the problems.
hey Garth,
Now I know that if I stop IIS service, CPU load is dropping to around 5%.
what can that mean? What is CCM Server Framework Pool doing?
Did you review you settings and inboxes to see what is coming in?