Purging Data

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

Purging Data

Postby bfdill » Fri Jul 19, 2013 3:48 am

:shock: 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
bfdill
 
Posts: 1
Joined: Fri Jul 19, 2013 3:39 am

Postby priyasinha » Fri Jul 19, 2013 8:51 am

Hi Ben,

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

Thanks,
Priya
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm

Postby myounger » Fri Jul 26, 2013 7:47 pm

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?
myounger
 
Posts: 1
Joined: Fri Jul 26, 2013 7:45 pm

Postby priyasinha » Mon Jul 29, 2013 8:26 am

Hello,

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

Thanks,
Priya
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm

Postby Fletchnz » Thu Aug 22, 2013 12:38 am

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.
Fletchnz
 
Posts: 1
Joined: Thu Aug 22, 2013 12:31 am

Re:

Postby priyasinha » Thu Aug 22, 2013 1:38 pm

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
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 0 guests