Question : Last week had an issue on one of SQL Servers, CPU started burning over 80 % (normal is […]
Tag: cpu
More than 15000 sleeping sessions in SQL Server 2014
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
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
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]
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?
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
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?
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?
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
Question : In the past couple of months my SQL Server instance has been experiencing higher than usual CPU usage […]