Real-time performance monitoring and troubleshooting
Post Reply
EBoucq
Expert
Posts: 232
Liked: 15 times
Joined: Jan 21, 2011 10:10 am
Full Name: Eric Boucq
Contact:

SQL Server edition to chose

Post by EBoucq » 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

P.Tide
Product Manager
Posts: 5306
Liked: 466 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: SQL Server edition to chose

Post by P.Tide » 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.

Vitaliy S.
Product Manager
Posts: 23062
Liked: 1582 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: SQL Server edition to chose

Post by Vitaliy S. » 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.

EBoucq
Expert
Posts: 232
Liked: 15 times
Joined: Jan 21, 2011 10:10 am
Full Name: Eric Boucq
Contact:

Re: SQL Server edition to chose

Post by EBoucq » 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

Vitaliy S.
Product Manager
Posts: 23062
Liked: 1582 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: SQL Server edition to chose

Post by Vitaliy S. » 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).

EBoucq
Expert
Posts: 232
Liked: 15 times
Joined: Jan 21, 2011 10:10 am
Full Name: Eric Boucq
Contact:

Re: SQL Server edition to chose

Post by EBoucq » 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....

Vitaliy S.
Product Manager
Posts: 23062
Liked: 1582 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: SQL Server edition to chose

Post by Vitaliy S. » Oct 12, 2015 11:03 am

Are you using Hyper-V or VMware?

EBoucq
Expert
Posts: 232
Liked: 15 times
Joined: Jan 21, 2011 10:10 am
Full Name: Eric Boucq
Contact:

Re: SQL Server edition to chose

Post by EBoucq » Oct 12, 2015 11:51 am

VMware

Vitaliy S.
Product Manager
Posts: 23062
Liked: 1582 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: SQL Server edition to chose

Post by Vitaliy S. » 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.

EBoucq
Expert
Posts: 232
Liked: 15 times
Joined: Jan 21, 2011 10:10 am
Full Name: Eric Boucq
Contact:

Re: SQL Server edition to chose

Post by EBoucq » Oct 12, 2015 11:56 am

I will.

Thanks Vitaliy.

EBoucq
Expert
Posts: 232
Liked: 15 times
Joined: Jan 21, 2011 10:10 am
Full Name: Eric Boucq
Contact:

Re: SQL Server edition to chose

Post by EBoucq » Oct 16, 2015 8:28 am

Hello Vitaliy,

Today, Friday, the VeeamOne db size is 8.25 GB !

Shestakov
Veeam Software
Posts: 6992
Liked: 717 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: SQL Server edition to chose

Post by Shestakov » 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!

Vitaliy S.
Product Manager
Posts: 23062
Liked: 1582 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: SQL Server edition to chose

Post by Vitaliy S. » Oct 16, 2015 10:16 am

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

Image

EBoucq
Expert
Posts: 232
Liked: 15 times
Joined: Jan 21, 2011 10:10 am
Full Name: Eric Boucq
Contact:

Re: SQL Server edition to chose

Post by EBoucq » Oct 16, 2015 1:57 pm


Vitaliy S.
Product Manager
Posts: 23062
Liked: 1582 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: SQL Server edition to chose

Post by Vitaliy S. » 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

EBoucq
Expert
Posts: 232
Liked: 15 times
Joined: Jan 21, 2011 10:10 am
Full Name: Eric Boucq
Contact:

Re: SQL Server edition to chose

Post by EBoucq » Oct 16, 2015 3:07 pm

Here is the result of the query:

https://gyazo.com/9c831fdce69e60f3b24371d2ec4b1e86

I chose 3 months retention policy. Does that mean I can't keep more information since the database is already close to 10 GB ? I'd like to keep data for at least 6 months.

Thanks.

Vitaliy S.
Product Manager
Posts: 23062
Liked: 1582 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: SQL Server edition to chose

Post by Vitaliy S. » Oct 16, 2015 3:52 pm

Hmm... Yes, it seems like 10 GBs will not be enough for live 200 VMs and 6 hosts (btw, good ratio for VMs per host!). The reason for this is that we keep 20 seconds for the last hour for every metric and for every object. In addition to this 5 minutes data samples are stored for the past 14 days for granular past performance reporting.

Given all that, I would suggest either to switch to a full version of SQL Server, select advanced scalability mode or you can ask our support to assist you with disabling some performance counters you don't plan to monitor. Hope this helps!

btmaus
Expert
Posts: 138
Liked: 10 times
Joined: Jul 17, 2015 9:02 am
Full Name: Glenn L
Contact:

Re: SQL Server edition to chose

Post by btmaus » Oct 22, 2015 3:19 am

I am having the exact same problem, 22 VMware hosts and 400 VMs. Database is full within a couple of days. monitor.PerfSampleMed is the main culprit.

Vitaliy S.
Product Manager
Posts: 23062
Liked: 1582 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: SQL Server edition to chose

Post by Vitaliy S. » Oct 22, 2015 9:25 am

Yes, for 400 VMs I would expect the database to outgrow 10 GBs due to granular performance data samples collection. Maybe it makes sense to limit the number of collected performance counters in the next updates or have an option in the UI to control that.

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest