Skip to content

Latest commit

 

History

History
59 lines (40 loc) · 2.16 KB

monitor-and-scale-database-cli.md

File metadata and controls

59 lines (40 loc) · 2.16 KB
Raw
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic ms.custom ms.devlang
Azure CLI example: Monitor and scale a single database in Azure SQL Database
Use an Azure CLI example script to monitor and scale a single database in Azure SQL Database.
WilliamDAssafMSFT
wiassaf
wiassaf, mathoma
01/26/2022
sql-database
performance
sample
sqldbrb=1
devx-track-azurecli
azurecli

Monitor and scale a single database in Azure SQL Database using the Azure CLI

[!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.

[!INCLUDE quickstarts-free-trial-note]

[!INCLUDE azure-cli-prepare-your-environment.md]

Sample script

[!INCLUDE cli-launch-cloud-shell-sign-in.md]

Run the script

:::code language="azurecli" source="~/../azure_cli_scripts/sql-database/monitor-and-scale-database/monitor-and-scale-database.sh" id="FullScript":::

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 resources

[!INCLUDE cli-clean-up-resources.md]

az group delete --name $resourceGroup

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.