Working with APM ETL

The APM ETL process extracts performance metric information from various SAS server logs. After the information is extracted, it is loaded into the SAS Environment Manager Data Mart. As with other information in the data mart, you can use this information to produce predefined reports or to conduct custom analysis and reporting.
APM extracts the data from the SAS logs only when the logs roll over at midnight, so the metric data and the reports display forensic or historical data. It provides a look back at how things have been running, rather than a real-time look at how things are currently running. Reports that are produced by APM display the following kinds of information:
  • the most heavily used SAS procedures
  • the top ten users of the SAS Workspace Server
  • the number of times per day each user ID has accessed the SAS Metadata Server
  • each instance of an authentication error or of an unauthorized login attempt
  • The response time and run time for SAS stored processes
Note: Enabling the APM ETL process causes a separate log to be created for each spawned SAS Workspace Server. You must plan for the large number of log files that this process creates. A best practice is to create a daily archive file of the day’s log files, and then to copy the file to archive storage.
Last updated: February 22, 2018