Amadeus cookies policy - you'll see this message only once.

Amadeus use cookies on this website. They help us to know a little bit about you and how you use our website, which improves the browsing experience and marketing - both for you and for others. They are stored locally on your computer or mobile device. To accept cookies, continue browsing as normal. Or, go to the privacy policy for more information.

Visual Analytics: LASR Memory Utilisation & Table Reporting

Introduction

If you are familiar with the Administrator section of Visual Analytics, this is the typical place to determine how much memory is being utilised by each Visual Analytics LASR server. From here, we can also view the details of each table loaded to LASR.

This information can be key to ensuring that your Visual Analytics/SAS Middle-Tier environment remains performant by:

  • Ensuring each individual LASR table remains within the recommended memory sizing boundaries of your Visual Analytics environment

  • Ensuring the total memory utilised by all tables loaded into Visual Analytics remains within the recommended sizing boundaries of your Visual Analytics environment.

As useful as this information is, it requires a degree of discipline and routine to ensure it is regularly checked. There is an alternative way to harness this information through SAS programs, opening the possibilities of how this information can be consumed.

Preparing to Query Visual Analytics LASR

You will require access to a SAS application which can connect to the server context associated with your Visual Analytics environment. In this example, we will be using SAS Enterprise Guide and connecting to the SASApp server context:

LASR Memory Utilisation Image 1

N.B. The server context associated with Visual Analytics is dependent upon your SAS platform configuration. For example, if you have a server context named SASAppVA, this is likely to be the server context you will need to connect to.

Once you have determined the server context to connect to:

  1. Open Enterprise Guide and connect to your SAS environment

  2. Connect to the server context by expanding it in the Servers pane (as demonstrated in the above screenshot)

  3. In Enterprise Guide, Click File, New and Program

LASR Memory Utilisation (_t_lasrmemory dataset)

Now that a connection to SAS® Visual Analytics libraries has been established, the LASR memory utilisation can be queried, in the form of the _t_lasrmemory dataset. This dataset is dynamically created each time it is queried, ensuring the results it outputs remain current:

  • In the Servers pane where the server context was expanded, expand Libraries and locate a Visual Analytics LASR library that you wish to report:

LASR Memory Utilisation Image 2

  • Right-click on the LASR library you would like to query and click Properties:

LASR Memory Utilisation Image 3

In our example, we are connecting to the public LASR library. Use the above details to form a libname statement in your program.

  • In your new program window, enter the libname, data and proc statements:

LASR Memory Utilisation Image 4

Results

Submitting the above program produces the following results:

LASR Memory Utilisation Image 5

Below are the descriptions for the key columns:

LASR Memory Utilisation Image 6

Querying LASR Table Detail (_t_tablememory dataset)

Retaining the same libname statement from the previous example, _t_tablememory dataset can be generated to return detail on the LASR tables loaded across all LASR servers. As per the _t_lasrmemory dataset, this dataset is dynamically created each time it is queried, ensuring the results it outputs remain current:

LASR Memory Utilisation Image 7

Results

Submitting the above program produces the following results:

LASR Memory Utilisation Image 8

LASR Memory Utilisation Image 9

N.B. The above results have been split over two outputs.

Below are descriptions for the key columns:

LASR Memory Utilisation Image 10

Harnessing the Data

As you can see, the information returned by the two datasets are very useful, but much the same as what is presented in the Administration section of Visual Analytics.

Some benefits of harnessing the data in this method are as follows:

  • Schedule the programs to run across many SAS applications
  • Visualise the data in the form of reports or dashboards (such as SAS Visual Analytics, SAS Web Report Studio or SAS BI Dashboards)
  • Use the programs to drive email alerts/KPI visual indicators, should sizing limits breach.