June 16, 2008 at 7:38 am
Hi All,
We have a Maintenance plan in one of our SQL Production server which will run DBCC REINDEX statement. But after executing of this statement Log file size is expanding approximately same as data .mdf file. So I am planning to shrink log files using DBCC SHRINKFILE. Does it affect any performance issue on Log files if we use DBCC SHRINKFILE?
Please help me.
Regards,
MG
June 16, 2008 at 7:45 am
I don't advise to shrink data/log files on production boxes !
If sqlserver needs it, leave it that way ! so if you make an assesment of your space needs, you know thats what it is.
Plus, it can only shrink the log up to the last log-chunk in use (read on log file in BOL).
INF: How to Shrink the SQL Server 7.0 Transaction Log
SQL7 http://support.microsoft.com/support/kb/articles/q256/6/50.asp?id=256650&SD
SQL2000 http://support.microsoft.com/kb/272318/en-us
SQL2005 http://support.microsoft.com/kb/907511/en-us
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
June 17, 2008 at 5:15 am
But If shriking log file is not recommended on Production box,then is there any alternative solution for above situation?
June 17, 2008 at 5:35 am
Set the log file for the max size it needs to be to support what you do to the DB.
You can space out the index rebuild and/or backup the log between index rebuilds to allow the space in the log file to be reused.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply