• 80+ filegroups is too much for that size of a database.

    80+ files is also a big number, but it's more normal for files.

    There are benefits of having multiple filegroups. Do you have a reason for having such many filegroups?

    I've worked on 100-500GB databases. They were having 15-20 filegroups and double number of files.

    However you can see in the survey that there are databases like yours.

    Igor Micev,My blog: www.igormicev.com