Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: cpu

SQL Server High CPU usage and RESOURCE_SEMAPHORE waits

By adminPosted on January 12, 2023

Question : Last week had an issue on one of SQL Servers, CPU started burning over 80 % (normal is […]

More than 15000 sleeping sessions in SQL Server 2014

By adminPosted on December 8, 2022

Question : The CPU utilization is going to 100% regularly, and when I check SP_who2, it is showing around 20000 […]

Excessive Postgres Docker CPU Consumption

By adminPosted on December 3, 2022

Question : I’m using a Postgres container to run some small non-critical apps and sites. It’s been stable for a […]

Near identical MySQL deployments behaving very different – High CPU Usage problem

By adminPosted on November 16, 2022

Question : So I have five identical websites, running on five machines provisioned in the same way. The only thing […]

Postgres consuming a lot of cpu [closed]

By adminPosted on September 29, 2022

Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]

Do I gain read performance improvement by using zlib rather than snappy compression in MongoDB?

By adminPosted on September 26, 2022

Question : My current storage engine is WiredTiger and its compression level is as default, snappy. I’ve come across MongoDB […]

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

By adminPosted on September 21, 2022

Question : I have seen a Microsoft SQL Server with CPU stuck near 100% (RAM was using 20GB of 32GB). […]

Major performance problems on our production SQL Server, how would I troubleshoot this?

By adminPosted on September 5, 2022

Question : This question is basically the a follow up question to this question: Strange performance problem with SQL Server […]

What’s the difference of setting up CPU affinity between by Server’s Task Manager and by SSMS?

By adminPosted on July 27, 2022

Question : What’s the difference of setting up CPU affinity between by Server’s Task Manager and by SSMS? Which one […]

High CPU and plan cache instability

By adminPosted on July 9, 2022

Question : In the past couple of months my SQL Server instance has been experiencing higher than usual CPU usage […]

  • 1
  • 2
  • 3
  • …
  • 5

Recent Posts

  • Index issue on upgrade from SQL Server 2000 to 2012
  • How to set up SQL Server 2017 as a service
  • How can one identify if FK’s needed to be indexed apart from the NC indexes already residing
  • INSERT array elements from JSON object as table rows
  • Table design for efficiently retrieving “most recent row” per FK’d item whose PK is a GUID
  • Why does my BETWEEN predicate not match any rows? [closed]
  • MySQL using a index referencing a different column
  • mysql – Recovering databases from ibdata1 , .frm and .idb
  • Postgres: What could cause the error “cannot call populate_composite on a scalar”?
  • Safely changing innodb_buffer_pool_size on MySQL replication master?
  • Why my index don’t update?
  • MySQL – What exactly does smallint(2) permit? [duplicate]
  • Optimize a slow nested loops join
  • How to perform query operation on another query result
  • Identity column re-seed: when it is necessary?
  • MySQL -> Loop through a table, running a stored procedure on each entry
  • Optimize Postgresql query
  • How to speed up mysql query?
  • How to optimize a query for < operator
  • SQL Server transaction log [duplicate]

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding