| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sp_replmonitorhelppublicationthresholds (T-SQL) |
Describes the sp_replmonitorhelppublicationthresholds stored procedure which returns the threshold metrics set for a monitored publication. |
markingmyname |
maghan |
03/04/2017 |
sql |
replication |
reference |
|
|
|
[!INCLUDE SQL Server SQL MI]
Returns the threshold metrics set for a monitored publication. This stored procedure, which is used to monitor replication, is executed at the Distributor on the distribution database.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
sp_replmonitorhelppublicationthresholds [ @publisher = ] 'publisher'
, [ @publisher_db = ] 'publisher_db'
, [ @publication = ] 'publication'
[ , [ @publication_type = ] publication_type ]
[ , [ @thresholdmetricname = ] 'thresholdmetricname'
[ @publisher = ] 'publisher'
Is the name of the Publisher. publisher is sysname, with no default.
[ @publisher_db = ] 'publisher_db'
Is the name of the published database. publisher_db is sysname, with no default.
[ @publication = ] 'publication'
Is the name of the publication. publication is sysname, with no default.
[ @publication_type = ] publication_type
If the type of publication. publication_type is int, and can be one of these values.
| Value | Description |
|---|---|
| 0 | Transactional publication. |
| 1 | Snapshot publication. |
| 2 | Merge publication. |
| NULL (default) | Replication tries to determine the publication type. |
| Column name | Data type | Description |
|---|---|---|
| metric_id | int | ID of the replication performance metric, which can be one of the following. 1expiration - monitors for imminent expiration of subscriptions to transactional publications. 2latency - monitors for the performance of subscriptions to transactional publications. 4mergeexpiration - monitors for imminent expiration of subscriptions to merge publications. 5mergeslowrunduration - monitors the duration of merge synchronizations over low-bandwidth (dial-up) connections. 6mergefastrunduration - monitors the duration of merge synchronizations over high-bandwidth (LAN) connections. 7mergefastrunspeed - monitors the synchronization rate of merge synchronizations over high-bandwidth (LAN) connections. 8mergeslowrunspeed - monitors the synchronization rate of merge synchronizations over low-bandwidth (dial-up) connections. |
| title | sysname | Name of the replication performance metric. |
| value | int | The threshold value of the performance metric. |
| shouldalert | bit | Is if an alert should be generated when the metric exceeds the defined threshold for this publication; a value of 1 indicates that an alert should be raised. |
| isenabled | bit | Is if monitoring is enabled for this replication performance metric for this publication; a value of 1 indicates that monitoring is enabled. |
0 (success) or 1 (failure)
sp_replmonitorhelppublicationthresholds is used with all types of replication.
Only members of the db_owner or replmonitor fixed database role on the distribution database can execute sp_replmonitorhelppublicationthresholds.