Show TOC

Setting Up Database Monitoring and Alerting in SAP Solution ManagerLocate this document in the navigation structure

Use

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:

Procedure
  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 Start of the navigation path (SOLMAN_SETUP) Next navigation step System Preparation End of the navigation path to connect the SAP Diagnostics Agent to SAP Solution Manager.

  4. Configure the systems managed by SAP Solution Manager.

    Before continuing, watch the detailed SCN presentation Monitoring Remote SQL Server Systems with SAP Solution Manager 7.1Information published on SAP site, which explains the following steps specifically for SQL Server target systems. Then use the transaction Start of the navigation path SAP Solution Manager Configuration (SOLMAN_SETUP) Next navigation step Managed System Configuration End of the navigation path to perform the following activities:

    • Connect the SAP Diagnostics Agent to the managed databases.
    • Specify system parameters required to configure the managed databases.

      Some of these parameters, such as the server and database names, are automatically detected by the Diagnostics Agent. Other parameters have default values.

      The following parameters are required for the initial setup:

      • Administrator login and password

        This is only used once to set up the connection.

        The administrator login must exist on the remote server.

      • Monitor login name and password

        This login is created and used for the monitoring.

      • Object Source Schema

        This is the schema that is created in the database to hold the monitoring objects. SAP recommends using the default name.

    • 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 Start of the navigation path SAP Solution Manager Configuration (SOLMAN_SETUP) Next navigation step Technical Monitoring End of the navigation path 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

      By 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.