Disk Defragmenter & SQL Svr

I'm looking for info on running Windows 2000 disk
defragmenter on a W2k server running 2 instances on SQL
Server 2000. Does anyone know of issues or problems
running disk defrag while the SQL Server(s) are up and
running? Please reply with any info on this subject.
Thanks.while it is possible to defragment the sql server data
files while the service is running, it is very strongly
not recommended, as per andrew's advice
i do it on my development system, but production is
another matter
2nd) within a sql server data, there is no guarantee a
given table occupies contiguous space
3rd) sql server has a very clever scatter gather
capability that hides any negative consequences of a
fragmented file, along with providing other benefits
>--Original Message--
>I'm looking for info on running Windows 2000 disk
>defragmenter on a W2k server running 2 instances on SQL
>Server 2000. Does anyone know of issues or problems
>running disk defrag while the SQL Server(s) are up and
>running? Please reply with any info on this subject.
>Thanks.
>.
>|||Hello Andrew. on this point about running a defrag while
SQL Server is started... say you detached the databases
first, but SQL Server was still running (and not touching
any files on a drive you are defragging), would this still
be a case when you shouldn't defrag that drive? Is there
any place you can point me to that references this issue
of defragging while SQL is started? THanks, Bruce
>--Original Message--
>You should never run a defragmentor while sql server is
in use. Why do you
>think you need to defrag it?
>--
>Andrew J. Kelly
>SQL Server MVP
>
>"B Wood" <brad.wood@.stclair.org> wrote in message
>news:2cb601c373c1$eba3f8a0$a401280a@.phx.gbl...
>> I'm looking for info on running Windows 2000 disk
>> defragmenter on a W2k server running 2 instances on SQL
>> Server 2000. Does anyone know of issues or problems
>> running disk defrag while the SQL Server(s) are up and
>> running? Please reply with any info on this subject.
>> Thanks.
>
>.
>|||Bruce,
I don't know if there are any actual articles per say. It's mostly just
good practice or common sense approach. If you defragging a drive that
doesn't have any sql server files on it then I guess you shouldn't have to
worry about it damaging sql server files then. But hopefully you don't
actually have users attempting to do anything on the server (otherwise why
keep sql running?) as a defrag utility usually monopolizes the cpu's and
hard drives.
--
Andrew J. Kelly
SQL Server MVP
"Bruce de Freitas" <bruce@.defreitas.com> wrote in message
news:3d5801c37622$ec1ff9b0$a101280a@.phx.gbl...
> Hello Andrew. on this point about running a defrag while
> SQL Server is started... say you detached the databases
> first, but SQL Server was still running (and not touching
> any files on a drive you are defragging), would this still
> be a case when you shouldn't defrag that drive? Is there
> any place you can point me to that references this issue
> of defragging while SQL is started? THanks, Bruce
>
>
> >--Original Message--
> >You should never run a defragmentor while sql server is
> in use. Why do you
> >think you need to defrag it?
> >
> >--
> >
> >Andrew J. Kelly
> >SQL Server MVP
> >
> >
> >"B Wood" <brad.wood@.stclair.org> wrote in message
> >news:2cb601c373c1$eba3f8a0$a401280a@.phx.gbl...
> >> I'm looking for info on running Windows 2000 disk
> >> defragmenter on a W2k server running 2 instances on SQL
> >> Server 2000. Does anyone know of issues or problems
> >> running disk defrag while the SQL Server(s) are up and
> >> running? Please reply with any info on this subject.
> >> Thanks.
> >
> >
> >.
> >|||Good article on this topic...
http://www.sql-server-performance.com/sql_fragmentation.asp
Use at your own risk...