Does Spotlight have a report to show who is using the most CPU on SQL Server?
The Workload Analysis can show you CPU as resource grouped by each of the following categories:
- Database
- Application
- User
- Host
- Statement
1. Go to "Monitor | Workload Analysis"
2. Under "Resource", choose CPU
3. Select the mentioned categories
4. There is a "Save As" button on the top left of the Workload Analysis dashboard to export the information into csv file
