How can Windows defragmentation tools cause internal fragmentation in SQL Server?
Posted
by
Martin
on Server Fault
See other posts from Server Fault
or by Martin
Published on 2011-02-02T11:38:41Z
Indexed on
2011/02/02
15:27 UTC
Read the original article
Hit count: 272
sql-server
|fragmentation
I was just reading this article where the author talks about the file system fragmentation that can be caused by growing database files. There was one bit that I didn't quite follow.
What about Windows defragmentation tools?
Although you can use a Windows defragmentation tool to defragment your database files, these tools simply move chunks of files around to get them contiguous. This moving of chunks of files can cause internal fragmentation that you might not be able to resolve easily.
Is the author saying here that the disc defragmenter makes no attempt to put the chunks of files in the correct sequence or have I misunderstood? If he is saying that then is this a limitation of all disc defragmenter utilities - even commercial ones?
© Server Fault or respective owner