Manually Purge Old Data

SQL Server performance monitoring and alerting

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

Manually Purge Old Data

Postby linque » Tue Mar 13, 2012 2:47 pm

I'm running SQL Monitor 2.3.0.334, and neglected to set up Data Purging when I first set it up. I've been slowly setting the purge dates from one-year to six-months to three-months so I don't overwhelm the server, but it's having little effect, and it's an hour between purge jobs. Is there a way to manually delete old data? I would prefer a way that doesn't cause my tempdb.ldf file to grow so huge (30 GB+).
linque
 
Posts: 20
Joined: Tue Jan 11, 2011 2:12 am
Location: Houston, TX

Postby chriskelly » Wed Mar 14, 2012 8:10 pm

It may be that the data is getting purged (the usage of tempdb would indicate that SQL Monitor is purging something), but the space is not being deallocated. It could be worth trying a DBCC SHRINKFILE.

Can you also run a sp_who2 on the tempdb to ensure that SQL Monitor isn't maintaining a constant connection?
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Postby linque » Wed Mar 14, 2012 8:34 pm

I had to have the SAN admin give me another 100GB since the tempdb.ldf file grew to 70 GB, and it did eventually free up about 60 GB. The db shrink was taking forever, though, so I decided to just drop the database and let it create a new one. Setup is really simple, so it didn't take long to reconfigure things. I made sure to set the data purge at 2-months retention this time.

Thx
linque
 
Posts: 20
Joined: Tue Jan 11, 2011 2:12 am
Location: Houston, TX


Return to SQL Monitor 2

Who is online

Users browsing this forum: No registered users and 0 guests