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

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

Manually Purge Old Data

Search in SQL Monitor 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
linque



Joined: 11 Jan 2011
Posts: 20
Location: Houston, TX

PostPosted: Tue Mar 13, 2012 2:47 pm    Post subject: Manually Purge Old Data Reply with quote

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+).
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 329
Location: Cambridge, UK

PostPosted: Wed Mar 14, 2012 8:10 pm    Post subject: Reply with quote

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



Joined: 11 Jan 2011
Posts: 20
Location: Houston, TX

PostPosted: Wed Mar 14, 2012 8:34 pm    Post subject: Reply with quote

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
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