Good morning everyone,
lately I have noticed a high cpu usage over time of a process named "sqlserver.exe", whose parent is Veeam backup. It looks like a background process consuming CPU although there's no backup running.... I have read about other using commenting on this issue...
Is this process running as a hook to collect and update the list of modified files so that on next backup only those files are being saved?
Or?
This is a SQL process that is responsible for storing Agent configuration data (Jobs, sessions, restore points, etc.) and it does not consume a significant amount of resources (that is proven on your screenshot). It is running at the same time when our Agent service is running (the parent service on your screenshot) and can not be disabled.
I keep the agent running so that as soon as the external unit is plugged in, it will start backup immediately.
Maybe I could opt for launching the Agent only when required....
Why does the SQL process runs if nothing is happening poses a question from an architectural perspective, as the process used more CPU time than any other process, including the active ones.....
BUT, this tool does its job, and works pretty well...... so I can deal with this minor issue!
Slight CPU load is expected since Agent service and Agent UI application running in the background (notice the system tray icon) constantly read data (jobs schedule, sessions status, etc.) from the underlying database.
Could you please raise a support request, upload all the logs (including ProcMon), screenshots indicating "spikes", "high CPU usage" etc., and information about the hardware of your machine and let us know your support case ID? We'd like to take a detailed look at this situation.