Skip to content

monitor-and-scale-database-cli.md

Latest commit

 

History

History
64 lines (43 loc) · 2.39 KB

monitor-and-scale-database-cli.md

File metadata and controls

64 lines (43 loc) · 2.39 KB
title Azure CLI: Monitor and scale a single database in Azure SQL Database
description Use an Azure CLI example script to monitor and scale a single database in Azure SQL Database.
services sql-database
ms.service sql-database
ms.subservice performance
ms.custom sqldbrb=1
ms.devlang azurecli
ms.topic sample
author juliemsft
ms.author jrasnick
ms.reviewer sstein
ms.date 06/25/2019

Use the Azure CLI to monitor and scale a single database in Azure SQL Database

[!INCLUDEappliesto-sqldb]

This Azure CLI script example scales a single database in Azure SQL Database to a different compute size after querying the size information of the database.

If you choose to install and use the Azure CLI locally, this article requires that you are running the Azure CLI version 2.0 or later. Run az --version to find the version. If you need to install or upgrade, see Install the Azure CLI.

Sample script

Sign in to Azure

[!INCLUDE quickstarts-free-trial-note]

$subscription = "<subscriptionId>" # add subscription here

az account set -s $subscription # ...or use 'az login'

Run the script

[!code-azurecli-interactivemain]

Tip

Use az sql db op list to get a list of operations performed on the database, and use az sql db op cancel to cancel an update operation on the database.

Clean up deployment

Use the following command to remove the resource group and all resources associated with it.

az group delete --name $resource

Sample reference

This script uses the following commands. Each command in the table links to command-specific documentation.

Script Description
az sql server Server commands.
az sql db show-usage Shows the size usage information for a database.

Next steps

For more information on the Azure CLI, see Azure CLI documentation.

Additional CLI script samples can be found in Azure CLI sample scripts.