How to create a new (custom) checkpoint using the sqlserver probe

book

Article ID: 39422

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

This guide provides the steps required to create and configure new (custom) checkpoints using the sqlserver probe. Custom checkpoints allow you to use your own preferred queries or stored procedures for database monitoring when the checkpoints provided out of the box do not satisfy your specific database monitoring requirements. This guide walks you through configuring and testing a custom checkpoint, configuring data collection (QoS), configuring alarms and alarm thresholds, and the use of restrictions on monitoring (Excludes/Includes). Note that the example used in this guide executes the new (custom) query against a specific database, not all databases.

Environment

The attached guide (.pdf) was created using the following CA test environment:
  • sqlserver probe v4.94 and later
  • CA UIM 8.3 and later
  • Microsoft SQL Server 2012 - 11.0.2100.60 (X64) Enterprise Edition (64-bit)
  • OS: Windows 2012 R2

Resolution

See attached guide:  How to create a new (custom) checkpoint using the sqlserver probe.pdf

Additional Information

This is the document page for the sqlserver probe Admin Console Configure:
https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/ca-unified-infrastructure-management-probes/GA/alphabetical-probe-articles/sqlserver-sql-server-monitoring/sqlserver-ac-configuration.html#concept.dita_b0612183d74fe796fc266ff9d2daf9e9fddd2afd_CreateaCustomCheckpoint

This is the document page for the sqlserver probe IM Console Configure:

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/ca-unified-infrastructure-management-probes/GA/alphabetical-probe-articles/sqlserver-sql-server-monitoring/sqlserver-im-configuration.html#concept.dita_6418cedd176b65bd76d08c07a34b8d59f840ad8f_OptionalCreateCustomCheckpoint

Attachments

1560541315638__How to create a new (custom) checkpoint using the sqlserver probe.pdf get_app