topic Re: Cache Table Size in SAS Visual Analytics

Cache Table Size

yapne — Thu, 26 May 2016 08:47:54 GMT

Hi,

I am wondering if it is possible to write SAS Code to query the size of the table cache instead of manually clicking on the tables in the VA Administrator LASR Table tab? If yes kindly please share the code. We are on 7.1 version of SAS VA.

Thanks

Nelson

Re: Cache Table Size

JuanS_OCS — Thu, 26 May 2016 09:51:14 GMT

Hi Nelson,

you might want to give a look into this, is great:

http://support.sas.com/documentation/cdl/en/inmsref/68736/HTML/default/viewer.htm#p050lknh5xepngn1s2kaa5nijrer.htm

Enjoy!

Re: Cache Table Size

yapne — Thu, 26 May 2016 09:59:52 GMT

Hi,

I tried the code example but it is complaining _T_LASRMEMORY and _T_TABLEMEMORY do not exist. Maybe the version of the LASR server in SAS VA 7.1 is pre LASR 2.5 version. Is there a way to find out the version of the LASR for VA 7.1?

THanks,

Nelson

Re: Cache Table Size

JuanS_OCS — Fri, 27 May 2016 20:19:40 GMT

I cannot answer that question sorry. Maybe this is avalable only on the updated version of LASR and SAS VA.

Re: Cache Table Size

PeterWijers — Sun, 29 May 2016 06:13:46 GMT

Its works fine for me on VA 7.1

Thinks Juan for the tip.

Greetings

Re: Cache Table Size

JuanS_OCS — Sun, 29 May 2016 09:42:12 GMT

You are welcome Peter, glad to know you have it working. Thanks!

@yapne, maybe you will need to review your implementation, or check if you need to install hotfixes.

If none of those work for you, I would suggest to contact SAS Technical Support.

Re: Cache Table Size

yapne — Tue, 31 May 2016 16:02:10 GMT

Peter - would you mind sharing your code with us?

Thanks.

Re: Cache Table Size

PeterWijers — Tue, 31 May 2016 16:14:12 GMT

Shure, no problem.

Greetings

Re: Cache Table Size

yapne — Tue, 31 May 2016 16:23:03 GMT

Thanks. I have tried your code and it didn't work either. I suspected it is because we are running on a distributed server mode?

Regards,

Nelson

Re: Cache Table Size

PeterWijers — Tue, 31 May 2016 16:31:09 GMT

He Nelson,

While reading the web item, its shows that the distributed script is a little different.

I will check out soon with a friend who has a distributed version, I will test it there.

Greetings and good luck

Re: Cache Table Size

yapne — Tue, 14 Jun 2016 13:28:51 GMT

Hi Peter

Did you manage to check and test?

THanks

Nelson

Re: Cache Table Size

RichardPaterson — Tue, 14 Jun 2016 15:10:00 GMT

If I am not mistaken the code for both a distributed and a non-distributed server is the same.

The only difference is in the results. For a distributed you get a record per distributed node. If you group these records as suggested in the documentation you will get the total memory usage. I am using this code now on my current project. As Juan stated this is a very interesting topic, especially when you start digging into data stored in HDFS and mapped to LASR. Some cool stuff here.

Richard