Answers to frequently asked questions.

I Found a bug

Please create an Issue. Before submitting an issue, please check if there is an existing issue for the bug. Include as much information as possible about your environment and how to reproduce the bug, including full error messages. Be careful not to include any security sensitive data in your issue.

Are you able to fix the bug yourself? Please mention this in the issue. We accept pull requests!

I have a feature suggestion

Please create an Issue. Before submitting an issue, please check if there is an existing issue for the feature request. Provide a clear description for the feature. If you are willing to help develop the new feature, please mention this in the issue. DBA Dash is an open soure project and will improve through community contributions.

How Do I Contribute?

There are some guidelines here for Trimble employees. We also accept external contributions. We will create some documentation for external contributions shortly.

I need help or want to ask a question

You can ask questions via the discussions on GitHub. There is also a #dbadash channel on the SQL Server Community slack. Before submitting a query, please check if there is an answer to your question in the documentation. Also search the discussions to see if a similar question has already been asked. DBA Dash is an open source project that relies on community support to help answer queries.

How do I create alert notifications with DBA Dash?

DBA Dash doesn’t have any built in alerting capabilities, but you can create your own custom alerts based on the data collected. Some examples here

How many instances can I monitor with DBA Dash?

There are no licensing restrictions or hard coded limits on the number of instances you can monitor with DBA Dash. There are some practical limitations to consider which will impact how you deploy DBA Dash. The DBA Dash GUI isn’t designed for thousands of instances. Collecting data from a large number of instances could also be a challenge. This will put additional pressure on the DBA Dash agent and the central repository database. The size of the central repository database will also increase with the number of instances monitored. There are options if you have a large number of instances:

  • Increase the ServiceThreads value in the ServiceConfig.json file to allow the DBA Dash agent to work with a larger number of instances.
  • Use multiple DBA Dash agents. Tip: Multiple agents can also be deployed to the same server. Change the ServiceName in the ServiceConfig.json file to configure a unique name for each service.
  • Split the instances between multiple DBA Dash repositories. Starting with version 2.40.0, the DBA Dash GUI can fast switch between multiple repositories.

Automation also becomes important as the number of instances increase. DBADashConfig.exe can be used for automation. To get started run:

DBADashConfig --help

I get a ‘Operation will cause database event session memory to exceed allowed limit.’ error on AzureDB

You will typically run into this issue when using elastic pools. You might need to be selective about which databases you enable slow query capture for. See here for more info.

The stored procedure names are not showing

Object names might display as {object_id:1234567}. This can occur if the DBA Dash service account doesn’t have permissions to collect the object name. Review the permissions assgined to the service account.

How do I get notifications of new releases?

Click the GitHub “Watch” button at the top of this page. A drop down will appear. Select “Custom”. Check “Releases” and click apply - this will only notify you when releases are published.

How do I remove an Instance?

  • First remove the instance from the service config tool to prevent data from been collected for the instance.
  • In the GUI, go to “Options\Manage Instances”. Find the instance and click “Mark Deleted”.

The mark deleted is a soft delete operation that will hide the instance from display. It’s possible to click “Restore” to undo this operation. If you want to remove the instance completely, this is a more resource intensive operation. You can complete this operation in SSMS:

Note You must wait at least 24hrs after stopping the collection for an instance before you can perform a hard delete.

/*  Find InstanceID:
    SELECT InstanceID FROM dbo.Instances WHERE InstanceName ='' 
EXEC dbo.Instance_Del @InstanceID = ???, @HardDelete = 1

    This script will provide the command to hard delete each instance marked deleted
    This takes into account the 24hr waiting period since the last collection date.
SELECT	I.InstanceDisplayName,
		CONCAT('EXEC dbo.Instance_Del @InstanceID = ',InstanceID,', @HardDelete = 1') AS DeleteCommand
FROM dbo.Instances I
WHERE IsActive=0
				FROM dbo.CollectionDates CD 
				WHERE CD.InstanceID = I.InstanceID 
				AND CD.SnapshotDate> DATEADD(d,-1,GETUTCDATE())

How do I customize the tooltip length in the grid?

The tooltip length can be adjusted using the script below. A value of 0 will disable tooltips.

DELETE dbo.Settings WHERE SettingName='GUICellToolTipMaxLength'
INSERT INTO dbo.Settings(SettingName,SettingValue)