topic Re: Help in SAS server infrastructure in Administration and Deployment

Help in SAS server infrastructure

cijo_v — Tue, 17 May 2022 11:58:33 GMT

Hello All,

I need advice on how much CORES/RAM etc is needed for below dataset size:
1. Around 200 datasets
2. Field count approx 150 per dataset
3. Record count approx 200 million records per dataset
4. Users 10

It would be helpful if anyone can guide in sizing needed.

Re: Help in SAS server infrastructure

MargaretC — Tue, 17 May 2022 12:03:58 GMT

A lot more information is needed before we can advise you on how many cores will be needed.

I advise you to work with your SAS team to get a hardware estimate (i.e. Sizing) that will be based on not only the data file size, but how your 10 users will be using SAS.

Re: Help in SAS server infrastructure

cijo_v — Tue, 17 May 2022 12:10:03 GMT

@MargaretC,
Can you specify what other information is needed?
We have an infrastructure at present which seems too basic for our need.

10 users will most probably execute profiling in concurrent mode

We just need a approx sizing for budgeting

Re: Help in SAS server infrastructure

andreas_lds — Tue, 17 May 2022 13:04:39 GMT

Talk to SAS, they know best how much (virtual) hardware is required.

Re: Help in SAS server infrastructure

SASKiwi — Tue, 17 May 2022 23:38:36 GMT

Ask your SAS account manager to organise a SAS installation sizing estimate. They will send you a questionnaire containing the required information and once this is completed they will respond with a sizing estimate.

Re: Help in SAS server infrastructure

LinusH — Wed, 18 May 2022 08:48:23 GMT

To add:

- query/update patterns

- how frequently?

- concurrent users

- requirement on response/query timings

Re: Help in SAS server infrastructure

Sajid01 — Sat, 21 May 2022 20:09:42 GMT

The following paper has guideliness on initially sizing a SAS Installation.
https://support.sas.com/resources/papers/proceedings09/310-2009.pdf In addition the following link has useful resources https://platformadmin.com/blogs/paul/category/sas-software/sas-architecture/ .

A pieces of advice, based on the estimate of 10 users your install would not be big, try to keep it simple unless you have something very specific and are planning to hire a SAS Administrator (SAS programming and SAS adminsistration are related but distinct tasks). Linux as the server OS is my preferred choice.