ACM Tables

These tables are located in the directory [levelroot]/Web/SASEnvironmentManager/emi-framework/Datamart/acm.

ACM.AVAILABILITY Table

The ACM.AVAILABILITY table contains data about resource availability.
This table contains the following metric data columns:
avail endtime
starttime minutes

ACM.FILEMOUNTS Table

The ACM.FILEMOUNTS table contains usage data for the file mounts in your SAS environment. If the feed to SAS Visual Analytics is enabled, this table is copied to the drop zone.
By default, this table contains the following metric data columns:
diskWrites1m DiskQueue
diskReads1m DiskSeviceTime
UsePercent DiskReadBytes1m
TotFsFree DiskWriteBytes1m
Capacity

ACM.GROUPINVENTORY Table

The ACM.GROUPINVENTORY table contains data about the resource groups that are defined in SAS Environment Manager.
This table contains the following inventory columns:
id desc
name

ACM.EVENTS Table

The ACM.EVENTS table contains data about the events that are logged by SAS Environment Manager.
This table contains the following metric data columns:
msg resource_id
fixdate status
datetime what
duration who
eventType

ACM.HOSTPLATFORMS Table

The ACM.HOSTPLATFORMS table contains metrics for the platforms. If the feed to SAS Visual Analytics is enabled, this table is copied to the drop zone.
By default, this table contains the following metric data columns:
MemFree PercentUsedSwap
SwapUsed ZombieProcesses
CpuUsage PercentFreeSwap
LoadAverage1 RunningProcesses
CpuSoftLrq TcpInErrs1m
CpuStolen SwapPagesOut1m
SwapFree TcpPassiveOpens1m
TotalProcesses TcpRetransSegs1m
CpuLrq Commit1m
CpuSys Write1m
CpuNice TcpEstabResets1m
TcpOutboundConnections Read1m
CpuIdle TcpOutRsts1m
LoadAverage2 TcpAttemptFails1m
MemUsed TcpActiveOpens1m
ActualMemUsed SwapPagesIn1m
PercentFreeMemory Access1m
PercentUsedMemory FileSystemReadsWrites1m
CpuUser SwapTotal
LoadAverage0 ActualMemFree
CpuWait NumCPUs
TcpInboundConnections MemTotal

ACM.HTTPCHECKS Table

The ACM.HTTPCHECKS table contains metric data for HTTP checks of web services. If the feed to SAS Visual Analytics is enabled, this table is copied to the drop zone.
By default, this table contains the following metric data columns:
AllInboundConnections ResponseTime
InboundConnections OutboundConnections
AllOutboundConnections ResponseCode
StateTIME_WAIT LastModified

ACM.IOMSERVERS Table

This table is deprecated, beginning with the third maintenance release after SAS 9.4. The following reports, which are created from data from this table, are also deprecated:
  • IOM Server Call Activity
  • IOM Server Client Activity
  • IOM Server Summary Reports
  • IOM Total Calls and Time in Calls
  • IOM Total Calls vs. Time in Calls
These reports should be deleted.

ACM.MEASUREINVENTORY Table

The ACM.MEASUREINVENTORY table contains data about the measurements that are being performed.
This table contains the following inventory columns:
measurement_id UNITS
resource_id type
enabled MONITORABLE_TYPE_ID
NAME category
PLUGIN resource_desc
ALIAS deleted

ACM.METADATASVRS Table

The ACM.METADATASVRS table contains metric data for the SAS Metadata Servers in the environment. If the feed to SAS Visual Analytics is enabled, this table is copied to the drop zone.
By default, this table contains the following metric data columns:
serverState ProcessShare
ProcessEnd_Last_Time SystemTime
HighestThreadCount health
ProcessStartTime UserTime
CurrentClients ProcessThreads
ProcessUserID Usage
ProcessGroupID ProcessMajorFaults
CounterJournalSpaceAvailable TotalCalls1m
HighestMemoryUsage CounterJournalDataWrite1m
CurrentThreadCount ProcessPageFaults1m
CurrentMemoryUsage CounterJournalTransProcessed1m
TotalClients1m ProcessMinorFaults1m
ProcessResidentMemorySize TimeInCalls1m
TotalTime CounerJournalTransQueued1m
ProcessVirtualMemorySize

ACM.NETWORKINTERFACE Table

The ACM.NETWORKINTERFACE table contains metric data for the network performance in your environment. If the feed to SAS Visual Analytics is enabled, this table is copied to the drop zone.
By default, this table contains the following metric data columns:
BitsIn1s RxDropped1m
PacketsOut1m BytesOut1m
BitsOut1m TxCollisions1m
PacketsOut1m TxDropped1m
RxErrors1m BytesIn1m
TxErrors1m

ACM.RESOURCEINVENTORY Table

The ACM.RESOURCEINVENTORY table contains information about the resources in the SAS Environment Manager inventory.
This table contains the following inventory columns:
ID type
desc prototype
platformResource invLevel
serverResource shortname
serviceResource deleted
name

ACM.SASAPPSERVERS Table

The ACM.SASAPPSERVERS table contains metric data for SAS Application Server resources. If the feed to SAS Visual Analytics is enabled, this table is copied to the drop zone.
By default, this table contains the following metric data columns:
ServerState NumProcesses
UnauthorizedAccesses TotalClients1m
LastAccessState CurrentClients
CurrentRunningServers_Local Usage
ActivePeers ResidentMemSize
CurrentPendingClients MemSize
TotalWaitingTime TotalTime1m
CurrentWaitingClients UserTime1m
CurrentConnectedClients SystemTime1m
TotalTimedOutClients TimeInCalls1m
CurrentWaitingClients_Local TotalCalls1m
CurrentRunningServers

ACM.SASLOGICALSERVERS Table

The ACM.SASLOGICALSERVERS table contains metric data for SAS logical server resources. If the feed to SAS Visual Analytics is enabled, this table is copied to the drop zone.
By default, this table contains the following metric data columns:
ServerState NumProcesses
UnauthorizedAccesses TotalClients1m
LastAccessState CurrentClients
CurrentRunningServers_Local Usage
ActivePeers ResidentMemSize
CurrentPendingClients MemSize
TotalWaitingTime TotalTime1m
CurrentWaitingClients UserTime1m
CurrentConnectedClients SystemTime1m
TotalTimedOutClients TimeInCalls1m
CurrentWaitingClients_Local TotalCalls1m
CurrentRunningServers

ACM.TCSSERVERMGRS Table

The ACM.TCSSERVERMGRS table contains metric data for tcServers in the system. If the feed to SAS Visual Analytics is enabled, this table is copied to the drop zone.
By default, this table contains the following metric data columns:
rejectedSessions1m activeSessions
sessionCreateRate sessionExpireRate
sessionAverageAliveTime processingTime

ACM.WEBAPPSERVER Table

The ACM.WEBAPPSERVER table contains metric data for SAS web applications. If the feed to SAS Visual Analytics is enabled, this table is copied to the drop zone.
By default, this table contains the following metric data columns:
HeapMemoryMax HeapMemoryUsed
HeapMemoryFree DeadlocksDetected
PercentUpTimeinGarbageCollection OpenFileDescriptionCount
Uptime ThreadCount1m
HeapMemoryCommitted

ACM.WIPDATADB Table

The ACM.WIPDATADB table contains metric data for the SAS Web Infrastructure Platform. If the feed to SAS Visual Analytics is enabled, this table is copied to the drop zone.
By default, this table contains the following metric data columns:
DataSpaceUsed seq_scan1m
idx_tup_read1m idx_blks_read1m
tup_fetched1s xact_rollbacks1s
numbackends xact_commit1s
blks_hit_p blks_read1s
granted_locks tup_altered1s