.png)
ChangeMonitorThreshold Método
SQL Server 2008 R2
Changes the monitoring threshold metric for a publication.
Ensamblado: Microsoft.SqlServer.Rmo (en Microsoft.SqlServer.Rmo.dll)
public void ChangeMonitorThreshold( int metricId, bool enable, int thresholdValue, int shouldAlert )
Parámetros
- metricId
- Tipo: 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
- Tipo: System..::..Boolean
Specifies whether the metric is enabled or disabled on the publication.
- thresholdValue
- Tipo: System..::..Int32
New value for the publication threshold metric.
- shouldAlert
- Tipo: 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.
