Free for PREMIUM members
[Last Call] Learn how to a build a cloud-first strategyRegister Now
Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers. It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.
I have a few instances of SQL on 2014 SP2 and they are using CPU consistently.
1. Restart SQL Server services first and then see the shoot up of memory and CPU.
15 express instances, all on the same server. 1 socket, 4 core- 2014 SP2. 18GB RAM.
Only a server reboot resolves the issue.
With only 1 instance using ~6-8% CPU constantly.
there are no connections on the database after restart while the CPU is being used.
;with cte ([totalCPU]) as (select sum(cpu) from master.dbo.sysprocesses)
, CONVERT(BIGINT,(tblSysprocess.cpu * CONVERT(BIGINT,100))) / CONVERT(BIGINT, cte.totalCPU) as [percentileCPU]
from master.dbo.sysprocesses tblSysprocess
cross apply cte
order by tblSysprocess.cpu desc
Open in new window
Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.