Database Management

Auto-generate an Azure SQL mass registration file for DPA

This article provides a PowerShell script plus instructions to auto-generate a CSV file containing the Azure SQL databases to monitor with DPA. You can upload this file to DPA to mass register all the database instances together.

First published date

10/29/2018 9:02 PM

Last published date

1/25/2022 4:23 PM

Overview

This article provides a PowerShell script and instructions to auto-generate a CSV file containing the Azure SQL databases you want to monitor with DPA. You can upload this file to DPA to mass register all the database instances together.

Product section

Database Performance Analyzer

Resolution

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

Each registered database creates load on DPA and its repository. If you are using an Azure SQL database as your repository, you could overwhelm the database if you register too many databases at once. Please see the Administrator Guide on recommended DTU levels.

Download one of the following scripts:
- For DPA 2021.3 and earlier, download this script.
- For DPA 2022.1 and later, download this script.
Download and install Azure PowerShell (© 2017 Microsoft, available at http://www.microsoft.com, obtained on January 9, 2017) from Microsoft.
Open the PowerShell console.
Set the policy level based on your company policy requirements.
```
Set-ExecutionPolicy Unrestricted
```
The available levels are Unrestricted, RemoteSigned, AllSigned, and Restricted. See this Microsoft article (© 2017 Microsoft, available at http://www.microsoft.com, obtained on January 9, 2017) for more information.
Log in using your account.
```
Login-AzAccount
```

Select your subscription.

Get-AzSubscription -SubscriptionName YOUR_SUBSCRIPTION_NAME | Select-AzSubscription

Run the PowerShell script you downloaded.
- In DPA 2021.3 and earlier:
```
.\GenerateMassRegFile.ps1
```
- In DPA 2022.1 and later:
```
.\GenerateMassRegFile_2022-1_and_later.ps1
```
A file named massreg_sql_database.csv is generated.
Edit and save the CSV file. Enter the required information in each column. Do not delete the header row.
SolarWinds recommends that you register less than 50 databases at a time. Trim the CSV file accordingly.
In DPA, click Options > Mass Registration.
Click Choose File, and locate the file.
Click Load Registration File.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.