VEB Config - why SQL?

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

Re: VEB Config - why SQL?

Veeam Logoby mkaec » Thu May 12, 2016 2:11 pm

Dima P. wrote:Could it be that your AV is somehow using the LocalDB as well?


How so? It's clear from the command line that the instance of LocalDB is dedicated to VEB. If AV wanted to use LocalDB, then I think it would need to start a second process.

"C:\Program Files\Microsoft SQL Server\120\LocalDB\Binn\\sqlservr.exe" -c -SMSSQL12E.LOCALDB -sLOCALDB#E54A66C0 -d"C:\Windows\System32\config\systemprofile\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\VeeamEndPoint\master.mdf" -l"C:\Windows\System32\config\systemprofile\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\VeeamEndPoint\mastlog.ldf" -e"C:\Windows\System32\config\systemprofile\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\VeeamEndPoint\error.log"

Also note that I was able to get the memory up to the same level when there was no AV installed.

Do you have VEB installed on any Windows Server 2012 R2 systems? I'd be interested in seeing a Task Manager screenshot of the LocalDB memory usage from one of those that has been running for 3 weeks.
mkaec
Expert
 
Posts: 200
Liked: 48 times
Joined: Thu Jul 16, 2015 1:31 pm
Full Name: Marc K

Re: VEB Config - why SQL?

Veeam Logoby Dima P. » Mon May 16, 2016 5:20 pm

Marc,

Sorry, forgot about your previous post. I am sure we got it in the QA lab – will update this thread with the results soon.
Dima P.
Veeam Software
 
Posts: 6988
Liked: 501 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: VEB Config - why SQL?

Veeam Logoby Dima P. » Thu Jun 09, 2016 3:51 pm

Marc,

Finally, got my hands on Windows 2016 TP5 with VEB running there since TP5 was published. Idle state 80MB / running state up to 200MB (although throttling was enabled but that should not take any effect of sql database at all).
Dima P.
Veeam Software
 
Posts: 6988
Liked: 501 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: VEB Config - why SQL?

Veeam Logoby mkaec » Thu Jun 09, 2016 5:37 pm

How much memory is in the system? How long had it been since the last reboot? Server 1 and Server 2 from my prior list have 48 GB of memory and the other 3 have 128 GB memory. I have a feeling that SQL sees this and decides it can use more. That could explain why my numbers were higher than typical.
mkaec
Expert
 
Posts: 200
Liked: 48 times
Joined: Thu Jul 16, 2015 1:31 pm
Full Name: Marc K

Re: VEB Config - why SQL?

Veeam Logoby Dima P. » Thu Jun 09, 2016 5:43 pm

Last was a week ago. It’s a VM with 8GB of RAM, so I can easily check your assumption. Let me double the memory and leave the VM running for a week or so.
Dima P.
Veeam Software
 
Posts: 6988
Liked: 501 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: VEB Config - why SQL?

Veeam Logoby sixstorm1 » Thu Aug 31, 2017 5:12 pm

Coming from thread veeam-agent-for-windows-f33/feature-request-lower-ram-usage-when-no-backups-running-t41900.html

I understand why you use SQL and for my part that is not the problem. Why don't you simply unload the SQL instance when the app is not backing up? This should be very simple to do and save ton of RAM. The client is backing up, like what, 10 minutes a day?
sixstorm1
Novice
 
Posts: 3
Liked: never
Joined: Thu May 11, 2017 12:49 am
Full Name: Olivier Robert

Re: VEB Config - why SQL?

Veeam Logoby Dima P. » Fri Sep 01, 2017 5:15 pm

Olivier,

Backup settings (including scheduling options) are stored in SQL. If we keep DB disabled it's impossible to trigger the backup at the given time.
Dima P.
Veeam Software
 
Posts: 6988
Liked: 501 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: VEB Config - why SQL?

Veeam Logoby mkaec » Fri Sep 01, 2017 7:35 pm

Settings only need to be read during startup and when the user makes a change. Otherwise, they can be cached in memory.

Code: Select all
void LoadSettings()
{
    SQLServer.Start();
    try
    {
        _backupSettings = LoadBackupSettings();
    }
    finally
    {
        SQLServer.ShutDown();  // Reference counting could be used to ensure shutdown only actually occurs if something else is not using the database (like a backup job).
    }
}
mkaec
Expert
 
Posts: 200
Liked: 48 times
Joined: Thu Jul 16, 2015 1:31 pm
Full Name: Marc K

Previous

Return to Veeam Agent for Windows



Who is online

Users browsing this forum: No registered users and 1 guest