Question : I have an asp.net application which use Mysql. I test it on testing server running MySQL. When the […]
Tag: cpu
What is the effect of number of CPU cores on update operations in Postgres?
Question : I have batch update operations being sent to the PostgreSQL server to be executed. Each operation (batch) will […]
How can I provision more CPU from VMware when MAXDOP is set to 1?
Question : We have a BizTalk Server group hosted over seven servers, all hosted in VMware. This group comprises four […]
Alternatives to User Defined Performance Counters for CPU Monitoring – SQL 2014
Question : I want to monitor CPU usage before implementing TDE on several production SQL Servers. My plan was to […]
How to get CPU usage in MySQL per user?
Question : I want to know is there anyway to get CPU usage per user in MySQL? for example I […]
Why does my server have thousands of “HIDDEN ONLINE” schedulers?
Question : We have a SQL Server 2012 instance with 16 CPU cores. When looking in sys.dm_os_schedulers we see the […]
Why is turning on Event Scheduler Maxing my CPU?
Question : I have search the web for the last week trying to figure this out. I have exported my […]
SQL Server High CPU usage and RESOURCE_SEMAPHORE waits
Question : Last week had an issue on one of SQL Servers, CPU started burning over 80 % (normal is […]
Help with execution plan analysis
Question : I need some help interpreting this execution plan – https://www.brentozar.com/pastetheplan/?id=SJ5NYLLSL Whenever this query is ran it uses up […]
I have 600% high CPU usage mysqld
Question : I have an insane usage of cpu mysqld +600% here is the file my cnf # Example MySQL […]