I am upgrading the disk arrays on my production server over the Christmas holiday, and would love to hear some opinions on how you would recommend partitioning the new array.
Currently, I have four disk arrays on the production server, divided into four drive letters (and hence four database files) for a total database size of approximately 305 GB.
Tentatively, I am thinking of making the new array one single drive letter (this would be approximately 870 GB) and locating the four database files on that volume, allowing only the fourth file to grow as required.
Your thoughts and opinions on this configuration would be appreciated. Thank you!