VEB on Windows 10 - Odd SQL behaviour

Backup agent for Microsoft Windows servers and workstations (formerly Veeam Endpoint Backup FREE)

VEB on Windows 10 - Odd SQL behaviour

Veeam Logoby PedroVDP » Fri Jul 31, 2015 1:41 pm

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
PedroVDP
Service Provider
 
Posts: 18
Liked: 2 times
Joined: Wed Jan 18, 2012 9:10 am

Re: VEB on Windows 10 - Odd SQL behaviour

Veeam Logoby JaxIsland7575 » Fri Jul 31, 2015 5:32 pm

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!
VMCE v9
JaxIsland7575
Veeam Vanguard
 
Posts: 364
Liked: 98 times
Joined: Mon Apr 27, 2015 1:59 pm
Location: NY, USA
Full Name: Ryan Jacksland

Re: VEB on Windows 10 - Odd SQL behaviour

Veeam Logoby Dima P. » Sun Aug 02, 2015 4:36 pm

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?
Dima P.
Veeam Software
 
Posts: 6242
Liked: 440 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: VEB on Windows 10 - Odd SQL behaviour

Veeam Logoby PedroVDP » Sun Aug 02, 2015 9:17 pm

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.

Image

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.
PedroVDP
Service Provider
 
Posts: 18
Liked: 2 times
Joined: Wed Jan 18, 2012 9:10 am

Re: VEB on Windows 10 - Odd SQL behaviour

Veeam Logoby Dima P. » Mon Aug 03, 2015 1:08 pm 2 people like this post

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.
Dima P.
Veeam Software
 
Posts: 6242
Liked: 440 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: VEB on Windows 10 - Odd SQL behaviour

Veeam Logoby hoFFy » Tue Aug 04, 2015 7:28 am

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

Image
VMCE 7 / 8 / 9, VCP-DC 5 / 5.5 / 6, MCITP:SA
Blog: machinewithoutbrain.de
hoFFy
Veeam ProPartner
 
Posts: 161
Liked: 25 times
Joined: Fri Apr 27, 2012 1:10 pm
Location: Germany / Lohne
Full Name: Sebastian Hoffmann

Re: VEB on Windows 10 - Odd SQL behaviour

Veeam Logoby Dima P. » Wed Aug 05, 2015 12:34 pm

Sebastian,
Can you re-take the screenshot with the "sql filter" enabled in the resource monitor?
Dima P.
Veeam Software
 
Posts: 6242
Liked: 440 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: VEB on Windows 10 - Odd SQL behaviour

Veeam Logoby PedroVDP » Sun Aug 09, 2015 10:14 pm

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.

Image
PedroVDP
Service Provider
 
Posts: 18
Liked: 2 times
Joined: Wed Jan 18, 2012 9:10 am

Re: VEB on Windows 10 - Odd SQL behaviour

Veeam Logoby Dima P. » Mon Aug 10, 2015 12:01 pm

I assume you did not read the article that I've posted above :D
$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.
Dima P.
Veeam Software
 
Posts: 6242
Liked: 440 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

[MERGED] Network traffic and SQL server: what does

Veeam Logoby cygnus » Tue Sep 01, 2015 3:04 pm

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?
cygnus
Novice
 
Posts: 5
Liked: 1 time
Joined: Tue Sep 01, 2015 2:42 pm

Re: VEB on Windows 10 - Odd SQL behaviour

Veeam Logoby Dima P. » Tue Sep 01, 2015 3:20 pm

cygnus,

Your behavior looks similar to discussed in this thread. Can you please share the screenshot of your resource monitor as described above? Thanks.
Dima P.
Veeam Software
 
Posts: 6242
Liked: 440 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: VEB on Windows 10 - Odd SQL behaviour

Veeam Logoby cygnus » Tue Sep 01, 2015 4:07 pm

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:

Image
cygnus
Novice
 
Posts: 5
Liked: 1 time
Joined: Tue Sep 01, 2015 2:42 pm

Re: VEB on Windows 10 - Odd SQL behaviour

Veeam Logoby cygnus » Tue Sep 01, 2015 4:18 pm

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

Image
cygnus
Novice
 
Posts: 5
Liked: 1 time
Joined: Tue Sep 01, 2015 2:42 pm

Re: VEB on Windows 10 - Odd SQL behaviour

Veeam Logoby hoFFy » Wed Sep 02, 2015 6:00 am

Image
VMCE 7 / 8 / 9, VCP-DC 5 / 5.5 / 6, MCITP:SA
Blog: machinewithoutbrain.de
hoFFy
Veeam ProPartner
 
Posts: 161
Liked: 25 times
Joined: Fri Apr 27, 2012 1:10 pm
Location: Germany / Lohne
Full Name: Sebastian Hoffmann

Re: VEB on Windows 10 - Odd SQL behaviour

Veeam Logoby Dima P. » Fri Sep 11, 2015 4:50 pm

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!
Dima P.
Veeam Software
 
Posts: 6242
Liked: 440 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Next

Return to Veeam Agent for Windows



Who is online

Users browsing this forum: majones and 6 guests