troubleshooting Question
SQL database won't defrag internally as well as physically on hard drive
asked on
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?
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?
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 17 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.