I've noticed today that my SQL Monitor collection database has doubled in size over one month.
Since installing SQL Monitor back in Jan 2013, the database data file has been 50GB and never grown at all. Since the 5th of Feb this year, the data file is now 104GB. I don't know why and as far as I can see, nothing has changed in the last month, with regards to the use or usage of SQL Monitor.
The growth rate has been consistently a few GB each day over the last month, rather than doubling in size rapidly.
I had already set the purge rules of the tool to be quite heavy handed and at most I keep 2 months of Database performance counters and Basic SQL Server data. This has worked fine since last year.
Is there anything I can do to investigate the reasons for this sudden growth rate?