SQL express is required...

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

SQL express is required...

Veeam Logoby tinto1970 » Thu Dec 11, 2014 9:52 pm

Good day all,

i've got the email with the link for dowloading the product when at home, so i could not resist and installed it on my own desktop pc, which i use just for fun (facebook and youtube :D ).
It has 4 GB Ram.

I have been a bit surprised that sql express was installed, and using >300MB of memory even while backups were not running.
IMHO that's a bit heavy for small desktops, laptops and so on, sorry.

I've been using i.e. this one: http://www.aomeitech.com/aomei-backupper.html, which is able to backup machine while normally running, but does not need a sql server permanently installed on it....
I understand VeeamEndpointBackup has much more functionalities but, at least in my own pc at home, i don't need them, and i prefer to "keep it light".
Alessandro Tinivelli aka Tinto
@tinto1970
tinto1970
Enthusiast
 
Posts: 69
Liked: 25 times
Joined: Thu Sep 26, 2013 8:40 am
Location: Bologna, Italy
Full Name: Alessandro Tinivelli

Re: SQL express is required...

Veeam Logoby tinto1970 » Thu Dec 11, 2014 11:20 pm

tinto1970 wrote:I understand VeeamEndpointBackup has much more functionalities


and, last but not least, it's free but still supported, which is very important in business use
Alessandro Tinivelli aka Tinto
@tinto1970
tinto1970
Enthusiast
 
Posts: 69
Liked: 25 times
Joined: Thu Sep 26, 2013 8:40 am
Location: Bologna, Italy
Full Name: Alessandro Tinivelli

Re: SQL express is required...

Veeam Logoby tomhkr » Fri Dec 12, 2014 8:21 am

Also noticed this.
It makes Veeam Endpoint Backup the single largest user of memory after startup.

Could the SQL server be stopped when backups are not scheduled?
Is it possible to configure the SQL server to use less memory, say ~100MB?
tomhkr
Enthusiast
 
Posts: 38
Liked: 7 times
Joined: Mon Feb 03, 2014 7:40 am

Re: SQL express is required...

Veeam Logoby Vitaliy S. » Fri Dec 12, 2014 10:23 am

Hi Alessandro,

SQL Server Express is not required, we are using LocalDB for storing all metadata -> Design related

Thanks!
Vitaliy S.
Veeam Software
 
Posts: 19575
Liked: 1106 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: SQL express is required...

Veeam Logoby Dima P. » Fri Dec 12, 2014 10:39 am

Alessandro,
4GB RAM laptop only for Youtube and Facebook and 300Mb is to much for an localdb usage? :)
Dima P.
Veeam Software
 
Posts: 6263
Liked: 441 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: SQL express is required...

Veeam Logoby Gostev » Sat Dec 13, 2014 7:09 pm

tinto1970 wrote:I have been a bit surprised that sql express was installed, and using >300MB of memory even while backups were not running.
IMHO that's a bit heavy for small desktops, laptops and so on, sorry.

So my latest Firefox has 9 super light-weight tabs (forum topics) open right now, consuming 411MB of physical memory. Why is this not considered a problem by anyone? Just because its internal database is running in-proc and you cannot see it?
Gostev
Veeam Software
 
Posts: 21396
Liked: 2350 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: SQL express is required...

Veeam Logoby tsightler » Sat Dec 13, 2014 7:51 pm 1 person likes this post

I'm actually quite surprised to see 300MB being used by the SQLserver localdb process though. My local install is only using 90Mb. Any chance this is being misinterpreted by task manager reporting shared memory instead of private memory? On my local system right now I have VEB installed, with Outlook running, one remote desktop connection, and Chrome with three tabs (Gmail, Google Maps, and this forum), and Chrome is by far the biggest memory user (with, as Anton says, it's in-proc internal database). The SQLserver process is 7th on the list at 90MB, but there are 5 Chrome processes each using between 100-160MB (private working set), and even my RDP session is using 144MB. Even with the two VEB processes + SQLserver they're only using 160MB on my system, which I'd say is pretty light overall.
tsightler
Veeam Software
 
Posts: 4775
Liked: 1742 times
Joined: Fri Jun 05, 2009 12:57 pm
Full Name: Tom Sightler

Re: SQL express is required...

Veeam Logoby Dima P. » Sat Dec 13, 2014 8:01 pm 1 person likes this post

Yes, mine in idle state is 22 MBs, during backup - 55MBs
Dima P.
Veeam Software
 
Posts: 6263
Liked: 441 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: SQL express is required...

Veeam Logoby tomhkr » Mon Dec 15, 2014 7:45 am

It's not relevant to compare to Firefox or Chrome memory usage.
They are both programs that are constantly used. Tabs and windows are opened and closed. Memory is reserved and released.

The Endpoint SQL process eats 300MB at idle. Doing nothing. It's not waiting for a request that cannot be foreseen, like instant messangers or Skype would do.
If you want to compare Firefox to Endpoint, my Firefox uses 200MB (private) while doing nothing. No open tabs, freshly opened.

Attaching my sqlservr.exe process info. It is at idle, consuming 300MB memory (private).
It's a Windows 7 laptop with 16GB memory and a 120GB solid state disk.

I'd be very happy if it would run with the numbers you are posting, 22, 55 or even 90MB.

Image
tomhkr
Enthusiast
 
Posts: 38
Liked: 7 times
Joined: Mon Feb 03, 2014 7:40 am

Re: SQL express is required...

Veeam Logoby tomhkr » Mon Dec 15, 2014 8:41 am 1 person likes this post

Funny, 2 hours after my previous post the process is now down to about 60MB private.
This is much better! :mrgreen:
tomhkr
Enthusiast
 
Posts: 38
Liked: 7 times
Joined: Mon Feb 03, 2014 7:40 am

Re: SQL express is required...

Veeam Logoby Dima P. » Mon Dec 15, 2014 10:07 am

tomhkr,
Any other applications that may utilize localdb on board?
Dima P.
Veeam Software
 
Posts: 6263
Liked: 441 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: SQL express is required...

Veeam Logoby Mike Resseler » Mon Dec 15, 2014 4:52 pm

Hey Tomhkr,

I still think 60 MB is rather a lot. Personally I have been seeing an average of 35 MB, and I actually use the localDB for another solution also. Of course, during backup, the mem used is increasing but stil...

Can you check for other databases also? You might be surprised how many solutions use localDB. Our files are located under C:\Windows\System32\config\systemprofile

So please check and reply to Dima.
Mike Resseler
Veeam Software
 
Posts: 3173
Liked: 362 times
Joined: Fri Feb 08, 2013 3:08 pm
Location: Belgium, the land of the fries, the beer, the chocolate and the diamonds...
Full Name: Mike Resseler

Re: SQL express is required...

Veeam Logoby tomhkr » Wed Dec 17, 2014 12:49 pm

Sorry nothing else uses localDb. Currently running at 110MB private, acceptable I think. Way better than initial 300MB..
tomhkr
Enthusiast
 
Posts: 38
Liked: 7 times
Joined: Mon Feb 03, 2014 7:40 am

Re: SQL express is required...

Veeam Logoby Dima P. » Wed Dec 17, 2014 2:20 pm 1 person likes this post

tomhkr,

Thank you for the update. We’ve actually run several tests on different machines. The average load we noticed is between 100-200Mbs, and it depends on the operating system. For instance on my desktop machine Win 7 SQL in idle state ~ 150Mb, however on the Win 8.1 tablet it does not go higher than 55MB during backup (I think there is a chance it is related to the Connected Standby default power plan)
Dima P.
Veeam Software
 
Posts: 6263
Liked: 441 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: SQL express is required...

Veeam Logoby davegold » Sat May 16, 2015 11:32 pm

Is there a way to tune the amount of RAM used?
Mine was at 180MB after doing a backup, and 31MB after cycling the Veeam Endpoint service

Dave
davegold
Enthusiast
 
Posts: 64
Liked: 2 times
Joined: Thu Dec 02, 2010 4:58 pm
Full Name: Dave Gold

Next

Return to Veeam Agent for Windows



Who is online

Users browsing this forum: No registered users and 12 guests