Operations - List
Lists all of the available SQL Rest API operations.
GET https://management.azure.com/providers/Microsoft.Sql/operations?api-version=2014-04-01
URI Parameters
Name | In | Required | Type | Description |
---|---|---|---|---|
api-version
|
query | True |
string |
The API version to use for the request. |
Responses
Name | Type | Description |
---|---|---|
200 OK |
OK. The request has succeeded. |
Examples
Get a list of operations for a resource provider
Sample request
GET https://management.azure.com/providers/Microsoft.Sql/operations?api-version=2014-04-01
Sample response
{
"value": [
{
"name": "Microsoft.Sql/servers/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Server",
"operation": "Get server details"
}
},
{
"name": "Microsoft.Sql/servers/write",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Server",
"operation": "Create new or update existing server"
}
},
{
"name": "Microsoft.Sql/servers/delete",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Server",
"operation": "Delete existing server"
}
},
{
"name": "Microsoft.Sql/servers/import/action",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Server",
"operation": "Create new database from DacPac"
}
},
{
"name": "Microsoft.Sql/servers/upgrade/action",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Server",
"operation": "Upgrade server version"
}
},
{
"name": "Microsoft.Sql/servers/firewallRules/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Server Firewall Rule",
"operation": "Get server firewall rules"
}
},
{
"name": "Microsoft.Sql/servers/firewallRules/write",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Server Firewall Rule",
"operation": "Create new or update existing server firewall rule"
}
},
{
"name": "Microsoft.Sql/servers/firewallRules/delete",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Server Firewall Rule",
"operation": "Delete server firewall rule"
}
},
{
"name": "Microsoft.Sql/servers/administrators/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "The server administrator",
"operation": "Get server administrator"
}
},
{
"name": "Microsoft.Sql/servers/administrators/write",
"display": {
"provider": "Microsoft SQL Database",
"resource": "The server administrator",
"operation": "Create new or update existing server administrator"
}
},
{
"name": "Microsoft.Sql/servers/administrators/delete",
"display": {
"provider": "Microsoft SQL Database",
"resource": "The server administrator",
"operation": "Delete server administrator"
}
},
{
"name": "Microsoft.Sql/servers/administratorOperationResults/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "The server administrator operation results",
"operation": "Get server administrator operation results"
}
},
{
"name": "Microsoft.Sql/servers/serviceObjectives/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Service Level Objective",
"operation": "Get service level objectives"
}
},
{
"name": "Microsoft.Sql/servers/restorableDroppedDatabases/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Restorable Dropped Database",
"operation": "Get list of restorable dropped databases"
}
},
{
"name": "Microsoft.Sql/servers/recoverableDatabases/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Recoverable Database",
"operation": "Get the last known database recovery point"
}
},
{
"name": "Microsoft.Sql/servers/importExportOperationResults/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Server Database Import Operation Result",
"operation": "Get details about database import operation on the server"
}
},
{
"name": "Microsoft.Sql/servers/operationResults/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Server Upgrade Operation Result",
"operation": "Get status of server upgrade operation"
}
},
{
"name": "Microsoft.Sql/servers/operationResults/delete",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Server Upgrade Operation Result",
"operation": "Cancel server upgrade"
}
},
{
"name": "Microsoft.Sql/servers/usages/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Server Usage",
"operation": "Get server usage details"
}
},
{
"name": "Microsoft.Sql/servers/recommendedElasticPools/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Recommended Elastic Database Pool",
"operation": "Get recommended elastic database pools"
}
},
{
"name": "Microsoft.Sql/servers/recommendedElasticPools/databases/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Recommended Elastic Pool Databases",
"operation": "Get recommended elastic pools databases"
}
},
{
"name": "Microsoft.Sql/servers/recommendedElasticPools/metrics/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Recommended Elastic Database Pool Metrics",
"operation": "Get recommended elastic database pools metrics"
}
},
{
"name": "Microsoft.Sql/servers/disasterRecoveryConfiguration/operationResults/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Server Disaster Recovery Configuration Operation Results",
"operation": "Retrieve result for Operation Results on a Disaster Recovery Configuration"
}
},
{
"name": "Microsoft.Sql/servers/advisors/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Server advisor",
"operation": "Get advisors for a server"
}
},
{
"name": "Microsoft.Sql/servers/advisors/write",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Server advisor",
"operation": "Update auto-execute status of a server advisor"
}
},
{
"name": "Microsoft.Sql/servers/advisors/recommendedActions/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Returns list of recommended actions of specified advisor for the server",
"operation": "Get recommended actions of a server"
}
},
{
"name": "Microsoft.Sql/servers/advisors/recommendedActions/write",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Returns list of recommended actions of specified advisor for the server",
"operation": "Update server recommended action state."
}
},
{
"name": "Microsoft.Sql/servers/elasticPoolEstimates/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Elastic pool estimate",
"operation": "Get elastic pool estimates of a server"
}
},
{
"name": "Microsoft.Sql/servers/elasticPoolEstimates/write",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Elastic pool estimate",
"operation": "Create an elastic pool estimate."
}
},
{
"name": "Microsoft.Sql/servers/databases/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database",
"operation": "Get server details"
}
},
{
"name": "Microsoft.Sql/servers/databases/write",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database",
"operation": "Create new or update existing server"
}
},
{
"name": "Microsoft.Sql/servers/databases/delete",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database",
"operation": "Delete existing server"
}
},
{
"name": "Microsoft.Sql/servers/databases/export/action",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database",
"operation": "Create new database from DacPac"
}
},
{
"name": "Microsoft.Sql/servers/databases/usages/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Usage",
"operation": "Get database usage details"
}
},
{
"name": "Microsoft.Sql/servers/databases/operationResults/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Operation Result",
"operation": "Get status of database operation"
}
},
{
"name": "Microsoft.Sql/servers/databases/importExportOperationResults/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Import/Export Operation Result",
"operation": "Get details about database import or export operation on the server"
}
},
{
"name": "Microsoft.Sql/servers/databases/replicationLinks/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Replication Link",
"operation": "Get database replication links"
}
},
{
"name": "Microsoft.Sql/servers/databases/replicationLinks/delete",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Replication Link",
"operation": "Force-terminate the replication relationship"
}
},
{
"name": "Microsoft.Sql/servers/databases/replicationLinks/unlink/action",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Replication Link",
"operation": "Terminate the replication relationship"
}
},
{
"name": "Microsoft.Sql/servers/databases/replicationLinks/failover/action",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Replication Link",
"operation": "Failover replication relationship after synchronizing"
}
},
{
"name": "Microsoft.Sql/servers/databases/replicationLinks/forceFailoverAllowDataLoss/action",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Replication Link",
"operation": "Failover replication relationship immediately"
}
},
{
"name": "Microsoft.Sql/servers/databases/replicationLinks/updateReplicationMode/action",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Replication Link",
"operation": "Update replication mode for link"
}
},
{
"name": "Microsoft.Sql/servers/databases/replicationLinks/operationResults/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Replication Link Operation Result",
"operation": "Get status of replication link operations"
}
},
{
"name": "Microsoft.Sql/servers/databases/providers/Microsoft.Insights/metricDefinitions/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Metric Definition",
"operation": "Get database metric definitions"
},
"properties": {
"serviceSpecification": {
"metricSpecifications": [
{
"name": "cpu_percent",
"displayName": "CPU percentage",
"displayDescription": "CPU percentage",
"unit": "Percent",
"aggregationType": "Average",
"fillGapWithZero": true
},
{
"name": "physical_data_read_percent",
"displayName": "Data IO percentage",
"displayDescription": "Data IO percentage",
"unit": "Percent",
"aggregationType": "Average",
"fillGapWithZero": true
},
{
"name": "log_write_percent",
"displayName": "Log IO percentage",
"displayDescription": "Log IO percentage",
"unit": "Percent",
"aggregationType": "Average",
"metricFilterPattern": "^((?!datawarehouse).)*$",
"fillGapWithZero": true
},
{
"name": "dtu_consumption_percent",
"displayName": "DTU percentage",
"displayDescription": "DTU percentage",
"unit": "Percent",
"aggregationType": "Average",
"metricFilterPattern": "^((?!datawarehouse).)*$",
"fillGapWithZero": true
},
{
"name": "storage",
"displayName": "Total database size",
"displayDescription": "Total database size",
"unit": "Bytes",
"aggregationType": "Maximum"
},
{
"name": "connection_successful",
"displayName": "Successful Connections",
"displayDescription": "Successful Connections",
"unit": "Count",
"aggregationType": "Total",
"fillGapWithZero": true
},
{
"name": "connection_failed",
"displayName": "Failed Connections",
"displayDescription": "Failed Connections",
"unit": "Count",
"aggregationType": "Total",
"fillGapWithZero": true
},
{
"name": "blocked_by_firewall",
"displayName": "Blocked by Firewall",
"displayDescription": "Blocked by Firewall",
"unit": "Count",
"aggregationType": "Total",
"fillGapWithZero": true
},
{
"name": "deadlock",
"displayName": "Deadlocks",
"displayDescription": "Deadlocks",
"unit": "Count",
"aggregationType": "Total",
"metricFilterPattern": "^((?!datawarehouse).)*$",
"fillGapWithZero": true
},
{
"name": "storage_percent",
"displayName": "Database size percentage",
"displayDescription": "Database size percentage",
"unit": "Percent",
"aggregationType": "Maximum",
"metricFilterPattern": "^((?!datawarehouse).)*$"
},
{
"name": "xtp_storage_percent",
"displayName": "In-Memory OLTP storage percent",
"displayDescription": "In-Memory OLTP storage percent",
"unit": "Percent",
"aggregationType": "Average",
"metricFilterPattern": "^((?!datawarehouse).)*$",
"fillGapWithZero": true
},
{
"name": "workers_percent",
"displayName": "Workers percentage",
"displayDescription": "Workers percentage",
"unit": "Percent",
"aggregationType": "Average",
"metricFilterPattern": "^((?!datawarehouse).)*$",
"fillGapWithZero": true
},
{
"name": "sessions_percent",
"displayName": "Sessions percentage",
"displayDescription": "Sessions percentage",
"unit": "Percent",
"aggregationType": "Average",
"metricFilterPattern": "^((?!datawarehouse).)*$",
"fillGapWithZero": true
},
{
"name": "dtu_limit",
"displayName": "DTU Limit",
"displayDescription": "DTU Limit",
"unit": "Count",
"aggregationType": "Average",
"metricFilterPattern": "^((?!datawarehouse).)*$"
},
{
"name": "dtu_used",
"displayName": "DTU used",
"displayDescription": "DTU used",
"unit": "Count",
"aggregationType": "Average",
"metricFilterPattern": "^((?!datawarehouse).)*$",
"fillGapWithZero": true
},
{
"name": "dwu_limit",
"displayName": "DWU limit",
"displayDescription": "DWU limit",
"unit": "Count",
"aggregationType": "Maximum",
"metricFilterPattern": ".*datawarehouse.*$"
},
{
"name": "dwu_consumption_percent",
"displayName": "DWU percentage",
"displayDescription": "DWU percentage",
"unit": "Percent",
"aggregationType": "Maximum",
"metricFilterPattern": ".*datawarehouse.*$",
"fillGapWithZero": true
},
{
"name": "dwu_used",
"displayName": "DWU used",
"displayDescription": "DWU used",
"unit": "Count",
"aggregationType": "Maximum",
"metricFilterPattern": ".*datawarehouse.*$",
"fillGapWithZero": true
}
]
}
}
},
{
"name": "Microsoft.Sql/servers/databases/metrics/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Metric",
"operation": "Get database resource consumption metrics"
}
},
{
"name": "Microsoft.Sql/servers/databases/providers/Microsoft.Insights/diagnosticSettings/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Diagnostic Settings",
"operation": "Read diagnostic setting"
}
},
{
"name": "Microsoft.Sql/servers/databases/providers/Microsoft.Insights/diagnosticSettings/write",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Diagnostic Settings",
"operation": "Write diagnostic setting"
}
},
{
"name": "Microsoft.Sql/servers/databases/providers/Microsoft.Insights/logDefinitions/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "The log definition of databases",
"operation": "Read databases log definitions"
},
"properties": {
"serviceSpecification": {
"logSpecifications": [
{
"name": "QueryStore",
"displayName": "Query Store",
"blobDuration": "PT1H"
}
]
}
}
},
{
"name": "Microsoft.Sql/servers/databases/missingindexes/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Index Advisor",
"operation": "Get recommended database indexes"
}
},
{
"name": "Microsoft.Sql/servers/databases/missingindexes/write",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Index Advisor",
"operation": "Apply recommended database index"
}
},
{
"name": "Microsoft.Sql/servers/databases/schemas/tables/recommendedIndexes/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Recommended Index",
"operation": "Get list of index recommendations"
}
},
{
"name": "Microsoft.Sql/servers/databases/schemas/tables/recommendedIndexes/write",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Recommended Index",
"operation": "Update Recommended Index State"
}
},
{
"name": "Microsoft.Sql/servers/databases/schemas/tables/columns/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database table column",
"operation": "Get columns"
}
},
{
"name": "Microsoft.Sql/servers/databases/queryStore/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Query Store settings",
"operation": "Get Query Store settings"
}
},
{
"name": "Microsoft.Sql/servers/databases/queryStore/write",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Query Store settings",
"operation": "Update Query Store settings"
}
},
{
"name": "Microsoft.Sql/servers/databases/topQueries/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Top Queries",
"operation": "Get Top Queries for the database"
}
},
{
"name": "Microsoft.Sql/servers/databases/topQueries/statistics/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Top Queries Statistics",
"operation": "Get Database Top Queries statistics"
}
},
{
"name": "Microsoft.Sql/servers/databases/topQueries/queryText/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Top Queries query text",
"operation": "Get Database Top Queries query text"
}
},
{
"name": "Microsoft.Sql/servers/databases/serviceTierAdvisors/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Service Tier Advisor",
"operation": "Get recommended database performance level"
}
},
{
"name": "Microsoft.Sql/servers/databases/transparentDataEncryption/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Transparent Data Encryption",
"operation": "Get database transparent data encryption details"
}
},
{
"name": "Microsoft.Sql/servers/databases/transparentDataEncryption/write",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Transparent Data Encryption",
"operation": "Change transparent data encryption state"
}
},
{
"name": "Microsoft.Sql/servers/databases/transparentDataEncryption/operationResults/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Transparent Data Encryption",
"operation": "Get database transparent data encryption details"
}
},
{
"name": "Microsoft.Sql/servers/databases/auditingPolicies/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Table Auditing Policy",
"operation": "Get database table auditing policy"
}
},
{
"name": "Microsoft.Sql/servers/databases/auditingPolicies/write",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Table Auditing Policy",
"operation": "Set database table auditing policy"
}
},
{
"name": "Microsoft.Sql/servers/auditingPolicies/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Default Server Table Auditing Policy",
"operation": "Get default server table auditing policy"
}
},
{
"name": "Microsoft.Sql/servers/auditingPolicies/write",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Default Server Table Auditing Policy",
"operation": "Set default server table auditing policy"
}
},
{
"name": "Microsoft.Sql/servers/databases/auditingSettings/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Blob Auditing Policy",
"operation": "Get database blob auditing policy"
}
},
{
"name": "Microsoft.Sql/servers/databases/auditingSettings/write",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Blob Auditing Policy",
"operation": "Set database blob auditing policy"
}
},
{
"name": "Microsoft.Sql/servers/auditingSettings/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Server Blob Auditing Policy",
"operation": "Get server blob auditing policy"
}
},
{
"name": "Microsoft.Sql/servers/auditingSettings/write",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Server Blob Auditing Policy",
"operation": "Set server blob auditing policy"
}
},
{
"name": "Microsoft.Sql/servers/auditingSettings/operationResults/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Server Blob Auditing Operation Results",
"operation": "Get server blob auditing operation results"
}
},
{
"name": "Microsoft.Sql/servers/databases/auditRecords/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Blob Audit Records",
"operation": "Get database blob audit records"
}
},
{
"name": "Microsoft.Sql/servers/databases/connectionPolicies/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Connection Policy",
"operation": "Get database connection policy"
}
},
{
"name": "Microsoft.Sql/servers/databases/connectionPolicies/write",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Connection Policy",
"operation": "Set database connection policy"
}
},
{
"name": "Microsoft.Sql/servers/databases/dataMaskingPolicies/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Data Masking Policy",
"operation": "Get database data masking policy"
}
},
{
"name": "Microsoft.Sql/servers/databases/dataMaskingPolicies/write",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Data Masking Policy",
"operation": "Set database data masking policy"
}
},
{
"name": "Microsoft.Sql/servers/databases/dataMaskingPolicies/rules/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Data Masking Policy Rule",
"operation": "Get database data masking policy rule"
}
},
{
"name": "Microsoft.Sql/servers/databases/dataMaskingPolicies/rules/write",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Data Masking Policy Rule",
"operation": "Set database data masking policy rule"
}
},
{
"name": "Microsoft.Sql/servers/databases/securityAlertPolicies/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Threat Detection Policy",
"operation": "Get database threat detection policy"
}
},
{
"name": "Microsoft.Sql/servers/databases/securityAlertPolicies/write",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database Threat Detection Policy",
"operation": "Set threat detection auditing policy"
}
},
{
"name": "Microsoft.Sql/servers/securityAlertPolicies/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Server Threat Detection Policy",
"operation": "Get server threat detection policy"
}
},
{
"name": "Microsoft.Sql/servers/securityAlertPolicies/write",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Server Threat Detection Policy",
"operation": "Set server threat detection policy"
}
},
{
"name": "Microsoft.Sql/servers/securityAlertPolicies/operationResults/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Server Threat Detection Operation Results",
"operation": "Get server Threat Detection operation results"
}
},
{
"name": "Microsoft.Sql/servers/databases/VulnerabilityAssessmentScans/action",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Vulnerability Assessment Database Scan",
"operation": "Execute vulnerability assessment database scan"
}
},
{
"name": "Microsoft.Sql/servers/VulnerabilityAssessmentScans/action",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Vulnerability Assessment Server Scan",
"operation": "Execute vulnerability assessment server scan"
}
},
{
"name": "Microsoft.Sql/servers/databases/advisors/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database advisor",
"operation": "Get advisors for a database"
}
},
{
"name": "Microsoft.Sql/servers/databases/advisors/write",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database advisor",
"operation": "Update auto-execute status of a database advisor"
}
},
{
"name": "Microsoft.Sql/servers/databases/advisors/recommendedActions/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database recommended action",
"operation": "Get recommended actions for a database"
}
},
{
"name": "Microsoft.Sql/servers/databases/advisors/recommendedActions/write",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database recommended action",
"operation": "Update database recommended action state."
}
},
{
"name": "Microsoft.Sql/servers/elasticPools/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Elastic Database Pool",
"operation": "Get elastic database pool details"
}
},
{
"name": "Microsoft.Sql/servers/elasticPools/write",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Elastic Database Pool",
"operation": "Create new or update existing elastic database pool"
}
},
{
"name": "Microsoft.Sql/servers/elasticPools/delete",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Elastic Database Pool",
"operation": "Delete elastic database pool"
}
},
{
"name": "Microsoft.Sql/servers/elasticPools/databases/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database",
"operation": "Get elastic pool databases"
}
},
{
"name": "Microsoft.Sql/servers/elasticPools/elasticPoolActivity/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Elastic Database Pool Activity",
"operation": "Get elastic database pool activity"
}
},
{
"name": "Microsoft.Sql/servers/elasticPools/elasticPoolDatabaseActivity/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Elastic Pool Database Activity",
"operation": "Get elastic pool database activity"
}
},
{
"name": "Microsoft.Sql/servers/elasticPools/providers/Microsoft.Insights/metricDefinitions/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Elastic Database Pool Metric Definition",
"operation": "Get elastic pool metric definitions"
},
"properties": {
"serviceSpecification": {
"metricSpecifications": [
{
"name": "cpu_percent",
"displayName": "CPU percentage",
"displayDescription": "CPU percentage",
"unit": "Percent",
"aggregationType": "Average",
"fillGapWithZero": true
},
{
"name": "physical_data_read_percent",
"displayName": "Data IO percentage",
"displayDescription": "Data IO percentage",
"unit": "Percent",
"aggregationType": "Average",
"fillGapWithZero": true
},
{
"name": "log_write_percent",
"displayName": "Log IO percentage",
"displayDescription": "Log IO percentage",
"unit": "Percent",
"aggregationType": "Average",
"fillGapWithZero": true
},
{
"name": "dtu_consumption_percent",
"displayName": "DTU percentage",
"displayDescription": "DTU percentage",
"unit": "Percent",
"aggregationType": "Average",
"fillGapWithZero": true
},
{
"name": "storage_percent",
"displayName": "Storage percentage",
"displayDescription": "Storage percentage",
"unit": "Percent",
"aggregationType": "Average"
},
{
"name": "workers_percent",
"displayName": "Workers percentage",
"displayDescription": "Workers percentage",
"unit": "Percent",
"aggregationType": "Average",
"fillGapWithZero": true
},
{
"name": "sessions_percent",
"displayName": "Sessions percentage",
"displayDescription": "Sessions percentage",
"unit": "Percent",
"aggregationType": "Average",
"fillGapWithZero": true
},
{
"name": "eDTU_limit",
"displayName": "eDTU limit",
"displayDescription": "eDTU limit",
"unit": "Count",
"aggregationType": "Average"
},
{
"name": "storage_limit",
"displayName": "Storage limit",
"displayDescription": "Storage limit",
"unit": "Bytes",
"aggregationType": "Average"
},
{
"name": "eDTU_used",
"displayName": "eDTU used",
"displayDescription": "eDTU used",
"unit": "Count",
"aggregationType": "Average",
"fillGapWithZero": true
},
{
"name": "storage_used",
"displayName": "Storage used",
"displayDescription": "Storage used",
"unit": "Bytes",
"aggregationType": "Average"
},
{
"name": "xtp_storage_percent",
"displayName": "In-Memory OLTP storage percent",
"displayDescription": "In-Memory OLTP storage percent",
"unit": "Percent",
"aggregationType": "Average",
"fillGapWithZero": true
}
]
}
}
},
{
"name": "Microsoft.Sql/servers/elasticPools/metrics/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Elastic Database Pool Metric",
"operation": "Get elastic pool resource consumption metrics"
}
},
{
"name": "Microsoft.Sql/servers/elasticPools/operationResults/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Elastic Database Pool Operation Result",
"operation": "Get elastic database pool operation result"
}
},
{
"name": "Microsoft.Sql/servers/elasticPools/advisors/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Elastic pool advisor",
"operation": "Get advisors for an elastic pool"
}
},
{
"name": "Microsoft.Sql/servers/elasticPools/advisors/write",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Elastic pool advisor",
"operation": "Update auto-execute status of a elastic pool advisor"
}
},
{
"name": "Microsoft.Sql/servers/elasticPools/advisors/recommendedActions/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Elastic pool recommended action",
"operation": "Get recommended actions for an elastic pool"
}
},
{
"name": "Microsoft.Sql/servers/elasticPools/advisors/recommendedActions/write",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Elastic pool recommended action",
"operation": "Update elastic pool recommended action state."
}
},
{
"name": "Microsoft.Sql/servers/elasticPools/providers/Microsoft.Insights/diagnosticSettings/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Elastic Database Pool Diagnostic Settings",
"operation": "Read diagnostic setting"
}
},
{
"name": "Microsoft.Sql/servers/elasticPools/providers/Microsoft.Insights/diagnosticSettings/write",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Elastic Database Pool Diagnostic Settings",
"operation": "Write diagnostic setting"
}
},
{
"name": "Microsoft.Sql/servers/databases/pause/action",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database",
"operation": "Pause a database"
}
},
{
"name": "Microsoft.Sql/servers/databases/resume/action",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Database",
"operation": "Resume a database"
}
},
{
"name": "Microsoft.Sql/servers/databases/dataWarehouseQueries/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Data Warehouse Query",
"operation": "Get details about data warehouse query"
}
},
{
"name": "Microsoft.Sql/servers/databases/dataWarehouseQueries/dataWarehouseQuerySteps/read",
"display": {
"provider": "Microsoft SQL Database",
"resource": "Data Warehouse Query Step",
"operation": "Get details about data warehouse query step"
}
}
]
}
Definitions
Name | Description |
---|---|
Display |
Display metadata associated with the operation. |
Operation |
SQL REST API operation definition. |
Operation |
Result of the request to list SQL operations. It contains a list of operations and a URL link to get the next set of results. |
Display
Display metadata associated with the operation.
Name | Type | Description |
---|---|---|
operation |
string |
Type of operation: get, read, delete, etc. |
provider |
string |
Service provider: Microsoft SQL Database. |
resource |
string |
Resource on which the operation is performed: Server, Database, etc. |
Operation
SQL REST API operation definition.
Name | Type | Description |
---|---|---|
display |
Display metadata associated with the operation. |
|
name |
string |
Operation name: {provider}/{resource}/{operation} |
OperationListResult
Result of the request to list SQL operations. It contains a list of operations and a URL link to get the next set of results.
Name | Type | Description |
---|---|---|
nextLink |
string |
URL to get the next set of operation list results if there are any. |
value |
List of SQL operations supported by the SQL resource provider. |