Export (0) Print
Expand All

sys.federation_history (Azure SQL Database)

SQL Server 2014

Contains historical information about 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: .

Columns

Data type

Description

federation_id

int

The federation id

name

sysname

Name of the federation

drop_date

datetimeoffset

Datetime the federation was dropped

create_date

datetimeoffset

Datetime the federation was created

This view requires VIEW DATABASE STATE permission.

Cleanup of historical data is performed automatically every two weeks. Cleanup is triggered by operations that update the log information. This can result in historical information being retained for longer than two weeks if no new operations have been performed.

The drop_date and create_date columns are populated on the completion of an operation. For asynchronous operations these fields are populated when the operation completes fully, not when the command returns.

Community Additions

ADD
Show:
© 2014 Microsoft