Igor Micev (3/14/2014)
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.
Sorry I wasn't very clear. There are four file groups all residing on one RAID10 volume:
Primary: one file
Filegroup2: forty files
Filegroup3: forty files
Filegroup 4: one file
I was told that this was done to reduce read and write latency but i just can't find any evidence that this is correct.