Monday, March 19, 2012

Defragmenting issues

I would like to know how many DBAs take care of their file systems
defrag status's server.
I would like to know also if someone here is using some commercial tool
(diskeeper, speed disk or perfect disk or..) to defrag also LDF and MDF
when they are in use.
Any feedback appreciated.
Regards.
Fabri
"Eat just one little baby and everyone remembers your name!"
- CELKODiskkeeper states that their tool is safe to use while sql server is
running. There will obviously be a performance hit while this is running
but it is up to you if you want to do it live or not.
Andrew J. Kelly SQL MVP
"Fabri" <no@.sp.am> wrote in message
news:OlOLe.72251$fm.4850956@.news4.tin.it...
>I would like to know how many DBAs take care of their file systems defrag
>status's server.
> I would like to know also if someone here is using some commercial tool
> (diskeeper, speed disk or perfect disk or..) to defrag also LDF and MDF
> when they are in use.
> Any feedback appreciated.
> Regards.
> --
> Fabri
> "Eat just one little baby and everyone remembers your name!"
> - CELKO|||"Fabri" <no@.sp.am> wrote in message
news:OlOLe.72251$fm.4850956@.news4.tin.it...
>I would like to know how many DBAs take care of their file systems defrag
>status's server.
> I would like to know also if someone here is using some commercial tool
> (diskeeper, speed disk or perfect disk or..) to defrag also LDF and MDF
> when they are in use.
> Any feedback appreciated.
>
I don't generally worry about fragmentation of database files. Regular best
practices like having extra space, pre-sizing data files and using large
auto-grow %, minimize both the fragmentation and the impact of
fragmentation.
A data file, or especially a log file, in a few large fragments has a
negligible impact on performance.
David

No comments:

Post a Comment