Real-time performance monitoring and troubleshooting
Post Reply
EBoucq
Service Provider
Posts: 263
Liked: 17 times
Joined: Jan 21, 2011 10:10 am
Full Name: Eric Boucq
Contact:

SQL Server edition to chose

Post by EBoucq »

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
PTide
Product Manager
Posts: 6408
Liked: 724 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: SQL Server edition to chose

Post by PTide »

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

Re: SQL Server edition to chose

Post by Vitaliy S. »

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
Service Provider
Posts: 263
Liked: 17 times
Joined: Jan 21, 2011 10:10 am
Full Name: Eric Boucq
Contact:

Re: SQL Server edition to chose

Post by EBoucq »

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

Re: SQL Server edition to chose

Post by Vitaliy S. »

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
Service Provider
Posts: 263
Liked: 17 times
Joined: Jan 21, 2011 10:10 am
Full Name: Eric Boucq
Contact:

Re: SQL Server edition to chose

Post by EBoucq »

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

Re: SQL Server edition to chose

Post by Vitaliy S. »

Are you using Hyper-V or VMware?
EBoucq
Service Provider
Posts: 263
Liked: 17 times
Joined: Jan 21, 2011 10:10 am
Full Name: Eric Boucq
Contact:

Re: SQL Server edition to chose

Post by EBoucq »

VMware
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: SQL Server edition to chose

Post by Vitaliy S. »

Ok, let's monitor the size of the database during this week. Let me know what figures you will have on Friday.
EBoucq
Service Provider
Posts: 263
Liked: 17 times
Joined: Jan 21, 2011 10:10 am
Full Name: Eric Boucq
Contact:

Re: SQL Server edition to chose

Post by EBoucq »

I will.

Thanks Vitaliy.
EBoucq
Service Provider
Posts: 263
Liked: 17 times
Joined: Jan 21, 2011 10:10 am
Full Name: Eric Boucq
Contact:

Re: SQL Server edition to chose

Post by EBoucq »

Hello Vitaliy,

Today, Friday, the VeeamOne db size is 8.25 GB !
Shestakov
Veteran
Posts: 7328
Liked: 781 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: SQL Server edition to chose

Post by Shestakov »

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

Re: SQL Server edition to chose

Post by Vitaliy S. »

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

Image
EBoucq
Service Provider
Posts: 263
Liked: 17 times
Joined: Jan 21, 2011 10:10 am
Full Name: Eric Boucq
Contact:

Re: SQL Server edition to chose

Post by EBoucq »

Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: SQL Server edition to chose

Post by Vitaliy S. »

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
Service Provider
Posts: 263
Liked: 17 times
Joined: Jan 21, 2011 10:10 am
Full Name: Eric Boucq
Contact:

Re: SQL Server edition to chose

Post by EBoucq »

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

Re: SQL Server edition to chose

Post by Vitaliy S. »

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 »

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

Re: SQL Server edition to chose

Post by Vitaliy S. »

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 10 guests