Servers Databases
Link to resource definition: Microsoft.Sql/servers/databases
| Default Path | Alias |
|---|---|
managedBy |
Microsoft.Sql/servers/databases/managedBy |
properties.autoPauseDelay |
Microsoft.Sql/servers/databases/autoPauseDelay |
properties.availabilityZone |
Microsoft.Sql/servers/databases/availabilityZone |
properties.catalogCollation |
Microsoft.Sql/servers/databases/catalogCollation |
properties.collation |
Microsoft.Sql/servers/databases/collation |
properties.containmentState |
Microsoft.Sql/servers/databases/containmentState |
properties.createMode |
Microsoft.Sql/servers/databases/createMode |
properties.creationDate |
Microsoft.Sql/servers/databases/creationDate |
properties.currentBackupStorageRedundancy |
Microsoft.Sql/servers/databases/currentBackupStorageRedundancy |
properties.currentServiceObjectiveId |
Microsoft.Sql/servers/databases/currentServiceObjectiveId |
properties.currentServiceObjectiveName |
Microsoft.Sql/servers/databases/currentServiceObjectiveName |
properties.currentSku |
Microsoft.Sql/servers/databases/currentSku |
properties.currentSku.capacity |
Microsoft.Sql/servers/databases/currentSku.capacity |
properties.currentSku.family |
Microsoft.Sql/servers/databases/currentSku.family |
properties.currentSku.name |
Microsoft.Sql/servers/databases/currentSku.name |
properties.currentSku.size |
Microsoft.Sql/servers/databases/currentSku.size |
properties.currentSku.tier |
Microsoft.Sql/servers/databases/currentSku.tier |
properties.databaseId |
Microsoft.Sql/servers/databases/databaseId |
properties.defaultSecondaryLocation |
Microsoft.Sql/servers/databases/defaultSecondaryLocation |
properties.earliestRestoreDate |
Microsoft.Sql/servers/databases/earliestRestoreDate |
properties.elasticPoolId |
Microsoft.Sql/servers/databases/elasticPoolId |
properties.elasticPoolName |
Microsoft.Sql/servers/databases/elasticPoolName |
properties.encryptionProtector |
Microsoft.Sql/servers/databases/encryptionProtector |
properties.encryptionProtectorAutoRotation |
Microsoft.Sql/servers/databases/encryptionProtectorAutoRotation |
properties.failoverGroupId |
Microsoft.Sql/servers/databases/failoverGroupId |
properties.federatedClientId |
Microsoft.Sql/servers/databases/federatedClientId |
properties.freeLimitExhaustionBehavior |
Microsoft.Sql/servers/databases/freeLimitExhaustionBehavior |
properties.highAvailabilityReplicaCount |
Microsoft.Sql/servers/databases/highAvailabilityReplicaCount |
properties.isInfraEncryptionEnabled |
Microsoft.Sql/servers/databases/isInfraEncryptionEnabled |
properties.isLedgerOn |
Microsoft.Sql/servers/databases/isLedgerOn |
properties.keys |
Microsoft.Sql/servers/databases/keys |
properties.licenseType |
Microsoft.Sql/servers/databases/licenseType |
properties.longTermRetentionBackupResourceId |
Microsoft.Sql/servers/databases/longTermRetentionBackupResourceId |
properties.maintenanceConfigurationId |
Microsoft.Sql/servers/databases/maintenanceConfigurationId |
properties.manualCutover |
Microsoft.Sql/servers/databases/manualCutover |
properties.maxLogSizeBytes |
Microsoft.Sql/servers/databases/maxLogSizeBytes |
properties.maxSizeBytes |
Microsoft.Sql/servers/databases/maxSizeBytes |
properties.minCapacity |
Microsoft.Sql/servers/databases/minCapacity |
properties.pausedDate |
Microsoft.Sql/servers/databases/pausedDate |
properties.performCutover |
Microsoft.Sql/servers/databases/performCutover |
properties.preferredEnclaveType |
Microsoft.Sql/servers/databases/preferredEnclaveType |
properties.primaryDelegatedIdentityClientId |
Microsoft.Sql/servers/databases/primaryDelegatedIdentityClientId |
properties.readReplicaCount |
Microsoft.Sql/servers/databases/readReplicaCount |
properties.readScale |
Microsoft.Sql/servers/databases/readScale |
properties.recommendedIndex |
Microsoft.Sql/servers/databases/recommendedIndex |
properties.recommendedIndex[*] |
Microsoft.Sql/servers/databases/recommendedIndex[*] |
properties.recommendedIndex[*].id |
Microsoft.Sql/servers/databases/recommendedIndex[*].id |
properties.recommendedIndex[*].name |
Microsoft.Sql/servers/databases/recommendedIndex[*].name |
properties.recommendedIndex[*].properties.action |
Microsoft.Sql/servers/databases/recommendedIndex[*].action |
properties.recommendedIndex[*].properties.columns |
Microsoft.Sql/servers/databases/recommendedIndex[*].columns |
properties.recommendedIndex[*].properties.columns[*] |
Microsoft.Sql/servers/databases/recommendedIndex[*].columns[*] |
properties.recommendedIndex[*].properties.created |
Microsoft.Sql/servers/databases/recommendedIndex[*].created |
properties.recommendedIndex[*].properties.estimatedImpact |
Microsoft.Sql/servers/databases/recommendedIndex[*].estimatedImpact |
properties.recommendedIndex[*].properties.estimatedImpact[*] |
Microsoft.Sql/servers/databases/recommendedIndex[*].estimatedImpact[*] |
properties.recommendedIndex[*].properties.estimatedImpact[*].changeValueAbsolute |
Microsoft.Sql/servers/databases/recommendedIndex[*].estimatedImpact[*].changeValueAbsolute |
properties.recommendedIndex[*].properties.estimatedImpact[*].changeValueRelative |
Microsoft.Sql/servers/databases/recommendedIndex[*].estimatedImpact[*].changeValueRelative |
properties.recommendedIndex[*].properties.estimatedImpact[*].name |
Microsoft.Sql/servers/databases/recommendedIndex[*].estimatedImpact[*].name |
properties.recommendedIndex[*].properties.estimatedImpact[*].unit |
Microsoft.Sql/servers/databases/recommendedIndex[*].estimatedImpact[*].unit |
properties.recommendedIndex[*].properties.includedColumns |
Microsoft.Sql/servers/databases/recommendedIndex[*].includedColumns |
properties.recommendedIndex[*].properties.includedColumns[*] |
Microsoft.Sql/servers/databases/recommendedIndex[*].includedColumns[*] |
properties.recommendedIndex[*].properties.indexScript |
Microsoft.Sql/servers/databases/recommendedIndex[*].indexScript |
properties.recommendedIndex[*].properties.indexType |
Microsoft.Sql/servers/databases/recommendedIndex[*].indexType |
properties.recommendedIndex[*].properties.lastModified |
Microsoft.Sql/servers/databases/recommendedIndex[*].lastModified |
properties.recommendedIndex[*].properties.reportedImpact |
Microsoft.Sql/servers/databases/recommendedIndex[*].reportedImpact |
properties.recommendedIndex[*].properties.reportedImpact[*] |
Microsoft.Sql/servers/databases/recommendedIndex[*].reportedImpact[*] |
properties.recommendedIndex[*].properties.reportedImpact[*].changeValueAbsolute |
Microsoft.Sql/servers/databases/recommendedIndex[*].reportedImpact[*].changeValueAbsolute |
properties.recommendedIndex[*].properties.reportedImpact[*].changeValueRelative |
Microsoft.Sql/servers/databases/recommendedIndex[*].reportedImpact[*].changeValueRelative |
properties.recommendedIndex[*].properties.reportedImpact[*].name |
Microsoft.Sql/servers/databases/recommendedIndex[*].reportedImpact[*].name |
properties.recommendedIndex[*].properties.reportedImpact[*].unit |
Microsoft.Sql/servers/databases/recommendedIndex[*].reportedImpact[*].unit |
properties.recommendedIndex[*].properties.schema |
Microsoft.Sql/servers/databases/recommendedIndex[*].schema |
properties.recommendedIndex[*].properties.state |
Microsoft.Sql/servers/databases/recommendedIndex[*].state |
properties.recommendedIndex[*].properties.table |
Microsoft.Sql/servers/databases/recommendedIndex[*].table |
properties.recommendedIndex[*].type |
Microsoft.Sql/servers/databases/recommendedIndex[*].type |
properties.recoverableDatabaseId |
Microsoft.Sql/servers/databases/recoverableDatabaseId |
properties.recoveryServicesRecoveryPointId |
Microsoft.Sql/servers/databases/recoveryServicesRecoveryPointId |
properties.recoveryServicesRecoveryPointResourceId |
Microsoft.Sql/servers/databases/recoveryServicesRecoveryPointResourceId |
properties.requestedBackupStorageRedundancy |
Microsoft.Sql/servers/databases/storageAccountType |
properties.requestedBackupStorageRedundancy |
Microsoft.Sql/servers/databases/requestedBackupStorageRedundancy |
properties.requestedServiceObjectiveId |
Microsoft.Sql/servers/databases/requestedServiceObjectiveId |
properties.requestedServiceObjectiveName |
Microsoft.Sql/servers/databases/requestedServiceObjectiveName.v2 |
properties.restorableDroppedDatabaseId |
Microsoft.Sql/servers/databases/restorableDroppedDatabaseId |
properties.restorePointInTime |
Microsoft.Sql/servers/databases/restorePointInTime |
properties.resumedDate |
Microsoft.Sql/servers/databases/resumedDate |
properties.sampleName |
Microsoft.Sql/servers/databases/sampleName |
properties.secondaryType |
Microsoft.Sql/servers/databases/secondaryType |
properties.serviceLevelObjective |
Microsoft.Sql/servers/databases/serviceLevelObjective |
properties.serviceTierAdvisors |
Microsoft.Sql/servers/databases/serviceTierAdvisors |
properties.serviceTierAdvisors[*] |
Microsoft.Sql/servers/databases/serviceTierAdvisors[*] |
properties.serviceTierAdvisors[*].id |
Microsoft.Sql/servers/databases/serviceTierAdvisors[*].id |
properties.serviceTierAdvisors[*].name |
Microsoft.Sql/servers/databases/serviceTierAdvisors[*].name |
properties.serviceTierAdvisors[*].properties.activeTimeRatio |
Microsoft.Sql/servers/databases/serviceTierAdvisors[*].activeTimeRatio |
properties.serviceTierAdvisors[*].properties.avgDtu |
Microsoft.Sql/servers/databases/serviceTierAdvisors[*].avgDtu |
properties.serviceTierAdvisors[*].properties.confidence |
Microsoft.Sql/servers/databases/serviceTierAdvisors[*].confidence |
properties.serviceTierAdvisors[*].properties.currentServiceLevelObjective |
Microsoft.Sql/servers/databases/serviceTierAdvisors[*].currentServiceLevelObjective |
properties.serviceTierAdvisors[*].properties.currentServiceLevelObjectiveId |
Microsoft.Sql/servers/databases/serviceTierAdvisors[*].currentServiceLevelObjectiveId |
properties.serviceTierAdvisors[*].properties.databaseSizeBasedRecommendationServiceLevelObjective |
Microsoft.Sql/servers/databases/serviceTierAdvisors[*].databaseSizeBasedRecommendationServiceLevelObjective |
properties.serviceTierAdvisors[*].properties.databaseSizeBasedRecommendationServiceLevelObjectiveId |
Microsoft.Sql/servers/databases/serviceTierAdvisors[*].databaseSizeBasedRecommendationServiceLevelObjectiveId |
properties.serviceTierAdvisors[*].properties.disasterPlanBasedRecommendationServiceLevelObjective |
Microsoft.Sql/servers/databases/serviceTierAdvisors[*].disasterPlanBasedRecommendationServiceLevelObjective |
properties.serviceTierAdvisors[*].properties.disasterPlanBasedRecommendationServiceLevelObjectiveId |
Microsoft.Sql/servers/databases/serviceTierAdvisors[*].disasterPlanBasedRecommendationServiceLevelObjectiveId |
properties.serviceTierAdvisors[*].properties.maxDtu |
Microsoft.Sql/servers/databases/serviceTierAdvisors[*].maxDtu |
properties.serviceTierAdvisors[*].properties.maxSizeInGB |
Microsoft.Sql/servers/databases/serviceTierAdvisors[*].maxSizeInGB |
properties.serviceTierAdvisors[*].properties.minDtu |
Microsoft.Sql/servers/databases/serviceTierAdvisors[*].minDtu |
properties.serviceTierAdvisors[*].properties.observationPeriodEnd |
Microsoft.Sql/servers/databases/serviceTierAdvisors[*].observationPeriodEnd |
properties.serviceTierAdvisors[*].properties.observationPeriodStart |
Microsoft.Sql/servers/databases/serviceTierAdvisors[*].observationPeriodStart |
properties.serviceTierAdvisors[*].properties.overallRecommendationServiceLevelObjective |
Microsoft.Sql/servers/databases/serviceTierAdvisors[*].overallRecommendationServiceLevelObjective |
properties.serviceTierAdvisors[*].properties.overallRecommendationServiceLevelObjectiveId |
Microsoft.Sql/servers/databases/serviceTierAdvisors[*].overallRecommendationServiceLevelObjectiveId |
properties.serviceTierAdvisors[*].properties.serviceLevelObjectiveUsageMetrics |
Microsoft.Sql/servers/databases/serviceTierAdvisors[*].serviceLevelObjectiveUsageMetrics |
properties.serviceTierAdvisors[*].properties.serviceLevelObjectiveUsageMetrics[*] |
Microsoft.Sql/servers/databases/serviceTierAdvisors[*].serviceLevelObjectiveUsageMetrics[*] |
properties.serviceTierAdvisors[*].properties.serviceLevelObjectiveUsageMetrics[*].inRangeTimeRatio |
Microsoft.Sql/servers/databases/serviceTierAdvisors[*].serviceLevelObjectiveUsageMetrics[*].inRangeTimeRatio |
properties.serviceTierAdvisors[*].properties.serviceLevelObjectiveUsageMetrics[*].serviceLevelObjective |
Microsoft.Sql/servers/databases/serviceTierAdvisors[*].serviceLevelObjectiveUsageMetrics[*].serviceLevelObjective |
properties.serviceTierAdvisors[*].properties.serviceLevelObjectiveUsageMetrics[*].serviceLevelObjectiveId |
Microsoft.Sql/servers/databases/serviceTierAdvisors[*].serviceLevelObjectiveUsageMetrics[*].serviceLevelObjectiveId |
properties.serviceTierAdvisors[*].properties.usageBasedRecommendationServiceLevelObjective |
Microsoft.Sql/servers/databases/serviceTierAdvisors[*].usageBasedRecommendationServiceLevelObjective |
properties.serviceTierAdvisors[*].properties.usageBasedRecommendationServiceLevelObjectiveId |
Microsoft.Sql/servers/databases/serviceTierAdvisors[*].usageBasedRecommendationServiceLevelObjectiveId |
properties.serviceTierAdvisors[*].type |
Microsoft.Sql/servers/databases/serviceTierAdvisors[*].type |
properties.sourceDatabaseDeletionDate |
Microsoft.Sql/servers/databases/sourceDatabaseDeletionDate |
properties.sourceDatabaseId |
Microsoft.Sql/servers/databases/sourceDatabaseId |
properties.sourceResourceId |
Microsoft.Sql/servers/databases/sourceResourceId |
properties.status |
Microsoft.Sql/servers/databases/status |
properties.transparentDataEncryption |
Microsoft.Sql/servers/databases/transparentDataEncryption |
properties.transparentDataEncryption[*] |
Microsoft.Sql/servers/databases/transparentDataEncryption[*] |
properties.transparentDataEncryption[*].id |
Microsoft.Sql/servers/databases/transparentDataEncryption[*].id |
properties.transparentDataEncryption[*].location |
Microsoft.Sql/servers/databases/transparentDataEncryption[*].location |
properties.transparentDataEncryption[*].name |
Microsoft.Sql/servers/databases/transparentDataEncryption[*].name |
properties.transparentDataEncryption[*].properties.status |
Microsoft.Sql/servers/databases/transparentDataEncryption[*].status |
properties.transparentDataEncryption[*].type |
Microsoft.Sql/servers/databases/transparentDataEncryption[*].type |
properties.useFreeLimit |
Microsoft.Sql/servers/databases/useFreeLimit |
properties.zoneRedundant |
Microsoft.Sql/servers/databases/zoneRedundant |
sku |
Microsoft.Sql/servers/databases/sku |
sku.capacity |
Microsoft.Sql/servers/databases/sku.capacity |
sku.family |
Microsoft.Sql/servers/databases/sku.family |
sku.name |
Microsoft.Sql/servers/databases/sku.name |
sku.name |
Microsoft.Sql/servers/databases/requestedServiceObjectiveName |
sku.size |
Microsoft.Sql/servers/databases/sku.size |
sku.tier |
Microsoft.Sql/servers/databases/sku.tier |
sku.tier |
Microsoft.Sql/servers/databases/edition |