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

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

Cookies on red-gate.com