SQL Server edition to chose

Real-time performance monitoring and troubleshooting

SQL Server edition to chose

Veeam Logoby EBoucq » Tue Oct 06, 2015 8:24 am

Hello,

To monitor a vcenter with 6 hosts and about 200 VMs, is an Express Edition of SQL Server enough ?
I installed Veeam One 8 yesterday and the database is already 2 GB !
(I set the retention to 6 months).

Thanks !
Eric
EBoucq
Expert
 
Posts: 213
Liked: 14 times
Joined: Fri Jan 21, 2011 10:10 am
Full Name: Eric Boucq

Re: SQL Server edition to chose

Veeam Logoby PTide » Tue Oct 06, 2015 10:16 am

Hi,

Express Edition is ok. With 6 hosts and 200 Vms you need to choose Typical installation of Veeam ONE, please check the article for detailed requirements.
PTide
Veeam Software
 
Posts: 3019
Liked: 246 times
Joined: Tue May 19, 2015 1:46 pm

Re: SQL Server edition to chose

Veeam Logoby Vitaliy S. » Tue Oct 06, 2015 11:36 am

SQL Server edition depends on how chatty your infrastructure is. Veeam ONE database will keep growing for 2 weeks, during this period it will save most of the performance data. After that it should settle down and grow slower.
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: SQL Server edition to chose

Veeam Logoby EBoucq » Tue Oct 06, 2015 11:39 am

Thank you Vitaly...
I'm a bit worried because the max size is 10 GB and it's about 2 GB already so I'll keep an eye on the database.

Regards,
Eric
EBoucq
Expert
 
Posts: 213
Liked: 14 times
Joined: Fri Jan 21, 2011 10:10 am
Full Name: Eric Boucq

Re: SQL Server edition to chose

Veeam Logoby Vitaliy S. » Tue Oct 06, 2015 11:49 am

As far as I remember we should have an alarm for the database size, please check out our internal alarms in v8. It should be either in v8 or in v9 (scheduled to this year).
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: SQL Server edition to chose

Veeam Logoby EBoucq » Mon Oct 12, 2015 8:59 am

Vitaliy,

FYI, after less than a week, the database size is now 7 GB ! So I don't think an Express Edition is enough for 6 hosts and 200 VMs....
EBoucq
Expert
 
Posts: 213
Liked: 14 times
Joined: Fri Jan 21, 2011 10:10 am
Full Name: Eric Boucq

Re: SQL Server edition to chose

Veeam Logoby Vitaliy S. » Mon Oct 12, 2015 11:03 am

Are you using Hyper-V or VMware?
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: SQL Server edition to chose

Veeam Logoby EBoucq » Mon Oct 12, 2015 11:51 am

VMware
EBoucq
Expert
 
Posts: 213
Liked: 14 times
Joined: Fri Jan 21, 2011 10:10 am
Full Name: Eric Boucq

Re: SQL Server edition to chose

Veeam Logoby Vitaliy S. » Mon Oct 12, 2015 11:54 am

Ok, let's monitor the size of the database during this week. Let me know what figures you will have on Friday.
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: SQL Server edition to chose

Veeam Logoby EBoucq » Mon Oct 12, 2015 11:56 am

I will.

Thanks Vitaliy.
EBoucq
Expert
 
Posts: 213
Liked: 14 times
Joined: Fri Jan 21, 2011 10:10 am
Full Name: Eric Boucq

Re: SQL Server edition to chose

Veeam Logoby EBoucq » Fri Oct 16, 2015 8:28 am

Hello Vitaliy,

Today, Friday, the VeeamOne db size is 8.25 GB !
EBoucq
Expert
 
Posts: 213
Liked: 14 times
Joined: Fri Jan 21, 2011 10:10 am
Full Name: Eric Boucq

Re: SQL Server edition to chose

Veeam Logoby Shestakov » Fri Oct 16, 2015 10:02 am

Hello Eric,
I remember we had the similar conversation in August
There was an issue with the old data deleting. Could you update if it was solved and if you contacted the support team?
Thanks!
Shestakov
Veeam Software
 
Posts: 4861
Liked: 395 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: SQL Server edition to chose

Veeam Logoby Vitaliy S. » Fri Oct 16, 2015 10:16 am

On top of that, can you please post the output of this query?

Image
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: SQL Server edition to chose

Veeam Logoby EBoucq » Fri Oct 16, 2015 1:57 pm

EBoucq
Expert
 
Posts: 213
Liked: 14 times
Joined: Fri Jan 21, 2011 10:10 am
Full Name: Eric Boucq

Re: SQL Server edition to chose

Veeam Logoby Vitaliy S. » Fri Oct 16, 2015 2:08 pm

Your database should stop growing on Monday, I see that data for 14 past days (takes the most space) is almost collected.

Can you please send the result of this query as well?
Code: Select all
select instance_id, count(*) cnt
from monitor.PerfSampleMed
group by instance_id
order by cnt desc

select CAST(timestamp AS DATE), count(*) cnt
from monitor.PerfSampleMed
group by CAST(timestamp AS DATE)
order by cnt desc
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Next

Return to Monitoring



Who is online

Users browsing this forum: No registered users and 3 guests