Listing Largest Tables in vCenter Database

Components: vCenter 5.0 / Windows 2008 / SQL Standard Edition 2008 R2

Open SQL Server Management Studio and log in. Click New Query then ensure you have selected the relevant database in the drop down box below. 

Paste the following code into the right hand side window:


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

Then click Execute.

sql_query_vcenter