Database Size Requirements

Real-time performance monitoring and troubleshooting

Database Size Requirements

Veeam Logoby boamek » Thu Oct 21, 2010 3:22 pm

Are there any specifics on what to expect for the size of the Veeam backend database?

I'm assuming the bigger your environment, the bigger the database, so along the same line is there a way to estimate this?

IE if I have 10 ESX hosts and 80 VMs can expect my database to be ? MB
If I have 100 ESX Hosts and 1200 VMs I can expect my database to be ? MB
boamek
Lurker
 
Posts: 1
Liked: never
Joined: Thu Oct 21, 2010 3:10 pm

Re: Database Size Requirements

Veeam Logoby Vitaliy S. » Thu Oct 21, 2010 3:52 pm

Hello Brian,

Yes, you're absolutely right, the size of the database heavily depends on the size of the infrastructure and the time you monitor your virtual environment. By default Veeam Monitor has a 1 year retention policy to keep performance data in the SQL databse.

Let me double-check the estimated figures for your examples with our R&D team. I will update the topic, as soon as I have the results.

Thanks!
Vitaliy
Vitaliy S.
Veeam Software
 
Posts: 19564
Liked: 1104 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Database Size Requirements

Veeam Logoby mhanbury » Fri Oct 22, 2010 2:09 pm

Had V5 running for a few weeks now after upgdading from V4.5 we had a SQL database around 5GB with the years worth of statistics on 65 ESX hosts and just under 400 VM's. The V5 database has now grown to over 45GB in just a few weeks.

Would appreciate it if Veaam could post some SQL database sizing guidelines.

Thanks

Matt
mhanbury
Novice
 
Posts: 5
Liked: never
Joined: Tue Oct 20, 2009 8:45 am
Full Name: Matthew Hanbury

Re: Database Size Requirements

Veeam Logoby mhanbury » Fri Oct 22, 2010 2:54 pm

Also noticed V5 does hit the SQL server quite a bit harder. Is there a way of altering the statistics collected and to reduce the data retention period?

Thanks

Matt
mhanbury
Novice
 
Posts: 5
Liked: never
Joined: Tue Oct 20, 2009 8:45 am
Full Name: Matthew Hanbury

Re: Database Size Requirements

Veeam Logoby Vitaliy S. » Fri Oct 22, 2010 3:17 pm

Hello Matt, could you tell me if the database keeps growing for you or not? Also could you tell me what retention policy (for both real time performance and aggregated data) you would like you use?
Vitaliy S.
Veeam Software
 
Posts: 19564
Liked: 1104 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Database Size Requirements

Veeam Logoby mhanbury » Mon Oct 25, 2010 7:51 am

Hi,

Yes the database is still growing? What are the defaults and how can I reduce the retention policy for realtime and aggregated data?

Thanks

Matt
mhanbury
Novice
 
Posts: 5
Liked: never
Joined: Tue Oct 20, 2009 8:45 am
Full Name: Matthew Hanbury

Re: Database Size Requirements

Veeam Logoby Vitaliy S. » Mon Oct 25, 2010 8:29 am

Matt,

The default retention policy for keeping aggregated data is one year. You may adjust those settings through the support utility which comes with Monitor installation, please refer to our technical team (support@veeam.com) to guide you through the proper steps of reducing the retention policy.

Thank you!
Vitaliy S.
Veeam Software
 
Posts: 19564
Liked: 1104 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Database Size Requirements

Veeam Logoby Vitaliy S. » Mon Nov 22, 2010 11:02 am

Hello All,

Here are the results of our own database size test in the labs, please note that those figures might differ from yours depending on the amount of events, alarms and past performance data available:

100 hosts / 1200 VMs / 100 datastores = approximately 55-60 GBs + the size of the transaction log
10 hosts / 80 VMs / 10 datastores = approximately 6-8 GBs + the size of the transaction log


P.S. if you want us to help you with the database size estimates, feel free to contact our support team for assistance directly.
Vitaliy S.
Veeam Software
 
Posts: 19564
Liked: 1104 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Database Size Requirements

Veeam Logoby Vitaliy S. » Tue Jan 25, 2011 10:39 am

Just wanted to update this topic that we've now got a Veeam Monitor Database Sizing Calculator available on the Monitor homepage under Resources section.
Vitaliy S.
Veeam Software
 
Posts: 19564
Liked: 1104 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov


Return to Monitoring



Who is online

Users browsing this forum: No registered users and 2 guests