Export (0) Print
Expand All
Expand Minimize

sys.federation_member_distributions (Azure SQL Database)

Updated: April 24, 2014

This topic is OBSOLETE. You can find the most current version in the SQL 14 Transact-SQL Reference. See sys.federation_member_distributions.

ImportantImportant
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.

Returns distribution information about members within a federation. Sys.federation_member_distributions is specific to Microsoft Azure SQL Database and is not supported in on-premises SQL Server.

 

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

ADD
Show:
© 2014 Microsoft