Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.