Questions tagged [cpu]
The cpu tag has no usage guidance.
45
questions
2
votes
0answers
81 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
34 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
1answer
114 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
52 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
38 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
25 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
120 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
25 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
81 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 ...
0
votes
0answers
21 views
Why is turning on Event Scheduler Maxing my CPU?
I have search the web for the last week trying to figure this out.
I have exported my tables and events, re-installed the lastest MySQL and imported.
I have tried checking individual procedures.
My ...
0
votes
1answer
105 views
How to get CPU usage in MySQL per user?
I want to know is there anyway to get CPU usage per user in MySQL? for example I have 3 different users 'user1', 'user2' and 'user3'. I want to get the average/real time memory usage and CPU usage of ...
0
votes
1answer
36 views
Where MySQL is taking time either in disk read or computation? [closed]
From SQl case study
System configuration is
Software: Percona 5.6.15-63.0. Hardware: Supermicro; X8DTG-D; 48G of RAM; 24xIntel(R) Xeon(R) CPU L5639 @ 2.13GHz, 1xSSD drive (250G)
Query is select ...
2
votes
1answer
184 views
Numa Node configuration for SQL server 2016
I have a question on one of my new build sql servers where we are planning to migrate our SQL databases from older SQL2012 running on windows 2012.
New build- SQL2016 on Windows 2016
My current [...
0
votes
1answer
181 views
Why is my AWS RDS (postgres) at a high percentage of cpu with no active sessions?
I have two postgres db, prod and dev. Lately, dev has been really slow, so I checked into it, and it appears to be using CPU credits faster than I'm getting them. I could not figure out why, so I ...
1
vote
1answer
110 views
How to Prevent heavy queries on one database, affecting the performance of other databases on same server?
I have a linux server running just Postgres with PostGIS Extension. There are several databases on this instance of the Postrges Server.
One of the databases has some computationally intensive ...
1
vote
1answer
170 views
MAX worker thread in SQL server 2012/14/16
I was just browsing the system health extended event to come across an event with diagnostic result for query processing showing status for worker threads:
Why max worker threads showing 2994 when I ...
2
votes
0answers
773 views
CPU usage constantly high after upgrading from Postgres 9.5 to 9.6 to 10.6
I upgraded my RDS instance (db.t2.medium) from Postgres 9.5 to 9.6 couple of days back. Since the upgrade, the CPU usage was almost 100% all the time. This brought down my application. Presuming that ...
-1
votes
1answer
61 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, ...
1
vote
0answers
36 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 ...
3
votes
1answer
290 views
MySQL CPU usage super high since server crashed
I've had a big crash on my server 2 days ago, still don't know why, but after resurrect it the mysql server is consuming a huge amount of cpu and I don't know why:
The server is Mariadb installed by ...
1
vote
1answer
1k views
Mysterious postgres process pegging CPU at 100%; no running queries
I have a recurring issue where a postgres process is pegging my cpu at > 100%. It's a strange one, you can see below the command is ./Ac2p20853 (surrounded by asterisks, added by me).
Running SELECT ...
-2
votes
2answers
1k views
How to query system specs (cpu, memory, data disks, free space) using t-sql [closed]
Is there an ability to query below system specifications using t-sql ?
1. cpu (show number of processors / cores / frequency)
2. memory (show total amount of RAM on a machine; show allocated RAM; ...
1
vote
1answer
238 views
What is the load impact of the Zabbix DB size query?
I am in the process of implementing Zabbix monitoring on multiple servers at an organization. I have recently run into some resistance from an Oracle / MySQL DBA. He claims that the following query ...
5
votes
1answer
835 views
Excessive Postgres Docker CPU Consumption
I'm using a Postgres container to run some small non-critical apps and sites. It's been stable for a while, but now the container has started to consume some serious CPU after it's been running for a ...
0
votes
0answers
51 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
18 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 ...
8
votes
2answers
3k views
What is causing high CPU usage from this query/execution plan?
I have an Azure SQL Database that powers a .NET Core API app. Browsing the performance overview reports in the Azure Portal suggests that the majority of the load (DTU usage) on my database server is ...
3
votes
1answer
716 views
SQL Server not using all NUMA memory with 20 core limit and affinity mask
I have a physical SQL Server 2016 SP1 machine with this spec:
CPU Sockets: 2
Cores per socket: 44
Multithreading: Yes
Number of cores: 88
RAM: 256 GB
SQL Server Max Memory: 240 GB
...
1
vote
1answer
54 views
Strange CPU load on SQL Server [closed]
Starting at midnight for 30-40 minutes our application responds slowly (or times-out completely) What would cause this kind of cpu usage on a SQL 2012 server?
I cannot find any scheduled tasks or ...
1
vote
0answers
204 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
1answer
301 views
MySQL killed query with status “copying to tmp table”
We had an ALTER TABLE statement that added a new column which was taking quite a long time on status
copying to tmp table
Given we did not know how long it will take we decided to kill the query ...
2
votes
1answer
1k views
Do I gain read performance improvement by using zlib rather than snappy compression in MongoDB?
My current storage engine is WiredTiger and its compression level is as default, snappy. I've come across MongoDB documentation and it's been mentioned that using zlib compress better but needs more ...
3
votes
1answer
1k views
how to get the CPU speed in SQL Server?
when I run the following query from Glenn Berry
-- Hardware information from SQL Server 2016 (Query 18) (Hardware Info)
SELECT cpu_count AS [Logical CPU Count], scheduler_count, hyperthread_ratio ...
1
vote
1answer
2k views
Wordpress causes high CPU usage (mysqld)
I have a wordpress site with 500k posts in MYSQL database running on debian dedicated server:
Server OS: Debian 8 "Jesssie)" - Linux version 4.9.58-xxxx-std-ipv6-64 (kernel@kernel.ovh.net) (gcc ...
2
votes
1answer
1k views
The CPU utilization spikes to 80+ even with just one user on Amazon RDS (MYSQL INNODB)
These are my RDS instance configs
Instance Class: db.m3.xlarge
Storage 40 GB
Engine MySQL 5.6.34
Multi AZ : No
I have a the node.js based backend hosted in EC2 instance and also have a cloud front ...
0
votes
2answers
67 views
Application on Different SQL Servers
In a Sql note "you should never put applications in each other's way if you do not have to.. Applications sharing memory, CPUs, internal tempdb can cause an issue. One application submitting a ...
0
votes
0answers
1k views
Availability Group Lease Timeout: what is causing 100% CPU utilization and lease time outs on PRIMARY replica?
We have an availability group
Replica-01 (Sync on-premise) PRIMARY
Replica-02 (Sync on-premise) SECONDARY
Replica-03 (Async Azure VM) SECONDARY
Replica-01 is sometimes having lease time out and ...
3
votes
3answers
5k views
More than 15000 sleeping sessions in SQL Server 2014
The CPU utilization is going to 100% regularly, and when I check SP_who2, it is showing around 20000 sessions, most of them are sleeping (also utilizing the CPU).
I think the CPU load is related to ...
11
votes
3answers
4k views
Major performance problems on our production SQL Server, how would I troubleshoot this?
This question is basically the a follow up question to this question:
Strange performance problem with SQL Server 2016
We now went productive with this system. Though another application database ...
3
votes
1answer
391 views
Cpu-Alert in SQL Server -2012 standard edition
My question is an extension to this.
We have SQL Server Agent alerts(Deadlocks, Network IO etc) to monitor SQL Server performance. So i would like to write an alert for CPU increase percentage. ...
1
vote
1answer
521 views
High memory usage due to RING_BUFFER
I have a server that is churning up the CPU using 60% to 80% constantly. Using a tool from Brent Ozar's First Responder Kit, it shows RING_BUFFER_SCHEDULER_MONITOR is the culprit. What is this, and ...
2
votes
1answer
42 views
What's the difference of setting up CPU affinity between by Server's Task Manager and by SSMS?
What's the difference of setting up CPU affinity between by Server's Task Manager and by SSMS?
Which one is more reliable?
Thanks in advance.
4
votes
3answers
8k views
Improving RAM and CPU utilization by PostgreSQL 9.6
I've been running a function on the database that is going into each table, ALTER COLUMN on all columns of a certain data type, and CAST to remove trailing zeros. About 115 tables varying from a few ...
3
votes
4answers
2k views
InnoDB memory/cpu use optimization for WordPress with MySQL
I'm not a DBA and need some help here... I have a high traffic WordPress site hosted in a EC2 instance. We are working in a new theme code that will have optimized queries, but right now I need to ...
3
votes
1answer
4k views
Is it bad to assign specific processors to SQL Server 2008 R2 cluster instances?
I have a SQL Server 2008 R2 failover cluster with a passive node and an active node. The servers are physically identical. I have two instances of SQL Server, one set to use all the CPUs in the ...
