How big is your vCenter DB?

How big is your vCenter DB?

I just want to know how much space does your vCenter DB consume and what are your biggest tables?

Earlier on my vCenter 5.5 we had a 90 GB Database. I shrinked it to 40 GB before i started my upgrade to vCenter 6.

To my environment:

  • Windows 2008 R2
  • MS SQL 2008 R2 Standard
  • vCenter 6.0 U2 (Upgraded from 5.1 Ux, to 5.5 U1 to 5.5 U3 )
  • around 900 VMs (700 running)
  • 40 Hosts
  • Backup every day with Veeam (direct SAN Mode)

Now my vCenter DB has 69 GB and 165 GB transaction logs. That sounds huge, isn’t it? So i talked to VMware Support, they gave me some scripts to shrink the Database (those I had already) and said that’s normal for that environment.

SQL Script to get the biggest tables:

select object_name(id) [Table Name],
[Table Size] = convert (varchar, dpages * 8 /1024) + 'MB'
from sysindexes where indid in (0,1)
oder by dpages desc

What do you think? How big are your DB’s?

Please leave a comment.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.