Which SQL Server Express is lighter and not resource hogger?

Real-time performance monitoring and troubleshooting

Which SQL Server Express is lighter and not resource hogger?

Veeam Logoby albertwt » Thu Mar 31, 2011 3:14 am

Hi,

I'm about to install Veeam monitor 5 on my laptop with Win XP Pro SP3, which Express Edition is the lighter and does not consume much RAM and disk I/O ?

SQL Server 2005 Express Edition with Advanced Services SP3

SQL Server 2005 Express Edition SP3

SQL Server 2008 Express Edition

SQL Server 2008 Express Edition R2
--
/* Veeam software enthusiast user & supporter ! */
albertwt
Expert
 
Posts: 607
Liked: 19 times
Joined: Thu Nov 05, 2009 12:24 pm
Location: Sydney, NSW

Re: Which SQL Server Express is lighter and not resource hog

Veeam Logoby Vitaliy S. » Thu Mar 31, 2011 7:47 am

Hi Albert,

I'm not a great expert in SQL Servers, though something tells me that SQL Server 2005 would consume less resources. Moreover, this SQL Server is shipped together with the default setup.

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

Re: Which SQL Server Express is lighter and not resource hog

Veeam Logoby Gostev » Thu Mar 31, 2011 2:53 pm

Hi Albert,

For light-weight solution, go with SQL Server 2005 SP4 Express for sure, but note that it has limit on max database size of 4GB. Of course, SQL Server 2008 R2 Express is noticeable more "fat", but the good thing about it is that it has limit on max database size of 10GB.

Thanks.
Gostev
Veeam Software
 
Posts: 21396
Liked: 2350 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: Which SQL Server Express is lighter and not resource hog

Veeam Logoby albertwt » Thu Mar 31, 2011 10:25 pm

Vitaliy and Gostev, many thanks for the reply well it seems that 4 GB should be more than enough for me since I run the Veeam free monitor 5 as freeware mode.
--
/* Veeam software enthusiast user & supporter ! */
albertwt
Expert
 
Posts: 607
Liked: 19 times
Joined: Thu Nov 05, 2009 12:24 pm
Location: Sydney, NSW

Re: Which SQL Server Express is lighter and not resource hog

Veeam Logoby Alexey D. » Fri Apr 01, 2011 7:34 am

Please consider than even in free mode, Monitor keeps all the performance data. You just have limited access to it - so if you decide to upgrade to paid, data will still be there.
Alexey D.
 

Re: Which SQL Server Express is lighter and not resource hog

Veeam Logoby DataAssure » Wed Jun 01, 2011 5:10 pm

I'll be installing Veeam Monitor to monitor over 80 vSphere hosts containing 200+ guest instances, mostly Windows servers. Should I go w/ SQL2K8R2 Express or just standard. How much disk space I need to allocate if I need to keep all data for at least 3 months.
Any best practice guide on large-scale Veeam Monitor design/deployment? TIA
DataAssure
Influencer
 
Posts: 12
Liked: never
Joined: Wed Nov 10, 2010 3:19 pm
Full Name: Stephen Hui

Re: Which SQL Server Express is lighter and not resource hog

Veeam Logoby Vitaliy S. » Wed Jun 01, 2011 5:28 pm 1 person likes this post

Hello Stephen,

Given the specifics of your deployment, I would definitely go with a SQL Server Standard Edition. Moreover, I would prefer to use a remote SQL Server in order to have best performance possible.

By the way, have you had a chance to check out our Veeam Monitor Database Sizing Calculator, which is available for download from our website?

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

Re: Which SQL Server Express is lighter and not resource hog

Veeam Logoby albertwt » Wed Oct 29, 2014 10:29 pm

Vitaliy S. wrote:Hello Stephen,

Given the specifics of your deployment, I would definitely go with a SQL Server Standard Edition. Moreover, I would prefer to use a remote SQL Server in order to have best performance possible.

By the way, have you had a chance to check out our Veeam Monitor Database Sizing Calculator, which is available for download from our website?

Thanks.


Hi,

The link to the database sizing calculator is now redirected to this page: http://www.veeam.com/one-vmware-hyper-v ... rting.html , so which one is hte correct updated new location ?
--
/* Veeam software enthusiast user & supporter ! */
albertwt
Expert
 
Posts: 607
Liked: 19 times
Joined: Thu Nov 05, 2009 12:24 pm
Location: Sydney, NSW

Re: Which SQL Server Express is lighter and not resource hog

Veeam Logoby Vitaliy S. » Thu Oct 30, 2014 11:37 am 1 person likes this post

Hi Albert,

Yes, that database calculator is no longer relevant, almost 4 years have passed since that time, so thank you for using search and posting into existing topic. Can you please tell me what is the size of your environment (N. of VMs, hosts, datastores) and what SQL Server edition do you have installed?

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

Re: Which SQL Server Express is lighter and not resource hog

Veeam Logoby albertwt » Thu Oct 30, 2014 12:20 pm

Vitaliy S. wrote:Hi Albert,

Yes, that database calculator is no longer relevant, almost 4 years have passed since that time, so thank you for using search and posting into existing topic. Can you please tell me what is the size of your environment (N. of VMs, hosts, datastores) and what SQL Server edition do you have installed?

Thanks!


Vitaliy,

Yes, it's been long time since I move into new company who is now using Veeam :-) so I'm back in managing and using this great software again :D
my environment is:

1x VCenter Standard
15 ESXi 5.1u1 hosts

200 VMs
15 SQL Servers ranging from 2005 SP4 up to 2012 SP1 Virtual and Physical
plus I'm going to use VeeamONE to do the monitoring of the VMs instead of using VCenter.

The reason I need thesizing is that because I'm consolidating those SQL Servers, so I need to know roughly the DB LUNs that I need to provision.
--
/* Veeam software enthusiast user & supporter ! */
albertwt
Expert
 
Posts: 607
Liked: 19 times
Joined: Thu Nov 05, 2009 12:24 pm
Location: Sydney, NSW

Re: Which SQL Server Express is lighter and not resource hog

Veeam Logoby Vitaliy S. » Thu Oct 30, 2014 2:11 pm

Good to know you're back to using Veeam :)

As regards the infrastructure you have, then I would expect the max size of the database to be from 10 GB to 30 GB (depends on how chatty your infrastructure is). And I would definitely recommend to use either SQL Server 2008R2 or 2012 for hosting Veeam ONE database.
Vitaliy S.
Veeam Software
 
Posts: 19564
Liked: 1104 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov


Return to Monitoring



Who is online

Users browsing this forum: No registered users and 2 guests