shrink log performance sql server 2008

Is there a performance concern when shrinking a log file, generally?

This is the first time I'm shrinking a log and I scheduled it after-hours as I was unsure of the performance impact.

Thanks,

pae2
pae2Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Carl TawnConnect With a Mentor Systems and Integration DeveloperCommented:
Generally it should be OK performance wise as long as you shrink it in smallish chunks, rather than trying to remove all the excess space at once.
0
 
pae2Author Commented:
Carl what happens if you try to remove all the excess space at once?
0
 
Carl TawnSystems and Integration DeveloperCommented:
Shrinking the file is going to require IO activity. The bigger chunk you try to shrink in one go the higher, and longer the IO activity. Shrinking in chunks should reduce the IO requirement, and the potential for the operation to fail. I'd usually shrink at around 512MB at a time.

Also, don't forget to take a full backup before shrinking anything. And bear in mind that regular log backups should prevent the log file from growing excessively large in the first place.
0
 
pae2Author Commented:
Thanks Carl!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.