• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 954
  • Last Modified:

T-SQL 2012 server auto grow question

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.
1 Solution
ste5anSenior DeveloperCommented:
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.
TickTechAuthor Commented:
thank you for your clarification.

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now