How to specify SQL Server FileGroup in Entity

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:

  1. Right click on the entity and select Open Specification.

    Open entity's specification dialog

    Open entity’s specification dialog

  2. Go to DDL Clause property and specify the target filegroup with the “ON” statement.

    Specify entity's filegroup in DDL Clause property

    Specify entity’s filegroup in DDL Clause property

  3. After that when generate DDL the filegroup info will being attached to the table.

    Generate DDL for the table having filegroup setting

    Generate DDL for the table having filegroup setting


Related Know-how

Related Links

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply