Let's assume that my storage is a SAN. This means it contains multiple disks. Even though we have logical drives configured, essentially everything - including the OS, SQL Server, and applications - all run on the same SAN, which means the data on the disk is highly fragmented.

So I want to ask: Is there any benefit when applying any of the following when the storage is SAN based?

  1. Separating data/log files
  2. Setting fill factor
  3. Index rebuild/reorganize

1 Answer 1



  1. No: Separating data/log files
  2. No: Setting fill factor
  3. No: Index rebuild/reorganize

The only thing you can improve if you are using HDD on your SAN is moving to SSD.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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