Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

shrink log performance sql server 2008

Posted on 2014-04-01
4
Medium Priority
?
455 Views
Last Modified: 2014-04-07
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
0
Comment
Question by:pae2
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 52

Accepted Solution

by:
Carl Tawn earned 2000 total points
ID: 39971603
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
 

Author Closing Comment

by:pae2
ID: 39972058
Carl what happens if you try to remove all the excess space at once?
0
 
LVL 52

Expert Comment

by:Carl Tawn
ID: 39972078
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
 

Author Comment

by:pae2
ID: 39984772
Thanks Carl!
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question