Can Top SQL Statements drilldown show what user and host SQL is from?
Can Top SQL Statements drilldown show what user and host SQL is from? User tries to see which user is using a bad SQL statement or who is running a long running query, and that information is not included in this drilldown.
Top SQL Statements contains data sourced from sys.dm_exec_query_stats. User and host names do not exist in this DMV – it is intended (by Microsoft) as an aggregate view of the plan cache. Spotlight cannot synthesize what does not exist.