Export (0) Print
Expand All

PublicationMonitor.ChangeMonitorThreshold Method

Changes the monitoring threshold metric for a publication.

Namespace:  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)

public void ChangeMonitorThreshold(
	int metricId,
	bool enable,
	int thresholdValue,
	int shouldAlert
)

Parameters

metricId
Type: System.Int32
Is the ID of the publication threshold metric being changed and can be one of these values:
Value
Metric Name
1
Expiration. Monitors for imminent expiration of subscriptions to transactional publications.
2
Latency. Monitors for the performance of subscriptions to transactional publications.
4
Mergeexpiration. Monitors for imminent expiration of subscriptions to merge publications.
5
Mergeslowrunduration. Monitors the duration of merge synchronizations over low-bandwidth (dial-up) connections.
6
Mergefastrunduration. Monitors the duration of merge synchronizations over high-bandwidth local area network (LAN) connections.
7
Mergefastrunspeed. Monitors the synchronization rate of merge synchronizations over high-bandwidth (LAN) connections.
8
Mergeslowrunspeed. Monitors the synchronization rate of merge synchronizations over low-bandwidth (dial-up) connections.
enable
Type: System.Boolean
Specifies whether the metric is enabled or disabled on the publication.
thresholdValue
Type: System.Int32
New value for the publication threshold metric.
shouldAlert
Type: System.Int32
Specifies whether or not an alert is generated when the publication threshold metric is reached.

The ChangeMonitorThreshold method can only be called by members of the db_owner or replmonitor fixed database roles in the distribution database.

Calling ChangeMonitorThreshold is equivalent to executing sp_replmonitorchangepublicationthreshold (Transact-SQL).

The ChangeMonitorThreshold method is only available with SQL Server 2005.

Community Additions

ADD
Show:
© 2014 Microsoft