BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Hi

 

I am wanting to create a report which will show how much space is used by a LASR library plus the limit allocated to it (if it has a limit imposed).  I have successfully found the amount used by the tables in the dataset _T_LASRMEMORY but I am also wanting to show what the limit is, so we can see what capacity is left.  Neither the _T_LASRMEMORY or _T_TABLEMEMORY tables show the limit.

 

I know you can see the limit in VA Administrator via the LASR Servers Administrator tab and the Tables Limit column, plus also via Management Console in the extended attributes VA.MaxTotalMemoryForTables but how can I get this programatically?  I know I could maintain the value in a table, but I'd rather I didn't have that maintenance to worry about when the limit is changed.

 

Alternatively, if I could get a report saying the capacity has been reached that would be sufficient.  The status shows if over capacity in VA Adminstrator but I'm unsure how to get this status myself.  I am using the macro %LASRSERVERRUNNING to see if a LASR server is started or stopped but it doesn't include over capacity.

 

thanks

Tammy

1 ACCEPTED SOLUTION

Accepted Solutions
alexal
SAS Employee

@tammy_dezilva,

 

The easiest way is to read the value of maxTotalTableMemory from server object through REST API. First of all, you have to find server ID here (for an example A5MTT44D_AZ00000F):

 

http://<MIDDLE_TIER_URL>/SASLASRAuthorization/rest/servers
<server port="10011" name="LASR Analytic Server" id="A5MTT44D_AZ00000F" hostname="test.unx.sas.com" description="SAS LASR Analytic server and the machine to which it is associated.">
<links>
<link uri="/servers/A5MTT44D_AZ00000F" rel="self" method="GET" href="http://test.unx.sas.com:7980/SASLASRAuthorization/rest/servers/A5MTT44D_AZ00000F"/>
</links>

 

Then, get information about the server:

 

http://<MIDDLE_TIER_URL>/SASLASRAuthorization/rest/servers/A5MTT44D_AZ00000F
<server port="10011" name="LASR Analytic Server" maxTotalTableMemory="-1" id="A5MTT44D_AZ00000F" hostname="test.unx.sas.com" description="SAS LASR Analytic server and the machine to which it is associated.">

-1 means no limit.

View solution in original post

4 REPLIES 4
alexal
SAS Employee

@tammy_dezilva,

 

The easiest way is to read the value of maxTotalTableMemory from server object through REST API. First of all, you have to find server ID here (for an example A5MTT44D_AZ00000F):

 

http://<MIDDLE_TIER_URL>/SASLASRAuthorization/rest/servers
<server port="10011" name="LASR Analytic Server" id="A5MTT44D_AZ00000F" hostname="test.unx.sas.com" description="SAS LASR Analytic server and the machine to which it is associated.">
<links>
<link uri="/servers/A5MTT44D_AZ00000F" rel="self" method="GET" href="http://test.unx.sas.com:7980/SASLASRAuthorization/rest/servers/A5MTT44D_AZ00000F"/>
</links>

 

Then, get information about the server:

 

http://<MIDDLE_TIER_URL>/SASLASRAuthorization/rest/servers/A5MTT44D_AZ00000F
<server port="10011" name="LASR Analytic Server" maxTotalTableMemory="-1" id="A5MTT44D_AZ00000F" hostname="test.unx.sas.com" description="SAS LASR Analytic server and the machine to which it is associated.">

-1 means no limit.

tammy_dezilva
Quartz | Level 8

Awesome, thank you so much @alexal.  That's working a treat now!

 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 1344 views
  • 1 like
  • 3 in conversation