Questions tagged [cpu]

The tag has no usage guidance.

25 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
451 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 ...
2
votes
1answer
48 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&...
1
vote
0answers
68 views

signal_wait_time_ms > wait_time_ms for SOS_SCHEDULER_YIELD in sys.dm_os_wait_stats

Question regarding SOS_SCHEDULER_YIELD when using sys.dm_os_wait_stats: Should signal_wait_time_ms not be exactly the same as wait_time_ms for the SOS_SCHEDULER_YIELD wait type? For other wait types ...
1
vote
2answers
98 views

CPU High usage crashing our server

The server where my database is running is suffering from CPU spikes. We're having trouble identifying what is causing these CPU spikes, and consequently how to mitigate them. I've tried adding some ...
1
vote
1answer
70 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 ...
1
vote
0answers
40 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 ...
1
vote
0answers
58 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
0answers
231 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 ...
0
votes
0answers
11 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
2answers
115 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 ...
0
votes
1answer
52 views

High CPU for SQL server running on VmWare

I am trying to understand the below behavior for one of our SQL server running on VM. SQL Server version 2017 has 64vCores and Host has 96 cores with base speed 2.1 GHZ Based on the article from https:...
0
votes
1answer
48 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, ...
0
votes
2answers
335 views

What can cause higher CPU time and duration for a given set of queries in trace(s) ran on two separate environments?

I'm troubleshooting a performance issue in a SQL Server DR environment for a customer. They are running queries that consistently take longer in their environment than our QA environment. After ...
0
votes
2answers
36 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 ...
0
votes
0answers
146 views

Postgres SQL CPU and RAM optimisation to improve decryption performance with pg_crypto

I am currently working on an application that requires column-based decryption for a few thousand of rows on a regular basis. The queries are decrypted using pgp_sym_decrypt, where several columns are ...
0
votes
0answers
99 views

100% CPU utilization for postgres processes

We are having 2.6M rows data within a single table and have joined with the other 2 tables having similar sizes. While running a select query it is taking 100% CPU and the query was hanging forever. ...
0
votes
1answer
35 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 ...
0
votes
0answers
44 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 ...
0
votes
0answers
44 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). ...
0
votes
0answers
29 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 ...
0
votes
1answer
35 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 ...
0
votes
1answer
33 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 ...
0
votes
0answers
71 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
1answer
44 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
votes
1answer
129 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, ...