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

SQL server CPU spike every minute

Post by willrussell » Feb 28, 2018 9:41 pm

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: 10306
Liked: 837 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. » Mar 02, 2018 12:21 pm

Hello willrussell,

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

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

Re: SQL server CPU spike every minute

Post by willrussell » Mar 03, 2018 11:32 am

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: 14
Liked: 6 times
Joined: Nov 23, 2017 5:05 pm
Contact:

Re: SQL server CPU spike every minute

Post by willrussell » Mar 06, 2018 4:21 pm

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: 14
Liked: 6 times
Joined: Nov 23, 2017 5:05 pm
Contact:

Re: SQL server CPU spike every minute

Post by willrussell » Mar 07, 2018 9:50 pm 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: 10306
Liked: 837 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. » Mar 08, 2018 10:13 am

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 » Mar 12, 2018 8:23 am

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 19 guests