Red Gate forums :: View topic - Monitor Database doubled in last month
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 4
SQL Monitor 4 forum

Monitor Database doubled in last month

Search in SQL Monitor 4 forum
Post new topic   Reply to topic
Jump to:  
Author Message
maddave



Joined: 11 Apr 2013
Posts: 18

PostPosted: Mon Mar 03, 2014 3:28 pm    Post subject: Monitor Database doubled in last month Reply with quote

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?
Back to top
View user's profile Send private message
maddave



Joined: 11 Apr 2013
Posts: 18

PostPosted: Mon Mar 03, 2014 5:54 pm    Post subject: Reply with quote

Edit - mistake.
Back to top
View user's profile Send private message
maddave



Joined: 11 Apr 2013
Posts: 18

PostPosted: Wed Mar 05, 2014 12:20 pm    Post subject: Reply with quote

I've received a support call about this issue, but when I view it it says the call doesn't exist.

Either way, I have had to remove and reinstall SQL Monitor and destroy the database as there was no way for me to recover from the problem as I couldn't extent the disk and the database had no free space in it.

Before I reinstalled I could see the purge options were working. If I changed the purge time to just one weeks of data, then this is all that was shown on the analysis page of SQL Monitor. Even though the data has purged the free space of the data file never increased.

There had been no changes in the number of databases or instances being monitored. I will keep an eye on the data growth and monitor for unusual patterns.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group