Dışarıya aktar (0) Yazdır
Tümünü Genişlet
EN
Bu içerik dilinizde bulunmamaktadır ancak İngilizce sürümüne buradan bakabilirsiniz.

sys.dm_federation_operation_members (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_operation_members.

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 a list of federation members involved in federation operations. The sys.dm_federation_operation_members view is specific to Microsoft Azure SQL Database and is not supported in on-premises SQL Server.

The sys.dm_federation_operation_members view contains the following fields:

 

Columns Data Type Description

federation_operation_id

uniqueidentifier

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

member_id

int

The ID of the source or destination member in the sys.federation_members view.

member_type

nvarchar(60)

‘Source’ or ‘Destination’

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_operations (Azure SQL Database), 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.

Topluluk İçeriği

Show:
© 2014 Microsoft