SQLSERVER high 100% CPU Usage

[scottmattingly]

We are having issues with the CPU on our monitor server pegging at 100%. Seems like SQLSERVER and VEEAMDCS are the highest processes. Mostly it is SQLSERVER at 80 - 90% we have 110 hosts monitoring and are running 4.5 We have had this issue in 4.0, 4.01, and now 4.5. We see the issue in Typical or Advanced collection modes. I saw some posts on this being fixed in 4.01, but we still have such a high CPU usage. Any ideas on what we can do to get this to be useable for us?

Thanks!

[Gostev]

Scott, this is because of the size of you environment. We recommend using standalone SQL server for large environments, instead of running local SQL Express installation on Veeam Monitor server.

[scottmattingly]

OK, I can try that. I'll bring up a new SQL server and see if that helps.

Thanks!

[Gostev]

Also, if you are running SQL in a VM, give it 2 or 4 vCPUs.