Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [cpu]

124 questions
22
votes
1 answer

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 the problem is with the 9.6 version, I did…
Raj
  • 405
  • 1
  • 4
  • 9
12
votes
3 answers

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 was added to this SQL Server since my last post. …
Emptyslot
  • 459
  • 4
  • 11
9
votes
2 answers

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 coming from CPU, and one query specifically: As…
kspearrin
  • 305
  • 3
  • 7
8
votes
1 answer

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. Even though they're sitting on 2 sockets, they…
hcm
  • 183
  • 5
7
votes
1 answer

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 short period of time. I have removed all other…
vipes
  • 173
  • 1
  • 5
7
votes
3 answers

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 thousand records to a few hundred thousand…
cheslijones
  • 413
  • 2
  • 7
  • 12
6
votes
1 answer

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 AS [Hyperthread Ratio], cpu_count/hyperthread_ratio…
Marcello Miorelli
  • 17,274
  • 53
  • 180
  • 320
5
votes
2 answers

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 following standard entry on startup: SQL Server detected 2…
JamesLean
  • 391
  • 1
  • 4
  • 10
4
votes
0 answers

SQL Server, what is the optimal Processor & Core configuration for VMs?

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 expected. My question is this: Have you ever looked into…
Jake Cohen
  • 41
  • 4
4
votes
1 answer

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 CPU. I want to know will zlib store more data in…
Alireza
  • 3,676
  • 10
  • 38
  • 44
4
votes
3 answers

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 the sleeping sessions The application name is…
Singh
  • 53
  • 1
  • 1
  • 4
4
votes
4 answers

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 keep the legacy code with lots of slow queries like…
Ricardo Gonçalves
  • 143
  • 1
  • 5
3
votes
1 answer

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 first 3 NUMA nodes, the other set to use all the CPUs…
influent
  • 339
  • 4
  • 15
3
votes
1 answer

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 recently cpu usage was really high, # uptime …
Mike Burgmuller
  • 31
  • 1
  • 1
  • 2
3
votes
1 answer

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 resolved the issue) Issue start: 12:15 Issue end: …
Aleksey Vitsko
  • 6,148
  • 5
  • 39
  • 70
1
2 3
…
8 9