Hi,

Yes, based on a consultant who came in to help us trobuleshoot performance issues, the two filegroups that we have each with one 300GB file was determined to be a bottleneck and recommended that we spread the data across multiple files instead of one.

When I first tried to shrink the file after it was empty, I was getting an error and after looking through SQL forums, I saw an article that stated the SQL server needed to be restarted before you can shrink the empty file. I did that and it worked.

I only chose 10 30GB datafiles because I just wanted to spread the data evenly and it seemed like an easy number.

Thanks,

Isabelle