File-Grouping

TIBCO MDM product documents recommend creating various file-groups while setting up seed-data. However, depending on the data model and the solution, you should create several file-groups so that the larger entities are on separate file-groups.

This reduces the input/output contention on the same file group. You can decide if you need more file groups by observing the file-group input/output in the SQL profiler. A Microsoft best practice is to limit the number of file groups.