All Questions
Tagged with cpu performance
4 questions with no upvoted or accepted answers
1
vote
0
answers
53
views
SQL Server suddenly using a lot of CPU: 300 compilations/s vs 2 batches/s
A instance of SQL Server Express 2016 that I'm in charge of has suddenly started to use a lot more CPU that usual. It's the backend database for a website, but doesn't see all that many queries due to ...
- 11
0
votes
0
answers
151
views
How to monitor Postgres workers' utilization?
I have a client who has a legacy application using a Postgres DB. They have SEVERE performance issues, so they figured it might be a good idea to scale their DB server to the GCP's max. Performance ...
- 101
0
votes
1
answer
1k
views
MySQL | Measure overall query cost (performance, cpu usage, memory usage)
The Problem
You have a MySQL query, let's say a SELECT and you need to identify its overall cost in all aspect (Host Resource Usage, Query speed / performance ...) so that your result can be ...
- 151
0
votes
0
answers
139
views
Trying to identify if the query is long running or long waiting
I have a sql query which has multiple joins and uses a view which has multiple joins.I captured the query in sql profiler and i see few information in there.
I am trying to understand whether the ...
- 1,335