Red Gate forums :: View topic - Purging Data
Return to www.red-gate.com RSS Feed Available

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

Purging Data

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
bfdill



Joined: 19 Jul 2013
Posts: 1

PostPosted: Fri Jul 19, 2013 3:48 am    Post subject: Purging Data Reply with quote

Shocked I've had a few versions of SQL Monitor installed and my database has worked its way up to 180+ GB. I keep changing the purging policy and it's still using all the data space its allocated. At this point, I'm down to three days worth of data retention...

I'm guessing (hoping) that the upgrade path has somehow caused an issue with the purge function and I just need some manual deletes or something to get the auto-purge to work again... Does something like this exist? Is there something I can run to clear out all collected data manually?

Also, one of my problems appears to be CDC monitoring being logged, but that's a different topic...

Thanks for any help,
Ben
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 530

PostPosted: Fri Jul 19, 2013 8:51 am    Post subject: Reply with quote

Hi Ben,

I would suggest getting in touch with support@red-gate.com. They should be able to help.

Thanks,
Priya
Back to top
View user's profile Send private message
myounger



Joined: 26 Jul 2013
Posts: 1

PostPosted: Fri Jul 26, 2013 7:47 pm    Post subject: Reply with quote

I am having the same issue actually. Changed my purge settings from 6 months to 2 months about three days ago and the data size has not budged at all. I have an email into support, but are there any known issues with this?
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 530

PostPosted: Mon Jul 29, 2013 8:26 am    Post subject: Reply with quote

Hello,

No, we are not aware of any issue with purge.

Thanks,
Priya
Back to top
View user's profile Send private message
Fletchnz



Joined: 22 Aug 2013
Posts: 1

PostPosted: Thu Aug 22, 2013 12:38 am    Post subject: Reply with quote

I too have the same issue, I upgraded to 3.5 on monday afternoon and by tuesday afternoon I notice abnormal size growth of the redgatemonitor database. I changed the main data purging settings from dont purge to 6 months, then 3 months and then even suspending monitoring but the DB growth doesnt stop. In the end I have to stop the SQL monitoring service.
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 530

PostPosted: Thu Aug 22, 2013 1:38 pm    Post subject: Re: Reply with quote

Fletchnz wrote:
I too have the same issue, I upgraded to 3.5 on monday afternoon and by tuesday afternoon I notice abnormal size growth of the redgatemonitor database. I changed the main data purging settings from dont purge to 6 months, then 3 months and then even suspending monitoring but the DB growth doesnt stop. In the end I have to stop the SQL monitoring service.


Hi,

Could you please contact support@red-gate.com so that we could investigate this? We are not aware of any issue with v3.5 release.

Thanks,
Priya
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