I did install the dashboard in the Azure Studio without error. But when I select the SQLdm database, no dashboard tab is displayed.
My SQLdm database has a custom, non-default name. Could it be, that the dashboard only works with databases named "SQLdmRepository" ?
Per the first bullet of the "Use Extension" section of the "Details" tab of the documentation of the extension in Azure Data Studio:
That is, SQL DM Performance Insights currently supports only SQL DM repository databases with the default name "SQLdmRepository".
Please also refer to the new forum post "SQL Diagnostic Manager repository database needs to be named "SQLdmRepository"".
I did change the database name in the SQL scripts according to the post "KB: How to use a SQL DM repository database other than SQLdmRepository", but the Performance Insights tab is still not displayed. Only the default Database Dashboard is shown when I select "Manage"
Is the Extension enabled? Click on Extension icon in the left ribbon of Azure Data Studio and locate the Enabled section. Verify that Enable is grayed out.
Also, in the right pane, select the + symbol and verify that the Extension is Enabled as a tab:
I needed to enable the "preview Features" in Azure Data Studio. Now I can see the SQLdm tab with data :-)
Awesome. That should probably be enabled by default with the option to opt out. It's hard to find if you ignore the notification after upgrade. I know there has been some debate about that in the past. I was not aware that a preview feature was being used but I'm happy you are up and running.
I did validate that turning off Preview Features hides the Extension. For anyone reading this, if you do not turn this on after upgrading ADS, open User Settings and turn it on by adding this override setting:
Other users have reported similar issues with ADS. Please see these issue reports for tracking: