-
- Veteran
- Posts: 908
- Liked: 51 times
- Joined: Nov 05, 2009 12:24 pm
- Location: Sydney, NSW
- Contact:
Which SQL Server Express is lighter and not resource hogger?
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
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 ! */
/* Veeam software enthusiast user & supporter ! */
-
- VP, Product Management
- Posts: 27267
- Liked: 2768 times
- Joined: Mar 30, 2009 9:13 am
- Full Name: Vitaliy Safarov
- Contact:
Re: Which SQL Server Express is lighter and not resource hog
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.
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.
-
- Chief Product Officer
- Posts: 31419
- Liked: 6992 times
- Joined: Jan 01, 2006 1:01 am
- Location: Baar, Switzerland
- Contact:
Re: Which SQL Server Express is lighter and not resource hog
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.
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.
-
- Veteran
- Posts: 908
- Liked: 51 times
- Joined: Nov 05, 2009 12:24 pm
- Location: Sydney, NSW
- Contact:
Re: Which SQL Server Express is lighter and not resource hog
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 ! */
/* Veeam software enthusiast user & supporter ! */
Re: Which SQL Server Express is lighter and not resource hog
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.
-
- 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
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
Any best practice guide on large-scale Veeam Monitor design/deployment? TIA
-
- VP, Product Management
- Posts: 27267
- Liked: 2768 times
- Joined: Mar 30, 2009 9:13 am
- Full Name: Vitaliy Safarov
- Contact:
Re: Which SQL Server Express is lighter and not resource hog
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.
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.
-
- Veteran
- Posts: 908
- Liked: 51 times
- Joined: Nov 05, 2009 12:24 pm
- Location: Sydney, NSW
- Contact:
Re: Which SQL Server Express is lighter and not resource hog
Hi,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.
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 ! */
/* Veeam software enthusiast user & supporter ! */
-
- VP, Product Management
- Posts: 27267
- Liked: 2768 times
- Joined: Mar 30, 2009 9:13 am
- Full Name: Vitaliy Safarov
- Contact:
Re: Which SQL Server Express is lighter and not resource hog
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!
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!
-
- Veteran
- Posts: 908
- Liked: 51 times
- Joined: Nov 05, 2009 12:24 pm
- Location: Sydney, NSW
- Contact:
Re: Which SQL Server Express is lighter and not resource hog
Vitaliy,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!
Yes, it's been long time since I move into new company who is now using Veeam
![Smile :-)](https://forums.veeam.com/images/smilies/icon_smile.gif)
![Very Happy :D](https://forums.veeam.com/images/smilies/icon_biggrin.gif)
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 ! */
/* Veeam software enthusiast user & supporter ! */
-
- VP, Product Management
- Posts: 27267
- Liked: 2768 times
- Joined: Mar 30, 2009 9:13 am
- Full Name: Vitaliy Safarov
- Contact:
Re: Which SQL Server Express is lighter and not resource hog
Good to know you're back to using Veeam ![Smile :)](https://forums.veeam.com/images/smilies/icon_smile.gif)
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.
![Smile :)](https://forums.veeam.com/images/smilies/icon_smile.gif)
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.
Who is online
Users browsing this forum: No registered users and 4 guests