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