All Questions
Tagged with cpu execution-plan
3 questions
0
votes
1
answer
399
views
How does SQL Server's Performance Dashboard categorize a query as "ad-hoc" or otherwise?
I'm looking at the CPU usage in sql server's server performance dashboard report.
I have 10 dbs on the server.
So the pie chart shows me 85% for adhoc queries. Whereas only 15% is split amongst all ...
- 3,489
0
votes
2
answers
90
views
Help with execution plan analysis
I need some help interpreting this execution plan -
https://www.brentozar.com/pastetheplan/?id=SJ5NYLLSL
Whenever this query is ran it uses up a huge amount of CPU and kills the server.
I have ...
- 13
9
votes
2
answers
9k
views
What is causing high CPU usage from this query/execution plan?
I have an Azure SQL Database that powers a .NET Core API app. Browsing the performance overview reports in the Azure Portal suggests that the majority of the load (DTU usage) on my database server is ...
- 305