About index partitioning for SQL Server

The partition-scheme attribute of the <mssql-index-ddl> element specifies the name of the partition scheme to use for the index. For example:

<database name="PolicyCenterDatabase" dbtype="sqlserver">
  ...
  <upgrade>
    ...
    <mssql-db-ddl>
      <mssql-table-ddl name="Table Name">
        <mssql-index-ddl partition-scheme="partition scheme" />
      </mssql-table-ddl>
    </mssql-db-ddl>
  </upgrade>
</database>

Define the partition scheme before starting PolicyCenter with the partition scheme attribute set. The referenced partition scheme in the configuration must exist, or PolicyCenter reports a configuration error during startup.

Whenever you partition a SQL Server index, that index is the clustering index for the table. Without a partition scheme defined, the clustering index for a PolicyCenter table is the primary key index.

The partition scheme is treated as a filegroup during index creation, and the SQL Server data space system catalog reports it almost the same as a filegroup.

The PolicyCenter database schema verifier checks that an index and the associated table are stored in the partition scheme configured in database-config.xml.

Refer to Microsoft documentation for information about how to create SQL Server partition schemes.

See also

• The <mssql-index-ddl> database configuration element