Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [cpu]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
22 views

Is there a way to assign PostgreSQL users' a priority level?

Does postgresql have the ability to assign users of a database "priorities" in order to decide how much resources (memory, CPU,..) we allocate for the user? Think about it like subscription ...
Sabaa's user avatar
  • 1
0 votes
1 answer
52 views

which db consume more core from my computer

I have several db in my instance in SQL Server. I wonder which db consume more core from my computer. How to find this information?
Merve's user avatar
  • 55
0 votes
0 answers
57 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 ...
Roman Schmidt's user avatar
0 votes
1 answer
46 views

Do threads that have finished processing rows, or threads that don't process any rows consume 4ms cpu time slice?

Say for a operator there are 8 threads. One control thread and 7 worker threads. Do threads that don't have any work, that is - either of the below consume the 4ms cpu time?: Thread that has finished ...
variable's user avatar
  • 3,636
8 votes
1 answer
1k views

Database-Instance using half of available CPU cores

I'm looking at the following scenario: MSSQL Server 2019 Standard running on Windows Server 2016. sys.dm_os_schedulers shows 12 available logical CPU cores. Those 12 cores are split between 2 sockets....
hcm's user avatar
  • 183
1 vote
2 answers
190 views

Track CPU time used by a Stored Procedure

I need to track CPU time (not duration!) used by a stored procedure. Procedure has many SQL statements inside it. I've tried module_end event in Extended Events, but it does not have cpu_time field (...
Aleksey Vitsko's user avatar
1 vote
1 answer
72 views

cpulimit/iolimit per mysql/mariadb user

I can set cpulimit, iolimit, etc for mysql process by moving its pid into cgroup.procs file of a cgroup. But single mysql process handles all the queries(threads) and I cant set cpulimit to the entire ...
jay's user avatar
  • 11
-2 votes
1 answer
225 views

Huge PREEMPTIVE_OS_GETPROCADDRESS Waits From sp_OAMethod. How to debug?

Some queries are hitting my CPU extremely hard. sp_WhoIsActive reports that sp_OAMethod is the cause (the sql_text column points to it) and that it has of huge waits of the ...
J. Mini's user avatar
  • 433
0 votes
0 answers
80 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 ...
netikras's user avatar
  • 101
0 votes
1 answer
88 views

How do I identify what appears to be a CPU bottleneck within SQL Sever?

I have virtual machines on two different types of hosts (vmware). Host type A has CPUs with a clock speed of 2.09GHz Host type B has CPUs with a clock speed of 2.69GHz All other resources are the same ...
Eta_Argus's user avatar
1 vote
2 answers
81 views

When can we downsize Azure Virtual machine for SQL Server?

For now our production SQL Server is Standard_D96ds_v5 Azure VM machine. We got request to check if we can downsize server to Standard_D48ds_v5. What measures will take into consideration to have ...
adam.g's user avatar
  • 355
1 vote
3 answers
542 views

Sudden spike in BinLogDiskUsage

Two days ago our MySQL RDS instance saw a sudden spike in BinLogDiskUsage, CPUUtilization, NetworkReceiveThroughput and NetworkTransmitThroughput. The result was a database that was extremely slow to ...
RED_Tom's user avatar
  • 13
0 votes
1 answer
132 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 ...
JM John's user avatar
  • 13
0 votes
1 answer
745 views

How to Check if SQL Server is Running Out of Memory or CPU Resources RIGHT NOW?

I recently noticed an error message in my SQL Server error log that said "The query processor ran out of internal resources and could not produce a query plan." I suspect that my server ...
Fajela Tajkiya's user avatar
-1 votes
1 answer
184 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 ...
Sajid Khan's user avatar
0 votes
1 answer
746 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 ...
Federico Baù's user avatar
2 votes
0 answers
1k 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 ...
MDR's user avatar
  • 121
1 vote
1 answer
404 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? ...
Risky Ageng Kharisma's user avatar
2 votes
2 answers
615 views

SQL Server - performance for certain partition is slow until restart

On production environment, randomly having strange issue. There are tables with days as partition (1,2..31). There is only last 5 day data in tables, there are also tables which doesn't have ...
Rezo's user avatar
  • 41
2 votes
0 answers
427 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 ...
CCR's user avatar
  • 21
0 votes
2 answers
2k views

Is there any way to find out if SQL Server is using all of CPU cores? [duplicate]

I have SQL server licensed to 16 cores only i have 48 core CPU. Is there any way to know that SQL is reaching or utilizing its peak 16 cores limit all time? any way to find it out? as i am having ...
Farhan's user avatar
  • 121
0 votes
1 answer
700 views

How to limit CPU by Db2 instance?

On Linux/x86_64 I have several Db2 database instances and most of them have one database per instance. Today I have had one "run away instance" that consumed most of the CPU resources of ...
folow's user avatar
  • 339
0 votes
1 answer
265 views

How does SQL Server's Performance Dashboard categorize a query as "ad-hoc" or otherwise?

I'm looking at the CPU usage in sql server's server performance dashboard report. I have 10 dbs on the server. So the pie chart shows me 85% for adhoc queries. Whereas only 15% is split amongst all ...
variable's user avatar
  • 3,636
2 votes
2 answers
268 views

Is it possible to query total CPU load on system that is hosting SQL Server 2014+ Express?

I can get the available memory by querying the [master].[sys].[dm_os_sys_memory] view, but I haven't found anything similar for getting info about the CPU load. I only find info about querying CPU ...
Martin Riddar's user avatar
0 votes
0 answers
81 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 - ...
FrugalShaun's user avatar
-1 votes
2 answers
363 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 ...
variable's user avatar
  • 3,636
0 votes
1 answer
117 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://learn.microsoft.com/en-us/troubleshoot/sql/performance/troubleshoot-high-cpu-usage-issues#step-1-verify-that-sql-server-is-causing-high-cpu-usage ...
variable's user avatar
  • 3,636
0 votes
0 answers
186 views

SQL 2019 Std Edition high recompilation and CPU spike [closed]

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 ...
kanishka basak's user avatar
0 votes
2 answers
380 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 ...
folow's user avatar
  • 339
2 votes
1 answer
676 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 ...
salim's user avatar
  • 21
0 votes
1 answer
229 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
erafi gen's user avatar
0 votes
0 answers
289 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....
Burt King's user avatar
0 votes
1 answer
127 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 ...
TheDataGuy's user avatar
  • 1,950
2 votes
2 answers
760 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 ...
Ivan Bonanno's user avatar
-1 votes
2 answers
1k 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 ...
ronnz's user avatar
  • 9
0 votes
0 answers
214 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 ...
Hasan Baidoun's user avatar
1 vote
0 answers
848 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 ...
Hamza AZIZ's user avatar
0 votes
1 answer
3k 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 % /...
sibert's user avatar
  • 176
3 votes
1 answer
28k 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 ...
Mike Burgmuller's user avatar
1 vote
1 answer
330 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 ...
xhr489's user avatar
  • 807
0 votes
1 answer
533 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 ...
PTL_SQL's user avatar
  • 341
0 votes
0 answers
269 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 ...
Santosh Pericharan's user avatar
0 votes
1 answer
494 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 ...
SQL_Guy's user avatar
  • 665
2 votes
1 answer
127 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&...
sarme's user avatar
  • 446
3 votes
1 answer
858 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 ...
Aleksey Vitsko's user avatar
1 vote
2 answers
326 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 ...
Newbie-DBA's user avatar
2 votes
1 answer
688 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 ...
JR Van Allen's user avatar
0 votes
2 answers
1k 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 ...
Odin's user avatar
  • 11
2 votes
2 answers
1k 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 ...
Garry's user avatar
  • 73
0 votes
1 answer
573 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:...
BeginnerDBA's user avatar
  • 2,170