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.
Good point. This option wasn't chosen for two reasons. First, the servers are hosted, and our I/O options weren't wide. Second, the activity on the server is not really that great, relatively speaking, necessitating the need for such tweaking. Of course, there are other performance issues, but separating the nonclustered indexes wouldn't have helped much to alleviate them. We will talk about what is causing the performance problems in a later article.
Brad M. McGehee
DBA