I'm trying to identify some slow and databases and queries on SQL Server 2008 R2. I have been able to filter by time and display the database name succefully. However the DatabaseName always says 'master' with DatabaseID populated with '1'.
I know these queries are not being executed against master and I have over 300 hosted databases so I can't find out from context clues which database is causing the issues. Why isn't the database name populating correctly and how do I get it to populate?