Server monitor

[Dreamer]

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

[SASKiwi]

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. 

[Dreamer]

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.

[Dreamer]

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?

[Dreamer]

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

[SASKiwi]

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!

[Dreamer]

Yes, I'm using SAS 9.4

[SASKiwi]

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

[jakarman]

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