How to retrieve information about memory utilization on the LASR server?

1 Like

Question

Answer

Now you know how to get the list of LASR servers, but what about memory utilization? Is there is a way to get information about that programmatically? The answer is yes. Here is an example of a SAS program that you can use to retrieve memory utilization from the LASR server. Do not forget to change LASR_PORT, LASR_HEAD_NODE_FQDN, and MIDDLE_TIER_URL.

LIBNAME LASRLIB SASIOLA TAG=VAPUBLIC  PORT=LASR_PORT HOST="LASR_HEAD_NODE_FQDN"  SIGNER="http://MIDDLE_TIER_URL/SASLASRAuthorization" ;

%let sizecols = InMemorySize UncompressedSize 
                CompressedSize TableAllocatedMemory
                InMemoryMappedSize ChildSMPTableMemory
                VirtualMemory ResidentMemory AllocatedMemory;
%let countcols = NumberRecords UseCount RecordLength ComputedColLength;

data tablemem;
    set lasrlib._T_TABLEMEMORY;
run;

data lasrmem;
	set lasrlib._T_LASRMEMORY;
run;

proc print data=lasrmem;
    title "LASR Server Memory Usage";
    format &sizecols.  sizekmg9.2;
    format &countcols. 8.;
    sum _numeric_;
run;

proc print data=tablemem;
    title "LASR Server Table Memory Usage";
    format &sizecols.  sizekmg9.2;
    format &countcols. 8.;
    sum _numeric_;
run;

More information about memory management in the LASR server is available here.