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

OperationListResult

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.

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.

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

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

Operation[]

List of SQL operations supported by the SQL resource provider.