DEFRAG disk drive

[csomberg@dwr.com]

SQL 2000

We took SQL Server offline last night and defragged the SAN. Should we
reindex or will be be okay ?

Thanks,

Craig

[Erland Sommarskog]

Re: DEFRAG disk drive

(csomberg@dwr.c om) writes:[color=blue]
> SQL 2000
>
> We took SQL Server offline last night and defragged the SAN. Should we
> reindex or will be be okay ?[/color]

An external disk fragmenter makes the file contiguous, as seen from
the file system. It does not work with the inside of the file, because
it does not know the structure of the file. So, yes, you need to run
reindexing to handle internal fragmentation.

Generally, reindexing is much more important to do on a regular basis
than running a disk defragmenter.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Gang He [MSFT]]

Re: DEFRAG disk drive

SQL level index defrag and OS level file defrag should be orthogonal to ech
other (both help for sure). There is no clear reason why conducting one
defrag requires the other one. I will be interested in knowing if this is
not the case, r me in that case please.

But it is a good practice to regularly check and defrag the index.

--
Gang He
Software Design Engineer
Microsoft SQL Server Storage Engine

This posting is provided "AS IS" with no warranties, and confers no rights.
<csomberg@dwr.c om> wrote in message
news:1115133809 .049446.242770@ z14g2000cwz.goo glegroups.com.. .[color=blue]
> SQL 2000
>
> We took SQL Server offline last night and defragged the SAN. Should we
> reindex or will be be okay ?
>
> Thanks,
>
> Craig
>[/color]