Questions tagged [cpu]
The cpu tag has no usage guidance.
34 questions with no upvoted or accepted answers
3
votes
0
answers
778
views
Brand new SQL Server 2016 (SP2/CU1), has high CPU utilization with no mounted databases when the box experiences memory pressure
Brand new SQL Server 2016 (SP2/CU1), has high CPU utilization with no mounted databases when the box experiences memory pressure.
I have a test box for nightly builds with a brand new SQL Server 2016 ...
- 131
2
votes
0
answers
2k
views
MS SQL Server 2022 High CPU Usage Spikes Every Minute under no Load (Dual Processor)
Brand new MS SQL Server Standard 2022 Installation on a Dual Xeon 3416 system doing nothing and configured to do nothing fancy.
Every minute, on the minute for about 6 seconds there is a massive CPU ...
- 121
2
votes
0
answers
451
views
SQL Server 2019 CPU spikes with no usage
We've configured two SQL Server 2019 VM one it's primary and other secondary, both take part in an Availability Group.
The primary node have CPU spikes every 30 min and there isn't any job, heavy ...
- 21
2
votes
2
answers
2k
views
High CPU and plan cache instability
In the past couple of months my SQL Server instance has been experiencing higher than usual CPU usage than before, at times hitting 100% and affecting an application.
There have been no recent changes ...
- 73
2
votes
1
answer
3k
views
I have 600% high CPU usage mysqld
I have an insane usage of cpu mysqld +600% here is the file my cnf
# Example MySQL config file for medium systems.
#
# This is for a system with little memory (32M - 64M) where MySQL plays
# an ...
Alfredo
2
votes
1
answer
161
views
Do SQL OS Background Tasks Yield to Normal Tasks?
I have a SQL Server 2019 server that is running at about 22% CPU. I look at what's running and I see that about half of that 22% is coming from background tasks (i.e. the status is "background&...
- 446
1
vote
1
answer
495
views
high CPU with high user connection, mysql database
I use a VPS with 56 CPU cores and 64 GB of memory, a with MySQL database, but the CPU usage is always high for my apps - user 10.000.
This is in my mysqld.cnf. What's wrong with my settings?
...
1
vote
1
answer
692
views
MySql doesn't use extra CPU
A server running only a MySql 5.7.30 instance consumes on average around 25% of its CPU, having over 100 threads connected, and of which generally 15-25 are running threads. The CPU in the server has ...
- 111
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
1
vote
0
answers
173
views
Database with lots of writes to a big table uses less CPU than the same database with less writes?
I'm trying to understand why InnoDB/MySQL behaves the way it does and if there's anything I can change in the configuration to fix it.
I have a table with nearly 5M rows, about 9GB in size. I also ...
1
vote
0
answers
242
views
mySQL task with high cpu usage
Hi i had 2 servers with the same hardware and software configuration, booth servers had the same my.cnf flags.
Centos 7.4
Cpanel
Mysql 5.6
Multi PHP
I execute a task on both servers, and on one of ...
- 19
0
votes
0
answers
90
views
Two NumaNode0 on SQL
we encountered one mysterious problem. After adding 6 more processors to our database server, from 6 to 12, we are unable to adjust the processor settings on any of the instances.
We are now running ...
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
254
views
Slow select queries but CPU usage always less than 1%
We recently moved to a bigger server (64G, 16core Amazon EC2) and I was hoping some increased performance.
However, there are plenty of slow queries (some even 50ms) but CPU usage remains very very ...
- 13
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
98
views
SQL Server - Measuring impact of CTFP change....at server level
I have a SQL Server 2017 server and CTFP has been set to 5 since it was set up. I'm considering changing it.
I'm comfortable in monitoring the impact of this change at the individual query level - ...
- 431
0
votes
1
answer
263
views
understanding Azure Sql Databse Billed VCores
trying to migrate from sql server on-prem to azure sql database and i cant understand Duration and CPU Used and Memory Used of Billed vCores
0
votes
0
answers
344
views
SQL Server Connection Reset/sec
I am trying to determine if Connection pooling resets is causing my high cpu. I have a server with 2000 batch/sec which doesn't seem terribly high yet I have 64 CPU at 40% or greater most of the time....
0
votes
1
answer
142
views
Can set command cause more CPU usage?
Im running AWS aurora 5.7. The application stack is PHP. After moving to Aurora, I noticed that the CPU consumption is really high. When I checked the performance insights, its showing the SET command ...
- 1,960
0
votes
0
answers
283
views
MSSQL Server Resource Governance alternative
I've been looking into solutions for managing CPU sharing over multiple apps accessing the same SQL server database engine.I found that Resource Governance is one perfect way for me to define those ...
- 185
0
votes
0
answers
276
views
CPU Spike 150% on postgresql Google Cloud SQL
I get random spikes running to 150% and it settles down in 2 mins
We have a postgres 9.6 database with 2TB data. Running on 48 cores and 180GB Ram
I have checked database logs,
I have set up cron job ...
0
votes
2
answers
2k
views
MySQL high CPU usage under medium load
I'm managing a Magento server with MySQL installed in it. 16GB RAM 8 core vCPU (Digitalocean).
We're having a problem with the site becoming a bit sluggish when under medium to heavy load. Under low ...
- 11
0
votes
1
answer
72
views
Understanding the load running on my SQL server
We have a project this year to move lot of physical SQL Servers, starting with medium critical servers onto Virtual machines.
Generally on physical boxes we have a large count of logical processors, ...
- 794
0
votes
2
answers
67
views
Near identical MySQL deployments behaving very different - High CPU Usage problem
So I have five identical websites, running on five machines provisioned in the same way. The only thing that differs between these installations are the language files and the languages of the text ...
- 363
0
votes
0
answers
98
views
MySQL cpu won't go down after query; need restart
I have a query triggered towards a MySQL server. Every time I run such a query, the cpu goes up until the query ends. After that, cpu usage goes down, but not to normal value: a little cpu is still ...
- 101
0
votes
0
answers
383
views
High constant CPU on Aurora/RDS
I've noticed recently that our resting CPU on our Aurora RDS cluster appears to be about 80%. I'm unsure when this started, as we don't have alarms/metrics in place (something I plan to rectify now).
...
- 101
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
0
votes
1
answer
87
views
MySQL server upgrade, how to adapt variables?
I am about to upgrade my MySQL server because I have currently used it mainly with a couple of people in the development stage. Before we launch, however, we would like more capacity to avoid the ...
- 101
0
votes
1
answer
49
views
Percona/XtraDB Database with many of writes to a small table uses less CPU than the same database with less writes?
I'm trying to understand why Percona and xtradb InnoDB/MySQL behaves the way it does and if there's anything I can change in the configuration to fix it.
I've a InnoDB database with only one table ...
- 1
0
votes
0
answers
76
views
troubleshoot cpu usage mysql
We are running a few Mysql server on EC2 instances and RDS instances on AWS. From time to time they suddenly spike in CPU, and/or memory usage but when we login into the instances, it's too late and ...
0
votes
1
answer
61
views
Alternatives to User Defined Performance Counters for CPU Monitoring - SQL 2014
I want to monitor CPU usage before implementing TDE on several production SQL Servers.
My plan was to use user defined performance counters, over a period of a couple of days, counters as defined ...
- 1,507
-1
votes
1
answer
280
views
Threads_running is always one Mariadb 10.5
Maria DB which is installed on linux server, always shows the Threads_running one , while we have 4 core of cpu .We changed thread_handling to pool of threads , but still no result , while we have ...
-1
votes
2
answers
2k
views
Amazon RDS MySQL high CPU issues
I am hoping for a bit of help or direction on how best to troubleshoot this issue. We have recently increased our application load (more processes interacting with the DB) and the DB CPU is constantly ...
- 9
-1
votes
1
answer
368
views
High MySQL Load 700% CPU usage
My mysql takes 700% of CPU while loading the website.
top command shows -
784% of CPU
6.3% of MEM.
This is the output of lscpu command.
Architecture: x86_64
CPU op-mode(s): 32-bit, ...
