We help IT Professionals succeed at work.
Get Started
SQL database won't defrag internally as well as physically on hard drive
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?
Why Experts Exchange?
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
Jim Murphy
Programmer at Smart IT Solutions
When asked, what has been your best career decision?
Deciding to stick with EE.
Mohamed Asif
Technical Department Head
Being involved with EE helped me to grow personally and professionally.
Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question
Connect with Certified Experts to gain insight and support on specific technology challenges including:
- Troubleshooting
- Research
- Professional Opinions
Did You Know?
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE