470,580 Members | 2,355 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,580 developers. It's quick & easy.

DEFRAG disk drive

SQL 2000

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

Thanks,

Craig

Jul 23 '05 #1
2 2575
(cs******@dwr.com) writes:
SQL 2000

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


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, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #2
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.
<cs******@dwr.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
SQL 2000

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

Thanks,

Craig

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Anthony Robinson | last post: by
12 posts views Thread by New World Order Pigs | last post: by
6 posts views Thread by Steve Gerhart | last post: by
1 post views Thread by iwdu15 | last post: by
3 posts views Thread by massi183 | last post: by
1 post views Thread by =?Utf-8?B?U2NvdHQgVHVybmVy?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.