EPO: Reveal Top 10 tables in Gigabytes

Version 2

    Legend

    1 = Obtains data from SQL. No changes to the database are performed.

    2 = Data will be modified (Backup your database)

    3 = Data will be deleted\removed (Backup your database)

     

    Query Rating: 1 - Obtain information from the database

     

    Purpose

    Here is a query that will read the top 10 tables in Gigabytes.

     

    History

    Post any suggestions or modification as they are always appreciated.

     

    Use

    1. Double-Click the .sql query on the db server with Management Studio (MS).
    2. Enter your credentials and select the ePO database from the upper left corner of the MS.
    3. Click Execute.

     

    Note: Modify the first line SELECT top 10 to a larger number to reveal added tables and size counts.