Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Online Services
Windows Azure
SQL Database
Transact-SQL Reference
System Views
sys.bandwidth_usage
sys.database_connection_stats
sys.database_usage
sys.databases
sys.dm_database_copies
sys.dm_db_index_operational_stats
sys.dm_db_index_physical_stats
sys.dm_db_index_usage_stats
sys.dm_db_missing_index_columns
sys.dm_db_missing_index_details
sys.dm_db_missing_index_groups
sys.dm_db_missing_index_group_stats
sys.dm_db_objects_impacted_on_version_change
sys.dm_db_partition_stats
sys.dm_db_wait_stats
sys.dm_exec_cached_plans
sys.dm_exec_connections
sys.dm_exec_describe_first_result_set
sys.dm_exec_describe_first_result_set_for_object
sys.dm_exec_procedure_stats
sys.dm_exec_query_memory_grants
sys.dm_exec_query_plan
sys.dm_exec_query_stats
sys.dm_exec_requests
sys.dm_exec_sessions
sys.dm_exec_sql_text
sys.dm_exec_text_query_plan
sys.dm_exec_trigger_stats
sys.dm_operation_status
sys.dm_tran_active_transactions
sys.dm_tran_database_transactions
sys.dm_tran_locks
sys.dm_tran_session_transactions
sys.dm_federation_operations
sys.dm_federation_operation_members
sys.dm_federation_operation_errors
sys.dm_federation_operation_error_members
sys.event_log
sys.federations
sys.federation_distributions
sys.federation_members
sys.federation_member_distributions
sys.federation_history
sys.federation_distribution_history
sys.federation_member_history
sys.federation_member_distribution_history
sys.federated_table_columns
sys.firewall_rules
sys.database_firewall_rules
sys.resource_usage
sys.resource_stats
Expand Minimize
This topic has not yet been rated - Rate this topic

sys.federation_member_distributions (Windows Azure SQL Database)

Returns distribution information about members within a federation. Sys.federation_member_distributions is specific to Windows Azure SQL Database and is not supported in on-premise 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.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.
|
Site Feedback
© 2013 Microsoft. All rights reserved.