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
You can run the DBADashService.exe console app as your own user account without installing as a service for testing purposes
Setup
- Download the latest release from GitHub:
(Select the one labelled DBADash_{version}.zip)
- Extract the files to a folder of your choosing
- Run DBADashServiceConfigTool.exe
If the application fails to start, please ensure you have .NET Framework 6 Runtime (desktop apps) 6.0.2 or later installed. See Requirements
- Set a destination connection
The destination connection is the SQL instance where your DBA Dash repository database is to be located. By default this is set to DBADashDB and the database will be created automatically when the service starts. If you select an existing database it will need to be completely blank with no existing objects created.
Use Windows authentication where possible.
- Click the “Source” tab
- Click the connect button to add a source connection (monitored instance)
Add multiple instances at the same time by entering a connection string or instance name on each line in the source textbox
- Review the options available on the “Extended Events” and “Other” tab.
- Click “Add/Update” to add the source connection(s)
- Repeat the process of adding source connections as necessary
- Click “Save”.
Your settings are stored in a file called ServiceConfig.json
- Click the “Destination” tab
- Click the “Install as service button”
- Click Install and enter credentials for the service.
- Click Start
Click View Service Log button to see what the service is doing. It will take a few moments to create the repository database and start collecting data.
- All done! Run DBADash.exe to see the data collected 🎉