05-26-2016 04:47 AM
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.
05-26-2016 05:51 AM
you might want to give a look into this, is great:
05-26-2016 05:59 AM
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?
05-29-2016 05:42 AM
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.
05-31-2016 12:31 PM
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
06-14-2016 11:09 AM - edited 06-14-2016 11:10 AM
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.