Managed Database Queries - List By Query

Referenz

Dienst:: SQL Database

API-Version:: 2021-11-01

Abrufen von Abfrageausführungsstatistiken nach Abfrage-ID.

GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/managedInstances/{managedInstanceName}/databases/{databaseName}/queries/{queryId}/statistics?api-version=2021-11-01

Mit optionalen Parametern:

GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/managedInstances/{managedInstanceName}/databases/{databaseName}/queries/{queryId}/statistics?startTime={startTime}&endTime={endTime}&interval={interval}&api-version=2021-11-01

URI-Parameter

Name	In	Erforderlich	Typ	Beschreibung
databaseName	path	True	string	Der Name der Datenbank.
managedInstanceName	path	True	string	Der Name der verwalteten Instanz.
queryId	path	True	string
resourceGroupName	path	True	string	Der Name der Ressourcengruppe, die die Ressource enthält. Dieser Wert kann über die Azure-Ressourcen-Manager-API oder das Portal abgerufen werden.
subscriptionId	path	True	string	Abonnement-ID für ein Azure-Abonnement.
api-version	query	True	string	API-Version, die für die Anforderung verwendet werden soll.
endTime	query		string	Endzeit für den beobachteten Zeitraum.
interval	query		QueryTimeGrainType	Der Zeitschritt, der zum Zusammenfassen der Metrikwerte verwendet werden soll.
startTime	query		string	Startzeit für den beobachteten Zeitraum.

Antworten

Name	Typ	Beschreibung
200 OK	ManagedInstanceQueryStatistics	Abfragetext wurde erfolgreich abgerufen.
Other Status Codes		Fehlerantworten: *** 404 SubscriptionDoesNotHaveServer: Der angeforderte Server wurde nicht gefunden. 404 ServerNotInSubscriptionResourceGroup: Der angegebene Server ist in der angegebenen Ressourcengruppe und dem angegebenen Abonnement nicht vorhanden. 404 ResourceNotFound: Die angeforderte Ressource wurde nicht gefunden.

Name

Typ

Beschreibung

200 OK

ManagedInstanceQueryStatistics

Abfragetext wurde erfolgreich abgerufen.

Other Status Codes

Fehlerantworten: ***

404 SubscriptionDoesNotHaveServer: Der angeforderte Server wurde nicht gefunden.
404 ServerNotInSubscriptionResourceGroup: Der angegebene Server ist in der angegebenen Ressourcengruppe und dem angegebenen Abonnement nicht vorhanden.
404 ResourceNotFound: Die angeforderte Ressource wurde nicht gefunden.

Beispiele

Obtain query execution statistics

Obtain query execution statistics. Example with all request parameters.

Obtain query execution statistics. Minimal example with only mandatory request parameters.

Obtain query execution statistics

GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-7398/providers/Microsoft.Sql/managedInstances/sqlcrudtest-4645/databases/database_1/queries/42/statistics?api-version=2021-11-01


/**
 * Samples for ManagedDatabaseQueries ListByQuery.
 */
public final class Main {
    /*
     * x-ms-original-file:
     * specification/sql/resource-manager/Microsoft.Sql/stable/2021-11-01/examples/ManagedInstanceQueryStatisticsList.
     * json
     */
    /**
     * Sample code: Obtain query execution statistics.
     * 
     * @param azure The entry point for accessing resource management APIs in Azure.
     */
    public static void obtainQueryExecutionStatistics(com.azure.resourcemanager.AzureResourceManager azure) {
        azure.sqlServers().manager().serviceClient().getManagedDatabaseQueries().listByQuery("sqlcrudtest-7398",
            "sqlcrudtest-4645", "database_1", "42", null, null, null, com.azure.core.util.Context.NONE);
    }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Beispiel für eine Antwort

Statuscode:: 200

{
  "value": [
    {
      "properties": {
        "databaseName": "db1",
        "queryId": "35",
        "startTime": "03/01/2020 18:34:58",
        "endTime": "03/02/2020 18:34:58",
        "intervals": [
          {
            "intervalStartTime": "03/02/2020 08:00:00",
            "intervalType": "PT1H",
            "executionCount": 160,
            "metrics": [
              {
                "name": "cpu",
                "displayName": "Cpu",
                "unit": "percentage",
                "value": 0,
                "min": 1.507638888888889E-05,
                "max": 2.5243055555555557E-05,
                "avg": 1.665347222222222E-05,
                "sum": 0.0026645555555555554,
                "stdev": 1.4894345929850385E-06
              },
              {
                "name": "io",
                "displayName": "Physical Io Reads",
                "unit": "percentage",
                "value": 0,
                "min": 0,
                "max": 0,
                "avg": 0,
                "sum": 0,
                "stdev": 0
              },
              {
                "name": "logIo",
                "displayName": "Log Writes",
                "unit": "percentage",
                "value": 0,
                "min": 0,
                "max": 0,
                "avg": 0,
                "sum": 0,
                "stdev": 0
              },
              {
                "name": "memory",
                "displayName": "Memory consumption",
                "unit": "KB",
                "value": 0,
                "min": 0,
                "max": 0,
                "avg": 0,
                "sum": 0,
                "stdev": 0
              },
              {
                "name": "duration",
                "displayName": "Query duration",
                "unit": "microseconds",
                "value": 0,
                "min": 4373,
                "max": 18490,
                "avg": 5026.625,
                "sum": 804260,
                "stdev": 1487.3520882343225
              }
            ]
          },
          {
            "intervalStartTime": "03/02/2020 09:00:00",
            "intervalType": "PT1H",
            "executionCount": 20,
            "metrics": [
              {
                "name": "cpu",
                "displayName": "Cpu",
                "unit": "percentage",
                "value": 0,
                "min": 2.3430555555555557E-05,
                "max": 0.00014645833333333332,
                "avg": 4.479774305555555E-05,
                "sum": 0.0008959548611111111,
                "stdev": 3.830118344204395E-05
              },
              {
                "name": "io",
                "displayName": "Physical Io Reads",
                "unit": "percentage",
                "value": 0,
                "min": 0,
                "max": 0,
                "avg": 0,
                "sum": 0,
                "stdev": 0
              },
              {
                "name": "logIo",
                "displayName": "Log Writes",
                "unit": "percentage",
                "value": 0,
                "min": 0,
                "max": 0,
                "avg": 0,
                "sum": 0,
                "stdev": 0
              },
              {
                "name": "memory",
                "displayName": "Memory consumption",
                "unit": "KB",
                "value": 0,
                "min": 0,
                "max": 0,
                "avg": 0,
                "sum": 0,
                "stdev": 0
              },
              {
                "name": "duration",
                "displayName": "Query duration",
                "unit": "microseconds",
                "value": 0,
                "min": 6813,
                "max": 42289,
                "avg": 12963.2,
                "sum": 259264,
                "stdev": 11040.140794392071
              }
            ]
          },
          {
            "intervalStartTime": "03/02/2020 15:00:00",
            "intervalType": "PT1H",
            "executionCount": 80,
            "metrics": [
              {
                "name": "cpu",
                "displayName": "Cpu",
                "unit": "percentage",
                "value": 0,
                "min": 1.8215277777777777E-05,
                "max": 2.764236111111111E-05,
                "avg": 1.9315538194444445E-05,
                "sum": 0.0015452430555555556,
                "stdev": 1.0716305801875179E-06
              },
              {
                "name": "io",
                "displayName": "Physical Io Reads",
                "unit": "percentage",
                "value": 0,
                "min": 0,
                "max": 0,
                "avg": 0,
                "sum": 0,
                "stdev": 0
              },
              {
                "name": "logIo",
                "displayName": "Log Writes",
                "unit": "percentage",
                "value": 0,
                "min": 0,
                "max": 0,
                "avg": 0,
                "sum": 0,
                "stdev": 0
              },
              {
                "name": "memory",
                "displayName": "Memory consumption",
                "unit": "KB",
                "value": 0,
                "min": 0,
                "max": 0,
                "avg": 0,
                "sum": 0,
                "stdev": 0
              },
              {
                "name": "duration",
                "displayName": "Query duration",
                "unit": "microseconds",
                "value": 0,
                "min": 5264,
                "max": 7982,
                "avg": 5586.2625,
                "sum": 446901,
                "stdev": 310.4915757210727
              }
            ]
          },
          {
            "intervalStartTime": "03/02/2020 17:00:00",
            "intervalType": "PT1H",
            "executionCount": 80,
            "metrics": [
              {
                "name": "cpu",
                "displayName": "Cpu",
                "unit": "percentage",
                "value": 0,
                "min": 1.7819444444444443E-05,
                "max": 2.782638888888889E-05,
                "avg": 1.9085373263888888E-05,
                "sum": 0.0015268298611111112,
                "stdev": 1.2309244108727927E-06
              },
              {
                "name": "io",
                "displayName": "Physical Io Reads",
                "unit": "percentage",
                "value": 0,
                "min": 0,
                "max": 0,
                "avg": 0,
                "sum": 0,
                "stdev": 0
              },
              {
                "name": "logIo",
                "displayName": "Log Writes",
                "unit": "percentage",
                "value": 0,
                "min": 0,
                "max": 0,
                "avg": 0,
                "sum": 0,
                "stdev": 0
              },
              {
                "name": "memory",
                "displayName": "Memory consumption",
                "unit": "KB",
                "value": 0,
                "min": 0,
                "max": 0,
                "avg": 0,
                "sum": 0,
                "stdev": 0
              },
              {
                "name": "duration",
                "displayName": "Query duration",
                "unit": "microseconds",
                "value": 0,
                "min": 5147,
                "max": 8052,
                "avg": 5517.2,
                "sum": 441376,
                "stdev": 356.8763581410226
              }
            ]
          }
        ]
      },
      "id": "35",
      "type": "Microsoft.Sql/managedInstances/databases/queries/statistics"
    }
  ]
}

Obtain query execution statistics. Example with all request parameters.

Beispielanforderung

HTTP
Java

GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-7398/providers/Microsoft.Sql/managedInstances/sqlcrudtest-4645/databases/database_1/queries/42/statistics?startTime=03/01/2020 16:23:09&endTime=03/11/2020 14:00:00&interval=P1D&api-version=2021-11-01


import com.azure.resourcemanager.sql.models.QueryTimeGrainType;

/**
 * Samples for ManagedDatabaseQueries ListByQuery.
 */
public final class Main {
    /*
     * x-ms-original-file:
     * specification/sql/resource-manager/Microsoft.Sql/stable/2021-11-01/examples/ManagedInstanceQueryStatisticsListMax
     * .json
     */
    /**
     * Sample code: Obtain query execution statistics. Example with all request parameters.
     * 
     * @param azure The entry point for accessing resource management APIs in Azure.
     */
    public static void obtainQueryExecutionStatisticsExampleWithAllRequestParameters(
        com.azure.resourcemanager.AzureResourceManager azure) {
        azure.sqlServers().manager().serviceClient().getManagedDatabaseQueries().listByQuery("sqlcrudtest-7398",
            "sqlcrudtest-4645", "database_1", "42", "03/01/2020 16:23:09", "03/11/2020 14:00:00",
            QueryTimeGrainType.P1D, com.azure.core.util.Context.NONE);
    }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Beispiel für eine Antwort

Statuscode:: 200

{
  "value": [
    {
      "properties": {
        "databaseName": "db1",
        "queryId": "28",
        "startTime": "03/01/2020 16:23:09",
        "endTime": "03/11/2020 14:00:00",
        "intervals": [
          {
            "intervalStartTime": "03/11/2020 00:00:00",
            "intervalType": "P1D",
            "executionCount": 1,
            "metrics": [
              {
                "name": "cpu",
                "displayName": "Cpu",
                "unit": "percentage",
                "value": 0,
                "min": 0.0015934667245370371,
                "max": 0.0015934667245370371,
                "avg": 0.0015934667245370371,
                "sum": 0.0015934667245370371,
                "stdev": 0
              },
              {
                "name": "io",
                "displayName": "Physical Io Reads",
                "unit": "percentage",
                "value": 0,
                "min": 4.224537037037037E-06,
                "max": 4.224537037037037E-06,
                "avg": 4.224537037037037E-06,
                "sum": 4.224537037037037E-06,
                "stdev": 0
              },
              {
                "name": "logIo",
                "displayName": "Log Writes",
                "unit": "percentage",
                "value": 0,
                "min": 0,
                "max": 0,
                "avg": 0,
                "sum": 0,
                "stdev": 0
              },
              {
                "name": "memory",
                "displayName": "Memory consumption",
                "unit": "KB",
                "value": 0,
                "min": 8336,
                "max": 8336,
                "avg": 8336,
                "sum": 8336,
                "stdev": 0
              },
              {
                "name": "duration",
                "displayName": "Query duration",
                "unit": "microseconds",
                "value": 0,
                "min": 11091296,
                "max": 11091296,
                "avg": 11091296,
                "sum": 11091296,
                "stdev": 0
              }
            ]
          }
        ]
      },
      "id": "28",
      "type": "Microsoft.Sql/managedInstances/databases/queries/statistics"
    }
  ]
}

Obtain query execution statistics. Minimal example with only mandatory request parameters.

Beispielanforderung

HTTP
Java

GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-7398/providers/Microsoft.Sql/managedInstances/sqlcrudtest-4645/databases/database_1/queries/42/statistics?interval=PT1H&api-version=2021-11-01


import com.azure.resourcemanager.sql.models.QueryTimeGrainType;

/**
 * Samples for ManagedDatabaseQueries ListByQuery.
 */
public final class Main {
    /*
     * x-ms-original-file:
     * specification/sql/resource-manager/Microsoft.Sql/stable/2021-11-01/examples/ManagedInstanceQueryStatisticsListMin
     * .json
     */
    /**
     * Sample code: Obtain query execution statistics. Minimal example with only mandatory request parameters.
     * 
     * @param azure The entry point for accessing resource management APIs in Azure.
     */
    public static void obtainQueryExecutionStatisticsMinimalExampleWithOnlyMandatoryRequestParameters(
        com.azure.resourcemanager.AzureResourceManager azure) {
        azure.sqlServers().manager().serviceClient().getManagedDatabaseQueries().listByQuery("sqlcrudtest-7398",
            "sqlcrudtest-4645", "database_1", "42", null, null, QueryTimeGrainType.PT1H,
            com.azure.core.util.Context.NONE);
    }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Beispiel für eine Antwort

Statuscode:: 200

{
  "value": [
    {
      "properties": {
        "databaseName": "db1",
        "queryId": "28",
        "startTime": "03/10/2020 14:00:30",
        "endTime": "03/11/2020 14:00:30",
        "intervals": [
          {
            "intervalStartTime": "03/11/2020 11:00:00",
            "intervalType": "PT1H",
            "executionCount": 1,
            "metrics": [
              {
                "name": "cpu",
                "displayName": "Cpu",
                "unit": "percentage",
                "value": 0,
                "min": 0.03824320138888889,
                "max": 0.03824320138888889,
                "avg": 0.03824320138888889,
                "sum": 0.03824320138888889,
                "stdev": 0
              },
              {
                "name": "io",
                "displayName": "Physical Io Reads",
                "unit": "percentage",
                "value": 0,
                "min": 0.0001013888888888889,
                "max": 0.0001013888888888889,
                "avg": 0.0001013888888888889,
                "sum": 0.0001013888888888889,
                "stdev": 0
              },
              {
                "name": "logIo",
                "displayName": "Log Writes",
                "unit": "percentage",
                "value": 0,
                "min": 0,
                "max": 0,
                "avg": 0,
                "sum": 0,
                "stdev": 0
              },
              {
                "name": "memory",
                "displayName": "Memory consumption",
                "unit": "KB",
                "value": 0,
                "min": 8336,
                "max": 8336,
                "avg": 8336,
                "sum": 8336,
                "stdev": 0
              },
              {
                "name": "duration",
                "displayName": "Query duration",
                "unit": "microseconds",
                "value": 0,
                "min": 11091296,
                "max": 11091296,
                "avg": 11091296,
                "sum": 11091296,
                "stdev": 0
              }
            ]
          }
        ]
      },
      "id": "28",
      "type": "Microsoft.Sql/managedInstances/databases/queries/statistics"
    }
  ]
}

Definitionen

Name	Beschreibung
ManagedInstanceQueryStatistics	Ausführungsstatistiken für eine bestimmte Abfrage
QueryMetricInterval	Eigenschaften eines Abfragemetrikenintervalls.
QueryMetricProperties	Eigenschaften einer Topquery-Metrik in einem Intervall.
QueryMetricUnitType	Die Einheit der Metrik.
QueryStatistics
QueryTimeGrainType	Intervalltyp (Länge).

ManagedInstanceQueryStatistics

Ausführungsstatistiken für eine bestimmte Abfrage

Name	Typ	Beschreibung
nextLink	string	Link zum Abrufen der nächsten Ergebnisseite.
value	QueryStatistics[]	Array von Ergebnissen.

QueryMetricInterval

Eigenschaften eines Abfragemetrikenintervalls.

Name	Typ	Beschreibung
executionCount	integer	Ausführungsanzahl einer Abfrage in diesem Intervall.
intervalStartTime	string	Die Startzeit für das Metrikintervall (ISO-8601-Format).
intervalType	QueryTimeGrainType	Intervalltyp (Länge).
metrics	QueryMetricProperties[]	Liste der Metrikobjekte für dieses Intervall

QueryMetricProperties

Eigenschaften einer Topquery-Metrik in einem Intervall.

Name	Typ	Beschreibung
avg	number	Metrikwert, wenn die avg()-Aggregatfunktion über das Intervall verwendet wird.
displayName	string	Der geeignete Name der Benutzeroberfläche für die Metrik.
max	number	Metrikwert, wenn die max()-Aggregatfunktion über das Intervall verwendet wird.
min	number	Metrikwert, wenn die min()-Aggregatfunktion über das Intervall verwendet wird.
name	string	Die Namensinformationen für die Metrik.
stdev	number	Metrikwert, wenn die stdev-Aggregatfunktion über das Intervall verwendet wird.
sum	number	Metrikwert, wenn die sum()-Aggregatfunktion über das Intervall verwendet wird.
unit	QueryMetricUnitType	Die Einheit der Metrik.
value	number	Der Wert der Metrik.

QueryMetricUnitType

Die Einheit der Metrik.

Name	Typ	Beschreibung
KB	string
count	string
microseconds	string
percentage	string

QueryStatistics

Name	Typ	Beschreibung
id	string	Ressourcen-ID
name	string	Name der Ressource.
properties.databaseName	string	Datenbankname der Datenbank, in der diese Abfrage ausgeführt wurde.
properties.endTime	string	Die Endzeit für die Metrik (ISO-8601-Format).
properties.intervals	QueryMetricInterval[]	Liste der Intervalle mit geeigneten Metrikdaten
properties.queryId	string	Eindeutige Abfrage-ID (innerhalb einer Datenbank eindeutig).
properties.startTime	string	Die Startzeit für die Metrik (ISO-8601-Format).
type	string	Der Ressourcentyp.

QueryTimeGrainType

Intervalltyp (Länge).

Name	Typ	Beschreibung
P1D	string
PT1H	string

Freigeben über

Managed Database Queries - List By Query

URI-Parameter

Antworten

Beispiele

Obtain query execution statistics

Beispielanforderung

Beispiel für eine Antwort

Obtain query execution statistics. Example with all request parameters.

Beispielanforderung

Beispiel für eine Antwort

Obtain query execution statistics. Minimal example with only mandatory request parameters.

Beispielanforderung

Beispiel für eine Antwort

Definitionen

ManagedInstanceQueryStatistics

QueryMetricInterval

QueryMetricProperties

QueryMetricUnitType

QueryStatistics

QueryTimeGrainType

Zusätzliche Ressourcen