All Rules in Microsoft.Azure.ManagedInstance.Monitoring Management Pack

 DisplayNameDescriptionIDTargetCategoryEnabledInstance NameCounter NameFrequencyEvent_IDEvent SourceAlert GenerateAlert SeverityAlert PriorityRemotableEvent Log
Microsoft.Azure.ManagedInstance.CollectionRule.Database.ActiveTransactionsAzure SQL DB Managed Instance: DB Active Transactions CountCollects number of active transactions for the database.Microsoft.Azure.ManagedInstance.CollectionRule.Database.ActiveTransactionsMicrosoft.Azure.ManagedInstance.DatabasePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.Database.DBActiveConnectionsCountAzure SQL DB Managed Instance: DB Active Connections CountCollects active connections’ count for Managed Instance Database.Microsoft.Azure.ManagedInstance.CollectionRule.Database.DBActiveConnectionsCountMicrosoft.Azure.ManagedInstance.DatabasePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.Database.DBActiveRequestsCountAzure SQL DB Managed Instance: DB Active Requests CountCollects Managed Instance Database Active Requests.Microsoft.Azure.ManagedInstance.CollectionRule.Database.DBActiveRequestsCountMicrosoft.Azure.ManagedInstance.DatabasePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.Database.DBActiveSessionsCountAzure SQL DB Managed Instance: DB Active Sessions CountManaged Instance databases Active Sessions performance collection ruleMicrosoft.Azure.ManagedInstance.CollectionRule.Database.DBActiveSessionsCountMicrosoft.Azure.ManagedInstance.DatabasePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.Database.TransactionsPerSecAzure SQL DB Managed Instance: DB Transactions per Second CountManaged Instance databases Transactions per second performance collection rule.Microsoft.Azure.ManagedInstance.CollectionRule.Database.TransactionsPerSecMicrosoft.Azure.ManagedInstance.DatabasePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.AverageWaitTimeAzure SQL DB Managed Instance: DB Engine Average Wait Time (Milliseconds)DB Engine Average Wait Time performance collection rule.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.AverageWaitTimeMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.BufferCacheHitRatioAzure SQL DB Managed Instance: Buffer Cache Hit RatioThe rule collects the Windows "Buffer Cache Hit Ratio" performance counter for each instance of DB Engine.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.BufferCacheHitRatioMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.CPUUtilizationAzure SQL DB Managed Instance: DB Engine CPU Utilization (\%)Managed Instance CPU Utilization (\%) performance collection rule.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.CPUUtilizationMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.HTTPStorage_AvgBytesReadAzure SQL DB Managed Instance: HTTP Storage: Average Bytes/ReadThe rule collects the "HTTP Storage: Average Bytes/Read" performance counter for Managed Instance that monitor Windows Azure Storage account.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.HTTPStorage_AvgBytesReadMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.HTTPStorage_AvgBytesTransferAzure SQL DB Managed Instance: HTTP Storage: Average Bytes/TransferThe rule collects the "HTTP Storage: Average Bytes/Transfer" performance counter for Managed Instance that monitor Windows Azure Storage account.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.HTTPStorage_AvgBytesTransferMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.HTTPStorage_AvgBytesWriteAzure SQL DB Managed Instance: HTTP Storage: Average Bytes/WriteThe rule collects the "HTTP Storage: Average Bytes/Write" performance counter for DB Engine that monitor Windows Azure Storage account.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.HTTPStorage_AvgBytesWriteMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.HTTPStorage_AvgMicrosecReadAzure SQL DB Managed Instance: HTTP Storage: Average Microseconds/ReadThe rule collects the "HTTP Storage: Average Microseconds/Read" performance counter for Managed Instance that monitor Windows Azure Storage account.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.HTTPStorage_AvgMicrosecReadMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.HTTPStorage_AvgMicrosecReadCompAzure SQL DB Managed Instance: HTTP Storage: Average Microseconds/Read CompThe rule collects the "HTTP Storage: Average Microseconds/Read Comp" performance counter for Managed Instance that monitor Windows Azure Storage account.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.HTTPStorage_AvgMicrosecReadCompMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.HTTPStorage_AvgMicrosecTransferAzure SQL DB Managed Instance: HTTP Storage: Average Microseconds/TransferThe rule collects the "HTTP Storage: Average Microseconds/Transfer" performance counter for DB Engine that monitor Windows Azure Storage account.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.HTTPStorage_AvgMicrosecTransferMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.HTTPStorage_AvgMicrosecWriteAzure SQL DB Managed Instance: HTTP Storage: Average Microseconds/WriteThe rule collects the "HTTP Storage: Average Microseconds/Write" performance counter for DB Engine that monitor Windows Azure Storage account.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.HTTPStorage_AvgMicrosecWriteMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.HTTPStorage_AvgMicrosecWriteCompAzure SQL DB Managed Instance: HTTP Storage: Average Microseconds/Write CompThe rule collects the "HTTP Storage: Average Microseconds/Write Comp" performance counter for DB Engine that monitor Windows Azure Storage account.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.HTTPStorage_AvgMicrosecWriteCompMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.HTTPStorage_HttpStorageIoFailedSecAzure SQL DB Managed Instance: HTTP Storage: HTTP Storage I/O Failed per SecondThe rule collects the "HTTP Storage: HTTP Storage I/O Failed per Second" performance counter for Managed Instance that monitor Windows Azure Storage account.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.HTTPStorage_HttpStorageIoFailedSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.HTTPStorage_HttpStorageIoRetrySecAzure SQL DB Managed Instance: HTTP Storage: HTTP Storage I/O Retry per SecondThe rule collects the "HTTP Storage: HTTP Storage I/O Retry per Second" performance counter for DB Engine that monitor Windows Azure Storage account.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.HTTPStorage_HttpStorageIoRetrySecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.HTTPStorage_OutstandingHttpStorageIoAzure SQL DB Managed Instance: HTTP Storage: Outstanding HTTP Storage I/OThe rule collects the "HTTP Storage: Outstanding HTTP Storage I/O" performance counter for Managed Instance that monitor Windows Azure Storage account.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.HTTPStorage_OutstandingHttpStorageIoMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.HTTPStorage_ReadBytesSecAzure SQL DB Managed Instance: HTTP Storage: Read Bytes per SecondThe rule collects the "HTTP Storage: Read Bytes per Second" performance counter for DB Engine that monitor Windows Azure Storage account.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.HTTPStorage_ReadBytesSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.HTTPStorage_ReadsSecAzure SQL DB Managed Instance: HTTP Storage: Reads per SecondThe rule collects the "HTTP Storage: Reads per Second" performance counter for DB Engine that monitor Windows Azure Storage account.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.HTTPStorage_ReadsSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.HTTPStorage_TotalBytesSecAzure SQL DB Managed Instance: HTTP Storage: Total Bytes per SecondThe rule collects the "HTTP Storage: Total Bytes per Second" performance counter for DB Engine that monitor Windows Azure Storage account.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.HTTPStorage_TotalBytesSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.HTTPStorage_TransfersSecAzure SQL DB Managed Instance: HTTP Storage: Transfers per SecondThe rule collects the "HTTP Storage: Transfers per Second" performance counter for DB Engine that monitor Windows Azure Storage account.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.HTTPStorage_TransfersSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.HTTPStorage_WriteBytesSecAzure SQL DB Managed Instance: HTTP Storage: Write Bytes per SecondThe rule collects the "HTTP Storage: Write Bytes per Second" performance counter for DB Engine that monitor Windows Azure Storage account.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.HTTPStorage_WriteBytesSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.HTTPStorage_WritesSecAzure SQL DB Managed Instance: HTTP Storage: Writes per SecondThe rule collects the "HTTP Storage: Writes per Second" performance counter for DB Engine that monitor Windows Azure Storage account.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.HTTPStorage_WritesSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.LockRequestsPerSecondAzure SQL DB Managed Instance: Number of Lock Requests per SecondThe rule collects the Windows "Number of Lock Requests per Second" performance counter for each instance of DB Engine.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.LockRequestsPerSecondMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.LockTimeoutsPerSecondAzure SQL DB Managed Instance: Lock Timeouts per SecondThe rule collects the Windows "Lock Timeouts per Second" performance counter for each instance of DB Engine.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.LockTimeoutsPerSecondMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.LockWaitsPerSecondAzure SQL DB Managed Instance: Number of Lock Waits per SecondThe rule collects the Windows "Number of Lock Waits per Second" performance counter for each instance of DB Engine.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.LockWaitsPerSecondMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.LoginsPerSecondAzure SQL DB Managed Instance: Logins per SecondTotal number of logins started per second. This does not include pooled connections.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.LoginsPerSecondMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.NumberDeadlocksPerSecondAzure SQL DB Managed Instance: Number of Deadlocks per SecondThe rule collects the Windows "Number of Deadlocks per Second" performance counter for each instance of DB Engine.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.NumberDeadlocksPerSecondMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.PageLifeExpectancyAzure SQL DB Managed Instance: DB Engine Page Life Expectancy (s)DB Engine Page Life Expectancy (s) performance collection ruleMicrosoft.Azure.ManagedInstance.CollectionRule.DBEngine.PageLifeExpectancyMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.SQLCompilationsPerSecondAzure SQL DB Managed Instance: SQL Compilations per SecondThe rule collects the Windows "SQL Compilations per Second" performance counter for each instance of DB Engine.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.SQLCompilationsPerSecondMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.SQLRecompilationsPerSecondAzure SQL DB Managed Instance: SQL Re-Compilations per SecondThe rule collects the Windows "SQL Recompiles per Second" performance counter for each instance of DB Engine.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.SQLRecompilationsPerSecondMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.StolenServerMemoryAzure SQL DB Managed Instance: DB Engine Stolen Server Memory (MB)DB Engine Stolen Server Memory (MB) performance collection rule.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.StolenServerMemoryMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.ThreadCountAzure SQL DB Managed Instance: DB Engine Thread CountDB Engine Thread Count performance collection ruleMicrosoft.Azure.ManagedInstance.CollectionRule.DBEngine.ThreadCountMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.TransactionsPerSecondAzure SQL DB Managed Instance: Total Transactions per SecondThe rule collects the Windows "Transaction per Second" performance counter for the _Total instance of the databases performance object for each instance of DB Engine.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.TransactionsPerSecondMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.UserConnectionsCollectionAzure SQL DB Managed Instance: User ConnectionsThis rule counts the number of users currently connected to Managed Instance.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.UserConnectionsCollectionMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpCursors_CursorDeletesSecAzure SQL DB Managed Instance: Cursor deletes/secThe rule collects the Windows "Cursor deletes/sec" performance counter for internal XTP engine cursors.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpCursors_CursorDeletesSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpCursors_CursorInsertsSecAzure SQL DB Managed Instance: Cursor inserts/secThe rule collects the Windows "Cursor inserts/sec" performance counter for internal XTP engine cursors.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpCursors_CursorInsertsSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpCursors_CursorScansStartedSecAzure SQL DB Managed Instance: Cursor scans started/secThe rule collects the Windows "Cursor scans started/sec" performance counter for internal XTP engine cursors.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpCursors_CursorScansStartedSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpCursors_CursorUniqueViolationsSecAzure SQL DB Managed Instance: Cursor unique violations/secThe rule collects the Windows "Cursor unique violations/sec" performance counter for internal XTP engine cursors.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpCursors_CursorUniqueViolationsSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpCursors_CursorUpdatesSecAzure SQL DB Managed Instance: Cursor updates/secThe rule collects the Windows "Cursor updates/sec" performance counter for internal XTP engine cursors.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpCursors_CursorUpdatesSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpCursors_CursorWriteConflictsSecAzure SQL DB Managed Instance: Cursor write conflicts/secThe rule collects the Windows "Cursor write conflicts/sec" performance counter for internal XTP engine cursors.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpCursors_CursorWriteConflictsSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpCursors_DustyCornerScanRetriesSecUserIssuedAzure SQL DB Managed Instance: Dusty corner scan retries/sec (user-issued)The rule collects the Windows "Dusty corner scan retries/sec (user-issued)" performance counter for internal XTP engine cursors.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpCursors_DustyCornerScanRetriesSecUserIssuedMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpCursors_ExpiredRowsRemovedSecAzure SQL DB Managed Instance: Expired rows removed/secThe rule collects the Windows "Expired rows removed/sec" performance counter for internal XTP engine cursors.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpCursors_ExpiredRowsRemovedSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpCursors_ExpiredRowsTouchedSecAzure SQL DB Managed Instance: Expired rows touched/secThe rule collects the Windows "Expired rows touched/sec" performance counter for internal XTP engine cursors.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpCursors_ExpiredRowsTouchedSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpCursors_RowsReturnedSecAzure SQL DB Managed Instance: Rows returned/secThe rule collects the Windows "Rows returned/sec" performance counter for internal XTP engine cursors.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpCursors_RowsReturnedSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpCursors_RowsTouchedSecAzure SQL DB Managed Instance: Rows touched/secThe rule collects the Windows "Rows touched/sec" performance counter for internal XTP engine cursors.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpCursors_RowsTouchedSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpCursors_TentativelyDeletedRowsTouchedSecAzure SQL DB Managed Instance: Tentatively-deleted rows touched/secThe rule collects the Windows "Tentatively-deleted rows touched/sec" performance counter for internal XTP engine cursors.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpCursors_TentativelyDeletedRowsTouchedSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpGarbageCollection_DustyCornerScanRetriesSecGcIssuedAzure SQL DB Managed Instance: Dusty corner scan retries/sec (GC-issued)The rule collects the Windows "Dusty corner scan retries/sec (GC-issued)" performance counter for the XTP engine's garbage collector.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpGarbageCollection_DustyCornerScanRetriesSecGcIssuedMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpGarbageCollection_MainGcWorkItemsSecAzure SQL DB Managed Instance: Main GC work items/secThe rule collects the Windows "Main GC work items/sec" performance counter for the XTP engine's garbage collector.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpGarbageCollection_MainGcWorkItemsSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpGarbageCollection_ParallelGcWorkItemSecAzure SQL DB Managed Instance: Parallel GC work item/secThe rule collects the Windows "Parallel GC work item/sec" performance counter for the XTP engine's garbage collector.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpGarbageCollection_ParallelGcWorkItemSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpGarbageCollection_RowsProcessedSecAzure SQL DB Managed Instance: Rows processed/secThe rule collects the Windows "Rows processed/sec" performance counter for the XTP engine's garbage collector.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpGarbageCollection_RowsProcessedSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpGarbageCollection_RowsProcessedSecFirstInBucketAzure SQL DB Managed Instance: Rows processed/sec (first in bucket)The rule collects the Windows "Rows processed/sec (first in bucket)" performance counter for the XTP engine's garbage collector.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpGarbageCollection_RowsProcessedSecFirstInBucketMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpGarbageCollection_RowsProcessedSecFirstInBucketAndRemovedAzure SQL DB Managed Instance: Rows processed/sec (first in bucket and removed)The rule collects the Windows "Rows processed/sec (first in bucket and removed)" performance counter for the XTP engine's garbage collector.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpGarbageCollection_RowsProcessedSecFirstInBucketAndRemovedMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpGarbageCollection_RowsProcessedSecMarkedForUnlinkAzure SQL DB Managed Instance: Rows processed/sec (marked for unlink)The rule collects the Windows "Rows processed/sec (marked for unlink)" performance counter for the XTP engine's garbage collector.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpGarbageCollection_RowsProcessedSecMarkedForUnlinkMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpGarbageCollection_RowsProcessedSecNoSweepNeededAzure SQL DB Managed Instance: Rows processed/sec (no sweep needed)The rule collects the Windows "Rows processed/sec (no sweep needed)" performance counter for the XTP engine's garbage collector.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpGarbageCollection_RowsProcessedSecNoSweepNeededMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpGarbageCollection_SweepExpiredRowsRemovedSecAzure SQL DB Managed Instance: Sweep expired rows removed/secThe rule collects the Windows "Sweep expired rows removed/sec" performance counter for the XTP engine's garbage collector.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpGarbageCollection_SweepExpiredRowsRemovedSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpGarbageCollection_SweepExpiredRowsTouchedSecAzure SQL DB Managed Instance: Sweep expired rows touched/secThe rule collects the Windows "Sweep expired rows touched/sec" performance counter for the XTP engine's garbage collector.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpGarbageCollection_SweepExpiredRowsTouchedSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpGarbageCollection_SweepExpiringRowsTouchedSecAzure SQL DB Managed Instance: Sweep expiring rows touched/secThe rule collects the Windows "Sweep expiring rows touched/sec" performance counter for the XTP engine's garbage collector.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpGarbageCollection_SweepExpiringRowsTouchedSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpGarbageCollection_SweepRowsTouchedSecAzure SQL DB Managed Instance: Sweep rows touched/secThe rule collects the Windows "Sweep rows touched/sec" performance counter for the XTP engine's garbage collector.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpGarbageCollection_SweepRowsTouchedSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpGarbageCollection_SweepScansStartedSecAzure SQL DB Managed Instance: Sweep scans started/secThe rule collects the Windows "Sweep scans started/sec" performance counter for the XTP engine's garbage collector.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpGarbageCollection_SweepScansStartedSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpIoGovernor_InsufficientCreditsWaitsSecAzure SQL DB Managed Instance: Insufficient Credits Waits/secThe rule collects the Windows "Insufficient Credits Waits/sec" performance counter for the XTP IO Rate Governor.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpIoGovernor_InsufficientCreditsWaitsSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpIoGovernor_IoIssuedSecAzure SQL DB Managed Instance: Io Issued/secThe rule collects the Windows "Io Issued/sec" performance counter for the XTP IO Rate Governor.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpIoGovernor_IoIssuedSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpIoGovernor_LogBlocksSecAzure SQL DB Managed Instance: Log Blocks/secThe rule collects the Windows "Log Blocks/sec" performance counter for the XTP IO Rate Governor.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpIoGovernor_LogBlocksSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpIoGovernor_MissedCreditSlotsAzure SQL DB Managed Instance: Missed Credit SlotsThe rule collects the Windows "Missed Credit Slots" performance counter for the XTP IO Rate Governor.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpIoGovernor_MissedCreditSlotsMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpIoGovernor_StaleRateObjectWaitsSecAzure SQL DB Managed Instance: Stale Rate Object Waits/secThe rule collects the Windows "Stale Rate Object Waits/sec" performance counter for the XTP IO Rate Governor.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpIoGovernor_StaleRateObjectWaitsSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpIoGovernor_TotalRateObjectsPublishedAzure SQL DB Managed Instance: Total Rate Objects PublishedThe rule collects the Windows "Total Rate Objects Published" performance counter for the XTP IO Rate Governor.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpIoGovernor_TotalRateObjectsPublishedMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpPhantomProcessor_DustyCornerScanRetriesSecPhantomIssuedAzure SQL DB Managed Instance: Dusty corner scan retries/sec (Phantom-issued)The rule collects the Windows "Dusty corner scan retries/sec (Phantom-issued)" performance counter for the XTP engine's phantom processing subsystem.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpPhantomProcessor_DustyCornerScanRetriesSecPhantomIssuedMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpPhantomProcessor_PhantomExpiredRowsRemovedSecAzure SQL DB Managed Instance: Phantom expired rows removed/secThe rule collects the Windows "Phantom expired rows removed/sec" performance counter for the XTP engine's phantom processing subsystem.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpPhantomProcessor_PhantomExpiredRowsRemovedSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpPhantomProcessor_PhantomExpiredRowsTouchedSecAzure SQL DB Managed Instance: Phantom expired rows touched/secThe rule collects the Windows "Phantom expired rows touched/sec" performance counter for the XTP engine's phantom processing subsystem.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpPhantomProcessor_PhantomExpiredRowsTouchedSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpPhantomProcessor_PhantomExpiringRowsTouchedSecAzure SQL DB Managed Instance: Phantom expiring rows touched/secThe rule collects the Windows "Phantom expiring rows touched/sec" performance counter for the XTP engine's phantom processing subsystem.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpPhantomProcessor_PhantomExpiringRowsTouchedSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpPhantomProcessor_PhantomRowsTouchedSecAzure SQL DB Managed Instance: Phantom rows touched/secThe rule collects the Windows "Phantom rows touched/sec" performance counter for the XTP engine's phantom processing subsystem.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpPhantomProcessor_PhantomRowsTouchedSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpPhantomProcessor_PhantomScansStartedSecAzure SQL DB Managed Instance: Phantom scans started/secThe rule collects the Windows "Phantom scans started/sec" performance counter for the XTP engine's phantom processing subsystem.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpPhantomProcessor_PhantomScansStartedSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpStorage_CheckpointsClosedAzure SQL DB Managed Instance: Checkpoints ClosedThe rule collects the Windows "Checkpoints Closed" performance counter for the XTP engine's storage subsystem.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpStorage_CheckpointsClosedMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpStorage_CheckpointsCompletedAzure SQL DB Managed Instance: Checkpoints CompletedThe rule collects the Windows "Checkpoints Completed" performance counter for the XTP engine's storage subsystem.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpStorage_CheckpointsCompletedMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpStorage_CoreMergesCompletedAzure SQL DB Managed Instance: Core Merges CompletedThe rule collects the Windows "Core Merges Completed" performance counter for the XTP engine's storage subsystem.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpStorage_CoreMergesCompletedMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpStorage_MergePolicyEvaluationsAzure SQL DB Managed Instance: Merge Policy EvaluationsThe rule collects the Windows "Merge Policy Evaluations" performance counter for the XTP engine's storage subsystem.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpStorage_MergePolicyEvaluationsMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpStorage_MergeRequestsOutstandingAzure SQL DB Managed Instance: Merge Requests OutstandingThe rule collects the Windows "Merge Requests Outstanding" performance counter for the XTP engine's storage subsystem.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpStorage_MergeRequestsOutstandingMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpStorage_MergesAbandonedAzure SQL DB Managed Instance: Merges AbandonedThe rule collects the Windows "Merges Abandoned" performance counter for the XTP engine's storage subsystem.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpStorage_MergesAbandonedMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpStorage_MergesInstalledAzure SQL DB Managed Instance: Merges InstalledThe rule collects the Windows "Merges Installed" performance counter for the XTP engine's storage subsystem.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpStorage_MergesInstalledMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpStorage_TotalFilesMergedAzure SQL DB Managed Instance: Total Files MergedThe rule collects the Windows "Total Files Merged" performance counter for the XTP engine's storage subsystem.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpStorage_TotalFilesMergedMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpTransactionLog_LogBytesWrittenSecAzure SQL DB Managed Instance: Log bytes written/secThe rule collects the Windows "Log bytes written/sec" performance counter for XTP transaction logging in Managed Instance.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpTransactionLog_LogBytesWrittenSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpTransactionLog_LogRecordsWrittenSecAzure SQL DB Managed Instance: Log records written/secThe rule collects the Windows "Log records written/sec" performance counter for XTP transaction logging in Managed Instance.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpTransactionLog_LogRecordsWrittenSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpTransactions_CascadingAbortsSecAzure SQL DB Managed Instance: Cascading aborts/secThe rule collects the Windows "Cascading aborts/sec" performance counter for XTP engine transactions in Managed Instance.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpTransactions_CascadingAbortsSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpTransactions_CommitDependenciesTakenSecAzure SQL DB Managed Instance: Commit dependencies taken/secThe rule collects the Windows "Commit dependencies taken/sec" performance counter for XTP engine transactions in Managed Instance.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpTransactions_CommitDependenciesTakenSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpTransactions_ReadOnlyTransactionsPreparedSecAzure SQL DB Managed Instance: Read-only transactions prepared/secThe rule collects the Windows "Read-only transactions prepared/sec" performance counter for XTP engine transactions in Managed Instance.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpTransactions_ReadOnlyTransactionsPreparedSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpTransactions_SavePointRefreshesSecAzure SQL DB Managed Instance: Save point refreshes/secThe rule collects the Windows "Save point refreshes/sec" performance counter for XTP engine transactions in Managed Instance.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpTransactions_SavePointRefreshesSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpTransactions_SavePointRollbacksSecAzure SQL DB Managed Instance: Save point rollbacks/secThe rule collects the Windows "Save point rollbacks/sec" performance counter for XTP engine transactions in Managed Instance.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpTransactions_SavePointRollbacksSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpTransactions_SavePointsCreatedSecAzure SQL DB Managed Instance: Save points created/secThe rule collects the Windows "Save points created/sec" performance counter for XTP engine transactions in Managed Instance.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpTransactions_SavePointsCreatedSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpTransactions_TransactionsAbortedByUserSecAzure SQL DB Managed Instance: Transactions aborted by user/secThe rule collects the Windows "Transactions aborted by user/sec" performance counter for XTP engine transactions in Managed Instance.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpTransactions_TransactionsAbortedByUserSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpTransactions_TransactionsAbortedSecAzure SQL DB Managed Instance: Transactions aborted/secThe rule collects the Windows "Transactions aborted/sec" performance counter for XTP engine transactions in Managed Instance.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpTransactions_TransactionsAbortedSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpTransactions_TransactionsCreatedSecAzure SQL DB Managed Instance: Transactions created/secThe rule collects the Windows "Transactions created/sec" performance counter for XTP engine transactions in Managed Instance.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpTransactions_TransactionsCreatedSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpTransactions_TransactionValidationFailuresSecAzure SQL DB Managed Instance: Transaction validation failures/secThe rule collects the Windows "Transaction validation failures/sec" performance counter for XTP engine transactions in Managed Instance.Microsoft.Azure.ManagedInstance.CollectionRule.DBEngine.XtpTransactions_TransactionValidationFailuresSecMicrosoft.Azure.ManagedInstance.DBEnginePerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBFileGroupFx.CheckpointFile.ActiveAzure SQL DB Managed Instance: Active Checkpoint File PairsThe rule collects the number of active checkpoint file pairs in Memory-Optimized Data Filegroup.Microsoft.Azure.ManagedInstance.CollectionRule.DBFileGroupFx.CheckpointFile.ActiveMicrosoft.Azure.ManagedInstance.DBFilegroupFxPerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBFileGroupFx.CheckpointFile.MergeTargetAzure SQL DB Managed Instance: Merge Target Checkpoint File PairsThe rule collects the number of merge target checkpoint file pairs in Memory-Optimized Data Filegroup.Microsoft.Azure.ManagedInstance.CollectionRule.DBFileGroupFx.CheckpointFile.MergeTargetMicrosoft.Azure.ManagedInstance.DBFilegroupFxPerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBFileGroupFx.CheckpointFile.PrecreatedAzure SQL DB Managed Instance: Precreated Checkpoint FilesThe rule collects the number of Precreated Checkpoint Files in Memory-Optimized Data Filegroup.Microsoft.Azure.ManagedInstance.CollectionRule.DBFileGroupFx.CheckpointFile.PrecreatedMicrosoft.Azure.ManagedInstance.DBFilegroupFxPerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBFileGroupFx.CheckpointFile.StaleAzure SQL DB Managed Instance: Checkpoint File Pairs Waiting For Log TruncationThe rule collects the number of Checkpoint Files Waiting For Log Truncation in Memory-Optimized Data Filegroup.Microsoft.Azure.ManagedInstance.CollectionRule.DBFileGroupFx.CheckpointFile.StaleMicrosoft.Azure.ManagedInstance.DBFilegroupFxPerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBFileGroupFx.CheckpointFile.UnderConstructionAzure SQL DB Managed Instance: Checkpoint File Pairs Under ConstructionThe rule collects the number of checkpoint file pairs under construction in Memory-Optimized Data Filegroup.Microsoft.Azure.ManagedInstance.CollectionRule.DBFileGroupFx.CheckpointFile.UnderConstructionMicrosoft.Azure.ManagedInstance.DBFilegroupFxPerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBFilegroupFx.IndexesUsedMemoryMBAzure SQL DB Managed Instance: Memory Used By Indexes (MB)The rule collects the amount of memory allocated for indexes defined for memory-optimized tables in the given Nabaged Instance database.Microsoft.Azure.ManagedInstance.CollectionRule.DBFilegroupFx.IndexesUsedMemoryMBMicrosoft.Azure.ManagedInstance.DBFilegroupFxPerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBFilegroupFx.TablesMemoryUsageMBAzure SQL DB Managed Instance: Memory Used By Tables (MB)The rule collects the amount of memory allocated for memory-optimized tables in the given Managed Instance.Microsoft.Azure.ManagedInstance.CollectionRule.DBFilegroupFx.TablesMemoryUsageMBMicrosoft.Azure.ManagedInstance.DBFilegroupFxPerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBFilegroupFx.XtpControllerDlcLatencyFetchAzure SQL DB Managed Instance: XTP Controller DLC Latency/FetchThe rule collects the Windows "XTP Controller DLC Latency/Fetch" performance counter for Managed Instance Database with Memory-Optimized tables.Microsoft.Azure.ManagedInstance.CollectionRule.DBFilegroupFx.XtpControllerDlcLatencyFetchMicrosoft.Azure.ManagedInstance.DBFilegroupFxPerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBFilegroupFx.XtpControllerDlcPeakLatencyAzure SQL DB Managed Instance: XTP Controller DLC Peak LatencyThe rule collects the Windows "XTP Controller DLC Peak Latency" performance counter for Managed Instance Database with Memory-Optimized tables.Microsoft.Azure.ManagedInstance.CollectionRule.DBFilegroupFx.XtpControllerDlcPeakLatencyMicrosoft.Azure.ManagedInstance.DBFilegroupFxPerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBFilegroupFx.XtpControllerLogProcessedSecAzure SQL DB Managed Instance: XTP Controller Log Processed/secThe rule collects the Windows "XTP Controller Log Processed/sec" performance counter for Managed Instance Database with Memory-Optimized tables.Microsoft.Azure.ManagedInstance.CollectionRule.DBFilegroupFx.XtpControllerLogProcessedSecMicrosoft.Azure.ManagedInstance.DBFilegroupFxPerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.DBFilegroupFx.XtpMemoryUsedKbAzure SQL DB Managed Instance: XTP Memory Used (KB)The rule collects the Windows "XTP Memory Used (KB)" performance counter for Managed Instance Database with Memory-Optimized tables.Microsoft.Azure.ManagedInstance.CollectionRule.DBFilegroupFx.XtpMemoryUsedKbMicrosoft.Azure.ManagedInstance.DBFilegroupFxPerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.ResourcePool.ActiveMemoryGrantAmountKBAzure SQL DB Managed Instance: Number of query memory grants in the resource poolThe rule collects the Windows "Active Memory grant amount (KB)" performance counter for each resource pool of Managed Instance.Microsoft.Azure.ManagedInstance.CollectionRule.ResourcePool.ActiveMemoryGrantAmountKBMicrosoft.Azure.ManagedInstance.ResourcePoolPerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.ResourcePool.ActiveMemoryGrantsCountAzure SQL DB Managed Instance: Total amount of granted memory in the resource pool (KB)The rule collects the Windows "Active memory grants count" performance counter for each resource pool of Managed Instance.Microsoft.Azure.ManagedInstance.CollectionRule.ResourcePool.ActiveMemoryGrantsCountMicrosoft.Azure.ManagedInstance.ResourcePoolPerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.ResourcePool.CacheMemoryTargetKBAzure SQL DB Managed Instance: Current memory target for cache memory (KB)The rule collects the Windows "Cache memory target (KB)" performance counter for each resource pool of DB Engine.Microsoft.Azure.ManagedInstance.CollectionRule.ResourcePool.CacheMemoryTargetKBMicrosoft.Azure.ManagedInstance.ResourcePoolPerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.ResourcePool.CompileMemoryTargetKBAzure SQL DB Managed Instance: Current memory target for query compile (KB)The rule collects the Windows "Compile Memory Target (KB)" performance counter for each resource pool of Managed Instance.Microsoft.Azure.ManagedInstance.CollectionRule.ResourcePool.CompileMemoryTargetKBMicrosoft.Azure.ManagedInstance.ResourcePoolPerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.ResourcePool.MaxMemoryKBAzure SQL DB Managed Instance: Maximum amount of memory the resource pool can have based on the settings and server state (KB)The rule collects the Windows "Max memory (KB)" performance counter for each resource pool of DB Engine.Microsoft.Azure.ManagedInstance.CollectionRule.ResourcePool.MaxMemoryKBMicrosoft.Azure.ManagedInstance.ResourcePoolPerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.ResourcePool.MemoryGrantsSecAzure SQL DB Managed Instance: Number of query memory grants per second occurring in the resource poolThe rule collects the Windows "Memory grants/sec" performance counter for each resource pool of Managed Instance.Microsoft.Azure.ManagedInstance.CollectionRule.ResourcePool.MemoryGrantsSecMicrosoft.Azure.ManagedInstance.ResourcePoolPerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.ResourcePool.MemoryGrantTimeoutsSecAzure SQL DB Managed Instance: Number of query memory grant timeouts per second occurring in the resource poolThe rule collects the "Memory grant timeouts/sec" performance counter for each resource pool of Managed Instance.Microsoft.Azure.ManagedInstance.CollectionRule.ResourcePool.MemoryGrantTimeoutsSecMicrosoft.Azure.ManagedInstance.ResourcePoolPerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.ResourcePool.PendingMemoryGrantsCountAzure SQL DB Managed Instance: Number of queries waiting for memory grants in the resource pool.The rule collects the "Pending memory grants count" performance counter for each resource pool ofmanaged Instance.Microsoft.Azure.ManagedInstance.CollectionRule.ResourcePool.PendingMemoryGrantsCountMicrosoft.Azure.ManagedInstance.ResourcePoolPerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.ResourcePool.QueryExecMemoryTargetKBAzure SQL DB Managed Instance: Current memory target for query execution memory grant (KB)The rule collects the "Query exec memory target (KB)" performance counter for each resource pool of Managed Instance.Microsoft.Azure.ManagedInstance.CollectionRule.ResourcePool.QueryExecMemoryTargetKBMicrosoft.Azure.ManagedInstance.ResourcePoolPerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.ResourcePool.TargetMemoryKBAzure SQL DB Managed Instance: Target amount of memory the resource pool is trying to attain based on the settings and server state (KB)The rule collects the Windows "Target memory (KB)" performance counter for each resource pool of Managed Instance.Microsoft.Azure.ManagedInstance.CollectionRule.ResourcePool.TargetMemoryKBMicrosoft.Azure.ManagedInstance.ResourcePoolPerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.ResourcePool.UsedMemoryKBAzure SQL DB Managed Instance: Used amount of memory in the resource pool (KB)The rule collects the "Used memory (KB)" performance counter for each resource pool of Managed Instance.Microsoft.Azure.ManagedInstance.CollectionRule.ResourcePool.UsedMemoryKBMicrosoft.Azure.ManagedInstance.ResourcePoolPerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.UserResourcePool.MemoryConsumptionMBAzure SQL DB Managed Instance: User Resource Pool Memory Consumption (MB)The rule collects the amount of memory used by the resource pool (in Megabytes).Microsoft.Azure.ManagedInstance.CollectionRule.UserResourcePool.MemoryConsumptionMBMicrosoft.Azure.ManagedInstance.UserResourcePoolPerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.CollectionRule.UserResourcePool.MemoryConsumptionPercentAzure SQL DB Managed Instance: User Resource Pool Memory Consumption (\%)The rule collects the amount of memory used by the resource pool, expressed as a percentage of memory available for Memory-Optimized Data tables for the given Resource Pool.Microsoft.Azure.ManagedInstance.CollectionRule.UserResourcePool.MemoryConsumptionPercentMicrosoft.Azure.ManagedInstance.UserResourcePoolPerformanceCollectionTrue00FalseTrue
Microsoft.Azure.ManagedInstance.Rule.MonitoringPoolAlertCollection.MonitoringErrorAzure SQL DB Managed Instance: Monitoring errorThe rule traces monitoring workflows’ errors and generates error alerts.Microsoft.Azure.ManagedInstance.Rule.MonitoringPoolAlertCollection.MonitoringErrorMicrosoft.Azure.ManagedInstance.MonitoringPoolAlertCollectionAlertTrue00TrueErrorNormalTrueOperations Manager
Microsoft.Azure.ManagedInstance.Rule.MonitoringPoolAlertCollection.MonitoringWarningAzure SQL DB Managed Instance: Monitoring warningThe rule traces monitoring workflows’ warnings and generates warning alerts.Microsoft.Azure.ManagedInstance.Rule.MonitoringPoolAlertCollection.MonitoringWarningMicrosoft.Azure.ManagedInstance.MonitoringPoolAlertCollectionAlertTrue00TrueWarningNormalTrueOperations Manager