SALES: 1-800-867-1380
Expand Minimize

sys.dm_federation_operations (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.dm_federation_operations .

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 one row per SPLIT or DROP operation on a federation. Each row contains information on the progress and any error conditions for the operation. The sys.dm_federation_operations view is specific to Microsoft Azure SQL Database and is not supported in on-premise SQL Server.

 

Column Data type Description

federation_operation_id

uniqueidentifier

Unique operation id that identifies the federation operation in the system.

federation_operation_type

nvarchar(60)

Federation operation description (‘CREATE FEDERATION’, ‘ALTER FEDERATION SPLIT’ or ‘ALTER FEDERATION DROP’ or ‘DROP FEDERATION’)

federation_id

int

The target federation_id for the federation operation from sys.federations system view.

federation_name

sysname

Name of the federation for the given federation_id. This information is mostly redundant except for operations like DROP FEDERATION where federation metadata is immediately cleaned up but federation operation may continue to execute.

start_date

datetimeoffset

The UTC time at a regional Azure SQL Database datacenter when the member filtered copying was initiated.

last_modify_date

datetimeoffset

The UTC time at regional Azure SQL Database datacenter when the information on the federation operation has last been updated.

percent_complete

real

The percentage of rows that have been copied. Values range from 0 to 100. Azure SQL Database may automatically recover from some errors, such as failover, and restart the member filtered copy. In this case, percentage_complete would restart from 0.

You must be connected to the database used to start the federation operation, and you must have VIEW DATABASE STATE permissions.

The primary key for this view is federation_operation_id, which contains a randomly generated value. In combination with sys.dm_federation_operation_members, this view provides information on the progress of an operation

Information is reported as long as an operation is being executed, and is cleaned up immediately after the operation completes.

This view exists in all databases, but returns no rows in databases that do not contain federations, or do not have any ongoing operations on federations. This view also exists in federation members, but will never return rows as federation members cannot contain federations or execute federation operations.

The operations types in sys.dm_federation_operations and the member_type in sys.dm_federation_operations_members are correlated as follows:

  • CREATE FEDERATION: federation_operation_type = ‘CREATE FEDERATION’

    All member types will be ‘DESTINATION’ for member_type in sys.federation_operation_members.

  • ALTER FEDERATION: federation_operation_type = ‘ALTER FEDERATION SPLIT’ or ‘ALTER FEDERATION DROP’

    The source will be marked as ‘SOURCE’ for member_type in sys.federation_operation_members.

    The destination will be marked as ‘DESTINATION’ for member_type in sys.federation_operation_members.

  • DROP FEDERATION federation_operation_type = ‘DROP FEDERATION’

    All member types should be ‘SOURCE’ for member_type in sys.federation_operation_members.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft