El lado crítico de las empresas multinivel

The Check Information area at the bottom of the Alerts tab provides a full list of all the checks carried out by the system. In addition to a description of what each check does (Description) and what you need to do in the event of an alert (User Action), you can see important scheduling information:

Column Description

Max Priority The most severe alert that was generated the last time the check was carried out For checks that consider only one object (for example, the check that determines how many days until your license expires), only one alert can be generated. This is

automatically the most severe.

However, for checks that consider several objects (for example, the check that determines CPU utilization in a system with multiple hosts), several alerts can be generated for one check. The most severe is recorded here. For example, if in a distributed system with 5 hosts, the CPU utilization of 2 hosts was acceptable, 2 hosts exceeded the minimum threshold value, and 1 host exceeded the medium threshold, then

"medium" would be the most severe alert generated.

Last Run When the check was last carried out On Schedule Whether or not the check is on schedule

Even if a check is scheduled, that is there is a time and date in the Next Run column, it is important to ensure that it is actually being carried out according to schedule. Otherwise, you will not be warned about critical situations, which could have serious consequences.

You can see whether or not a check is being carried out on schedule in the On Schedule column. If a check is not on schedule (No in the On Schedule column), then the system not performing checks as it should, and you must investigate further.

Next Run When the check is scheduled to be carried out again Interval Interval at which the check is carried out in seconds

In addition to the above information available on the Alerts tab, the following tables in the _SYS_STATISTICS schema provide you with further information about the default checks, their configuration and scheduled execution.

Note

These tables are only available if you have migrated to the new implementation of the statistics server available with SPS 07. For more information, see SAP Note 1917938 .

Table Description

STATISTICS_ALERT_INFORMATION This table describes what each check does and what to do when an alert is issued.

STATISTICS_ALERT_THRESHOLDS This table contains the threshold values for each check. The severity level indicates the type of alert that is issued when the threshold value is reached or exceeded as follows. Severity level 1 corresponds to an information alert and level 4 a high priority alert.

STATISTICS_SCHEDULE This table contains the scheduling information for all checks.

Table Description

Note

It also contains the scheduling information for historical data collection.

2.5.7.1 Configuring E-Mail Notifications for Alerts

You can configure the system in such a way that you receive an e-mail when an alert condition for all or specific checks is fulfilled.

Prerequisites

You have the system privilege INIFILE ADMIN.

Procedure

1. In the Administration editor, choose the Alerts tab.

2. From the tab toolbar, choose the (Configure Check Settings) button.

The Configure Check Settings dialog box appears.

3. Enter the following information:

○ Sender's e-mail address

E-mail address that is entered as the email's sender

○ SMTP server

The mailserver that the system sends the e-mails to

○ Optional: SMTP Port

The default SMTP port is 25. If the configured mailserver uses a different port, enter it.

4. Optional: Specify the recipient(s) to whom you want an e-mail notification to be sent when an alert is generated for any check.

To do so, choose Modify Recipients and add the e-mail addresses of the users.

Note

You can omit this step and only configure e-mail notification for specific checks (next step).

5. Specify the recipients to whom you want to an e-mail notification to be sent when an alert is generated for a specific check or checks.

a) Choose Recipients Configuration for Specific Checks.

b) Select the checks for which you want to configure e-mail notification and then choose Add Recipients to add the e-mail addresses of the users to be notified.

6. Choose OK to save the configuration.

Results

The specified recipients are notified by e-mail when the system issues an alert for the relevant checks.

2.5.7.2 Configuring Check Thresholds

For some checks performed by the system, you can configure when an alert is issued, that is the alert condition. A check can have a low, medium, and high priority threshold.

Prerequisites

You have the system privilege INIFILE ADMIN.

Procedure

1. In the Administration editor, choose the Alerts tab.

2. From the tab toolbar, choose the (Configure Check Settings) button.

The Configure Check Settings dialog box appears.

3. Choose the Configure Check Thresholds tab.

4. Choose the check that you want to change and enter the threshold values.

The threshold value and unit depend on what is being measured. For example, for check 2 (disk usage), you could enter 90, 95 and 100 as the thresholds, where 90, 95 and 100 represent the percentage of disk space used.

Tip

Hover over a threshold value with the mouse to see information about the unit and the default value.

5. Choose OK when you have finished configuring the check thresholds.

Results

Alerts are generated when the system records the configured threshold values. The color of the bar views on the Overview tab may also change when certain thresholds are changed. For example, you change the disk space

threshold from 90, 95 and 100, to 85, 90 and 95. If the disk is at 95% usage, then the bar view would change from yellow to red.

2.5.7.3 Configuring Start Times of Periodic Checks

Some statistics server checks are performed every 6 or 24 hours. For example, the age of the last data backup is checked every 24 hours. You can configure the start times for these checks.

Prerequisites

You have the system privilege INIFILE ADMIN.

Procedure

Note

It is only possible to configure start times of periodic checks if the statistics server component is still available in your system, that is, you have not migrated to the new mechanism available with SPS 07.

1. In the Administration editor, choose the Alerts tab.

2. From the tab toolbar, choose the (Configure Check Settings) button.

The Configure Check Settings dialog box appears.

3. Choose the Configure Start Time on Check Intervals tab.

This tab has two sections, one for setting the start time of checks performed every 6 hours and one for setting the start time of checks performed every 24 hours. You can also see which checks are performed at these intervals.

Note

The intervals between checks cannot be changed.

4. Set the start time for both periodic check types.

5. Choose OK.

Results

The start time for the checks is changed.

2.5.8 Monitoring System Performance

Gathering and analyzing data regarding the performance of your SAP HANA systems is important for root-cause analysis and the prevention of future performance issues.

General information about overall system performance is available in the System Monitor and on the Overview tab of the Administration editor. You can monitor the following fine-grained aspects of system performance on the Performance tab:

● Threads

● Sessions

● Blocked transactions

● Execution statistics of frequently-executed queries in the SQL plan cache

● Expensive statements

● Progress of long-running jobs

● System load

As the information available on the Performance tab is very detailed, several filtering and configuration options are available with which you can customize the amount and type of information displayed. For example:

● You can show and hide columns using the Table Viewer.

To open the Table Viewer, choose (Configure Viewer) in the toolbar on the top-right of the screen.

● You can hide idle sessions, as well as sessions originating in the Administration editor or the SAP HANA studio.

This filter is available on the Threads, Sessions, and Blocked Transactions sub-tabs.

Any filters or layout configuration that you apply on the following sub-tabs are saved when you close the SAP HANA studio and applied the next time you open the tab. This is independent of which system you open.

● Sessions

● Expensive Statements Trace

● SQL Plan Cache

● Job Progress

2.5.8.1 Thread Monitoring

You can monitor all running threads in your system in the Administration editor on the Performance

Threads sub-tab. It may be useful to see, for example, how long a thread is running, or if a thread is blocked for an inexplicable length of time.