Standalone backup agent for Microsoft Windows servers and workstations (formerly Veeam Endpoint Backup FREE)
Post Reply
Zek
Novice
Posts: 5
Liked: 2 times
Joined: Mar 29, 2019 3:32 am
Contact:

SQL server cpu usage on idle state

Post by Zek » Mar 29, 2019 4:08 am

Sometimes, when there is no active jobs on workstations with installed agent (v3.0.0.748), process sqlservr.exe (localdb instance belongs to veeam) shortly usage significant CPU cycles (10-30%), that has a negative effect on performance in high-load applications (like games) or for low-performance PC like old laptops, and impact on battery life. In my opinion, a good backup application should not use system resources until it starts to perform the task. I suspect some maintenance plans in SQL are working at this moment.
To avoid this, I have to close the veeam agent and start it only when i need to run job.
Could please developers work on optimizing the usage of SQL server, because from this point the solution looks much less attractive than other products?

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

Re: SQL server cpu usage on idle state

Post by Dima P. » Mar 29, 2019 6:16 pm

Hello Zek,

Any chance you have another application that might use localdb? Thanks!

Zek
Novice
Posts: 5
Liked: 2 times
Joined: Mar 29, 2019 3:32 am
Contact:

Re: SQL server cpu usage on idle state

Post by Zek » Apr 01, 2019 11:25 pm

No, this is an instance belongs to the veeam agent, it is installed by distributive, and it also starts and stops with the service veeam agent. Other applications cannot use it because there is only created by installer users in db.

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

Re: SQL server cpu usage on idle state

Post by Dima P. » Apr 05, 2019 6:35 pm

Noted. We will review your idea regarding the maintenance plans, thanks for sharing your feedback!

Zek
Novice
Posts: 5
Liked: 2 times
Joined: Mar 29, 2019 3:32 am
Contact:

Re: SQL server cpu usage on idle state

Post by Zek » Apr 07, 2019 5:30 pm 2 people like this post

IMHO, it would be a good solution to stop the sql service while there are no active tasks, and start the service when job is activated.

Skeltek
Lurker
Posts: 2
Liked: 1 time
Joined: Apr 07, 2019 7:18 pm
Full Name: Halim Paracki
Contact:

Re: SQL server cpu usage on idle state

Post by Skeltek » Apr 07, 2019 7:37 pm 1 person likes this post

Greetings, I can confirm this issue. The Veeam Agent for Windows is unusable on my Windows10 machine. The regular CPU usage peaks render most other applications nearly unusable, and prohbit a normal workflow. Every 30-60 seconds the CPU load spikes to about 50% (I got an old dual core 2.5GHz Athlon on that computer) by sqlservr.exe, preventing other apps from proper execution during that time, basically freezing the screen and denying any calcs there.
The SQL server module was installed by Veeam and was neither present nor in use prior to installation of Veeam. I dont see any point in having a weekly backup, if the tray uses this much CPU and breaks the workflow of every other app for the whole week.
Tested this on both my main Computer running Windwos 10 Education (german) and on my notebook running Windows 10 Student (english).

Even Im still a student, I wouldnt recommend using Veeam to my employer when I get a job if this issue persists. I dont get why using the SQL server is even a requirement while the Veeam agent is inactive for another week until the next backup is scheduled.

Skeltek
Lurker
Posts: 2
Liked: 1 time
Joined: Apr 07, 2019 7:18 pm
Full Name: Halim Paracki
Contact:

Re: SQL server cpu usage on idle state

Post by Skeltek » Apr 08, 2019 2:00 pm

Found a solution at least for me:
Apparently there was MySQL Workbench 6.3 CE (1033) copy installed by either Veeam or it was an unused instal from a year ago which I never cared deinstalling.
After deinstalling that MySQL Workbench package, deinstalling WD Drive Utilities package and some other applications, the system runs fine again.

From reading various articles online I initially believed the SQL stuff got installed exclusively by Veeam, but apparently Veeam doesnt need the deinstalled MySQLWorkbench to run and do backups successfully.
After deinstalling the MySQL Workbench and a reboot, there is still a 'SQL Server Wndows NT - 64 Bit' shown running in the task manager, except this time it doesnt make any problems.

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

Re: SQL server cpu usage on idle state

Post by Dima P. » Apr 09, 2019 11:54 am 1 person likes this post

Halim,

MySQL Workbench is not a part of Veeam Agent for Windows installation bundle, likely you got it from another source. Glad to hear that your performance was not caused by our components, so thanks for sharing!

FaberfoX
Novice
Posts: 4
Liked: 2 times
Joined: Sep 22, 2018 8:27 pm
Full Name: Fabricio Ferrari
Contact:

Re: SQL server cpu usage on idle state

Post by FaberfoX » Sep 26, 2019 7:29 am 1 person likes this post

I see the same issue on my computer, 20% cpu usage from the single sqlservr.exe instance that belongs to veeam agent on an i5-4460.
I've tried manually stopping the localdb instance using sqllocaldb from a cmd.exe started as system (using psexec from sysinternals), but that leaves the veeam agent in a zombie state, running but non responsive.
If I stop the veeam service and manually start the localdb instance, sqlservr.exe cpu usage stays at 0, but goes back to 20% as soon as I restart the service.
Right now, I've resorted to using task scheduler to stop the veeam service after event 190 is posted (backup finished), and to start it one minute before my daily scheduled backup.

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

Re: SQL server cpu usage on idle state

Post by Dima P. » Sep 26, 2019 7:00 pm

Hello Fabricio,

Is it possible for you to raise a support case and share the case ID with us? Thank you in advance!

FaberfoX
Novice
Posts: 4
Liked: 2 times
Joined: Sep 22, 2018 8:27 pm
Full Name: Fabricio Ferrari
Contact:

Re: SQL server cpu usage on idle state

Post by FaberfoX » Sep 26, 2019 11:36 pm

Done, case #03785279 opened

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

Re: SQL server cpu usage on idle state

Post by Dima P. » Oct 04, 2019 12:30 pm

Thank you, passed to QA team.

Keyser
Enthusiast
Posts: 43
Liked: 5 times
Joined: Feb 13, 2014 10:11 am
Contact:

Re: SQL server cpu usage on idle state

Post by Keyser » Oct 04, 2019 2:05 pm

I have seen the exact same issue since the agent was installed on my machine back when it was v.2.x
It's still the same here at v.3

Perhaps it's related to the destination being a network NAS with specified credentials in the agent?
That's my config, and that's probably not the most used scenario.

-Keyser

Post Reply

Who is online

Users browsing this forum: Google [Bot] and 7 guests