Files
azure-sdk-for-js/sdk/sql/arm-sql/samples-dev/managedInstancesListByManagedInstanceSample.ts

85 lines
2.9 KiB
TypeScript

// Copyright (c) Microsoft Corporation.
// Licensed under the MIT License.
import { SqlManagementClient } from "@azure/arm-sql";
import { DefaultAzureCredential } from "@azure/identity";
/**
* This sample demonstrates how to get top resource consuming queries of a managed instance.
*
* @summary get top resource consuming queries of a managed instance.
* x-ms-original-file: 2025-01-01/ManagedInstanceTopQueriesList.json
*/
async function obtainListOfInstanceTopResourceConsumingQueries(): Promise<void> {
const credential = new DefaultAzureCredential();
const subscriptionId = "00000000-1111-2222-3333-444444444444";
const client = new SqlManagementClient(credential, subscriptionId);
const resArray = new Array();
for await (const item of client.managedInstances.listByManagedInstance(
"sqlcrudtest-7398",
"sqlcrudtest-4645",
{ interval: "PT1H", observationMetric: "duration" },
)) {
resArray.push(item);
}
console.log(resArray);
}
/**
* This sample demonstrates how to get top resource consuming queries of a managed instance.
*
* @summary get top resource consuming queries of a managed instance.
* x-ms-original-file: 2025-01-01/ManagedInstanceTopQueriesListMax.json
*/
async function obtainListOfInstanceTopResourceConsumingQueriesFullBlownRequestAndResponse(): Promise<void> {
const credential = new DefaultAzureCredential();
const subscriptionId = "00000000-1111-2222-3333-444444444444";
const client = new SqlManagementClient(credential, subscriptionId);
const resArray = new Array();
for await (const item of client.managedInstances.listByManagedInstance(
"sqlcrudtest-7398",
"sqlcrudtest-4645",
{
databases: "db1,db2",
startTime: "2020-03-10T12:00:00Z",
endTime: "2020-03-12T12:00:00Z",
interval: "P1D",
observationMetric: "cpu",
},
)) {
resArray.push(item);
}
console.log(resArray);
}
/**
* This sample demonstrates how to get top resource consuming queries of a managed instance.
*
* @summary get top resource consuming queries of a managed instance.
* x-ms-original-file: 2025-01-01/ManagedInstanceTopQueriesListMin.json
*/
async function obtainListOfInstanceTopResourceConsumingQueriesMinimalRequestAndResponse(): Promise<void> {
const credential = new DefaultAzureCredential();
const subscriptionId = "00000000-1111-2222-3333-444444444444";
const client = new SqlManagementClient(credential, subscriptionId);
const resArray = new Array();
for await (const item of client.managedInstances.listByManagedInstance(
"sqlcrudtest-7398",
"sqlcrudtest-4645",
)) {
resArray.push(item);
}
console.log(resArray);
}
async function main(): Promise<void> {
await obtainListOfInstanceTopResourceConsumingQueries();
await obtainListOfInstanceTopResourceConsumingQueriesFullBlownRequestAndResponse();
await obtainListOfInstanceTopResourceConsumingQueriesMinimalRequestAndResponse();
}
main().catch(console.error);