June 15, 2007 at 8:34 am
We have a 30 GB database with both the auto-grow and auto-shrink options turned on. I know this is not an optimal configuration but we currently have no DBA or resources to monitor space. We are eventually going to implement some jobs that send notifications out concerning space usage. The log file grows an average of 800 MB and shrinks an average of 800 MB daily.
My question is, how big of a performance hit do we take for a 30 GB database whose log file grows and shrinks 800 MB on a daily basis? I know there isn't a definitive answer to the question but on a small, medium, large scale what impact is there on performance?
June 15, 2007 at 9:20 am
grow and shrink will fragment the internal structures inside the database as well as producing ntfs fragmentation .. it's a really bad way to go. Try to fix the sizes so normal usage etc. doesn't make any changes to the file sizes.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply