Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Cache Table Size

Reply
Occasional Contributor
Posts: 6

Cache Table Size

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

Trusted Advisor
Posts: 1,326

Re: Cache Table Size

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#p050lknh5xepngn1s2...

 

Enjoy!

Occasional Contributor
Posts: 6

Re: Cache Table Size

Posted in reply to JuanS_OCS

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

 

 

Trusted Advisor
Posts: 1,326

Re: Cache Table Size

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

Regular Contributor
Posts: 183

Re: Cache Table Size

Posted in reply to JuanS_OCS

Its works fine for me on VA 7.1

Thinks Juan for the tip.

Greetings

Trusted Advisor
Posts: 1,326

Re: Cache Table Size

Posted in reply to PeterWijers

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.

Occasional Contributor
Posts: 6

Re: Cache Table Size

Posted in reply to PeterWijers

Peter - would you mind sharing your code with us?

 

Thanks.

Regular Contributor
Posts: 183

Re: Cache Table Size

Shure, no problem.

Greetings

31-05-2016 18-11-33.png

Occasional Contributor
Posts: 6

Re: Cache Table Size

Posted in reply to PeterWijers

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

Regular Contributor
Posts: 183

Re: Cache Table Size

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

Occasional Contributor
Posts: 6

Re: Cache Table Size

Posted in reply to PeterWijers
Hi Peter

Did you manage to check and test?

THanks

Nelson
Contributor
Posts: 26

Re: Cache Table Size

[ Edited ]

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

Ask a Question
Discussion stats
  • 11 replies
  • 679 views
  • 4 likes
  • 4 in conversation