October 17, 2009 at 12:24 pm
Hi,
if i have a LDF file that is about 25GB size and MDF file about 9GB
and i run a weekly maintenance plan that do CHECKDB,REBUILD INDEX, and UPDATE STATE.and i use Full recovery model and TLog backup hourly.
i don't have a free space issue on my HD.
now for the questions:
1.large LDF file can impact performance on the bad size?
2.if i shrink the LDF on weekly basis and it is auto grow because it is need,can it make a fragmentation to the HD? or hurt it somehow?
3.what you do on your server about the LDF files?
THX
October 17, 2009 at 2:43 pm
If you aren't having disk space issues and the LDF file is maintaining the same size, I'd leave everything alone. If you shrink the log file it will just have to grow again when it needs additional space.
October 19, 2009 at 2:49 am
I would say a 25GB logfile on a 9GB database is a little "out of balance"
How much of this 25GB is active? (measure over a longer period of time)
dbcc sqlperf(logspace)
If you discover that only 10 GB is being used you could shrink the logfile to this size (plus some additional size) if this amount of logspace is annoying you.
If the 25GB is almost full you could consider a more frequent logbackup.
Wilfred
The best things in life are the simple things
October 19, 2009 at 2:53 am
Forgot to say: rebuilding indexes eates logspace.
In order to prevent blowing up your logfile, you could consider a more intelligent rebuild. There are some scripts available (kimberly tripp has some excellent articles/scripts about this) which only rebuild/reorganize fragmented indexes
Wilfred
The best things in life are the simple things
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply