Manually Purge Old Data

Monitor, diagnose and receive alerts to problems across your SQL Servers.

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: 23
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: 368
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: 23
Joined: Tue Jan 11, 2011 2:12 am
Location: Houston, TX


Return to SQL Monitor Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests