Evdlaar
database names with dots are not handled properly
Do you want to request a feature or report a bug?
I consider this as a bug.
What is the current behavior?
Errors get reported when executing the dashboard.
If the current behavior is a bug, please provide the steps to reproduce and if possible a minimal demo of the problem via http://sqlfiddle.com/
- create database with a name that contains a single dot, enable query store for it, run dashboard => one type of error
- create database with a name that contains two or more dots, enable query store for it, run dashboard => another type of error
What is the expected behavior?
That the dashboards works like with db names without dots.
Which versions of SQL Server and which OS are affected by this issue? Did this work in previous versions of our procedures?
Only tested on sql server 2017 with october 2020 CU.
The lastest available QueryStoreInstanceDashboard.rdl does fix it already. But please refresh the zip file with that.