Listing Largest Tables in vCenter Database

May 21, 2015 Jordansphere MS SQL

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

Powered by WordPress. Designed by elogi.