Skip to content

Latest commit

 

History

History
58 lines (43 loc) · 3.29 KB

sql-database-monitor-and-scale-database-powershell.md

File metadata and controls

58 lines (43 loc) · 3.29 KB
title description services ms.service ms.subservice ms.custom ms.devlang ms.topic author ms.author ms.reviewer manager ms.date
PowerShell example-monitor-scale-single Azure SQL database | Microsoft Docs
Azure PowerShell example script to monitor and scale a single Azure SQL database
sql-database
sql-database
performance
PowerShell
sample
CarlRabeler
carlrab
craigg
09/14/2018

Use PowerShell to monitor and scale a single SQL database

This PowerShell script example monitors the performance metrics of a database, scales it to a higher compute size, and creates an alert rule on one of the performance metrics.

[!INCLUDE quickstarts-free-trial-note] [!INCLUDE cloud-shell-powershell.md]

If you choose to install and use the PowerShell locally, this tutorial requires the Azure PowerShell module version 5.7.0 or later. Run Get-Module -ListAvailable AzureRM to find the version. If you need to upgrade, see Install Azure PowerShell module. If you are running PowerShell locally, you also need to run Connect-AzureRmAccount to create a connection with Azure.

Sample script

[!code-powershell-interactivemain]

Tip

Use Get-AzureRmSqlDatabaseActivity to get the status of database operations and use Stop-AzureRmSqlDatabaseActivity to cancels an update operation on the database.

Clean up deployment

After the script sample has been run, the following command can be used to remove the resource group and all resources associated with it.

Remove-AzureRmResourceGroup -ResourceGroupName $resourcegroupname

Script explanation

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

Command Notes
New-AzureRmResourceGroup Creates a resource group in which all resources are stored.
New-AzureRmSqlServer Creates a logical server that hosts a database or elastic pool.
Get-AzureRmMetric Shows the size usage information for the database.
Set-AzureRmSqlDatabase Updates database properties or moves a database into, out of, or between elastic pools.
Add-AzureRMMetricAlertRule Sets an alert rule to automatically monitor DTUs in the future.
Remove-AzureRmResourceGroup Deletes a resource group including all nested resources.

Next steps

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

Additional SQL Database PowerShell script samples can be found in the Azure SQL Database PowerShell scripts.