• Use the Data Collector.

    You can create a custom collection set to capture the size of the tables and whatever you need to capture.

    You can use Extended T-SQL Collector to set up the collection set with a GUI.

    To capture the size of the tables, this is a good example: http://stackoverflow.com/questions/7892334/get-size-of-all-tables-in-database

    -- Gianluca Sartori