Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [cpu]

95 questions
11
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…
Lenin Raj Rajasekaran
  • 295
  • 3
  • 9
11
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
  • 439
  • 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
  • 295
  • 3
  • 7
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…
cjones
  • 303
  • 1
  • 3
  • 9
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
  • 14,544
  • 46
  • 126
  • 249
5
votes
1 answer

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
  • 371
  • 1
  • 2
  • 9
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,526
  • 10
  • 34
  • 41
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
  • 3
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
  • 329
  • 4
  • 15
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
  • 4,308
  • 3
  • 21
  • 47
3
votes
2 answers

SQL Server Socket/CPU Configuration

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 cpu per socket) provides for optimal…
SQLDBAND
  • 315
  • 2
  • 4
3
votes
0 answers

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 SP2/CU1. There are no databases on the instance…
Chris Holt
  • 131
  • 2
3
votes
2 answers

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 into. The problem is that sometimes one or more…
user3213459
  • 49
  • 1
  • 3
1
2 3 4 5 6 7