1 *. Sp_mstablespace 'Table_name'
Returns the number of records in Table, data use space and log usage space
2 * .dbcc traceon (3604)
Track the output of each DBCC
3.DBCC SQLPERF (LOGSPACE)
Returns the log space usage of each database
