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

Document ID : KB000039422
Last Modified Date : 07/05/2018
Show Technical Document Details
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
Instructions:
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://docops.ca.com/ca-unified-infrastructure-management-probes/ga/en/alphabetical-probe-articles/sqlserver-sql-server-monitoring/sqlserver-ac-configuration#sqlserverACConfiguration-CreateaCustomCheckpoint


This is the document page for the sqlserver probe IM Console Configure:
https://docops.ca.com/ca-unified-infrastructure-management-probes/ga/en/alphabetical-probe-articles/sqlserver-sql-server-monitoring/sqlserver-im-configuration#sqlserverIMConfiguration-(Optional)CreateCustomCheckpoint
 
File Attachments:
TEC1702463.zip