When analyzing the hard drive on the server (RAID array) it shows as severely fragmented and despite trying various sophisticated software like PerfectDisk, Diskeeper for servers,etc. it hasn't improved a bit.
Shows the two SQL files (.mdf and .ldf) as being very fragmented (91 fragments). Running SQL server 2000. File size is about 30GB.
Then I researched how to defrag SQL database internally which led me to scripts that defrag the indexes. Ran script to show level of fragmentation and then ran defrag script...no improvement in fragmentation..same fragmented report after doing this.
If I were to simply move the database files to another drive\partition would that resolve the physical fragmentation? Then maybe the index fragmentation could be defragged?
Any other suggestions?
Our community of experts have been thoroughly vetted for their expertise and industry experience.