Re: Database and OS monitoring

Try http://brendangregg.com/

Lots of great tidbits there from a guy who really knows his performance
stuff (ex-Sun, now Netflix)

On Sunday, 14 December 2014, Vick Khera <vivek(at)khera(dot)org> wrote:

>
> On Sat, Dec 13, 2014 at 1:55 PM, Edson Carlos Ericksson Richter <
> edsonrichter(at)hotmail(dot)com
> <javascript:_e(%7B%7D,'cvml','edsonrichter(at)hotmail(dot)com');>> wrote:
>>
>> I've been searching in web for guidelines on OS (Linux) and PostgreSQL
>> (9.3.5) active monitoring best practices.
>>
>
> Recent trends are more toward monitoring response latency by first
> establishing a baseline level of activity and latency, then alerting when
> those numbers get out of acceptable range.
>
> There are some open source tools to collect and sort and report this way
> (see Kibana and Grafana and their underlying data stores). I've not seen
> alerting tools based on this that are non-commercial, though. Two services
> I know of are Ruxit and Circonus.
>
> Personally I still use Nagios to tell my staff when things are down or not
> responding, but often that is too late to proactively fix things.
>
> One thing that'd be really cool is to use the new binary JSON storage in
> the upcoming Pg release to store the time series data for use with
> Grafana... but then you'd have a chicken/egg problem with monitoring
> itself. :)
>