SLA Report Slow to Load

[ssoliveira]

Good afternoon,

The SLA report page is too slow.
It stays in loading infinite.

We're trying to analyze what I can see.
As the sla.php page is encrypted, I can not see which queries it does.

I believe it could be the database, which needs indexes, etc.

Could you help me by passing me the procedures for evaluating the health of the database, and if I need some optimization in the tables?

[scottwilkerson]

Unfortunately, the SLA report uses very little out if the database, it as well as the availability reports must process the nagios.log files and archives, and having them on fast disks in really the only way to speed up the reports.

We do have a planned re-write of these reports to use info from the database but that is several versions out.

[ssoliveira]

Hi Scot,

Thank you.

We were using Nagios as part of our high availability processes; together with the ISO 20000/20001 auditors.

I will study moving the data to a faster disk, however, we already have a LUN in a Storage VMAX HighEnd, so I think we can not add more IEE performance.

Is there any kind of log that I can analyze? Even when I request a short period report; as 24 hours; It has taken a long time (sometimes it opens, but most of the time it runs until the browser gives timeout).

[scottwilkerson]

Is there any kind of log that I can analyze?

This is part of the problem, the calculations are currently done by parsing nagios.log and all of the logs in /usr/local/nagios/var/archives