Real-time performance monitoring and troubleshooting
Post Reply
albertwt
Veteran
Posts: 931
Liked: 52 times
Joined: Nov 05, 2009 12:24 pm
Location: Sydney, NSW
Contact:

Which SQL Server Express is lighter and not resource hogger?

Post by albertwt »

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 ! */
Vitaliy S.
VP, Product Management
Posts: 27347
Liked: 2785 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

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

Post by Vitaliy S. »

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.
Gostev
Chief Product Officer
Posts: 31754
Liked: 7259 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

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

Post by Gostev »

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.
albertwt
Veteran
Posts: 931
Liked: 52 times
Joined: Nov 05, 2009 12:24 pm
Location: Sydney, NSW
Contact:

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

Post by albertwt »

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 ! */
Alexey D.

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

Post by Alexey D. »

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.
DataAssure
Influencer
Posts: 12
Liked: never
Joined: Nov 10, 2010 3:19 pm
Full Name: Stephen Hui
Contact:

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

Post by DataAssure »

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
Vitaliy S.
VP, Product Management
Posts: 27347
Liked: 2785 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

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

Post by Vitaliy S. » 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.
albertwt
Veteran
Posts: 931
Liked: 52 times
Joined: Nov 05, 2009 12:24 pm
Location: Sydney, NSW
Contact:

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

Post by albertwt »

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 ! */
Vitaliy S.
VP, Product Management
Posts: 27347
Liked: 2785 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

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

Post by Vitaliy S. » 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!
albertwt
Veteran
Posts: 931
Liked: 52 times
Joined: Nov 05, 2009 12:24 pm
Location: Sydney, NSW
Contact:

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

Post by albertwt »

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 ! */
Vitaliy S.
VP, Product Management
Posts: 27347
Liked: 2785 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

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

Post by Vitaliy S. »

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.
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests