Order for Defragmenting

If you have a database and the disk it is on to defragment which order
should they be defragmented in?I'd do the disk first. SQL Server doesn't know whether the disk is fragmented or not, so the end
result would be the same. But if you defrag the disk first, then SQL Server's defragmentation might
be a bit quicker (since its database files now are ... defragmented).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Robin9876" <robin9876@.hotmail.com> wrote in message
news:cc8d6907-20cd-44e9-8b5f-f717879a7787@.v67g2000hse.googlegroups.com...
> If you have a database and the disk it is on to defragment which order
> should they be defragmented in?|||I agree with Tibor's suggestion. I would also recommend shutting down SQL
Server prior to the disk defrag operation.
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:B3CE7A63-E1FE-447E-AA2A-882EDCA0DEFB@.microsoft.com...
> I'd do the disk first. SQL Server doesn't know whether the disk is
> fragmented or not, so the end result would be the same. But if you defrag
> the disk first, then SQL Server's defragmentation might be a bit quicker
> (since its database files now are ... defragmented).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Robin9876" <robin9876@.hotmail.com> wrote in message
> news:cc8d6907-20cd-44e9-8b5f-f717879a7787@.v67g2000hse.googlegroups.com...
>> If you have a database and the disk it is on to defragment which order
>> should they be defragmented in?
>sql