Files
azure-sdk-for-js/sdk/sql/arm-sql/samples/v11/javascript/workloadGroupsCreateOrUpdateSample.js

60 lines
1.9 KiB
JavaScript

// Copyright (c) Microsoft Corporation.
// Licensed under the MIT License.
const { SqlManagementClient } = require("@azure/arm-sql");
const { DefaultAzureCredential } = require("@azure/identity");
/**
* This sample demonstrates how to creates or updates a workload group.
*
* @summary creates or updates a workload group.
* x-ms-original-file: 2025-01-01/CreateOrUpdateWorkloadGroupMax.json
*/
async function createAWorkloadGroupWithAllPropertiesSpecified() {
const credential = new DefaultAzureCredential();
const subscriptionId = "00000000-1111-2222-3333-444444444444";
const client = new SqlManagementClient(credential, subscriptionId);
const result = await client.workloadGroups.createOrUpdate(
"Default-SQL-SouthEastAsia",
"testsvr",
"testdb",
"smallrc",
{
importance: "normal",
maxResourcePercent: 100,
maxResourcePercentPerRequest: 3,
minResourcePercent: 0,
minResourcePercentPerRequest: 3,
queryExecutionTimeout: 0,
},
);
console.log(result);
}
/**
* This sample demonstrates how to creates or updates a workload group.
*
* @summary creates or updates a workload group.
* x-ms-original-file: 2025-01-01/CreateOrUpdateWorkloadGroupMin.json
*/
async function createAWorkloadGroupWithTheRequiredPropertiesSpecified() {
const credential = new DefaultAzureCredential();
const subscriptionId = "00000000-1111-2222-3333-444444444444";
const client = new SqlManagementClient(credential, subscriptionId);
const result = await client.workloadGroups.createOrUpdate(
"Default-SQL-SouthEastAsia",
"testsvr",
"testdb",
"smallrc",
{ maxResourcePercent: 100, minResourcePercent: 0, minResourcePercentPerRequest: 3 },
);
console.log(result);
}
async function main() {
await createAWorkloadGroupWithAllPropertiesSpecified();
await createAWorkloadGroupWithTheRequiredPropertiesSpecified();
}
main().catch(console.error);