sql monitor db has grown exponentially

SQL Server performance monitoring and alerting

Moderators: Colin Millerchip, priyasinha, Adam, chriskelly

sql monitor db has grown exponentially

Postby sql_guy75 » Fri May 02, 2014 3:55 pm

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.
sql_guy75
 
Posts: 3
Joined: Thu Apr 03, 2014 12:35 pm

Postby Evan Moss » Mon May 05, 2014 7:09 pm

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/libr ... 90488.aspx).

Hope that helps.

Thanks,
Evan
Evan Moss
Product Support
(866) 627-8107
Evan Moss
 
Posts: 99
Joined: Wed Jun 12, 2013 9:56 pm

Postby sql_guy75 » Thu May 08, 2014 3:15 pm

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.
sql_guy75
 
Posts: 3
Joined: Thu Apr 03, 2014 12:35 pm


Return to SQL Monitor 4

Who is online

Users browsing this forum: No registered users and 0 guests