Is there a way to found out what is the CPU usage of the reporting server? Sometimes the CPU usage is rised up by 40% percent for several seconds. I think the reporting server is causing it but I am not able to track it down.
I have try different techniques:
- SQL Server Performance Dashboard Reports
- Activity top session report
- this query
- looking at ExecutionLog3 View
The major problem is that the CPU usage value is raised from 20 to 60 percent for several seconds only. A lot of queries are executed and I am not able to identify which ones belongs to the reporting server.
Also, a bit of offtopic, but I have read that is a good practice to use the reporting server of the secondary databases when you have
Always on Availability Group - is there any other licence requirements?