SALG : 1-800-867-1389
Expand Minimize
EN
Dette indhold er ikke tilgængeligt på dit sprog, men her er den engelske version.

sys.federation_member_history (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_history.

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 historical information for each member of a federation. Sys.federation_member_history 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

The unique id of the federation member

drop_date

datetimeoffset

Datetime the federation member was dropped.

create_date

datetimeoffset

Datetime the federation member 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.

The value for federation_id is not reused within a single root database, and the value of member_id is not reused within a federation.

Syntes du, dette var nyttigt?
(1500 tegn tilbage)
Tak for din feedback

Fællesskabsindhold

Tilføj
Vis:
© 2014 Microsoft