Standalone backup agent for Microsoft Windows servers and workstations (formerly Veeam Endpoint Backup FREE)
Post Reply
willrussell
Service Provider
Posts: 16
Liked: 7 times
Joined: Nov 23, 2017 5:05 pm
Contact:

SQL server CPU spike every minute

Post by willrussell »

Hi there,

I have a machine with VAW Free, and the CPU spikes to 10-15% roughly every minute. This is with no backup jobs running.
Image

The spikes are caused by the SQL server process (SQL is only used for VAW).

If I stop the VAW service, the spikes stop.

Image

Any ideas?

Thanks,

Will

Dima P.
Product Manager
Posts: 11528
Liked: 1000 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: SQL server CPU spike every minute

Post by Dima P. »

Hello willrussell,

Do you have any Antivirus Software installed? Please share the screenshot of your Resource Monitor. Thanks.

willrussell
Service Provider
Posts: 16
Liked: 7 times
Joined: Nov 23, 2017 5:05 pm
Contact:

Re: SQL server CPU spike every minute

Post by willrussell »

Hi there,

It's Windows 10 using the built-in Windows Defender. I tried disabling real-time protection, but it didn't help.

Resource monitor just confirms the SQL process using the CPU. The following was captured during the spike.

Image

However, I reset the VAW database using the article at https://www.veeam.com/kb2335 and it seems to have stopped the spikes for now. I'll let you know if they come back (only one full backup has run so far).

Thanks,

Will

willrussell
Service Provider
Posts: 16
Liked: 7 times
Joined: Nov 23, 2017 5:05 pm
Contact:

Re: SQL server CPU spike every minute

Post by willrussell »

Sadly the spikes seem to have returned.

I'm unsure of what tests / diagnostic I can do. I've stopped the Veeam Agent service and started the SQL LocalDB manually using SqlLocalDb.exe (had to do this as system via psexec). There didnt seem to be any spikes when I did this, but the when I checked next, the SQL instance had stopped itself anyway.

I tried to use the tracing function of SqlLocalDb.exe, but the timestamps of the trace files didn't change, so I'm guessing there's nothing to be gained from those (and I don't have Sql Profiler installed).

Any diagnostic suggestions welcome.

Will

willrussell
Service Provider
Posts: 16
Liked: 7 times
Joined: Nov 23, 2017 5:05 pm
Contact:

Re: SQL server CPU spike every minute

Post by willrussell » 2 people like this post

OK. I tested a bit more thoroughly by running the SQL instance alone - and I was wrong about it not causing the spikes. It seems as though when VeeamEndpointBackupSvc is stopped, but the SQL LocalDB instance is started, the regular CPU spikes do continue.

Therefore not a Veeam problem, but a SQL one. However, I'm still stuck on the possible cause as I am not a SQL expert. Will update if I find more.

Dima P.
Product Manager
Posts: 11528
Liked: 1000 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: SQL server CPU spike every minute

Post by Dima P. »

Hello willrussell.

Thank you for sharing the updates. Please keep us posted!

flaren
Veeam Software
Posts: 23
Liked: 5 times
Joined: Mar 18, 2013 9:00 am
Full Name: Alexander Lupashku
Contact:

Re: SQL server CPU spike every minute

Post by flaren »

This issue happens when there is not enough free memory on the machine running SQL LocalDB. Not sure though if Microsoft is going to do anything about it.
VCSP Support | Veeam Software

Post Reply

Who is online

Users browsing this forum: No registered users and 7 guests