SAS Visual Analytics Memory Issue

[sandeep_reddy]

Hi All,

Today i have observed a different issue in SAS Visual Analytics. I have unloaded all the tables from Public LASR Analytics Library and for a check from  SAS VA Administration - LASR Servers ,the memory occupied is "0 MB".  

But when i ran through the query from SAS EG to check the table memory ,still it is showing as "80 GB". Every time to resolve this issue i am doing a restart of physical server. 

Then all the memory tables are  getting cleared . Please let me know if there is any way to rectify this issue if i unload a table that should also be cleared from memory.

Thanks & Regards,

Sandeep

[SASKiwi]

@sandeep_reddy - "But when i ran through the query from SAS EG to check the table memory ,still it is showing as "80 GB". "

Please post the query that reports this.

[sandeep_reddy]

Hi There, i am using below query to check .
libname lamem sasiola host="server name" port=10031;



/* Alternatively, use the PRINT procedure */
data lasrmemory;
set lamem._T_LASRMEMORY;
run;

proc print data=lasrmemory;
title "Non-distributed Server Memory Use";
format _numeric_ sizekmg9.2;
run;

[alexal]

@sandeep_reddy,

I assume that you are loading data to the LASR server somewhere outside of SAS Visual Analytics. If my assumption is correct, after successful load you have to create the metadata entry for a table that was loaded into the memory. You can do that by using macro below:

/* Register Table Macro */
%macro registertable( REPOSITORY=Foundation, REPOSID=, LIBRARY=, TABLE=, FOLDER=, TABLEID=, PREFIX= );

/* Mask special characters */

%let REPOSITORY=%superq(REPOSITORY);
%let LIBRARY   =%superq(LIBRARY);
%let FOLDER    =%superq(FOLDER);
%let TABLE     =%superq(TABLE);

%let REPOSARG=%str(REPNAME="&REPOSITORY.");
%if ("&REPOSID." ne "") %THEN %LET REPOSARG=%str(REPID="&REPOSID.");

%if ("&TABLEID." ne "") %THEN %LET SELECTOBJ=%str(&TABLEID.);
%else                         %LET SELECTOBJ=&TABLE.;

%if ("&FOLDER." ne "") %THEN
   %PUT INFO: Registering &FOLDER./&SELECTOBJ. to &LIBRARY. library.;
%else
   %PUT INFO: Registering &SELECTOBJ. to &LIBRARY. library.;

proc metalib;
   omr (
      library="&LIBRARY."
      %str(&REPOSARG.)
       );
   %if ("&TABLEID." eq "") %THEN %DO;
      %if ("&FOLDER." ne "") %THEN %DO;
         folder="&FOLDER.";
      %end;
   %end;
   %if ("&PREFIX." ne "") %THEN %DO;
      prefix="&PREFIX.";
   %end;
   select ("&SELECTOBJ.");
run;
quit;

%mend;

How to use it?

%registerTable(
  LIBRARY=%nrstr(/Shared Data/SAS Visual Analytics/Public/Visual Analytics Public LASR)
 , REPOSITORY=%nrstr(Foundation)
 , TABLE=%nrstr(<TABLE_NAME>)
 , FOLDER=%nrstr(/Shared Data/SAS Visual Analytics/Public/LASR)
);

_T_LASRMEMORY shows what you have in the memory. SAS Visual Analytics Administrator checks if any entries exist in the metadata, then gets their size information.