tgarland (3/7/2011)
Besides the obvious filegrowth setting issues mentioned previously, one thing I found was there was not much use of filegroups. One of the things I like to do is have all of my nonclustered indexes on a separate filegroup that is located on a different I/O path.
To follow on from Brad, we also have cost constraints, as do many other companies. Getting additional drive paths in this hosted environment was outside our budget. We could potentially argue for it, but as Brad mentioned, not sure there is a need for this.
However planning for the future makes some sense. Perhaps Brad, Grant, and I will consider this as a way to plan for future growth and pre-separate things so that a quick alter would allow us to take advantage of a new array.