This SAS Note is part of a series of SAS Notes about diagnosing and resolving issues with SAS Micro Analytic Service on SAS Viya 3.5 and SAS Viya. For additional information, see the related SAS Notes below:

• SAS Note 70240, “General questions about diagnosing and resolving issues with SAS® Micro Analytic Service (MAS) on SAS® Viya® 3.5 and SAS® Viya®”
• SAS Note 70241, “Using logging to diagnose and resolve issues with SAS® Micro Analytic Service (MAS) on SAS® Viya® 3.5 and SAS® Viya®”
• SAS Note 70229, “Database considerations for diagnosing and resolving issues with SAS® Micro Analytic Service on SAS® Viya® 3.5 and SAS® Viya®”

Performance Tuning

The tunings in the following “Eventing and Authorization” sections of the Programming and Administration Guide are critical for any environment that is expected to perform:

• SAS Viya 3.5 SAS Micro Analytic Service Tuning Guidelines
• SAS Viya SAS Micro Analytic Service Tuning Guidelines

Approaches to Performance Issues

One approach to diagnosing performance issues (which is explained in SAS Note 70241) is to look at the logs and analyze where time is being spent. However, it is sometimes quicker to simplify the problematic module to identify the cause of the performance issue.

For example, in the following scenario, a module accesses a database and performs slowly. One diagnostic approach is to create a modified module that contains a hardcoded result instead of a call to the database for a result. If the modified module performs better than the original, look into the performance between MAS and the database. (For more information, see SAS Note 70229.)

Note: If the performance of the modified module and the original module are similar, then the database issue is not likely related to the slow performance.

If there are other external resources that the module interacts with, try to isolate them and determine whether the performance issue is in one of those external calls.

Performance Issues with Modules Published to MAS from SAS® Intelligent Decisioning

Modules that are published to MAS from SAS Intelligent Decisioning can generate additional performance-related logging through the App.tk.SID.Perf logger, as detailed in the following documentation:

• SAS Viya 3.5 Enabling Performance Logging
• SAS Viya Enabling Performance Logging

Operating System and Release Information