topic Re: SAS EBI tools are Slow in SAS Web Report Studio

SAS EBI tools are Slow

Venkat4 — Tue, 09 Aug 2016 15:25:00 GMT

Anyone here experiencing SAS EBI tools especially SAS BI Dashboard, WRS, STPs etc., are really slow. Here admin says they use JBOSS as mid-tier and web-tier also in there. I am not really familiar with all these. According to them, when the 9.4 upgrade happens it might be faster, just a hope.

Why SAS even develop these tools if it is dead slow in bringing in 10 rows and 2 columns visual via BI Dashboard? Some reports got 4-5 static and dynamic prompts, but even the one without prompts takes time.

Sometimes, it takes 5-10 minutes to see this small (10x2 table) info map based BI Dashboard. I am not sure if this is an issue with these SAS tools or issue on the JSP pages (?) on the browser side or web-tier side.

Can someone shed some lights? Thanks!

So far, I advised admins to look at:

1) Multi-threading on the web-tier

2) Increase memory on the web-tier

3) Enable caching on the web-tier

Re: SAS EBI tools are Slow

JuanS_OCS — Tue, 09 Aug 2016 15:34:20 GMT

Hi,

Update the platform to 9.4 will definetely increase your performance on the middle tier, secially if you update to SAS 9.4 M3.

Also, the increase of the Java Virtual Machines will increase your performance, specially if twhat is slow is the web application itself. http://support.sas.com/documentation/cdl/en/bimtag/65708/HTML/default/viewer.htm#p1tcuvmd2k2xlrn1bhpgiab5ecwm.htm

Another idea is to request a sizing from SAS. Maybe your requirement have increased and the sizing of the servers (physical or virtualised) have to be recalculated.

Re: SAS EBI tools are Slow

LinusH — Wed, 10 Aug 2016 11:19:36 GMT

My experience from one migration (9.2 -> 9.4) is that especially the dashborads got much faster.

A bit too late, since VA where shiping at the same time...