ESM and S9CA: Useful Tools for Migration from SAS 9 to SAS Viya

Change is hard and can be a bit scary. We tend to resist change as we get comfortable with our routines and how things work. However, many times we fail to see the benefits of that something new. Imagine if we didn't move from MS DOS to Windows? If we'd chose beta over VHS? If we still drove station wagons instead of SUVs? I could go on, but I think you get the point. Change is many times beneficial and necessary, even if it's different.

So, this brings me to the topic of migrating from SAS 9 to SAS Viya. Much has been written on the benefits of SAS Viya, so I'll not cover that here. What I do plan to pass along is that SAS has created many helpful tools to ease the migration. I'll cover two of these tools in detail: the Enterprise Session Monitor and SAS 9 Content Assessment.

Enterprise Session Monitor (ESM) and SAS 9 Content Assessment (S9CA) are part of the Ecosystem Diagnostics Family providing glass view into your SAS Environment.

Key features of ESM include maximizing resource utilization, substantially increasing your effective operating capacity through advanced batch schedule optimization, performance tuning, and enabling cooperative resource sharing. Moreover, S9CA is a collection of applications designed to help you understand your SAS 9.4 deployment and content, gather and prepare SAS 9.4 content for migration, and import SAS 9.4 content.

ESM and S9CA work together offering a complete picture of your SAS Environment, but can also work independently. ESM provides capacity planning information which helps in the sizing of SAS environments. The SAS 9 Content Assessment provides information on the types of artifacts in your SAS Environment. Together, ESM and S9CA provide information on how to successfully migrate from SAS 9.4 to SAS Viya.

Let's explore some of the features of each tool.

Reports

ESM

ESM provides the following information:

Number of Distinct SAS Users

SAS Users consuming resources

Capacity Report – CPU. Memory, I/O and sessions

Sizing Reports

Reports for proactive migration of jobs and users to SAS Viya

SAS Jobs being executed

Real-time workload identification

Self-service administration

S9CA

S9CA provides the following information:

Counts and collects data about what exists on the SAS 9 system

Granular details about selected artifacts

Validates code will migrate to SAS Viya

Finds internationalization issues in SAS programs

Prepares results for reporting

Summaries SAS 9 logs steps to analyze SAS Code for optimization

Counts the number of users for SAS application on SAS Workspace Servers

Analyzes SAS 9.4 system and configuration details to identify known deployment issues.

How it works

ESM

A prerequisite for ESM installation and configuration is an ESM server and agent. The agents connect to the server. There are various tools like proc-mon to collect the data. The ESM server receives events from the ESM agents at a rate of every two seconds. The impact to the servers with ESM agents is less than 20 percent of one CPU. The ESM agent's data is stored in a Postgres database for historical reporting. The ESM Maintenance Utility is installed and used to extract data from the agents.

S9CA

There are many applications that make up the SAS Content Assessment Tool. For example, the inventory application counts SAS artifacts defined to the SAS Metadata Server, SAS Mid-tier and the file system. The profile application provides more granular details for the SAS artifacts i.e., Enterprise Guide Projects, Enterprise Miner, Stored Processes etc. After each application runs via the command line, the published application creates an aggregated data mart for reporting. After each application runs, the published application is used to create an aggregated data mart for reporting. By default, Personal Identifiable Information (PII) data is obfuscated when the publish application runs, so this information is protected.

Timeline

ESM

Customer and SAS Activities | Time Commitment | Notes
Install/Config | 4 hours/per environment | If SAS resource is involved.
ESM Extraction | After 7 days/1 hour | After 90 days/1 hour

S9CA

Customer and SAS Activities | Time Commitment | Notes
Install/Config | 1 hour/per environment | Ensure to get the latest version of the software
Execute each application | Time depends on Data being scanned |

Data Collection

ESM

ESM collects data on these SAS platforms

SAS x

SAS Viya 3

SAS Viya 4

S9CA

SAS artifacts scanned by S9CA

SAS code

SAS Stored Process

SAS Enterprise Guide

SAS Enterprise Miner

SAS Catalogs

SAS Object Spawner

SAS Workspace Server

SAS Metadata Server

Number of SAS data sets

As mentioned earlier, they can work independently, but they are better together. Together, ESM and S9CA assist with knowing the state of your SAS Environment and make the migration process to SAS Viya from SAS 9.4 straightforward.

ESM and S9CA: Useful Tools for Migration from SAS 9 to SAS Viya was published on SAS Users.