By default SQL Server will store all your database objects, system objects, tables, stored procedures, etc… into the primary file group. This basically is putting everything into a single data file (.mdf) and transaction log (.ldf). This should be pretty sufficient in development environment. But in production environment the default setting could causing performance limitation. To achieve higher throughput we can design the database to work with multiple files and filegroups.
To specify FileGroup in entity:
- Right click on the entity and select Open Specification.
- Go to DDL Clause property and specify the target filegroup with the “ON” statement.
- After that when generate DDL the filegroup info will being attached to the table.