devlekhu_98 Tracker

Re: Join SAS Users Group for Administrators (SUGA)

devlekhu_98 — Mon, 14 Nov 2016 21:55:38 GMT

Thank you very much

Re: Join SAS Users Group for Administrators (SUGA)

devlekhu_98 — Mon, 14 Nov 2016 18:58:56 GMT

Would you please post here next webinar (SUGA) session details for Administrators? This is good place to have information for Administrators.

Thank you

Enterprise Guide 7.1 Same Query running differently for different users

devlekhu_98 — Thu, 22 Oct 2015 17:31:17 GMT

Hi Everyone,

I have little weird problem with SAS EG7.1 that exactly same query using same data takes takes more than an hour or sometime takes forever for one user and runs in 30 second for other users. It does open/import data taking same time though. Problem starts when query submitted. Data size is 1.8 million rows with 100 columns.

Our setup is Windows12-Virtual SAS servers (Metadata & SASApp) and 10 virtual-Desktop-users (EG7.1) submitting query/programs to SASApp server. All users have same setup on SAS_Management_Console and Active Directory.

Please reply with any idea why it's behaving differently for two different users, particularly only one user has this problem and rest 9-users are OK.

Thank you

Hitesh Bhatt

Re: Server performance slow down?

devlekhu_98 — Fri, 21 Aug 2015 15:32:01 GMT

Hi All,

Thank you very much for all your suggestions and support. I did install fresh SAS-Servers on New Windows2012R2 Servers and now even with 4-cores/16G RAM whole system works very fast and smooth.

Hitesh

Re: How to uninstall SAS/EG from servers SAS 9.3/EG5.1 after migrating to SAS 9.4 ?

devlekhu_98 — Thu, 23 Apr 2015 20:40:01 GMT

Hi SASKiwi,

That makes sense but when we asked SAS to prepare a plan file for migration, they have to let us know about these issues and recommend 3-server plan instead of just making up one!

We are suffering since 2-months with this issue. Even I was talking to SAS-tech support since last 2-3 weeks now and now they are also suggesting some serious systematic issue about sizing and asked me to contact SAS Account representative and EEC Sizing team!!

That's why I created this topic here to get insights/fine tuning solution from SAS Admin experts.

Thank you

Re: How to uninstall SAS/EG from servers SAS 9.3/EG5.1 after migrating to SAS 9.4 ?

devlekhu_98 — Thu, 23 Apr 2015 15:36:06 GMT

I found almost 10-12 SASV9.cfg & 10-12 SASV9_Usermods.cfg files (One each for SASApp, ShareServer,ConnectServer,StoredProcess,PooledWorkSpace etc.). In which file I need to make change or all files?

Re: How to Start SAS Environment Manager?

devlekhu_98 — Wed, 22 Apr 2015 18:59:45 GMT

It's already started as a windows services but I want to see dashboard like this.

How to Start SAS Environment Manager?

devlekhu_98 — Wed, 22 Apr 2015 18:31:11 GMT

On my Mid-tier VM-Server (Windows 2008 R2) services, I see only SAS Environment Manager (Can't see any agent here). I've tried to search windows-start-Sas-utilities folder & SAS support website, couldn't find the exact location and how to start. Is there any suggestion about how do I start (May be baby step for you!)? Do I need to install any EM-Agent to see the dashboard?

Re: How to uninstall SAS/EG from servers SAS 9.3/EG5.1 after migrating to SAS 9.4 ?

devlekhu_98 — Wed, 22 Apr 2015 16:56:23 GMT

SAS Technical support provided tuning guidelines and I followed some of those steps:

Component:tomcatThreadPool : set to 500

Component: Various JDBC Resouces :Set to 256

Componebt:Atomikos transaction manager : Set to 50 (Wasn't in a list so I added this line)

2. JVM Tuning (Web Application Server):

Single server -xms4096m, -xmx4096m, -xx : permSize:1280m, xx : MaxPermSize:1280m

3. Operating system tuning: It's under process

4. SAS Web infrastructure platform data server (We don't have any database server though) : Tuned for Medium Database setup

Usually it performs faster in the morning (Even with multiple users) slows down as day progresses and worse around end of the day..Next day again same issue.

Should I change any of those values?

Re: Server performance slow down?

devlekhu_98 — Wed, 22 Apr 2015 14:30:10 GMT

Is there any particular log or logs for all servers running on mid-tier? Any particular folder? My Lev1 folder has 12.1GB size (Most of them are "EAR Files" & in "Lev1\Web\Staging" directory), looks like you are right. Do I need to delete those old logs manually or is there any way we can limit number of logs? Do you have any idea about size of that folder?

Should I stop WebApp Server? Does it affect any SAS-Functionality? My observation is: When I start this server, it runs JAVA.EXE process and starts using lot's of CPUs.

Thanks

Re: Server performance slow down?

devlekhu_98 — Tue, 21 Apr 2015 21:51:15 GMT

Thanks I'll stop that and monitor performance. If you want to see logs please let me know the name of the server and I can provide you with log of respective server.

Thank you

Re: Server performance slow down?

devlekhu_98 — Tue, 21 Apr 2015 21:04:40 GMT

If I stop the Environment manager, is going to affect any functionality?

Re: How to uninstall SAS/EG from servers SAS 9.3/EG5.1 after migrating to SAS 9.4 ?

devlekhu_98 — Tue, 21 Apr 2015 15:15:58 GMT

Hi Kurt,

Previous installation had same number of users. Would you please provide more details/links about memsize setup?

Re: Server performance slow down?

devlekhu_98 — Tue, 21 Apr 2015 15:13:40 GMT

Hi SASKiwi,

We had old SAS 9.3 plan with only two servers (Meta & App). Time of migration I asked SAS to provide me with a plan file to migrate and they provided 2-servers plan. The didn't recommend additional server plan. My mid-tier has App & All mid-tiers. It runs with almost same 20-25%CPU use (Goes upto 80-95% with few jobs submissions) but with only 2-4GB RAM (Lower than yours).We are observing a weird pattern of slowing down as in the morning system runs faster even with 2-4 clients login but in afternoon it runs extremely slow (3 minute job takes almost 2-3 hours to run!). Our network team says something (Most likely JAVA processes) holds resources and releases them very slowly (After office hours & Night enough to release completely). I've couple of questions:

1. Can I stop this environment manager ? or Even SASWebApp Server ? What's minimum set/subset of servers/services I can run with? Do I need to run DIP Job runner/JMS Broker/SHARE/Cache locator/Deployment agent? I ask these question to SAS Tech-support but they said I need to run all!

2. Did you followed fine-tuning document from SAS?

3. What resources allocated to all 3-servers (CPUs/RAM) etc?

Thanks

Re: Server performance slow down?

devlekhu_98 — Mon, 20 Apr 2015 18:43:28 GMT

Hi Jaap,

The used OS is Windows 2008 R2 on both VM-servers. I've migrated system to 9.4 from 9.3 in January, 2015. We had 2-servers (Metadata & SASApp) in SAS9.3 system. The old system was running faster. We received a plan file (Metadata & Mid-tier with SASApp) to migrate the system and migrated successfully. SASApp servers are configured on Mid-tier server. I only have two VM Servers, 1. Metadata server 4-cpus, 16gb RAM and 1. Mid-tier/SASApp 4-CPUs, 32GB RAM.

Authentication is host-based.

The other two-topics (VM & network access), I don't have complete knowledge.

In all the system was working with old SAS9.3 system!

Re: How to uninstall SAS/EG from servers SAS 9.3/EG5.1 after migrating to SAS 9.4 ?

devlekhu_98 — Mon, 20 Apr 2015 15:57:17 GMT

Hi All,

Thank you very much for the reply. Yes, I did disable/Manual stop to all SAS 9.3 related services (Metadata/Object Spawner etc.) and I am OK with that. Do I need to remove EG 5.1 from SASApp-Mid-tier/Metadata server? How? Does it affect system in any way?

I only thought about removing old system (SAS9.3/EG5.1) because of having issues with performance of the servers. My system is running extremely slow with only 2-4 users at a time logged-in and running moderately large jobs.

Any advise on that?

How to uninstall SAS/EG from servers SAS 9.3/EG5.1 after migrating to SAS 9.4 ?

devlekhu_98 — Fri, 17 Apr 2015 19:00:12 GMT

I've migrated from SAS 9.3 to SAS 9.4 on Windows 2008 R2 servers and now want to remove/uninstall old SAS9.3 installation. I afraid that Deployment manager If I would remove some linked portion it would japerdize new system. I've searched SAS website for tips and tricks or list of files to keep, couldn't find. Please help me!

Server performance slow down?

devlekhu_98 — Fri, 17 Apr 2015 18:43:00 GMT

Hi There,

I've migrated our servers from SAS 9.3 (EG 5.1) to SAS 9.4 (EG 7.1) with 10-clients & two Virtual servers (VMWareVSphere): 1. Metadataserver (4-cpu, 16gb RAM) & 2. Mid-tier has Web infrastructure platform data/object spawner/share/connect/DIP Job runner/JMS Broker/Cache locator/WbAppServer &Environmanager server/services (8-CPU, 32 GB RAM). Migration was successful.

When clients (2-4 at the same time) try to run codes/query from EG7.1 or tries to connect the connection/run is extremely slow.

I've asked SAS Technical support and fine-tune all servers according to their suggestions & even fixed the networking issue with our IT, still we face sluggish connections.

Is there any suggestion/solution to this issue?

Re: Calculating Mode across variables..

devlekhu_98 — Wed, 02 Jul 2014 21:53:46 GMT

Hi Xia,

Thank you very much for providing the codes.

The code works but gives same value of mode selected (results) all the runs which may causes some bias. To eliminate this bias I want random selection in two different situations, which are:

1. If there are multiple modes (two or three), pick one mode value randomly

2. If there is no mode, pick one value randomly from available values in the columns

Your help is appreciated.

Hitesh