By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,854 Members | 1,871 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,854 IT Pros & Developers. It's quick & easy.

DEFRAG disk drive

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
(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

P: n/a
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.