Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In the past, I have used contig.exe to remove physical fragmentation from SQL Server data files. They have always been on locally attached storage. Is there any benefit to running this on a data file that is stored on a SAN?

share|improve this question
up vote 2 down vote accepted

Not recommended to defragment files on a SAN, SQL or otherwise.

See this related ServerFault question and this excellent whitepaper. The major points include:

  • Defragmenting is very I/O intensive
  • Defragmenting doesn't always improve performance on logical volumes
  • Defragmenting is definitely not recommended for certain specific configurations, like Virtual Storage Pools and Replicated Volumes
share|improve this answer
Good pointers. I should have looked a little harder before posting thanks – Jason Horner Sep 17 '09 at 22:25

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.