VEB on Windows 10 - Odd SQL behaviour

[PedroVDP]

Hi,

I installed VEB a few days prior to doing the W10 upgrade to be sure I had a fall-back. Having done it so recently however I don't know if the behaviour is due to the usage of the rig or if it's due to W10. I used the KB to fix the installation and it seems to be working just fine now, apart form this oddity.

The behaviour is the following: when I am playing one of my games (this being a home computer) I noticed that the SQL instance related to VEB was suddenly eating 5-15% CPU. On its own it's not very noticable but when the rest of my applications running, the game primarily, already guzzle up 70-85% of the CPU this extra load suddenly becomes an issue. When I am not playing the game, it's not presenting the behaviour.

I do have to add that the game is installed on the system partition (seeing that is an SSD) and is quite resource heavy in terms of disk reads... It shouldn't be writing much however so it struck me as odd why the SQL instance would be so active. When the VEB service is not running it also is not presenting this issue so it's very much VEB doing... something?...

Anyone who has a W7 with and SSD and a resource hungy game that can confirm the behaviour? Or anyone on W10 already with big disk reads who can confirm it isn't just me?


P

[JaxIsland7575]

PedroVDP,
I do not have a setup like yours with a CPU intensive game or application. What I am curious though is what kind of destination are you backing up to? If it is USB, is it connected during this time? And what is the setting for "Back up no more often than every"?

Cheers!

[Dima P.]

The behaviour is the following: when I am playing one of my games (this being a home computer) I noticed that the SQL instance related to VEB was suddenly eating 5-15% CPU. On its own it's not very noticable but when the rest of my applications running, the game primarily, already guzzle up 70-85% of the CPU this extra load suddenly becomes an issue. When I am not playing the game, it's not presenting the behaviour.

Are you sure that this game is not using SQL components? In addition, I wonder if throttling is enabled in the endpoint’s Control Panel > Settings?

[PedroVDP]

Throttling is set but backup is not running when it is presenting the issue.

The game (World of Warcraft) is not using any SQL components. It's self-contained within its own folder. It is quite I/O read intensive obviously loading its graphics.

When I check in performance monitor to see what it's doing it is guzzling cpu and just accessing the VEB database, not even massive read or write operations. It's not constant but can spike up quite high.



I'd just assume changed block tracking if I was doing massive writes but since I'm doing mostly reads it struck me as very odd behaviour.

[Dima P.]

According to the screenshot the resource consumption is not related to the Endpoint instance, but to the NTFS Volume log instead. Here is an explanation I found at the TechNet.

[hoFFy]

Hey Perdo,

I can confirm this behaviour, talked with support and after we couldn't find a reason for this, I accepted my situation, because my client is the only one in our company I'm administrating and I haven't seen such a behaviour at our customers, too.

Here is a screenshot of my resource monitor

[Dima P.]

Sebastian,
Can you re-take the screenshot with the "sql filter" enabled in the resource monitor?

[PedroVDP]

Apologies for the late reply but I've been out and about and wanted to go to v1.1 to make sure the problem was still current. Sadly the behaviour seems to be still present.

[Dima P.]

I assume you did not read the article that I've posted above

$LogFile is an NTFS metadata file which catching all changes to your file system. It is not only be used by System, but also by your programs e.g. Chrome.exe or iTunes.exe.

Looking at your screenshot where $LogFile has the most resource consumption makes it clear that your issue is not related to the Endpoint's SQL usage anyhow.

[cygnus]

Hi,

since I installed Veeam Endpoint Backup, I notice significant background activities in the Windows 10 resource manager (run resmon.exe), even when Veeam Endpoint Backup is not running :

- The SQL server (sqlservr.exe activated by Veeam) has significant CPU activities.
- There is permanent network traffic (20.000 B/s) caused by the tasks Veeam.Endpoint.Tray.exe and Veeam.EndPoint.Service.exe.

What does VEB do in the background? Are these permanent background activities really necessary?

[Dima P.]

cygnus,

Your behavior looks similar to discussed in this thread. Can you please share the screenshot of your resource monitor as described above? Thanks.

[cygnus]

Thanks Dima. At least one of my two topics could be related to the SQL topic.

But what about the permanent network traffic of the Veeam processes?
Here is a screenshot. No programs running except resource monitor:

[cygnus]

... and the other topic, permanent CPU usage of SQL server:

[hoFFy]

[Dima P.]

Folks,

I’ve been trying to reproduce the behavior for the past week without any success, so once you confirm resource consumption to be unexpectedly high while Veeam Endpoint Backup is idle – shoot a case to support team. Additionally, make similar screenshots of process explorer with filters for SQL and Veeam Endpoint Backup and share it with the support crew. Once done – please post here the case ID, so I could forward it to QA team. Thanks in advance!

[hoFFy]

Case # 01022833
thx

[hoFFy]

A questions for the other users: Are you all using Google Chrome? What happens when you close Chrome? It seems reproducable that my cpu usage goes down when closing Chrome and goes up again when reopening Chrome... I surfed for a few minutes with the Internet Explorer, aht the same sites opened and the sqlservr.exe usage stayed low, near zero.

[Mike Resseler]

Sebastian,

Interesting, I'm going to look into it with some tracers to see if this might be something... No clue though to be honest

[hoFFy]

I have no clue, too. But if you have any ideas how I can trace the dependencies between Chrome and sqlservr.exe I'll give it a try, just tell me how

[Dima P.]

hoFFy,
Any Chrome extentions around?

[hoFFy]

Good point Dima!
I'm using three extensions, one of them is AdBlock 2.39.1
After disabling sqlservr.exe goes idle most of the time, after reactivating cpu usage goes up again...

Can someone confirm that?

[Mike Resseler]

I did some testing on different machines and I can't reproduce it...

I think you indeed need to check in the area of extensions... Disable one by one to see if it solves something?

Mike

[hoFFy]

Mike,

try the AdBlock extension

[Mike Resseler]

Nice

[Dima P.]

Yup. Looks like the right spot - Addblock's community forums has a good thread regarding the resource consumption.

P.S. I vote for keeping this extension anyway even if eats a lot of resources and makes you Chrome a bit laggy (Have to admit - yes it does). I love to see how it works.