Operations - List

Enumera todas las operaciones disponibles de la API rest de SQL.

GET https://management.azure.com/providers/Microsoft.Sql/operations?api-version=2014-04-01

Parámetros de identificador URI

Nombre En Requerido Tipo Description
api-version
query True

string

Versión de la API que se va a usar para la solicitud.

Respuestas

Nombre Tipo Description
200 OK

OperationListResult

De acuerdo. La solicitud se ha realizado correctamente.

Ejemplos

Get a list of operations for a resource provider

Solicitud de ejemplo

GET https://management.azure.com/providers/Microsoft.Sql/operations?api-version=2014-04-01

Respuesta de muestra

{
  "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"
      }
    }
  ]
}

Definiciones

Nombre Description
Display

Mostrar metadatos asociados a la operación.

Operation

Definición de la operación de la API REST de SQL.

OperationListResult

Resultado de la solicitud para enumerar las operaciones SQL. Contiene una lista de operaciones y un vínculo de dirección URL para obtener el siguiente conjunto de resultados.

Display

Mostrar metadatos asociados a la operación.

Nombre Tipo Description
operation

string

Tipo de operación: obtener, leer, eliminar, etc.

provider

string

Proveedor de servicios: Microsoft SQL Database.

resource

string

Recurso en el que se realiza la operación: servidor, base de datos, etc.

Operation

Definición de la operación de la API REST de SQL.

Nombre Tipo Description
display

Display

Mostrar metadatos asociados a la operación.

name

string

Nombre de la operación: {provider}/{resource}/{operation}

OperationListResult

Resultado de la solicitud para enumerar las operaciones SQL. Contiene una lista de operaciones y un vínculo de dirección URL para obtener el siguiente conjunto de resultados.

Nombre Tipo Description
nextLink

string

Dirección URL para obtener el siguiente conjunto de resultados de la lista de operaciones si hay alguno.

value

Operation[]

Lista de operaciones sql admitidas por el proveedor de recursos de SQL.