| title | sp_replmonitorhelppublicationthresholds (T-SQL) | ||
|---|---|---|---|
| description | Describes the sp_replmonitorhelppublicationthresholds stored procedure which returns the threshold metrics set for a monitored publication. | ||
| ms.custom | seo-lt-2019 | ||
| ms.date | 03/04/2017 | ||
| ms.prod | sql | ||
| ms.prod_service | database-engine | ||
| ms.reviewer | |||
| ms.technology | replication | ||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | d6b1aa4b-3369-4255-a892-c0e5cc9cb693 | ||
| author | stevestein | ||
| ms.author | sstein |
[!INCLUDEappliesto-ss-asdbmi-xxxx-xxx-md]
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.
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.