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.

[Show slideshow]

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.