Hello @sasprofile ,
excellent questions, all of them. I will try to answer them below, but I will need some information as well.
Your questions:
Exploiting largest data set: this relates to schema if you have any.
# Concurrent sessions: in SAS 9.4 you can analyse this with SAS Environment Manager, Resources, SASServer12_1, Application Management, View, then you will see how many sessions are being used per application: the Builder, the ReportViewer, Explorer, etc. In SAS Viya it will be even easier. I suggest to look at different times, to get an average, and your peaks. SAS Visual Analytics Administration Reports can give you this information as well.
Largest data size: find your largest dataset in VA Administrator LAST Tables.
Total size of the data that will be loaded onto the disk Data on Disk: Total size of data that will be lifted into the memory Data lifted to memory:
The size of a dataset in memory and on disk are not necessarily the same. It depends if you upload compressed or uncompressed, the encoding of your LASR/CAS session vs the encoding of the dataset on disk, and it depends on the queries over the dataset (SAS reserves memory for the dataset based on its usage/queries).
I would suggest to run the memory usage reports https://documentation.sas.com/?cdcId=bicdc&cdcVersion=9.4&docsetId=inmsref&docsetTarget=p050lknh5xepngn1s2kaa5nijrer.htm&locale=en and compare them with your proc contents data=your_library._all_;run;
My questions:
I understand you already have SAS VA and you need to upgrade it.
What version of SAS VA do you have? To what version are you upgrading, and why?
Mind the fact that if you upgrade to SAS Viya (SAS VA 8.x), the new CAS engine works internally with UTF-8 encoding, this means that your data has got good chances to be significantly larger, depending on the characters including in your datasets.
https://stackoverflow.com/questions/44565859/how-does-utf-8-encoding-identify-single-byte-and-double-byte-characters
... View more