troubleshooting Question

SQL database won't defrag internally as well as physically on hard drive

Avatar of ETdude
ETdudeFlag for United States of America asked on
Microsoft SQL ServerStorage HardwareWindows Server 2003
17 Comments2 Solutions252 ViewsLast Modified:
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?
ASKER CERTIFIED SOLUTION
GuardianMicro

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 17 Comments.
Start Free Trial
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.

-Mike Kapnisakis, Warner Bros