Good question; I hadn't checked yet. Turns out I can use the FileStatsHistory table data to answer your question: dba.mdf is growing at 7.2 MB per day on a system with 148 databases. I plotted the size vs. time in Excel and the growth rate is steady. At this rate, the database will be around 2.5 GB after a year.

Here are the biggest tables:

Table_Name Space_Used_MB Table_Row_Count

FileStatsHistory 19.36 27807

HealthReport 3.40 5

SchemaChangeLog 2.76 248

JobStatsHistory 1.33 3128

QueryHistory 0.25 357

CPUStatsHistory 0.23 6404

MemoryUsageHistory 0.21 367

PerfStatsHistory 0.14 1099

Looks like I could slow the growth rate by decreasing the sampling frequency of the file stats. The other thing I'll need to do is delete old data after a while; e.g. delete data over 1 year old.