defrag using deskeeper 2007

Is there anything I need to be aware of when I defrag my SQL 2000 server
using deskeeper 2007? Do I need to stop the services or anything else?
Thanks,"Dooma" <nowhere@.noway.com> wrote in message
news:OW1mw8lnIHA.980@.TK2MSFTNGP06.phx.gbl...
> Is there anything I need to be aware of when I defrag my SQL 2000 server
> using deskeeper 2007? Do I need to stop the services or anything else?
>
> Thanks,
>
Hi
If you are using diskeeper as a service then you should be ok, I am not
sure what stand alone application does, but if it is the same windows
defragmenter you will need to make sure the database is not in use i.e SQL
Server is stopped of the database is detached.
John|||IIRC, Diskeeper claims that there server product will defrag sql database
files while sql is still running. I could be misremembering this. I do
have several clients that have done that without any corruptions.
Having said that - stop your sql server. Best not to take the chance, IMHO.
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Dooma" <nowhere@.noway.com> wrote in message
news:OW1mw8lnIHA.980@.TK2MSFTNGP06.phx.gbl...
> Is there anything I need to be aware of when I defrag my SQL 2000 server
> using deskeeper 2007? Do I need to stop the services or anything else?
>
> Thanks,
>
>|||Do you really need to defrag your filesystem?
Linchi
"Dooma" wrote:
> Is there anything I need to be aware of when I defrag my SQL 2000 server
> using deskeeper 2007? Do I need to stop the services or anything else?
>
> Thanks,
>
>|||Not sure about this poster's need, but I have certainly had client's that
needed to defrag their file system. 300K+ file fragments (which I have seen
at a client) in their database file directory WILL affect performance! :-)
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:6A544A98-8CCE-433F-85FE-3718DCD793AE@.microsoft.com...
> Do you really need to defrag your filesystem?
> Linchi
> "Dooma" wrote:
>> Is there anything I need to be aware of when I defrag my SQL 2000 server
>> using deskeeper 2007? Do I need to stop the services or anything else?
>>
>> Thanks,
>>
>>|||"TheSQLGuru" <kgboles@.earthlink.net> wrote in message
news:8c-dnQ1nWOUmsZXVnZ2dnUVZ_oqhnZ2d@.earthlink.com...
> Not sure about this poster's need, but I have certainly had client's that
> needed to defrag their file system. 300K+ file fragments (which I have
> seen at a client) in their database file directory WILL affect
> performance! :-)
> --
> Kevin G. Boles
> Indicium Resources, Inc.
> SQL Server MVP
> kgboles a earthlink dt net
>
> "Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
> news:6A544A98-8CCE-433F-85FE-3718DCD793AE@.microsoft.com...
>> Do you really need to defrag your filesystem?
>> Linchi
>> "Dooma" wrote:
>> Is there anything I need to be aware of when I defrag my SQL 2000 server
>> using deskeeper 2007? Do I need to stop the services or anything else?
>>
>> Thanks,
Hi
There should usually be a need to defrag the data drives of a system
dedicated to SQL Server unless you have autoshrink on (which is not
recommended), but systems (such as SBS, test or development servers) that
have multiple uses or transient databases can quite often benefit from a
hard disc being defragmented, and I have seen improvements of 20% on some
badly affected systems.
John