So for today’s blog post, we will concentrate on 4 different reports:
- Top Queries by Average CPU Time
- Top Queries by Total CPU Time
- Top Queries by Average IO Time
- Top Queries by Total IO Time
These are the standard reports from the Server node.
Go to Server Node -> Right Click -> Reports -> Standard Reports and you will find these in SQL Server Management Studio.