Spotlight Essentials alerts to fix a query but there is no way to see in what DB that query is running.
In Spotlight on SQL Server Enterprise there is no database name field available in Top SQL Statements | organise columns.
Top SQL Statements gets its data from sys.dm_exec_query_stats – there is no database context in this DMV, so consequently no way to tell which database it is executed in.
WORKAROUND
None.
STATUS
Enhancement request number SOSSE-2939 has been submitted to Development for consideration in a future release of Spotlight on SQL Server Enterprise.
