Data Model Adapter and Domain Category Specifications

BMC Perf Mgr Adapter - BMC Perf Mgr Domain Category

About the BMC Perf Mgr Adapter - BMC Perf Mgr Domain Category

The domain categories for this adapter use the server activity strategy for the staging and aggregating of data. A SAS IT Resource Management staging transformation is used in staging the data.
The staged tables for this adapter are input to a series of aggregation jobs that create aggregation tables across a spectrum of daily, weekly, monthly, and sub-hourly time periods. Hourly and shift-based activity is included in a number of these aggregation tables. Filters that query the CPU instance are used to divide aggregation tables that contain global CPU measurements from those that contain individual CPU processor measurements.

Focus of Report-Ready Data for the BMC Perf Mgr Adapter

Report-ready data for this adapter focuses primarily on the following areas:
  • utilization of CPU, memory, queuing, cache, paging, and swapping on the global server level
  • utilization of CPU for individual CPU processors
  • utilization, response times, transfer rates, and wait and queuing for physical disks
  • utilization of space for file systems
  • packet and data volume transfer activity, utilization, and queuing for network interfaces

DT Perf Sentry Adapter - DT Perf Sentry Server-Based Domain Categories

About the DT Perf Sentry Adapter - DT Perf Sentry Server-Based Domain Categories

The domain categories for this adapter represent a subset of data collected by Performance Sentry software that is available from Demand Technology Software. They focus on server-level activity and performance on the Windows platform. These adapter and domain category combinations use the server activity strategy for the staging and aggregating of data. A SAS IT Resource Management staging transformation is used in staging the data.
The staged tables for this adapter are input to a series of aggregation jobs that create aggregation tables across a spectrum of daily, weekly, monthly, and sub-hourly time periods. Hourly and shift-based activity is included in a number of these aggregation tables.

Focus of Report-Ready Data for the DT Perf Sentry Adapter - DT Perf Sentry Server-Based Domain Categories

Report-ready data for these adapter and domain combinations focuses primarily on the following areas:
  • utilization of CPU, memory, queuing, cache, and paging on the global server level
  • utilization of CPU for individual CPU processors
  • utilization, response times, transfer rates, and wait and queuing for logical and physical disks
  • packet and data volume transfer activity, utilization, and queuing for network interfaces

DT Perf Sentry Adapter - DT Perf Sentry Exchange Domain Category

About the DT Perf Sentry Adapter - DT Perf Sentry Exchange Domain Category

The domain categories for this adapter represents a subset of data that is collected by Performance Sentry software, which focuses on Microsoft Exchange server activity and performance on the Windows platform. This adapter and domain category combination uses the server activity strategy for the staging and aggregating of data. A SAS IT Resource Management staging transformation is used in staging the data.
The staged tables for this adapter are input to a series of aggregation jobs that create aggregation tables across a spectrum of daily, weekly, monthly, and sub-hourly time periods. Hourly and shift-based activity is included in a number of these aggregation tables.

Focus of Report-Ready Data for the DT Perf Sentry Adapter - DT Perf Sentry Exchange Domain Category

Report-ready data for this adapter and domain combination focuses primarily on the following areas:
  • Remote Procedure Call (RPC) response times, transfer rates, and request and operation rates at the global Exchange server level
  • total and active user counts at the global Exchange server level
  • virtual memory utilization at the global Exchange server level
  • delivered, sent, and submitted messages and receive and send queue lengths for mailboxes and public and private information stores
  • message rates, data transfer rates, and queue lengths for Exchange mail servers

HP Perf Agent and HP Reporter Adapters

About the HP Perf Agent and HP Reporter Adapters

The domain categories for the HP Perf Agent and HP Reporter adapters focus on server level activity and performance on the UNIX and Windows platforms. Recent changes were made to data collection by HP Perf Agent and HP Reporter. As a result, it is possible to monitor the performance of logical systems that are configured as virtual guests of host servers. These adapters provide some support of the new technology of virtualization. Operating environments that are currently supported for virtualization are HP Virtual machines, AIX LPARs, and VMWARE ESX guests on Linux. These adapters use the server activity strategy for the staging and aggregating of data. A SAS IT Resource Management staging transformation is used in staging the data.
The staged tables for this adapter are input to a series of aggregation jobs that create aggregation tables across a spectrum of daily, weekly, monthly, and sub-hourly time periods. Hourly and shift-based activity is included in a number of these aggregation tables. Filters that query the operating system are used to divide aggregation tables that contain UNIX platform performance measurements from those that contain Windows platform performance measurements.

Focus of Report-Ready Data for the HP Perf Agent and HP Reporter Adapters

Report-ready data for these adapters focuses primarily on the following areas:
  • utilization of CPU, memory, queuing, paging, swap, disk, and network on the global server level
  • utilization of CPU for individual CPU processors
  • utilization, response times, transfer rates, and wait and queuing for physical disks
  • packet and data volume transfer activity, utilization, queuing, and error rates for network interfaces
  • utilization of CPU and memory for logical systems to determine the share of resource utilization for the virtual guests associated with host servers

MS System Center Operations Manager - MS SCOM Server-Based Domain Categories

About the MS System Center Operations Manager - MS SCOM Server-Based Domain Categories

The domain categories for this adapter represent a subset of data collected by a Microsoft product called System Center Operations Manager. They focus on server-level activity and performance on the Windows platform. These adapter and domain category combinations use the server activity strategy for the staging and aggregating of data. A SAS IT Resource Management staging transformation is used in staging the data.
The staged tables for this adapter are input to a series of aggregation jobs that create aggregation tables across a spectrum of daily, weekly, monthly, and sub-hourly time periods. Hourly and shift-based activity is included in a number of these aggregation tables.

Focus of Report-Ready Data for the MS SCOM Adapter - MS SCOM Server-Based Domain Categories

Report-ready data for this adapter and domain combination focuses primarily on the following areas:
  • utilization of CPU and memory the global server level
  • utilization, response times, transfer rates, and wait and queuing for logical and physical disks

SAPR3 Adapter - Systems, Machines, Tasks, and Transactions

About the SAPR3 Adapter - Systems, Machines, Tasks, and Transactions Domains

SAP R/3 performance data is collected by using the SAS IT Management Adapter for SAP in conjunction with SAS/ACCESS to SAP R/3 software. This adapter and domain category combination uses the event hourly summarization strategy for the staging and aggregating of data. A SAS IT Resource Management staging transformation is used in staging the data.
These staged tables are input to a series of aggregation jobs that create aggregation tables across a spectrum of daily, weekly, and monthly time periods. Hourly activity is included in a number of these aggregation tables. (There are no sub-hourly aggregation tables for this domain category due to the staged data being pre-summarized to the hourly level.) There are groups of aggregation tables that are created for each of the staged tables in the previous table. Filters that query the transaction code are used to exclude blank transaction codes from the system-transaction aggregation tables.

Focus of Report-Ready Data for the SAPR3 Adapter - Systems, Machines, Tasks, and Transactions Domain Categories

Report-ready data for these adapter and domain combinations focuses primarily on the following areas for various groups of classifications:
  • event, task type, and transaction counts
  • total and average values for CPU, database, elapsed, response, processing, overhead, wait, and RFC times
  • total and average values for database requests and physical database accesses and changes
  • total and average values for kilobytes of data transferred
  • request counts and time expended for Sequential Reads, Direct Reads, Update, Insert, and Delete operations
  • counts of physical records read, updated, inserted, and deleted
  • lock counts

SAPR3 Adapter - SAPBTCH (Batch Job) and SAPWKLD (Workload)

About the SAPR3 Adapter - SAPBTCH (Batch Job) and SAPWKLD (Workload) Domains

SAP R/3 performance data is collected by using the SAS IT Resource Management Adapter for SAP in conjunction with SAS/ACCESS to SAP R/3 software. This adapter and domain categories combination uses the event activity strategy for the staging and aggregating of data. A SAS IT Resource Management staging transformation is used in staging the data.
These staged tables are input to a series of aggregation jobs that create aggregation tables for daily, weekly, and monthly time periods. (At this time, there is no hourly, sub-hourly, or shift-based activity in these aggregations.) There are several groups of aggregation tables that are created for each of the staged tables that are listed in the previous table. Filters that query transaction code are used to exclude blank transaction codes from the workload-related aggregation tables that focus on transaction activity.

Focus of Report-Ready Data for the SAPR3 Adapter - SAPBTCH and SAPWKLD Domain Categories

Report-ready data for these adapter and domain combinations focuses primarily on the following areas for various groups of classifications:
  • event, job, and transaction counts
  • total and average values for CPU, database, elapsed, response, processing, overhead, wait, and RFC times
  • total and average values for database requests and physical database accesses and changes
  • total and average values for kilobytes of data transferred
  • request counts and time expended for Sequential Reads, Direct Reads, Update, Insert, and Delete operations
  • counts of physical records read, updated, inserted, and deleted
  • lock counts

SAR Adapter - SAR Domain Category

About the SAR Adapter - SAR Domain Category

This domain category represents a subset of data collected by the System Activity Reporter (SAR) utility on various UNIX environments and focuses on server level activity and performance on the UNIX platform. This adapter and domain category combination uses the server activity strategy for the staging and aggregating of data. A SAS IT Resource Management staging transformation is used in staging the data.
The staged tables for this adapter are input to a series of aggregation jobs that create aggregation tables across a spectrum of daily, weekly, monthly, and sub-hourly time periods. Hourly and shift-based activity is included in a number of these aggregation tables.

Focus of Report-Ready Data for the SAR Adapter

Report-ready data for this adapter focuses primarily on the following areas:
  • utilization of CPU, memory, queuing, cache, paging, and swapping on the global server level
  • utilization of CPU for individual CPU processors
  • utilization, response times, transfer rates, and wait and queuing for physical disks
  • packet and data volume transfer activity for network interfaces

SAS Environment Manager Adapter - Agent-Collected Metrics (ACM) Data Source Domain Categories

About the SAS Environment Manager Adapter – Agent-Collected Metrics (ACM) Data Source Domain Categories

This ACM data source domain category represents a subset of data collected by the SAS Environment Manager Data Mart on various Windows and UNIX environments. It focuses on level activity and performance of SAS Resources and includes administering the SAS Web Application Server resources and monitoring SAS foundation servers, SAS metadata server resources, such as authorization and user definitions on the Windows and UNIX platforms. This adapter and domain category combination uses the SAS Resources activity strategy for the staging and aggregating of data. A SAS IT Resource Management staging transformation (SAS Environment Manager) is used in staging the data.
The staged tables for this adapter are input to a series of aggregation jobs that create aggregation tables across a spectrum of daily, weekly, monthly, and sub-hourly time periods. Hourly and shift-based activity is included in a number of these aggregations tables.

Focus of Report-Ready Data for the Agent-Collected Metrics (ACM) Data Source Domain Categories

Report-ready ACM data for this adapter focuses primarily on the following areas:
  • 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

SAS Environment Manager Adapter - Audit, Performance, and Measurement (APM) Data Source Domain Categories

About the SAS Environment Manager Adapter - Audit, Performance, and Measurement (APM) Data Source Domain Categories

This APM data source domain category represents a subset of data collected by the SAS Environment Manager Data Mart (an extension of APM package ETL) on various Windows and UNIX environments. It focuses on creating auditing authentication reports for regulatory compliance or producing reports on the performance and usability of your SAS Intelligence Platform. This adapter and domain category combination uses the SAS Artifacts Resources usage activity strategy for the staging and aggregating of data. A SAS IT Resource Management staging transformation is used in staging the data.
The staged tables for this adapter are input to a series of aggregation jobs that create aggregation tables across a spectrum of daily, weekly, monthly, and sub-hourly time periods. Hourly and shift-based activity is included in a number of these aggregation tables.

Focus of Report-Ready Data for the Audit, Performance and Measurement (APM) Data Source Domain Categories

Report-ready APM data for this adapter focuses primarily on the following areas:
  • the most heavily used SAS procedures
  • the top ten users of the SAS Workspace Server
  • the number of times per day that each user ID has accessed the SAS Metadata Server
  • each instance of an authentication error or an unauthorized login attempt
  • the response time and run time for SAS stored processes

SMF Adapter - RMF Domain Category

About the SMF Adapter - RMF Domain Category

Resource Management Facility (RMF) data collection represents a subset of the following record types: 70, 71, 72, 75, 77, and 78. These record types are collected by SMF on the z/OS platform. This adapter and domain category combination uses the server activity strategy for staging and aggregating data. MXG software is the primary tool that is used in staging the data. A SAS IT Resource Management staging transformation uses the MXG staged output to complete the staging of the data.
The staged tables for this adapter are input to a number of aggregation jobs that create aggregation tables across a spectrum of daily, weekly, monthly, and sub-hourly time periods. Hourly and shift-based activity is included in many of these aggregations. These aggregations are structured by domain categories. In some cases, domain categories are further broken down into subsets of aggregations known as subcategories. The following table summarizes these domain categories and subcategories.

Focus of Report-Ready Data for the SMF Adapter - RMF Domain Category

Report-ready data for this adapter and domain combination focuses primarily on the following domain categories:
  • utilization of CPU, memory, queuing, paging, and swap activity on the global server level
  • CPU-based hardware MSU and MIPS usage on the global server level and by Processor engine type
  • utilization of CPU and level of service measurements by logical partition (LPAR)
  • CPU-based hardware MSU and MIPS usage by LPAR and by Processor engine type
  • utilization of CPU for individual CPU processors
  • utilization of CPU, memory, I/O, and level of service measurements by defined workload
  • CPU-based software MSU and MIPS usage by defined workload and by Processor engine type
  • utilization of CPU, memory, I/O, and level of service measurements by defined Service class and period
  • CPU-based software MSU and MIPS usage by defined Service class and period and by Processor engine type
  • utilization, response times, and wait and queuing for devices (disk and tape)

SMF Adapter - Jobs, TSO, and OMVS Domain Categories

About the SMF Adapter - Jobs, TSO, and OMVS Domain Categories

Batch Job, TSO session, and OMVS session data collection represents a subset of record types (6, 26, and 30) collected by SMF on the z/OS platform. The full complement of data that is collected by SMF for these record types contains performance measurements for batch jobs, TSO sessions, started tasks, Open Edition MVS sessions, and APPC tasks. For SAS IT Resource Management 3.2 and later, this domain category focuses solely on Batch job, TSO sessions, and OMVS session activity. This adapter and domain category combination uses the event activity strategy for the staging and aggregating of data. MXG software is the primary tool that is used in staging the data. A SAS IT Resource Management staging transformation uses the MXG staged output as input and then completes the staging of the data.
This staged table is input to a number of aggregation jobs that create aggregation tables across a spectrum of daily, weekly, and monthly time periods. Shift-based activity is included in a number of these aggregation tables. These aggregations are structured by domain categories. All domain categories in this group are further broken down into subsets of aggregations known as subcategories. The following table summarizes these domain categories and subcategories.

Focus of Report-Ready Data for the SMF Adapter - Jobs, TSO, and OMVS Domain Categories

Report-ready data for these adapter and domain combinations focuses primarily on the following domain categories:
  • job counts, TSO session counts, and OMVS session counts for various groups of classifications
  • accumulated service and times for CPU, memory, and I/O for individual batch jobs, TSO sessions, OMVS sessions across various groups of classifications
  • accumulated CPU-based software MSU and MIPS by Engine type for individual batch jobs, TSO sessions, and OMVS sessions across various groups of classifications
  • printing output associated with batch jobs and TSO sessions
  • utilization of tape resources for batch jobs
  • batch job, TSO session, and OMVS abends and associated return codes

SMF Adapter - CICS Domain Category

About the SMF Adapter - CICS Domain Category

CICS data represents record type 110 collected by SMF on the z/OS platform. This adapter and domain category combination uses the event hourly summarization strategy for the staging and aggregating of data. MXG software is the primary tool that is used in staging the data and in performing the hourly summarization of the staged data. A SAS IT Resource Management staging transformation uses the MXG staged output as input, and then completes the staging of the CICS transaction data. The staging job generates the XCICSUM staged table as output.
This staged table is input to a number of aggregation jobs that create aggregation tables across a spectrum of daily, weekly, and monthly time periods. Hourly and shift-based activity is included in many of these aggregations. There are no sub-hourly aggregations for this domain category because the staged data is pre-summarized to the hourly level. A filter that queries transaction ID is used to exclude all CICS management transactions from the aggregated data. Other filters can easily be created that can be used to exclude conversational transactions. Filters can also be created to include or exclude various operating environments (such as production, test, development, or quality assurance) from the aggregated data. These aggregations are structured by domain categories. All domain categories are further broken down into subsets of aggregations known as subcategories.

Focus of Report-Ready Data for the SMF Adapter - CICS Domain Category

Report-ready data for this adapter and domain combination focuses primarily on the following areas, using the classifications previously specified:
  • transaction counts
  • average response time
  • average and accumulated CPU time
  • file access counts
  • counts and percentages of selected response time criteria
  • monitoring of service level objectives for transactions
Note: SAS IT Resource Management includes the new metrics that the ASUMCICX member creates.
  • This MXG member is stored in a location that is based on its operating environment.
    Windows Specifics: SASHome\SASFoundation\9.4\itmsmvadata\sasmisc
    UNIX Specifics: SASHOME/SASFoundation/9.4/misc
    z/OS Specifics: &prefix.ITRM.CPMISC
Before you use the ASUMCICX member, you must run the UTILEXCL MXG job. This job creates and implements the IMACEXCL member that is customized for your site. Documentation for ASUMCICX and UTILEXCL can be found inside each member.

SMF Adapter - DB2 Domain Category

About the SMF Adapter - DB2 Domain Category

DB2 data represents record type 101 collected by SMF on the z/OS platform. This adapter and domain category combination uses the event activity strategy for the staging and aggregating of data. MXG software is the primary tool that is used in staging the data. A SAS IT Resource Management staging transformation uses the MXG staged output as input, and then completes the staging of the DB2 accounting data. The staging job that the Adapter Setup wizard creates from the DB2 report group generates the XDBACCT staged table as output.
This staged table is input to a number of aggregation jobs that create aggregation tables across a spectrum of daily, weekly, and monthly time periods. Hourly and shift-based activity is included in many of these aggregations. These aggregations are structured by domain categories. All domain categories are further broken down into subsets of aggregations known as subcategories.

Focus of Report-Ready Data for the SMF Adapter - DB2 Domain Category

Report-ready data for this adapter and domain combination focuses primarily on the following areas, using the classifications previously specified:
  • thread counts
  • CPU, Elapsed, and I/O time in DB2
  • CPU and Elapsed total time (inside and outside DB2)
  • CPU and Elapsed percentages in DB2
  • lock, latch, and I/O wait time in DB2
  • lock escalations
  • SQL operations counts

SNMP Adapter - Network Activity, Device and Interface Data, and System Data

About the SNMP Adapter - Network Activity, Device and Interface Data, and System Data Domain Categories

The SNMP adapter contains several domain categories that are based on MIB II SNMP metrics. The data that is collected by default by the SNMP adapter is focused on measuring network activity through several protocols (IP, TCP, UDP, and ICMP), as well as device and interface data and system data. The SAS IT Resource Management staging transformation for SNMP is used in staging the data.
These staged tables are input into a series of aggregation jobs that create aggregation tables across a spectrum of daily, weekly, and monthly time periods. Hourly and shift-based activity is included in a number of these aggregation tables, as well as several simple aggregations.

Focus of Report-Ready Data for the SNMP Adapter

Report-ready data for this adapter focuses primarily on the following areas:
  • Throughput - bits per second, packets or datagrams per second, packet sizes, and packet types
  • Error Rates
  • Utilization and Availability by interface
  • TCP Connections

VMware Adapter - Cluster, Guest, and Host Domain Categories

About the VMware Adapter - Cluster Storage, Cluster System, Guest Disk, Guest Network, Guest Storage, Guest System, Host Disk, Host Network, Host Storage, and Host System Domain Categories

The domain categories for this adapter represent a subset of data stored in the VMware vCenter database. They focus on cluster, guest, and host level activity and performance. These adapter and domain category combinations use the server activity strategy for the staging and aggregating of data. A SAS IT Resource Management staging transformation is used in staging the data.
The staged tables for this adapter are input to a series of aggregation jobs that create aggregation tables across a spectrum of daily, weekly, monthly, and sub-hourly time periods. Hourly and shift-based activity is included in a number of these aggregation tables.

Focus of Report-Ready Data for the VMware Adapter

Report-ready data for this adapter focuses primarily on the following areas:
  • effective CPU, effective Memory, Failover, Total Memory, and Total CPU for the cluster
  • utilization of CPU and memory, CPU ready, memory ballooning, and paging for guests
  • utilization of CPU and memory, memory ballooning, and paging for hosts
  • transfer rates and counts of reads and writes for disks
  • packet and data volume transfer activity for network interfaces
  • utilization of space for data stores

Web Log Adapter - All Domain Categories

About the Web Log Adapter - All Domain Categories

The Web Log adapter contains four domain categories that are supported by the Adapter Setup wizard. These domain categories represent different categorizations of the same, limited set of metrics that are available from web logs. The data that is collected focuses on measuring page counts and requests, the size of those requests and the response time to service those requests. The SAS IT Resource Management staging transformation for the Web Log adapter is used in staging the data.
The staged tables for this adapter are input into a series of aggregation jobs that create aggregation tables across a spectrum of daily, weekly, and monthly time periods. Hourly and shift-based activity is included in a number of these aggregation tables, but no simple aggregations are included.

Focus of Report-Ready Data for the Web Log Adapter

Report-ready data for this adapter focuses primarily on the following metrics:
  • Bytes sent and received
  • Number of pages received
  • Number of requests sent
  • Response time