Questions tagged [cpu]
The cpu tag has no usage guidance.
83
questions
0
votes
1answer
46 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 ...
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&...
3
votes
1answer
125 views
SQL Server High CPU usage and RESOURCE_SEMAPHORE waits
Last week had an issue on one of SQL Servers, CPU started burning over 80 % (normal is 10-30 %)
This lasted for about 2 hours until I manually failed over to secondary replica in AG (and this has ...
1
vote
2answers
40 views
Unable to understand correlation between MaxWorkers created and CPU utilization
I am having a strange issue which i am unable to understand:
On my server with 64 Logical processors having maxworkers 1472, there are peak periods in day where workers created for an hour lets say ...
2
votes
1answer
78 views
SQL Server 2019 running 100% on only 1-2 cores with MAXDOP 8 to 14
Here is the background on this issue.
I am inserting slightly over 1 million records into a table from within a C++ program using ADO. One row at a time is read in from flat file and converted info a ...
0
votes
3answers
101 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
46 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
47 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, ...
3
votes
2answers
103 views
SQL Server Socket/CPU Configuration [closed]
In your opinion what is the best configuration for optimal SQL Server performance in regards to virtual guest Socket/CPU configuration? I've read numerous articles stating wide socket configuration (1 ...
1
vote
2answers
97 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
61 views
How can I provision more CPU from VMware when MAXDOP is set to 1?
We have a BizTalk Server group hosted over seven servers, all hosted in VMware. This group comprises four BizTalk application servers and three SQL Server instances.
As per Microsoft's out of the box ...
2
votes
1answer
98 views
CPU for SQL Server
We want to buy a new server for SQL server,
We have around 10 DB, and heavy jobs every 10 minutes to process millions of records,
Also, we have around 20 end users,
We want to know what is the best ...
0
votes
2answers
266 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 ...
1
vote
1answer
56 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
1answer
49 views
MySQL shows CPU usage over 40% though total CPU usage is less than 30% as per TOP - How to debug this issue?
Not sure if I am reading this incorrectly. In the below screenshot of TOP command, it shows that mysql process CPU usage is 41.2% but at the 4 core CPU shows a total of 26% usage.
is MYSQL not ...
0
votes
1answer
26 views
What is the effect of number of CPU cores on update operations in Postgres?
I have batch update operations being sent to the PostgreSQL server to be executed. Each operation (batch) will be updating rows in the same table but it is assured that they will be updating different ...
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
133 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
2answers
40 views
Backup Restore, CPU usage and Extended Events
I'm working on measuring the performance impact of Backups on CPU. I would like to capture all the backup operations and CPU usage. I'm running a weekly full backup, daily diff, and 15 min log backup. ...
0
votes
0answers
89 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
2answers
146 views
MySQL taking up 400% CPU
LEMP stack on DigitalOcean (48GB ram, 960GB SSD, 12 vCPU) with WordPress on it. Added a new theme and mysql went through the roof. 400% CPU usage taken up by MySQL itself!
Looked at slow-log to figure ...
0
votes
1answer
32 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 ...
1
vote
1answer
100 views
High CPU Usage on certain query when changing DB Compatibility Level
We migrated from SQL 2008R2 to SQL 2016 a few years ago and have been running on Compatibility Level 100 since that point.
We are looking to make use of memory optimization introduced in SQL 2016 and ...
5
votes
1answer
487 views
Why does my server have thousands of “HIDDEN ONLINE” schedulers?
We have a SQL Server 2012 instance with 16 CPU cores. When looking in sys.dm_os_schedulers we see the expected 16 rows that are "VISIBLE ONLINE", one per core. The error log shows the ...
0
votes
1answer
59 views
SQL Server - One of the cores always at 100%
I'm running SQL Server Web on a VM with 20 cores. (I know, Web edition can only make use of 16 cores but I'll get that resolved soon when I upgrade to Standard).
But what's funny to me is that for ...
1
vote
1answer
120 views
Setting MAX memory for SQL servers depending upon the model of CPU
I have a general question regrading setting up the MAX SQL memory settings-
For our current CPU with below specs, server team bumped up OS memory from 400GB to 1TB:
Intel® Xeon® Processor E5-4640 v2 ...
1
vote
1answer
517 views
What is Oracle CPU Time and CPU Usage and why is it important?
I am trying to understand Oracle's CPU Usage and CPU Time metric for its monitoring (such as in the ASH Viewer) for individual queries
From my understanding:
CPU Time -- the amount of CPU time (in ...
0
votes
2answers
76 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 ...
0
votes
2answers
67 views
SQL Server Standard Edition CPU + Tempdb Configuration
I have SQL 2014 sp3 (Standard) With below CPU Details according to 8 CPU we have configured 8 Tempdb datafiles.
Based on my configuration could you please suggest what should be the CPU & Tempdb ...
2
votes
1answer
514 views
what does I/O affinity automatically do when cpu affinity is manually set
I have a 2016 Enterprise db server with 4 processors and 24 cores which is CAL licensed. So only the first 20 cores are used. Now I would like to set affinity so SQL Server will not use the first 20 ...
2
votes
1answer
391 views
Why does my MySQL page cleaner thread step up its minimum CPU usage over time and never decrease back to zero?
I’m running a MySQL 5.7.29 instance on Ubuntu 16.04 on a dedicated Amazon EC2 t3a.XLARGE instance (4 vCPUS, 16 GiB Memory connected to an iOPS optimized EBS volume with 1000 provisioned iOPS) and have ...
3
votes
0answers
77 views
SQL Server, what is the optimal Processor & Core configuration for VMs? [duplicate]
In my day job I deal with alot of SQL Servers...and lately I've had a rash of clients running 16 cores but configured as 1 core per processor and their SQL Standard edition runs like a dog, as ...
2
votes
2answers
73 views
Virtualized SQL Server hits 100% CPU and 0 Active Memory
We recently experienced an odd crash with one of our server. We know what caused it, but we don't know why SQL Server responded the way it did.
SQL Server 2016
Here is what happened:
Friday: ...
-3
votes
1answer
1k views
What is the optimal configuration for MariaDB ? (CentOS 8, MariaDB 10.5)
Hello i have MariaDB 10.5 on a Centos 8
Server configuration
18cores 32 threads and 32gb ram
I have plenty of free ram but I am trying to optimize for CPU
less CPU work and more ram usage
How I do ...
0
votes
0answers
42 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 ...
1
vote
2answers
2k views
How to calculate the max number of worker threads in SQL Server?
I use 64-bit OS with two CPUs (each of them makes 7 logical processors) and with total number of logical processors equal to 14.
When I run this code I get 2048
SELECT max_workers_count FROM sys....
2
votes
1answer
284 views
User connections without a login
I was looking at SQL Server performance and noticed that CPU utilization goes high when the number of connections go high(I believe it is normal).Usually number of connections on an average was ...
0
votes
0answers
42 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).
...
-1
votes
1answer
199 views
Mysql keep high cpu usage and I cannot tune it down
I have an asp.net application which use Mysql as database server. In my application have some threading which will query mysql database. It always caused the Mysql database server CPU usage up to 99%. ...
0
votes
2answers
94 views
asp.net caused mysql 99% usage
I have an asp.net application which use Mysql. I test it on testing server running MySQL. When the application is running, it consumes 40% of cpu. I run the same code in production server which also ...
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 ...
3
votes
0answers
434 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 ...
0
votes
1answer
104 views
Postgres consuming a lot of cpu [closed]
I have a Java system with Postgres 8.3 and Glassfish application server, from time to time, the application is very slow at certain times - when it has more hits; by the top command, we can see the ...
3
votes
2answers
959 views
Best way to divide CPU along all sql instances on 1 server
I have a physical server with 40 CPU's (hyperthreaded) with 2 NUMA nodes. On this server I have 20 SQL Server instances installed and I need to make sure each instance has some dedicated CPU assigned ...
0
votes
1answer
1k views
Finding the cause of a stuck “Sending Data” query in MySQL
I'm running MySQL on a 1gb DigitalOcean droplet, and I have a number of scheduled tasks through the Laravel framework that run. One task in particular (seemingly) randomly causes MySQL to sit at 100% ...
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 ...
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 ...
-3
votes
1answer
239 views
Sql Server consumes CPU but no one is using the server
In my server I have a SQL process that consumes CPU (~10%) but no one is using the server.
In query select * from master.dbo.sysprocesses order by cpu desc I see at least one suspect process:
spid: 9
...
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
1answer
1k views
Thread Count is too high-what can I do in short term?
Before I posted this question read following articles.
Max. Worker Threads and when you should change it by Sakthivel Chidambaram
Are my actual worker threads exceeding the sp_configure 'max worker ...
