Is there a report for poorly running queries? Queries like the following:
1. abnormally high cpu time
2. abnormally high reads and/or writes physical or logical
3. abnormally high logical reads
Unfortunately, this information is currently not saved in the Spotlight Statistics Repository. Therefore, it is impossible to generate such a report.
You could just use the Top SQL drilldown.
We are planning to add Top SQL as an Spotlight Statistics Repository report as an enhancement, but this will only be for the top 200 longest running SQL statements.