All Questions
2 questions
0
votes
1
answer
397
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,499
0
votes
1
answer
521
views
While testing our workload on SQL Server 2019 we experience much higher CPU utilization compare to the same test on SQL Server 2014
We are getting ready to upgrade our SQL Server 2014 systems to SQL Server 2019. As part of our due diligence we created a workload which we are testing against both systems. What we have observed was ...
- 675