Q. Can I do an NT defrag on a SQL Server .DAT device/file? Will it causeQuote:> Anybody have experience with using Executive Software's Diskeeper
> on the SQL server database???
A. Yes you can as long as you stop SQL first - NT needs exclusive access
to a file in order to defragment it. As long as there are no bugs in the
defrag program and the system doesn't crash in the middle of a defrag then
there shouldn't be any problems.
Will it help? Usually not much as SQL devices don't tend to change in size
once they are created, so unless a disk was badly fragmented when the device
was created so that NT could not allocate contiguous space for it all then it
won't be fragmented.
If you create your SQL devices on a freshly formatted drive then you won't get
Neil Pike MVP/MCSE
Protech Computing Ltd
(Please post ALL replies to the newsgroup only unless indicated otherwise)
I am the corporate DBMS product manager responsible for all of my
company's MS SQL Server installations. Our in-house OS support group
wants to install Diskeeper on their NT4 and W2K servers, including my
SQL Server boxes. I am uncomfortable with an OS level product possibly
moving file blocks/segments of any database DATA or LOG files around
without the DBMS engine knowing about it. I've searched MS TechNet,
usenet and Executive Software's online KB and have been unable to find
any information about the compatability (or lack there of), between
Diskeeper and MS SQL Server. Does anyone have any documentation,
warnings or white papers concerning this combination?
Does anyone know if Executive Software recommend running or not
running Diskeeper on drives containing MS SQL Server DATA and/or LOG
10. Diskeeper 4.0
11. Diskeeper 5.0