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

SAS Visual Analytics Memory Issue

Reply
Contributor
Posts: 63

SAS Visual Analytics Memory Issue

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

Super User
Posts: 4,030

Re: SAS Visual Analytics Memory Issue

Posted in reply to sandeep_reddy

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

Contributor
Posts: 63

Re: SAS Visual Analytics Memory Issue

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;
SAS Super FREQ
Posts: 560

Re: SAS Visual Analytics Memory Issue

Posted in reply to sandeep_reddy

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

Ask a Question
Discussion stats
  • 3 replies
  • 176 views
  • 0 likes
  • 3 in conversation