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:
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.
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.
Use the transaction SAP Solution Manager Configuration
to connect the SAP Diagnostics Agent to SAP Solution Manager.Before continuing, watch the detailed SCN presentation Monitoring Remote SQL Server Systems with SAP Solution Manager 7.1, which explains the following steps specifically for SQL Server target systems. Then use the transaction to perform the following activities:
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:
This is only used once to set up the connection.
The administrator login must exist on the remote server.
This login is created and used for the monitoring.
This is the schema that is created in the database to hold the monitoring objects. SAP recommends using the default name.
This includes the setup of database extractors, which collect data for monitoring the databases in SAP Solution Manager.
Use the transaction
to set up the technical monitoring of databases in SAP Solution Manager. You set up the following:By default, auto-notification is activated.
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.