Working with ACM ETL

The ACM ETL process extracts and stores metric data that is collected by the SAS Environment Manager agents into the data mart. Storing the data in the data mart enables you to access the data for a longer period of time than if it was stored only in the SAS Environment Manager web application.
ACM data is processed and loaded into the data mart in these steps:
  1. Metric data is collected from the SAS Environment Manager agents and sent to the SAS Environment Manager database.
  2. At specified intervals, the ACM ETL process runs. The process copies data from the database, standardizes the data, and loads the data into the data mart.
  3. ACM data in the data mart is available for analysis and reporting.
The Report Center contains reports that are produced by ACM that display the following types of information:
  • response time for SAS HTTP web services
  • workload, CPU usage, and memory usage for each platform in your environment
  • usage and response information for file mounts
  • total number of clients per minute on the SAS Metadata Server machine