Quick Start

One page summary of how to setup DBA Dash

Requirements

Repository DB:

  • SQL 2016 SP1 or later, including Azure DB and RDS (SQL Server)

Monitored Instances:

  • SQL 2005-2022, including Azure DB and RDS (SQL Server)

DBA Dash Service:

  • .NET Framework 6 Runtime (desktop apps). Version 6.0.2 or later

    Download .NET 6 Desktop Runtime

    If the .NET 6 runtime is not installed, you will be prompted to install it when you try to run the application.

    If you have an older version of the .NET framework installed (6.0.0 or 6.0.1), the application will fail to start (no errors). This is due to a breaking change in 6.0.2. If you want to check the version of the .NET runtime you have installed you can run:

    dotnet --list-runtimes

  • Account to run the service with appropriate permissions to connect to the monitored instances and repository database instance

Setup

DBA Dash setup

  1. Download the latest release from GitHub:

Download

(Select the one labelled DBADash_{version}.zip)

  1. Extract the files to a folder of your choosing
  2. Run DBADashServiceConfigTool.exe
  1. Set a destination connection

ServiceConfig.json is used to store the connection details.

  1. Click the “Source” tab
  2. Click the connect button to add a source connection (monitored instance)
  1. Review the options available on the “Extended Events” and “Other” tab.
  2. Click “Add/Update” to add the source connection(s)
  3. Repeat the process of adding source connections as necessary
  4. Click “Save”.
  1. Click the “Destination” tab
  2. Click the “Install as service button”
  3. Click Install and enter credentials for the service.
  4. Click Start
  1. All done! Run DBADash.exe to see the data collected 🎉