topic Re: Hello, If sas in installed on windows os then How to troubleshoot or catch performance of sas DI jobs on unix? By using nmon? in SAS Programming https://communities.sas.com/t5/SAS-Programming/Hello-If-sas-in-installed-on-windows-os-then-How-to-troubleshoot/m-p/206033#M306470 <HTML><HEAD></HEAD><BODY><P>First thing: You need access to the SAS log. If you're using DI Studio then you have access to the log within DI, if you're running your deployed jobs in batch then you need access to the file systems where the SAS logs get stored (SSH using something like WinSCP). </P><P></P><P>For the SAS logs to give you enough information you want options like "fullstimer" turned on, if interacting with a database you want also options "<SPAN style="line-height: 1.5em; color: #545454; font-family: arial, sans-serif; font-size: small; background-color: #ffffff;">SASTRACE=',,,d' SASTRACELOC=SASLOG </SPAN><SPAN style="line-height: 1.5em; font-weight: bold; color: #6a6a6a; font-family: arial, sans-serif; font-size: small; background-color: #ffffff;">NOSTSUFFIX</SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;">" set.</SPAN></P><P></P><P>Very often poor performance comes from poor design/code so that's the first thing I would be looking into. What are the long running steps? Why are they long running? Could it be done more efficiently (eg. less movement of data between servers).</P><P></P><P>It can of course also be caused by environmental limitations. Here for a start:&nbsp; <A href="http://support.sas.com/documentation/cdl/en/hostunx/67929/HTML/default/viewer.htm#p108wmx6a3y7tbn0z5ihlkrfj704.htm" title="http://support.sas.com/documentation/cdl/en/hostunx/67929/HTML/default/viewer.htm#p108wmx6a3y7tbn0z5ihlkrfj704.htm">SAS(R) 9.4 Companion for UNIX Environments, Fifth Edition</A></P></BODY></HTML> Sun, 19 Jul 2015 22:25:42 GMT Patrick 2015-07-19T22:25:42Z Hello, If sas in installed on windows os then How to troubleshoot or catch performance of sas DI jobs on unix? By using nmon? https://communities.sas.com/t5/SAS-Programming/Hello-If-sas-in-installed-on-windows-os-then-How-to-troubleshoot/m-p/206030#M306467 <HTML><HEAD></HEAD><BODY><P>DI Jobs </P></BODY></HTML> Sun, 19 Jul 2015 12:32:48 GMT https://communities.sas.com/t5/SAS-Programming/Hello-If-sas-in-installed-on-windows-os-then-How-to-troubleshoot/m-p/206030#M306467 vishu 2015-07-19T12:32:48Z Re: Hello, If sas in installed on windows os then How to troubleshoot or catch performance of sas DI jobs on unix? By using nmon? https://communities.sas.com/t5/SAS-Programming/Hello-If-sas-in-installed-on-windows-os-then-How-to-troubleshoot/m-p/206031#M306468 <HTML><HEAD></HEAD><BODY><P>In your situation sas DI jobs on Unix SAS is installed on Unix not Windows.&nbsp;&nbsp; <BR />The fist thing for working SAS on Unix is understanding Unix than getting access to by SSH on the same machine so you can see your processes running (ps).<BR />As you need SSH the NOXCMD setting from SAS to Unix is humbug. It is a signal there is no alignment with your IT department. Start there...&nbsp; </P></BODY></HTML> Sun, 19 Jul 2015 14:28:21 GMT https://communities.sas.com/t5/SAS-Programming/Hello-If-sas-in-installed-on-windows-os-then-How-to-troubleshoot/m-p/206031#M306468 jakarman 2015-07-19T14:28:21Z Re: Hello, If sas in installed on windows os then How to troubleshoot or catch performance of sas DI jobs on unix? By using nmon? https://communities.sas.com/t5/SAS-Programming/Hello-If-sas-in-installed-on-windows-os-then-How-to-troubleshoot/m-p/206032#M306469 <HTML><HEAD></HEAD><BODY><P>Thank you</P></BODY></HTML> Sun, 19 Jul 2015 16:54:49 GMT https://communities.sas.com/t5/SAS-Programming/Hello-If-sas-in-installed-on-windows-os-then-How-to-troubleshoot/m-p/206032#M306469 vishu 2015-07-19T16:54:49Z Re: Hello, If sas in installed on windows os then How to troubleshoot or catch performance of sas DI jobs on unix? By using nmon? https://communities.sas.com/t5/SAS-Programming/Hello-If-sas-in-installed-on-windows-os-then-How-to-troubleshoot/m-p/206033#M306470 <HTML><HEAD></HEAD><BODY><P>First thing: You need access to the SAS log. If you're using DI Studio then you have access to the log within DI, if you're running your deployed jobs in batch then you need access to the file systems where the SAS logs get stored (SSH using something like WinSCP). </P><P></P><P>For the SAS logs to give you enough information you want options like "fullstimer" turned on, if interacting with a database you want also options "<SPAN style="line-height: 1.5em; color: #545454; font-family: arial, sans-serif; font-size: small; background-color: #ffffff;">SASTRACE=',,,d' SASTRACELOC=SASLOG </SPAN><SPAN style="line-height: 1.5em; font-weight: bold; color: #6a6a6a; font-family: arial, sans-serif; font-size: small; background-color: #ffffff;">NOSTSUFFIX</SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;">" set.</SPAN></P><P></P><P>Very often poor performance comes from poor design/code so that's the first thing I would be looking into. What are the long running steps? Why are they long running? Could it be done more efficiently (eg. less movement of data between servers).</P><P></P><P>It can of course also be caused by environmental limitations. Here for a start:&nbsp; <A href="http://support.sas.com/documentation/cdl/en/hostunx/67929/HTML/default/viewer.htm#p108wmx6a3y7tbn0z5ihlkrfj704.htm" title="http://support.sas.com/documentation/cdl/en/hostunx/67929/HTML/default/viewer.htm#p108wmx6a3y7tbn0z5ihlkrfj704.htm">SAS(R) 9.4 Companion for UNIX Environments, Fifth Edition</A></P></BODY></HTML> Sun, 19 Jul 2015 22:25:42 GMT https://communities.sas.com/t5/SAS-Programming/Hello-If-sas-in-installed-on-windows-os-then-How-to-troubleshoot/m-p/206033#M306470 Patrick 2015-07-19T22:25:42Z Re: Hello, If sas in installed on windows os then How to troubleshoot or catch performance of sas DI jobs on unix? By using nmon? https://communities.sas.com/t5/SAS-Programming/Hello-If-sas-in-installed-on-windows-os-then-How-to-troubleshoot/m-p/206034#M306471 <HTML><HEAD></HEAD><BODY><P>Thank you</P></BODY></HTML> Mon, 20 Jul 2015 05:26:00 GMT https://communities.sas.com/t5/SAS-Programming/Hello-If-sas-in-installed-on-windows-os-then-How-to-troubleshoot/m-p/206034#M306471 vishu 2015-07-20T05:26:00Z