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 Read More…