I know this can be sound a little like an open question, but I want your thoughts here. Maybe if someone have make a benchmark test or based on your experience.
Do you think that Windows Defragmenter is good enough? Are tools like Diskeeper or Raxco PerfectDisk worthwhile? Do you really win I/O performance or are the optimizations not high enough to be noticed?
We have a server with a RAID volume. Windows DEFRAG shows very high fragmentation (90%) on the volume. My chief asked if DEFRAG reported fragmentation is correct (or near correct) or not.
We don't have any defrag being made for a long time (at least, not in the last 4 months, the time I work here). It's a production server and we are very worried about it.
Having come from a windows enviroment, I was curious if defragmenters are useful in *nix. More specifically, OS X.
What is the best practice for measuring SQLServer database fragmentation/performance rolloff and determining when to defrag a SQLServer database table?
I'm most interested in learning what the useful metrics are and what level of performance degradation should trigger the defrag.
It seems to me that since RAID volumes are logical (as opposed to physical), the layout that the OS believes they have might not correspond to the actual phsyical layout.
So does defrag make sense for RAID?