topic Server monitor in SAS Data Management

Server monitor

Dreamer — Wed, 15 Oct 2014 18:45:20 GMT

Hi,

Is there any way, a SAS admin can monitor SAS code submitted to server and sql that it's using?

So that owner of a long running query / Processor intensive can be notified!!

This is available in other data bases and I wonder if SAS provides something like this.

Thanks

Re: Server monitor

SASKiwi — Wed, 15 Oct 2014 18:59:30 GMT

Most servers have IT performance monitoring tools (eg Perfmon) installed. To see these you would need the authority to do a remote log-on to the server.

With SAS 9.4 a new SAS-based monitoring tool is available through a web browser called Environment Manager. EMgr monitors all SAS servers in the same inteface so this is a major improvement on previous SAS releases.

With earlier SAS releases it is possible to set up monitoring capabilities in SAS but this takes a lot of work to set up the SAS programs required, so I suspect most SAS sites don't do it.

Re: Server monitor

Dreamer — Wed, 15 Oct 2014 19:34:48 GMT

Yes I can remote log-on to the server.

Windows task manager and Windows power shell gives very much idea about system resource consumption by each SAS process.

But it doesn't give information at data access level.

Re: Server monitor

Dreamer — Wed, 15 Oct 2014 19:42:26 GMT

Since sas codes execute on SAS App server, I wonder if we have any such information in server log.

But when I tried connecting to SASApp work space, I got following error message.

Is there any way I can get SASApp workspace Server log?

Re: Server monitor

Dreamer — Wed, 15 Oct 2014 19:48:28 GMT

Natezza provides following information and I'm looking for something similar in SAS environment:

--Active Query Entry
--Host: hostname
--October 14, 2014 11:33 AM

--Identifiers
--Plan Id:	44894
--Session Id:	90360
--Client Id:	135
--Database:	dbname
--User:	userid
--Client IP address:	10.11.12.134
--Timing
--Submit time:	2014-10-14 10:06:22
--Start time:	2014-10-14 10:06:22
--Elapsed seconds:	5223
--Estimates
--Estimated seconds:	11.522
--Estimated disk:	479 KB
--Estimated memory:	1 KB
--Details
--Priority:	Normal
--Snippets:	18
--Current snippet:	7
--Result rows:	0
--Result bytes:	0

--SQL Statement
select * from db.table1

Re: Server monitor

SASKiwi — Wed, 15 Oct 2014 20:35:52 GMT

SAS server logs are of no use for monitoring resources, they are primarily used for monitoring connections, server errors etc.

If you are not using SAS 9.4, then my comment above about setting up SAS monitoring applies. For a quick fix I would suggest getting Perfmon or similar installed. At least that will monitor overall SAS performance, just not individual SAS jobs/users.

SAS Environment Manager looks very good - no consolation if you are not on 9.4!

Re: Server monitor

Dreamer — Thu, 16 Oct 2014 17:45:15 GMT

Yes, I'm using SAS 9.4

Re: Server monitor

SASKiwi — Thu, 16 Oct 2014 18:38:46 GMT

Do you have SAS Environment Manager installed and monitoring your servers?

Re: Server monitor

jakarman — Thu, 16 Oct 2014 18:41:01 GMT

If you are only wanting to follow sas processes use the apm tool. It creates log files as of arm api calls.

This is the same for the eventmanager.

Real os monitoring and real dbms monitoring is out of scope for sas. That they are offering some of those way without mentioning the limitations is a bad sales approach.

When you are really needing tooling at that low level at the os, you are needing os knowledge and os tools dbms tools