Red Gate forums :: View topic - SQL Monitor 3.3.X Purge Settings Issue
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

SQL Monitor 3.3.X Purge Settings Issue

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



Joined: 25 Nov 2008
Posts: 88

PostPosted: Wed Oct 16, 2013 5:10 pm    Post subject: SQL Monitor 3.3.X Purge Settings Issue Reply with quote

For as long as we’ve been using SQL Monitor we’ve had the Purge settings set to DO NOT PURGE. Yesterday I tried to adjust a few of those selecting 1yr as the Retention/Purge value. I changed only 2 of the Purge choices. Within a very short period of time the tempdb database on the SQL Server hosting our Data Repository blew up and ate up all the available drive space on the drive hosting the tempdb log file.

To fix this I had to change the Purge settings back to NEVER PURGE and restart SQL Server so as to shrink tempdb back down. Twice I’ve done this and both times tempdb blew up and so I know for a fact that changing the Purge settings is causing this issue.

Does anyone know if there is any way to either control how the purge is done or to calculate in advance how much space the tempdb needs so that IO can adjust the drive space and then re-do the purge settings? I am at the point where I’d like to purge some of the data that is beyond 1 year but I can’t till I know what tempdb will need to get the job done.


PS – If RedGate support has some tool/script/query that can be used to manually purge older data I’m happy to take a look at it.


Thanks
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