Operations - List

Hizmet:

SQL Database

API Sürümü:

2014-04-01

Kullanılabilir tüm SQL Rest API işlemlerini listeler.

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

URI Parametreleri

Name	İçinde	Gerekli	Tür	Description
api-version	query	True	string	İstek için kullanılacak API sürümü.

Yanıtlar

Name	Tür	Description
200 OK	OperationListResult	TAMAM. İstek başarılı oldu.

Örnekler

Get a list of operations for a resource provider

Örnek isteği

HTTP

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

Örnek yanıt

Durum kodu:

200

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

Tanımlar

Name	Description
Display	İşlemle ilişkili meta verileri görüntüleme.
Operation	SQL REST API işlem tanımı.
OperationListResult	SQL işlemlerini listeleme isteğinin sonucu. Bir işlem listesi ve bir sonraki sonuç kümesini almak için bir URL bağlantısı içerir.

Display

Nesne

İşlemle ilişkili meta verileri görüntüleme.

Name	Tür	Description
operation	string	İşlem türü: alma, okuma, silme vb.
provider	string	Hizmet sağlayıcısı: Microsoft SQL Veritabanı.
resource	string	İşlemin gerçekleştirildiği kaynak: Sunucu, Veritabanı vb.

Operation

Nesne

SQL REST API işlem tanımı.

Name	Tür	Description
display	Display	İşlemle ilişkili meta verileri görüntüleme.
name	string	İşlem adı: {provider}/{resource}/{operation}

OperationListResult

Nesne

SQL işlemlerini listeleme isteğinin sonucu. Bir işlem listesi ve bir sonraki sonuç kümesini almak için bir URL bağlantısı içerir.

Name	Tür	Description
nextLink	string	Varsa sonraki işlem listesi sonuçlarını almak için URL.
value	Operation[]	SQL kaynak sağlayıcısı tarafından desteklenen SQL işlemlerinin listesi.