sys.federation_member_distributions (Azure SQL Database)

Returns distribution information about members within a federation.

Important note Important

The current implementation of Federations will be retired with Web and Business service tiers. Consider deploying custom sharding solutions to maximize scalability, flexibility, and performance. For more information about custom sharding, see Scaling Out Azure SQL Databases.

Applies to: Azure SQL Database.

Columns

Data type

Description

federation_id

int

Reference to federation id.

member_id

int

Is the unique id to identify the federation member.

Distribution_name

sysname

Reference to the federation_distribution_schemes distribution_name for the federation

Range_low

sqlvariant

Low range of the key that the federation member will be servicing. The low range value is inclusive in all cases.

Range_high

sqlvariant

High range of the key that the federation member will be servicing. High value range is excluded in the values serviced by the federation member.

Community Additions

Show: