Show TOC

Procedure documentationSetting Up Database Monitoring and Alerting in SAP Solution Manager Locate this document in the navigation structure

Procedure

To set up the end-to-end monitoring and alerting infrastructure, you use the standard transactions for setting up SAP Solution Manager. You need to perform the following steps:

  1. Install the Diagnostics Agent on your database systems.

    The Diagnostics Agent gathers information from the managed systems and reports them to the SAP Solution Manager system. This also includes information about the availability of the database and its host. You need to install a Diagnostics Agent on each server (virtual hostname) that you want to monitor. You can use the SAP installation tool to install the Diagnostics Agent.

  2. Configure data suppliers in the system landscape directory (SLD).

    Use the transaction System Landscape Directory: Local Administration (RZ70) to configure SLD data suppliers in the system landscape. Here, you need to provide the port and the host of the SLD. The SLD data suppliers are programs that collect the database attributes Database Host, Database Type and Database Name at defined periods. Once the SLD data suppliers are up and running, they push database attributes from the database to the SLD.

  3. Connect the Diagnostics Agent to SAP Solution Manager.

    Use the transaction   SAP Solution Manager Configuration (SOLMAN_SETUP)   System Preparation   to connect the SAP Diagnostics Agent to SAP Solution Manager.

  4. Configure the systems managed by SAP Solution Manager.

    Use the transaction   SAP Solution Manager Configuration (SOLMAN_SETUP)   Managed System Configuration   to perform the following activities:

    • Connect the SAP Diagnostics Agent to the managed databases

    • Specify system parameters required to configure the managed databases

      Most of these parameters, such as hosts or ports, are automatically detected by the Diagnostics Agent, so only a password is required here.

    • Trigger automatic configuration activities

      This includes the setup of database extractors, which collect data for monitoring the databases in SAP Solution Manager.

  5. Set up technical monitoring, including alerting.

    Use the transaction   SAP Solution Manager Configuration (SOLMAN_SETUP)   Technical Monitoring   to set up the technical monitoring of databases in SAP Solution Manager. You set up the following:

    • Activation or deactivation of auto-notifications (for example, e-mail notifications) about database alerts

      As a default, auto-notification is activated.

    • Recipients and recipient lists of auto-notifications

    • Assignment of monitoring templates to selected systems in scope for monitoring

    Monitoring templates contain the definitions or values of metrics, events, and alerts (MEA) that trigger incidents and notifications. The SAP templates have predefined settings, but you can also adapt the templates to your customer-specific needs.

More Information

  • Complete setup of SAP Solution Manager: Documentation for SAP Solution Manager on SAP Help Portal at http://help.sap.com/solutionmanager

  • Additional database-specific setup steps: SAP Note 1027146

  • Overall architecture: Architecture Overview: End-to-End Monitoring and Alerting in SAP Solution Manager and DBA Cockpit