Questions tagged [cpu]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-1 votes
2 answers
40 views

How to estimate cpu based on peak rate of query requests?

By default, SQL Server allows a maximum of 32767 concurrent connections which is the maximum number of users that can simultaneously log in to the SQL server instance. I am developing 10 web apis ...
user avatar
  • 2,249
-1 votes
1 answer
22 views

How would %privilege time of sqlsvr instance indicate cpu consumption of other processes?

I am looking at msdn doc to monitor cpu. Link: https://docs.microsoft.com/en-us/troubleshoot/sql/performance/troubleshoot-high-cpu-usage-issues#step-1-verify-that-sql-server-is-causing-high-cpu-usage ...
user avatar
  • 2,249
0 votes
0 answers
92 views

SQL 2019 Std Edition high recompilation and CPU spike

I am having an issue in SQL 2019 Std edition where I am seeing high compilation across multiple stored procedure. The reason for the recompilation as per the extended event trace is 'temp table ...
user avatar
0 votes
2 answers
70 views

How to get IP addresses of applications that have consumed most CPU in last 10 minutes in Db2/Linux?

Db2 v11.1 on Linux I would like to get top 5 SQL statements that consumed the most CPU in last 10 minutes and there corresponding IP addresses. I queried "package cache" table function and I ...
user avatar
  • 77
2 votes
1 answer
97 views

MySQL 5.7.37 is consuming CPU and High memory ( 90-95% )

I have a problem with my MySQL database. RAM usage is too high, CPU too. Does it come from my configuration ? Here's my configuration : auto_generate_certs ON auto_increment_increment 1 ...
user avatar
  • 21
0 votes
1 answer
39 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
user avatar
0 votes
0 answers
84 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....
user avatar
0 votes
1 answer
28 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 ...
user avatar
  • 1,688
2 votes
2 answers
165 views

CPU near 100% but exec sp_who2 doesn't return anything RUNNABLE

I have seen a Microsoft SQL Server with CPU stuck near 100% (RAM was using 20GB of 32GB). Task Manager showed that the SQL Server process was using the most of the CPU. The strange thing is exec ...
user avatar
-1 votes
2 answers
333 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 ...
user avatar
  • 9
0 votes
0 answers
54 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 ...
user avatar
1 vote
0 answers
32 views

high CPU usage of MySQL and recommendation from Mysqltunner [closed]

we have noticed that our database server is getting so high CPU (more than 90 % used by mysqld process), the output of mysqltunner is shown below, can you help me please, i'm okay about the ...
user avatar
0 votes
1 answer
364 views

Almost 100% CPU Postgresql

When I restart Postgresql 11, the CPU shows basically no CPU usage. But after a while the CPU is occupied by "kdevtmpfsi". What is this and how can I fix this? 1275 postgres 99.8 % /...
user avatar
  • 156
1 vote
1 answer
4k views

Mysql showing 100% CPU usage

We are facing problem of high cpu usage for mysql process (almost 100%). Here is the information related to server Server Infos: VPS - CENTOS 7.9 kvm - 6 GB RAM - 4 Core CPU - 180 GB SSD - MariaDB And ...
user avatar
0 votes
0 answers
30 views

Can we track historically or see queries on server is landing on which schedulers

The ask may sound weird but we are seeing sort of awkward behavior. Or may be we do not have historical data to confirm if it is true. For our 4 sockets 16 core processor SQL server with total of 64 ...
user avatar
1 vote
1 answer
107 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 ...
user avatar
  • 587
0 votes
1 answer
79 views

How to get host server CPU info from SSMS [duplicate]

Help please! I need to get number of CPU's and cores per cpu for each host server running SQL Server. Querying master.sys.dm_os_sys_info is not producing the same result as what is seen when checked ...
user avatar
  • 231
0 votes
0 answers
65 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 ...
user avatar
0 votes
1 answer
154 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 ...
user avatar
  • 575
2 votes
1 answer
56 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&...
user avatar
  • 446
3 votes
1 answer
364 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 ...
user avatar
1 vote
2 answers
57 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 ...
user avatar
2 votes
1 answer
260 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 ...
user avatar
1 vote
2 answers
320 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 ...
user avatar
  • 63
0 votes
1 answer
179 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:...
user avatar
  • 2,127
0 votes
1 answer
50 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, ...
user avatar
3 votes
2 answers
699 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 ...
user avatar
  • 315
1 vote
2 answers
241 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 ...
user avatar
1 vote
1 answer
109 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 ...
user avatar
2 votes
1 answer
459 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 ...
user avatar
  • 21
2 votes
1 answer
601 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 ...
user avatar
1 vote
1 answer
95 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 ...
user avatar
0 votes
1 answer
133 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 ...
user avatar
  • 202
0 votes
2 answers
41 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 ...
user avatar
  • 333
0 votes
0 answers
308 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 ...
user avatar
0 votes
2 answers
92 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. ...
user avatar
  • 326
0 votes
2 answers
323 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 ...
user avatar
0 votes
1 answer
159 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 ...
user avatar
  • 101
1 vote
1 answer
197 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 ...
user avatar
5 votes
1 answer
1k 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 ...
user avatar
  • 391
0 votes
1 answer
124 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 ...
user avatar
  • 1
1 vote
1 answer
148 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 ...
user avatar
  • 2,127
1 vote
1 answer
1k 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 ...
user avatar
0 votes
2 answers
83 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 ...
user avatar
0 votes
2 answers
103 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 ...
user avatar
2 votes
1 answer
1k 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 ...
user avatar
  • 21
2 votes
1 answer
685 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 ...
user avatar
4 votes
0 answers
88 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 ...
user avatar
2 votes
2 answers
211 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: ...
user avatar
-3 votes
1 answer
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 ...
user avatar
  • 13