N_Muller (8/19/2014)

---

curious_sqldba (8/19/2014)

---

Are there any other reasons except maintenance overhead if I split my partitions to separate file group? Reason I say that is if I have multiple file groups I can just backup that one file group and restore on Dev server for troubleshooting purposes.

Gail already answered you in regards to the maintenance. As far as performance impact of splitting into different filegroups an files, it depends on your hardware and system configuration, the types of disks you have (SSD?) and other parameters. You need to discuss this with your IT about the benefits and drawbacks of splitting into different disks that R/W at different speeds.