topic SAS Web infra structure DATA server monitoring tool in Administration and Deployment

SAS Web infra structure DATA server monitoring tool

sandeep_reddy — Fri, 08 Sep 2017 06:01:50 GMT

Hi There,

I am facing issues with my Web infra structructure data server. So i always have to monitor by checking the service status.

I have read in some documents about pgpool-II tool which monitors the Web data server .

I have already a sas 9.4 M3 installed distributed platform in which i have meta and mid installed in same machine.

Please kindly help with some ideas to manage and monitor Web Data Server .

Thanks & Regards,

Sanddep

Re: SAS Web infra structure DATA server monitoring tool

vbkm — Wed, 11 Oct 2017 16:11:06 GMT

We had similar issue with one of the SAS process at my previous site, created a wrapper script in shell for this process in such a way that it will send an alert if the process goes down and restarts it right away. Scheduled it to run in 30 sec intervals in crontab. Hope this helps!

Re: SAS Web infra structure DATA server monitoring tool

Damo — Wed, 11 Oct 2017 20:30:15 GMT

Hi @sandeep_reddy

Did you try the SAS Environment Manager?

You should be able to create an event which monitor that particular component and eventually alert/email you if there is a problem.

Cheers,

Damo

Re: SAS Web infra structure DATA server monitoring tool

JuanS_OCS — Thu, 12 Oct 2017 13:08:35 GMT

Hello @sandeep_reddy,

I completely agree with @Damo. Environment Manager allows you to monitor the postgresql database (WIP database), and also to test the connection of a user to the database, so not only the availability of the port for the service.

If your company has got any other enterprise-level monitoring tool, they can use ir as well to monitor the port, to test the connection to the database, etc, and send alerts if needed, and even trigger commands under certain conditions.

For your information, https://wiki.postgresql.org/wiki/Monitoring