Real-time performance monitoring and troubleshooting
Post Reply
boamek
Lurker
Posts: 1
Liked: never
Joined: Oct 21, 2010 3:10 pm

Database Size Requirements

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

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

Re: Database Size Requirements

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

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

Re: Database Size Requirements

Post by mhanbury » 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: Oct 20, 2009 8:45 am
Full Name: Matthew Hanbury
Contact:

Re: Database Size Requirements

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

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

Re: Database Size Requirements

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

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

Re: Database Size Requirements

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

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

Re: Database Size Requirements

Post by Vitaliy S. » 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.
Product Manager
Posts: 23073
Liked: 1582 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Database Size Requirements

Post by Vitaliy S. » 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.
Product Manager
Posts: 23073
Liked: 1582 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Database Size Requirements

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

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests