Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Database Performance Analyzer (DPA) > Auto-generate an Azure SQL mass registration file for DPA

Auto-generate an Azure SQL mass registration file for DPA

Table of contents

Updated January 10, 2017

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.

Environment

  • DPA 11.0 and later

Steps

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.

  1. Download this script.
  2. Download and install Azure PowerShell from Microsoft.
  3. Open the PowerShell console.
  4. 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 for more information.

  5. Get the Azure resources for PowerShell.
    Get-AzureRmResource
  6. Log in using you account.
    Login-AzureRmAccount
  7. Select your subscription.
    Get-AzureRmSubscription -SubscriptionName YOUR_SUBSCRIPTION_NAME | Select-AzureRmSubscription
  8. Run the PowerShell script you downloaded.
    .\GenerateMassRegFile.ps1

    A file named massreg_sql_database.csv is generated.

  9. 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.

  10. In DPA, click Options > Mass Registration.
  11. Select Azure SQL as the database type, and click From Local Computer.
  12. Click Choose File, and locate the file.
  13. Click Load Registration File.
Last modified

Tags

Classifications

Public