Submit a ticketCall us

Training ClassThe Orion® Platform Instructor-led Classes

Provided by SolarWinds® Academy, these trainings will introduce users to the Orion Platform and its features, management, and navigation. These courses are suitable for users looking to discover new tips, tricks, and ways to adapt their Orion products to better suit their monitoring needs:
Deploying the Orion Platform
Configuring Orion views, maps, and accounts
Configuring Orion alerts and reports

Reserve your seat.

Home > Success Center > Database Performance Analyzer (DPA) > DPA - Knowledgebase Articles > 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


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.


  • DPA 11.0 and later


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.
  6. Log in using you account.
  7. Select your subscription.
    Get-AzureRmSubscription -SubscriptionName YOUR_SUBSCRIPTION_NAME | Select-AzureRmSubscription
  8. Run the PowerShell script you downloaded.

    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