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

62 lines
1.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 creates or updates a workload classifier.
*
* @summary creates or updates a workload classifier.
* x-ms-original-file: 2025-01-01/CreateOrUpdateWorkloadClassifierMax.json
*/
async function createAWorkloadGroupWithAllPropertiesSpecified(): Promise<void> {
const credential = new DefaultAzureCredential();
const subscriptionId = "00000000-1111-2222-3333-444444444444";
const client = new SqlManagementClient(credential, subscriptionId);
const result = await client.workloadClassifiers.createOrUpdate(
"Default-SQL-SouthEastAsia",
"testsvr",
"testdb",
"wlm_workloadgroup",
"wlm_workloadclassifier",
{
context: "test_context",
endTime: "14:00",
importance: "high",
label: "test_label",
memberName: "dbo",
startTime: "12:00",
},
);
console.log(result);
}
/**
* This sample demonstrates how to creates or updates a workload classifier.
*
* @summary creates or updates a workload classifier.
* x-ms-original-file: 2025-01-01/CreateOrUpdateWorkloadClassifierMin.json
*/
async function createAWorkloadGroupWithTheRequiredPropertiesSpecified(): Promise<void> {
const credential = new DefaultAzureCredential();
const subscriptionId = "00000000-1111-2222-3333-444444444444";
const client = new SqlManagementClient(credential, subscriptionId);
const result = await client.workloadClassifiers.createOrUpdate(
"Default-SQL-SouthEastAsia",
"testsvr",
"testdb",
"wlm_workloadgroup",
"wlm_workloadclassifier",
{ memberName: "dbo" },
);
console.log(result);
}
async function main(): Promise<void> {
await createAWorkloadGroupWithAllPropertiesSpecified();
await createAWorkloadGroupWithTheRequiredPropertiesSpecified();
}
main().catch(console.error);