4,608 questions
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?
statesys.log notifications - SQL Server 100% - SCCM 2023
![](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)
Sven H
46
Reputation points
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?
Microsoft Security | Intune | Configuration Manager | Other
SQL Server | Other
14,501 questions
1 answer
Sort by: Most helpful
-
Garth 5,801 Reputation points2023-06-16T11:22:05.5166667+00:00 -
Sven H 46 Reputation points
2023-06-19T06:58:02.6333333+00:00 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.
-
Sven H 46 Reputation points
2023-06-19T10:08:01.7166667+00:00 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 :(
-
Garth 5,801 Reputation points
2023-06-19T12:48:25.4666667+00:00 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.
-
Sven H 46 Reputation points
2023-06-21T06:23:54.5266667+00:00 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?
-
Garth 5,801 Reputation points
2023-06-21T09:50:22.64+00:00 Did you review you settings and inboxes to see what is coming in?
Sign in to comment -