T-SQL 2012 server auto grow question

Posted on 2014-07-10
Last Modified: 2014-07-11
Preparing for the SQL 2012 MS exam 70-462, constantly seeing all review materials mention about reducing the frequency of triggering the auto growth.

I got the point that the more frequently it triggers auto grow, the more fragmented the files are. It would be slower to read in the future. But can't we just do a disk defragment and resolve this concern? If so, what is the big deal about it?

I would appreciate your help to clarify my confusion.
Question by:TickTech
    LVL 31

    Accepted Solution

    There is also a second point about auto grow: It normally happens under load. Any operation pending must wait for the auto grow to finish. This is a performance issues, especially when it happens to often or needs to long to require new space for the log file(s).

    Haven't tested that for a while, but it should still apply: you need to take the database offline, before defragmenting it.

    Author Comment

    thank you for your clarification.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now