We have integrated our SAP Business Intelligence with Nagios so that we can create Performance/Availability reports. We are wondering what solutions are out there for keeping performance data in separate databases for historical reports. We are aware that most performance data is only typically kept for a short period of time but we are looking for a solution to keep it longer.
What database types are supported for this sort of solution?
Thanks,
Nagios XI Performance Data
-
slansing
- Posts: 7698
- Joined: Mon Apr 23, 2012 4:28 pm
- Location: Travelling through time and space...
Re: Nagios XI Performance Data
Well, the typical way that we store that performance data is in round robin database files, which is held indefinitely, but the values can become increasingly averaged. Another way we handle reporting is by writing host/service returns to the NDO database for reports such as the Availability Summary. It sounds like you don't have that tool fully integrated yet.
In your case, would entirely depend on the tool you are using, and what it accepts, perhaps their support team has worked with Nagios integration before? I would definitely check with them first, before you get plugging away at one type of database and find out it wont work properly.What database types are supported for this sort of solution?
-
AMacintosh
- Posts: 59
- Joined: Mon Nov 07, 2011 12:26 pm
Re: Nagios XI Performance Data
What we need is the ability to provide performance reports on a weekly/monthly basis. We also need the ability to keep historical data. What we don't want is to impede on the performance of Nagios XI.
Re: Nagios XI Performance Data
You can tweak performance settings in XI (specify data retention intervals) by going to Admin->Performance Settings->Databases tab-><make mods>->Update Settings.
Be sure to check out our Knowledgebase for helpful articles and solutions!
-
AMacintosh
- Posts: 59
- Joined: Mon Nov 07, 2011 12:26 pm
Re: Nagios XI Performance Data
Is it an easy/common task to have the nagios database on a separate server?
-
slansing
- Posts: 7698
- Joined: Mon Apr 23, 2012 4:28 pm
- Location: Travelling through time and space...
Re: Nagios XI Performance Data
It is pretty easy, yes, while I would not necessarily label it as common, I've seen it quite a few times.
http://assets.nagios.com/downloads/nagi ... Server.pdf
http://assets.nagios.com/downloads/nagi ... Server.pdf