Red Gate forums :: View topic - sql monitor db has grown exponentially
Return to www.red-gate.com RSS Feed Available

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

sql monitor db has grown exponentially

Search in SQL Monitor 4 forum
Post new topic   Reply to topic
Jump to:  
Author Message
sql_guy75



Joined: 03 Apr 2014
Posts: 3

PostPosted: Fri May 02, 2014 3:55 pm    Post subject: sql monitor db has grown exponentially Reply with quote

Hi guys,

our data purge settings were set to default settings of 2 months data retention. The .mdf file has grown 36 GB - so I went ahead and set the settings to 2 weeks for all the 'high volume data'. I've waited about 2 days now and the db size is still sitting at 36 GB.

Is there something I'm doing wrong or there is another way of purging the data? Please advise. Thanks.
Back to top
View user's profile Send private message
Evan Moss



Joined: 12 Jun 2013
Posts: 96

PostPosted: Mon May 05, 2014 7:09 pm    Post subject: Reply with quote

Hello,

Thanks for your post.

Your database won't actually change size by changing the purge settings (it'll just be the amount of data in it that changes.)

You can check the total size and total allocated space by running "EXEC sp_spaceused" on your database.

You could probably shrink the database manually by running DBCC SHRINKDATABASE (see this article: http://technet.microsoft.com/en-us/library/ms190488.aspx).

Hope that helps.

Thanks,
Evan
_________________
Evan Moss
Product Support
(866) 627-8107
Back to top
View user's profile Send private message Send e-mail
sql_guy75



Joined: 03 Apr 2014
Posts: 3

PostPosted: Thu May 08, 2014 3:15 pm    Post subject: Reply with quote

Thanks guys.

I was under the impression that maybe the alert retention was causing the data file to grow, but applying the SHRINKDATABASE command took care of the issue.

I appreciate you looking into it and providing guidance. Thanks again.
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