SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Server monitor

Reply
Frequent Contributor
Posts: 89

Server monitor

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

Super User
Posts: 3,108

Re: Server monitor

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. 

Frequent Contributor
Posts: 89

Re: Server monitor

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.

Frequent Contributor
Posts: 89

Re: Server monitor

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.

SASApp Server log .png

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

Frequent Contributor
Posts: 89

Re: Server monitor

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:

  1. 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:

  1. 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



Super User
Posts: 3,108

Re: Server monitor

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!

Frequent Contributor
Posts: 89

Re: Server monitor

Yes, I'm using SAS 9.4

Super User
Posts: 3,108

Re: Server monitor

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

Valued Guide
Posts: 3,208

Re: Server monitor

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

---->-- ja karman --<-----
Ask a Question
Discussion stats
  • 8 replies
  • 460 views
  • 0 likes
  • 3 in conversation