Redgate Monitor 14

The API endpoints' data have relationships that can be leveraged to improve how you perceive the data. The following are some useful data mapping.

Joining Endpoint Data
Metric types to monitored entity mapping

Joining Endpoint Data

You can perform joins on specific properties of the data obtained from different endpoints. The table below outlines the properties and endpoints on which you can perform joins.

Endpoint	Property	Mapped Endpoint	Mapped Property
`/api/v1/alerts/types`	id name	`/api/v1/alerts`	alertType.id alertType.name
`/api/v1/metrics/types`	id name	`/api/v1/metrics`	metricType.id metricType.name
`/api/v1/monitored-entities/types`	entityType	`/api/v1/monitored-entities`	type
`/api/v1/monitored-entities`	id name	`/api/v1/alerts` `/api/v1/metrics` `/api/v1/disk-usage` `/api/v1/backups`	monitoredEntity.id monitoredEntity.name

Monitored entity types

Entity Type	Description
Cluster	Windows cluster instance (This will be a machine in the case of a standalone machine)
Machine	Windows machine which hosts a SQL Server instance
LinuxMachine	Linux machine instance
AmazonRdsHost	Amazon RDS host instance
SqlServer	SQL Server instance on a Windows machine
SqlServerInstance	SQL Server instance on a Linux machine
PostgresInstance	Postgres server instance
AzureManagedInstance	Azure SQL Managed Instance
AzureSqlServer	Virtual SQL Server in Azure used to group Azure SQL Databases
AmazonRdsSqlServer	Amazon RDS SQL Server instance

Metric type to Monitored entity mapping

The following table gives you a list of metric IDs supported by the relevant entity type

Entity Type	Metric Type Id's
Cluster - Windows cluster instance (This will be a machine in the case of a standalone machine)	`[Cluster].[AvailabilityGroup].[Replica].[Database].[Performance].[LogBytesReceivedPerSecond]` `[Cluster].[AvailabilityGroup].[Replica].[Database].[Performance].[LogSendQueue]` `[Cluster].[AvailabilityGroup].[Replica].[Database].[Performance].[RecoveryQueue]` `[Cluster].[AvailabilityGroup].[Replica].[Database].[Performance].[RedoneBytesPerSecond]` `[Cluster].[AvailabilityGroup].[Replica].[Database].[Performance].[TransactionDelay]` `[Cluster].[AvailabilityGroup].[Replica].[Performance].[FlowControlTime]` `[Cluster].[ClusterSharedVolumes].[FreeBytes]` `[Cluster].[ClusterSharedVolumes].[FreePercent]` `[Cluster].[ClusterSharedVolumes].[UsedBytes]` `[Cluster].[ClusterSharedVolumes].[UsedPercent]`
Machine - Windows machine which hosts a SQL Server instance	`[Cluster].[Machine].[LogicalDisk].[AverageReadTime]` `[Cluster].[Machine].[LogicalDisk].[AverageTransferQueueLength]` `[Cluster].[Machine].[LogicalDisk].[AverageWriteTime]` `[Cluster].[Machine].[LogicalDisk].[Capacity].[FreeBytes]` `[Cluster].[Machine].[LogicalDisk].[Capacity].[UsedBytes]` `[Cluster].[Machine].[LogicalDisk].[Capacity].[UsedPercent]` `[Cluster].[Machine].[LogicalDisk].[ReadBytesPerSecond]` `[Cluster].[Machine].[LogicalDisk].[TotalBytesPerSecond]` `[Cluster].[Machine].[LogicalDisk].[TransfersPerSecond]` `[Cluster].[Machine].[LogicalDisk].[WriteBytesPerSecond]` `[Cluster].[Machine].[Memory].[PagesPerSecond]` `[Cluster].[Machine].[Memory].[UsedBytes]` `[Cluster].[Machine].[Network].[PercentUtilization]` `[Cluster].[Machine].[Processors].[AverageQueueLength]` `[Cluster].[Machine].[Processors].[PercentProcessorTime]` `[Cluster].[Machine].[VMware].[CpuCostop]` `[Cluster].[Machine].[VMware].[DiskLatency]` `[Cluster].[Machine].[VMware].[DiskReadBytes]` `[Cluster].[Machine].[VMware].[DiskWriteBytes]` `[Cluster].[Machine].[VMware].[GuestCpuReady]` `[Cluster].[Machine].[VMware].[GuestCpuSwapWait]` `[Cluster].[Machine].[VMware].[GuestMemoryBalloonedBytes]` `[Cluster].[Machine].[VMware].[HostMemoryBalloonedBytes]` `[Cluster].[Machine].[VMware].[MemorySwapInRateBytesPerSecond]` `[Cluster].[Machine].[VMware].[MemorySwapOutRateBytesPerSecond]` `[Cluster].[Machine].[VMware].[NetworkUsageBytes]` `[Cluster].[Machine].[VMware].[PercentCpuUsage]` `[Cluster].[Machine].[VMware].[PercentGuestMemoryLatency]` `[Cluster].[Machine].[VMware].[PercentMemoryUsage]` `[Cluster].[Machine].[VMware].[Processor].[EffectiveVmSpeedMhz]` `[Cluster].[Machine].[VMware].[TotalIOBytes]`
LinuxMachine - Linux machine instance	`[LinuxMachine].[Processors].[PercentProcessorTime]` `[LinuxMachine].[Processors].[AverageQueueLength]` `[LinuxMachine].[Memory].[UsedBytes]` `[LinuxMachine].[Memory].[PagesPerSecond]` `[LinuxMachine].[Network].[PercentUtilization]` `[LinuxMachine].[LogicalDisk].[Capacity].[UsedBytes]` `[LinuxMachine].[LogicalDisk].[Capacity].[UsedPercent]` `[LinuxMachine].[LogicalDisk].[Capacity].[FreeBytes]` `[LinuxMachine].[LogicalDisk].[AverageReadTime]` `[LinuxMachine].[LogicalDisk].[AverageWriteTime]` `[LinuxMachine].[LogicalDisk].[ReadBytesPerSecond]` `[LinuxMachine].[LogicalDisk].[WriteBytesPerSecond]` `[LinuxMachine].[LogicalDisk].[TotalBytesPerSecond]` `[LinuxMachine].[LogicalDisk].[TransfersPerSecond]` `[LinuxMachine].[LogicalDisk].[AverageTransferQueueLength]`
AmazonRdsHost - Amazon RDS host instance	`[AmazonRdsHost].[Processors].[PercentProcessorTime]` `[AmazonRdsHost].[Memory].[UsedBytes]` `[AmazonRdsHost].[Network].[BytesTotalPerSecond]` `[AmazonRdsHost].[LogicalDisk].[Capacity].[UsedBytes]` `[AmazonRdsHost].[LogicalDisk].[Capacity].[UsedPercent]` `[AmazonRdsHost].[LogicalDisk].[Capacity].[FreeBytes]` `[AmazonRdsHost].[LogicalDisk].[ReadBytesPerSecond]` `[AmazonRdsHost].[LogicalDisk].[WriteBytesPerSecond]` `[AmazonRdsHost].[LogicalDisk].[TotalBytesPerSecond]` `[AmazonRdsHost].[LogicalDisk].[TransfersPerSecond]`
SqlServer - SQL Server instance on a Windows machine	`[Cluster].[SqlServer].[AccessMethods].[FullScansPerSecond]` `[Cluster].[SqlServer].[AccessMethods].[PageSplitsPerBatchRequest]` `[Cluster].[SqlServer].[AccessMethods].[PageSplitsPerSecond]` `[Cluster].[SqlServer].[BufferManager].[FreeListStallsPerSec]` `[Cluster].[SqlServer].[BufferManager].[PageLifeExpectancy]` `[Cluster].[SqlServer].[BufferManager].[PageReadsPerSec]` `[Cluster].[SqlServer].[Database].[File].[Performance].[AverageStallPerRead]` `[Cluster].[SqlServer].[Database].[File].[Performance].[AverageStallPerWrite]` `[Cluster].[SqlServer].[Database].[File].[Performance].[ReadBytesPerSecond]` `[Cluster].[SqlServer].[Database].[File].[Performance].[TotalBytesPerSecond]` `[Cluster].[SqlServer].[Database].[File].[Performance].[WriteBytesPerSecond]` `[Cluster].[SqlServer].[Database].[File].[Size]` `[Cluster].[SqlServer].[Database].[File].[UsedSize]` `[Cluster].[SqlServer].[Database].[Performance].[ActiveTransactions]` `[Cluster].[SqlServer].[Database].[Performance].[LogBytesFlushedPerSecond]` `[Cluster].[SqlServer].[Database].[Performance].[LogFlushesPerSecond]` `[Cluster].[SqlServer].[Database].[Performance].[LogFlushWaitsPerSecond]` `[Cluster].[SqlServer].[Database].[Performance].[TransactionsPerSecond]` `[Cluster].[SqlServer].[Database].[Storage].[PercentTotalLogUsed]` `[Cluster].[SqlServer].[Database].[Storage].[TotalDataSizeBytes]` `[Cluster].[SqlServer].[Database].[Storage].[TotalDataUsedBytes]` `[Cluster].[SqlServer].[Database].[Storage].[TotalLogSizeBytes]` `[Cluster].[SqlServer].[Database].[Storage].[TotalLogUsedBytes]` `[Cluster].[SqlServer].[Database].[Storage].[TotalSizeBytes]` `[Cluster].[SqlServer].[GeneralStatistics].[UserConnections]` `[Cluster].[SqlServer].[Latches].[AverageLatchWaitTime]` `[Cluster].[SqlServer].[Locks].[AverageLockWaitTime]` `[Cluster].[SqlServer].[Locks].[LockTimeoutsPerSecond]` `[Cluster].[SqlServer].[Locks].[LockWaitsPerSecond]` `[Cluster].[SqlServer].[MemoryManager].[ConnectionMemoryBytes]` `[Cluster].[SqlServer].[MemoryManager].[DatabaseCacheMemoryBytes]` `[Cluster].[SqlServer].[MemoryManager].[DynamicSqlCacheMemoryBytes]` `[Cluster].[SqlServer].[MemoryManager].[FreeMemoryBytes]` `[Cluster].[SqlServer].[MemoryManager].[LockMemoryBytes]` `[Cluster].[SqlServer].[MemoryManager].[LogPoolMemoryBytes]` `[Cluster].[SqlServer].[MemoryManager].[MaximumWorkspaceMemoryBytes]` `[Cluster].[SqlServer].[MemoryManager].[MemoryGrantsPending]` `[Cluster].[SqlServer].[MemoryManager].[OptimizerMemoryBytes]` `[Cluster].[SqlServer].[MemoryManager].[ReservedMemoryBytes]` `[Cluster].[SqlServer].[MemoryManager].[StolenServerMemoryBytes]` `[Cluster].[SqlServer].[MemoryManager].[TargetServerMemoryBytes]` `[Cluster].[SqlServer].[MemoryManager].[TotalServerMemoryBytes]` `[Cluster].[SqlServer].[MemoryManager].[WorkspaceMemoryBytes]` `[Cluster].[SqlServer].[PlanCache].[PlanCacheMemoryBytes]` `[Cluster].[SqlServer].[Process].[PercentProcessorTime]` `[Cluster].[SqlServer].[Process].[WorkingSet]` `[Cluster].[SqlServer].[ServerWaits].[WaitTimeDelta]` `[Cluster].[SqlServer].[SqlStatistics].[BatchRequestsPerSecond]` `[Cluster].[SqlServer].[SqlStatistics].[CompilationsPerBatchRequest]` `[Cluster].[SqlServer].[SqlStatistics].[CompilationsPerSecond]` `[Cluster].[SqlServer].[SqlStatistics].[RecompilationsPerSecond]` `[Cluster].[SqlServer].[TempDB].[Distribution].[FreeBytes]` `[Cluster].[SqlServer].[TempDB].[Distribution].[InternalBytes]` `[Cluster].[SqlServer].[TempDB].[Distribution].[MixedExtentBytes]` `[Cluster].[SqlServer].[TempDB].[Distribution].[UserObjectBytes]` `[Cluster].[SqlServer].[TempDB].[Distribution].[VersionBytes]` `[Cluster].[SqlServer].[TempDB].[Files].[FreeBytes]` `[Cluster].[SqlServer].[TempDB].[Files].[InternalBytes]` `[Cluster].[SqlServer].[TempDB].[Files].[MixedBytes]` `[Cluster].[SqlServer].[TempDB].[Files].[UserBytes]` `[Cluster].[SqlServer].[TempDB].[Files].[VersionStoreBytes]` `[Cluster].[SqlServer].[TempDB].[VersionStore].[CleanupRate]` `[Cluster].[SqlServer].[TempDB].[VersionStore].[GenerationRate]` `[Cluster].[SqlServer].[TempDB].[VersionStore].[LongestRunningTransactionTime]`
SqlServerInstance - SQL Server instance on a Linux machine	`[SqlServerInstance].[GeneralStatistics].[UserConnections]` `[SqlServerInstance].[Process].[PercentProcessorTime]` `[SqlServerInstance].[MemoryManager].[TotalServerMemoryBytes]` `[SqlServerInstance].[MemoryManager].[TargetServerMemoryBytes]` `[SqlServerInstance].[MemoryManager].[FreeMemoryBytes]` `[SqlServerInstance].[MemoryManager].[DynamicSqlCacheMemoryBytes]` `[SqlServerInstance].[MemoryManager].[ConnectionMemoryBytes]` `[SqlServerInstance].[MemoryManager].[LockMemoryBytes]` `[SqlServerInstance].[MemoryManager].[OptimizerMemoryBytes]` `[SqlServerInstance].[MemoryManager].[DatabaseCacheMemoryBytes]` `[SqlServerInstance].[MemoryManager].[WorkspaceMemoryBytes]` `[SqlServerInstance].[MemoryManager].[LogPoolMemoryBytes]` `[SqlServerInstance].[MemoryManager].[ReservedMemoryBytes]` `[SqlServerInstance].[MemoryManager].[MaximumWorkspaceMemoryBytes]` `[SqlServerInstance].[MemoryManager].[StolenServerMemoryBytes]` `[SqlServerInstance].[MemoryManager].[MemoryGrantsPending]` `[SqlServerInstance].[PlanCache].[PlanCacheMemoryBytes]` `[SqlServerInstance].[SqlStatistics].[BatchRequestsPerSecond]` `[SqlServerInstance].[SqlStatistics].[CompilationsPerSecond]` `[SqlServerInstance].[SqlStatistics].[CompilationsPerBatchRequest]` `[SqlServerInstance].[SqlStatistics].[RecompilationsPerSecond]` `[SqlServerInstance].[BufferManager].[PageLifeExpectancy]` `[SqlServerInstance].[BufferManager].[FreeListStallsPerSec]` `[SqlServerInstance].[BufferManager].[PageReadsPerSec]` `[SqlServerInstance].[AccessMethods].[FullScansPerSecond]` `[SqlServerInstance].[AccessMethods].[PageSplitsPerSecond]` `[SqlServerInstance].[AccessMethods].[PageSplitsPerBatchRequest]` `[SqlServerInstance].[Latches].[AverageLatchWaitTime]` `[SqlServerInstance].[Locks].[LockTimeoutsPerSecond]` `[SqlServerInstance].[Locks].[LockWaitsPerSecond]` `[SqlServerInstance].[Locks].[AverageLockWaitTime]` `[SqlServerInstance].[TempDB].[Distribution].[FreeBytes]` `[SqlServerInstance].[TempDB].[Distribution].[InternalBytes]` `[SqlServerInstance].[TempDB].[Distribution].[UserObjectBytes]` `[SqlServerInstance].[TempDB].[Distribution].[MixedExtentBytes]` `[SqlServerInstance].[TempDB].[Distribution].[VersionBytes]` `[SqlServerInstance].[TempDB].[Files].[FreeBytes]` `[SqlServerInstance].[TempDB].[Files].[InternalBytes]` `[SqlServerInstance].[TempDB].[Files].[UserBytes]` `[SqlServerInstance].[TempDB].[Files].[MixedBytes]` `[SqlServerInstance].[TempDB].[Files].[VersionStoreBytes]` `[SqlServerInstance].[TempDB].[VersionStore].[GenerationRate]` `[SqlServerInstance].[TempDB].[VersionStore].[CleanupRate]` `[SqlServerInstance].[TempDB].[VersionStore].[LongestRunningTransactionTime]` `[SqlServerInstance].[Database].[Performance].[TransactionsPerSecond]` `[SqlServerInstance].[Database].[Performance].[ActiveTransactions]` `[SqlServerInstance].[Database].[Storage].[TotalSizeBytes]` `[SqlServerInstance].[Database].[Storage].[TotalDataSizeBytes]` `[SqlServerInstance].[Database].[Storage].[TotalDataUsedBytes]` `[SqlServerInstance].[Database].[File].[Size]` `[SqlServerInstance].[Database].[File].[UsedSize]` `[SqlServerInstance].[Database].[Storage].[TotalLogSizeBytes]` `[SqlServerInstance].[Database].[Storage].[TotalLogUsedBytes]` `[SqlServerInstance].[Database].[Storage].[PercentTotalLogUsed]` `[SqlServerInstance].[Database].[Performance].[LogBytesFlushedPerSecond]` `[SqlServerInstance].[Database].[Performance].[LogFlushesPerSecond]` `[SqlServerInstance].[Database].[Performance].[LogFlushWaitsPerSecond]` `[SqlServerInstance].[Database].[File].[Performance].[AverageStallPerRead]` `[SqlServerInstance].[Database].[File].[Performance].[AverageStallPerWrite]` `[SqlServerInstance].[Database].[File].[Performance].[ReadBytesPerSecond]` `[SqlServerInstance].[Database].[File].[Performance].[WriteBytesPerSecond]` `[SqlServerInstance].[Database].[File].[Performance].[TotalBytesPerSecond]`
PostgresInstance - Postgres server instance	`[PostgresInstance].[GeneralStatistics].[NumberOfConnections]` `[PostgresInstance].[GeneralStatistics].[NumberOfActiveConnections]` `[PostgresInstance].[GeneralStatistics].[NumberOfIdleConnections]` `[PostgresInstance].[Database].[Performance].[TransactionsCommittedByRolledBack]` `[PostgresInstance].[Database].[Performance].[TemporaryDataWrittenPerSecond]` `[PostgresInstance].[Database].[Performance].[BlockWriteTimePerSecond]` `[PostgresInstance].[Database].[Performance].[BlockReadTimePerSecond]` `[PostgresInstance].[Database].[Performance].[TransactionsCommittedPerSecond]` `[PostgresInstance].[Database].[Performance].[TransactionsRolledBackPerSecond]` `[PostgresInstance].[Database].[Performance].[DeadlocksPerSecond]` `[PostgresInstance].[Database].[Performance].[CacheHitRatio]` `[PostgresInstance].[Database].[Performance].[TransactionIdConsumption]` `[PostgresInstance].[StatReplication].[ReplayLagBytes]` `[PostgresInstance].[Wal].[WalSize]`
AzureManagedInstance - Azure SQL Managed Instance	`[AzureManagedInstance].[ServerWaits].[WaitTimeDelta]` `[AzureManagedInstance].[GeneralStatistics].[UserConnections]` `[AzureManagedInstance].[Resources].[PercentProcessorTime]` `[AzureManagedInstance].[MemoryManager].[TotalServerMemoryBytes]` `[AzureManagedInstance].[MemoryManager].[TargetServerMemoryBytes]` `[AzureManagedInstance].[MemoryManager].[FreeMemoryBytes]` `[AzureManagedInstance].[MemoryManager].[DynamicSqlCacheMemoryBytes]` `[AzureManagedInstance].[MemoryManager].[ConnectionMemoryBytes]` `[AzureManagedInstance].[MemoryManager].[LockMemoryBytes]` `[AzureManagedInstance].[MemoryManager].[OptimizerMemoryBytes]` `[AzureManagedInstance].[MemoryManager].[DatabaseCacheMemoryBytes]` `[AzureManagedInstance].[MemoryManager].[WorkspaceMemoryBytes]` `[AzureManagedInstance].[MemoryManager].[LogPoolMemoryBytes]` `[AzureManagedInstance].[MemoryManager].[ReservedMemoryBytes]` `[AzureManagedInstance].[MemoryManager].[MaximumWorkspaceMemoryBytes]` `[AzureManagedInstance].[MemoryManager].[StolenServerMemoryBytes]` `[AzureManagedInstance].[MemoryManager].[MemoryGrantsPending]` `[AzureManagedInstance].[PlanCache].[PlanCacheMemoryBytes]` `[AzureManagedInstance].[Process].[WorkingSet]` `[AzureManagedInstance].[SqlStatistics].[BatchRequestsPerSecond]` `[AzureManagedInstance].[SqlStatistics].[CompilationsPerSecond]` `[AzureManagedInstance].[SqlStatistics].[CompilationsPerBatchRequest]` `[AzureManagedInstance].[SqlStatistics].[RecompilationsPerSecond]` `[AzureManagedInstance].[BufferManager].[PageLifeExpectancy]` `[AzureManagedInstance].[BufferManager].[FreeListStallsPerSec]` `[AzureManagedInstance].[BufferManager].[PageReadsPerSec]` `[AzureManagedInstance].[AccessMethods].[FullScansPerSecond]` `[AzureManagedInstance].[AccessMethods].[PageSplitsPerSecond]` `[AzureManagedInstance].[AccessMethods].[PageSplitsPerBatchRequest]` `[AzureManagedInstance].[Latches].[AverageLatchWaitTime]` `[AzureManagedInstance].[Locks].[LockTimeoutsPerSecond]` `[AzureManagedInstance].[Locks].[LockWaitsPerSecond]` `[AzureManagedInstance].[Locks].[AverageLockWaitTime]` `[AzureManagedInstance].[TempDB].[Distribution].[FreeBytes]` `[AzureManagedInstance].[TempDB].[Distribution].[InternalBytes]` `[AzureManagedInstance].[TempDB].[Distribution].[UserObjectBytes]` `[AzureManagedInstance].[TempDB].[Distribution].[MixedExtentBytes]` `[AzureManagedInstance].[TempDB].[Distribution].[VersionBytes]` `[AzureManagedInstance].[TempDB].[Files].[FreeBytes]` `[AzureManagedInstance].[TempDB].[Files].[InternalBytes]` `[AzureManagedInstance].[TempDB].[Files].[UserBytes]` `[AzureManagedInstance].[TempDB].[Files].[MixedBytes]` `[AzureManagedInstance].[TempDB].[Files].[VersionStoreBytes]` `[AzureManagedInstance].[TempDB].[VersionStore].[GenerationRate]` `[AzureManagedInstance].[TempDB].[VersionStore].[CleanupRate]` `[AzureManagedInstance].[TempDB].[VersionStore].[LongestRunningTransactionTime]` `[AzureManagedInstance].[Resources].[ReadBytesPerSecond]` `[AzureManagedInstance].[Resources].[WriteBytesPerSecond]` `[AzureManagedInstance].[Resources].[TotalBytesPerSecond]` `[AzureManagedInstance].[Resources].[TransfersPerSecond]` `[AzureManagedInstance].[Database].[Performance].[TransactionsPerSecond]` `[AzureManagedInstance].[Database].[Performance].[ActiveTransactions]` `[AzureManagedInstance].[Database].[Storage].[TotalSizeBytes]` `[AzureManagedInstance].[Database].[Storage].[TotalDataSizeBytes]` `[AzureManagedInstance].[Database].[Storage].[TotalDataUsedBytes]` `[AzureManagedInstance].[Database].[File].[Size]` `[AzureManagedInstance].[Database].[File].[UsedSize]` `[AzureManagedInstance].[Database].[Storage].[TotalLogSizeBytes]` `[AzureManagedInstance].[Database].[Storage].[TotalLogUsedBytes]` `[AzureManagedInstance].[Database].[Storage].[PercentTotalLogUsed]` `[AzureManagedInstance].[Database].[Performance].[LogBytesFlushedPerSecond]` `[AzureManagedInstance].[Database].[Performance].[LogFlushesPerSecond]` `[AzureManagedInstance].[Database].[Performance].[LogFlushWaitsPerSecond]` `[AzureManagedInstance].[Database].[File].[Performance].[AverageStallPerRead]` `[AzureManagedInstance].[Database].[File].[Performance].[AverageStallPerWrite]` `[AzureManagedInstance].[Database].[File].[Performance].[ReadBytesPerSecond]` `[AzureManagedInstance].[Database].[File].[Performance].[WriteBytesPerSecond]` `[AzureManagedInstance].[Database].[File].[Performance].[TotalBytesPerSecond]`
AzureSqlServer - Virtual SQL Server in Azure used to group Azure SQL Databases	`[AzureSqlServer].[Database].[Resources].[PercentDtu]` `[AzureSqlServer].[Database].[Resources].[PercentCpu]` `[AzureSqlServer].[Database].[Resources].[PercentIo]` `[AzureSqlServer].[Database].[Resources].[PercentLogWrite]` `[AzureSqlServer].[Database].[Resources].[PercentMemoryUsed]` `[AzureSqlServer].[Database].[Waits].[WaitTimeDelta]` `[AzureSqlServer].[Database].[GeneralStatistics].[UserConnections]` `[AzureSqlServer].[Database].[MemoryManager].[TotalServerMemoryBytes]` `[AzureSqlServer].[Database].[MemoryManager].[TargetServerMemoryBytes]` `[AzureSqlServer].[Database].[MemoryManager].[FreeMemoryBytes]` `[AzureSqlServer].[Database].[PlanCache].[PlanCacheMemoryBytes]` `[AzureSqlServer].[Database].[SqlStatistics].[BatchRequestsPerSecond]` `[AzureSqlServer].[Database].[SqlStatistics].[CompilationsPerSecond]` `[AzureSqlServer].[Database].[SqlStatistics].[CompilationsPerBatchRequest]` `[AzureSqlServer].[Database].[SqlStatistics].[RecompilationsPerSecond]` `[AzureSqlServer].[Database].[BufferManager].[PageLifeExpectancy]` `[AzureSqlServer].[Database].[AccessMethods].[FullScansPerSecond]` `[AzureSqlServer].[Database].[AccessMethods].[PageSplitsPerSecond]` `[AzureSqlServer].[Database].[AccessMethods].[PageSplitsPerBatchRequest]` `[AzureSqlServer].[Database].[Latches].[AverageLatchWaitTime]` `[AzureSqlServer].[Database].[Locks].[LockTimeoutsPerSecond]` `[AzureSqlServer].[Database].[Locks].[LockWaitsPerSecond]` `[AzureSqlServer].[Database].[Locks].[AverageLockWaitTime]` `[AzureSqlServer].[Database].[Performance].[TransactionsPerSecond]` `[AzureSqlServer].[Database].[Performance].[ActiveTransactions]` `[AzureSqlServer].[Database].[Performance].[LogBytesFlushedPerSecond]` `[AzureSqlServer].[Database].[Performance].[LogFlushesPerSecond]` `[AzureSqlServer].[Database].[Performance].[LogFlushWaitsPerSecond]` `[AzureSqlServer].[Database].[Storage].[DatabaseUsedSizeInBytes]` `[AzureSqlServer].[Database].[Resources].[MaxWorkerPercent]` `[AzureSqlServer].[Database].[Resources].[MaxSessionPercent]` `[AzureSqlServer].[ElasticPool].[Resources].[DtuPercent]` `[AzureSqlServer].[ElasticPool].[Resources].[AvgCpuPercent]` `[AzureSqlServer].[ElasticPool].[Resources].[AvgDataIoPercent]` `[AzureSqlServer].[ElasticPool].[Resources].[AvgLogWritePercent]` `[AzureSqlServer].[ElasticPool].[Resources].[MaxWorkerPercent]` `[AzureSqlServer].[ElasticPool].[Resources].[MaxSessionPercent]`
AmazonRdsSqlServer - Amazon RDS SQL Server instance	`[AmazonRdsSqlServer].[ServerWaits].[WaitTimeDelta]` `[AmazonRdsSqlServer].[GeneralStatistics].[UserConnections]` `[AmazonRdsSqlServer].[MemoryManager].[TotalServerMemoryBytes]` `[AmazonRdsSqlServer].[MemoryManager].[TargetServerMemoryBytes]` `[AmazonRdsSqlServer].[MemoryManager].[FreeMemoryBytes]` `[AmazonRdsSqlServer].[MemoryManager].[DynamicSqlCacheMemoryBytes]` `[AmazonRdsSqlServer].[MemoryManager].[ConnectionMemoryBytes]` `[AmazonRdsSqlServer].[MemoryManager].[LockMemoryBytes]` `[AmazonRdsSqlServer].[MemoryManager].[OptimizerMemoryBytes]` `[AmazonRdsSqlServer].[MemoryManager].[DatabaseCacheMemoryBytes]` `[AmazonRdsSqlServer].[MemoryManager].[WorkspaceMemoryBytes]` `[AmazonRdsSqlServer].[MemoryManager].[LogPoolMemoryBytes]` `[AmazonRdsSqlServer].[MemoryManager].[ReservedMemoryBytes]` `[AmazonRdsSqlServer].[MemoryManager].[MaximumWorkspaceMemoryBytes]` `[AmazonRdsSqlServer].[MemoryManager].[StolenServerMemoryBytes]` `[AmazonRdsSqlServer].[MemoryManager].[MemoryGrantsPending]` `[AmazonRdsSqlServer].[PlanCache].[PlanCacheMemoryBytes]` `[AmazonRdsSqlServer].[Process].[WorkingSetKilobytes]` `[AmazonRdsSqlServer].[SqlStatistics].[BatchRequestsPerSecond]` `[AmazonRdsSqlServer].[SqlStatistics].[CompilationsPerSecond]` `[AmazonRdsSqlServer].[SqlStatistics].[CompilationsPerBatchRequest]` `[AmazonRdsSqlServer].[SqlStatistics].[RecompilationsPerSecond]` `[AmazonRdsSqlServer].[BufferManager].[PageLifeExpectancy]` `[AmazonRdsSqlServer].[BufferManager].[FreeListStallsPerSec]` `[AmazonRdsSqlServer].[BufferManager].[PageReadsPerSec]` `[AmazonRdsSqlServer].[AccessMethods].[FullScansPerSecond]` `[AmazonRdsSqlServer].[AccessMethods].[PageSplitsPerSecond]` `[AmazonRdsSqlServer].[AccessMethods].[PageSplitsPerBatchRequest]` `[AmazonRdsSqlServer].[Latches].[AverageLatchWaitTime]` `[AmazonRdsSqlServer].[Locks].[LockTimeoutsPerSecond]` `[AmazonRdsSqlServer].[Locks].[LockWaitsPerSecond]` `[AmazonRdsSqlServer].[Locks].[AverageLockWaitTime]` `[AmazonRdsSqlServer].[TempDB].[Distribution].[FreeBytes]` `[AmazonRdsSqlServer].[TempDB].[Distribution].[InternalBytes]` `[AmazonRdsSqlServer].[TempDB].[Distribution].[UserObjectBytes]` `[AmazonRdsSqlServer].[TempDB].[Distribution].[MixedExtentBytes]` `[AmazonRdsSqlServer].[TempDB].[Distribution].[VersionBytes]` `[AmazonRdsSqlServer].[TempDB].[Files].[FreeBytes]` `[AmazonRdsSqlServer].[TempDB].[Files].[InternalBytes]` `[AmazonRdsSqlServer].[TempDB].[Files].[UserBytes]` `[AmazonRdsSqlServer].[TempDB].[Files].[MixedBytes]` `[AmazonRdsSqlServer].[TempDB].[Files].[VersionStoreBytes]` `[AmazonRdsSqlServer].[TempDB].[VersionStore].[GenerationRate]` `[AmazonRdsSqlServer].[TempDB].[VersionStore].[CleanupRate]` `[AmazonRdsSqlServer].[TempDB].[VersionStore].[LongestRunningTransactionTime]` `[AmazonRdsSqlServer].[Processors].[PercentProcessorTime]` `[AmazonRdsSqlServer].[Memory].[UsedBytes]` `[AmazonRdsSqlServer].[Network].[BytesTotalPerSecond]` `[AmazonRdsSqlServer].[LogicalDisk].[Capacity].[UsedBytes]` `[AmazonRdsSqlServer].[LogicalDisk].[Capacity].[UsedPercent]` `[AmazonRdsSqlServer].[LogicalDisk].[Capacity].[FreeBytes]` `[AmazonRdsSqlServer].[LogicalDisk].[ReadBytesPerSecond]` `[AmazonRdsSqlServer].[LogicalDisk].[WriteBytesPerSecond]` `[AmazonRdsSqlServer].[LogicalDisk].[TotalBytesPerSecond]` `[AmazonRdsSqlServer].[LogicalDisk].[TransfersPerSecond]` `[AmazonRdsSqlServer].[Database].[Performance].[TransactionsPerSecond]` `[AmazonRdsSqlServer].[Database].[Performance].[ActiveTransactions]` `[AmazonRdsSqlServer].[Database].[Storage].[TotalSizeBytes]` `[AmazonRdsSqlServer].[Database].[Storage].[TotalDataSizeBytes]` `[AmazonRdsSqlServer].[Database].[Storage].[TotalDataUsedBytes]` `[AmazonRdsSqlServer].[Database].[File].[Size]` `[AmazonRdsSqlServer].[Database].[File].[UsedSize]` `[AmazonRdsSqlServer].[Database].[Storage].[TotalLogSizeBytes]` `[AmazonRdsSqlServer].[Database].[Storage].[TotalLogUsedBytes]` `[AmazonRdsSqlServer].[Database].[Storage].[PercentTotalLogUsed]` `[AmazonRdsSqlServer].[Database].[Performance].[LogBytesFlushedPerSecond]` `[AmazonRdsSqlServer].[Database].[Performance].[LogFlushesPerSecond]` `[AmazonRdsSqlServer].[Database].[Performance].[LogFlushWaitsPerSecond]` `[AmazonRdsSqlServer].[Database].[File].[Performance].[AverageStallPerRead]` `[AmazonRdsSqlServer].[Database].[File].[Performance].[AverageStallPerWrite]` `[AmazonRdsSqlServer].[Database].[File].[Performance].[ReadBytesPerSecond]` `[AmazonRdsSqlServer].[Database].[File].[Performance].[WriteBytesPerSecond]` `[AmazonRdsSqlServer].[Database].[File].[Performance].[TotalBytesPerSecond]`

Redgate Monitor 14

Endpoint Data Mapping

Joining Endpoint Data

Monitored entity types

Metric type to Monitored entity mapping

Cluster - Windows cluster instance (This will be a machine in the case of a standalone machine)

Machine - Windows machine which hosts a SQL Server instance

LinuxMachine - Linux machine instance

AmazonRdsHost - Amazon RDS host instance

SqlServer - SQL Server instance on a Windows machine

SqlServerInstance - SQL Server instance on a Linux machine

PostgresInstance - Postgres server instance

AzureManagedInstance - Azure SQL Managed Instance

AzureSqlServer - Virtual SQL Server in Azure used to group Azure SQL Databases

AmazonRdsSqlServer - Amazon RDS SQL Server instance