topic Re: SAS Visual Analytics Memory Issue in SAS Visual Analytics

SAS Visual Analytics Memory Issue

sandeep_reddy — Thu, 12 Oct 2017 03:37:49 GMT

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

Re: SAS Visual Analytics Memory Issue

SASKiwi — Thu, 12 Oct 2017 04:26:34 GMT

@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.

Re: SAS Visual Analytics Memory Issue

sandeep_reddy — Thu, 12 Oct 2017 05:18:16 GMT

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;

Re: SAS Visual Analytics Memory Issue

alexal — Thu, 12 Oct 2017 10:58:30 GMT

@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.