<div>
There could be various reasons why CPU utilization is high in SQL (missing indexes/outdated stats being one of the most common as far as I'm aware) and I recommend you use SQL own Performance Dashboard reports for deeper in detail analysis why the CPU is so high - down to the query level.<br />
<br />
<a href="https://www.microsoft.com/en-ca/download/details.aspx?id=29063" rel="ugc">https://www.microsoft.com/en-ca/download/details.aspx?id=29063</a><br />
<a href="http://www.sqlshack.com/performance-dashboard-reports-sql-server-2014/" rel="ugc">http://www.sqlshack.com/performance-dashboard-reports-sql-server-2014/</a><br />
<br />
Anti-virus software can also do this in some occasions if SQL own database files mfd, ldf, ndf, aren't excluding from scanning.
</div>


<div>
This may help:<br />
<br />
<a href="https://www.mssqltips.com/sqlservertip/2827/troubleshooting-sql-server-resourcesemaphore-waittype-memory-issues/" rel="ugc">https://www.mssqltips.com/sqlservertip/2827/troubleshooting-sql-server-resourcesemaphore-waittype-memory-issues/</a>
</div>


<div>
However, seeing just the summary of the wait type doesn't help too much to pinpoint the particular query(ies) that is(are) causing it. For that I recommend you to install the Adam Mechanic's sp_whoisactive stored procedure and execute it to see what exactly processes/queries have that wait type:<br />
<br />
<a href="http://sqlblog.com/files/folders/beta/entry42453.aspx" rel="ugc">http://sqlblog.com/files/folders/beta/entry42453.aspx</a><br />
<br />
Just install it in master database and then execute it with:<br />
<br />
EXEC sp_whoisactive<br />
<br />
and look for queries with a lot of CPU in CPU column and their wait type in wait_info column. here are article how you can use the procedure for more complex monitoring:<br />
<br />
<a href="https://www.brentozar.com/archive/2010/09/sql-server-dba-scripts-how-to-find-slow-sql-server-queries/" rel="ugc">https://www.brentozar.com/archive/2010/09/sql-server-dba-scripts-how-to-find-slow-sql-server-queries/</a><br />
<br />
<a href="https://www.brentozar.com/responder/log-sp_whoisactive-to-a-table/" rel="ugc">https://www.brentozar.com/responder/log-sp_whoisactive-to-a-table/</a>
</div>


<div>
1. Restart SQL Server services first and then see the shoot up of memory and CPU. <br />
<br />
2. If the utilization is still high then check the session which is consuming it.<br />
<br />
3. Check whats going on.. if any query is taking too much of time the update the stats and rebuild indexes on the tables used.<br />
<br />
Please let me know if you still face any issues.
</div>


<div>
<blockquote>
I have a few instances of SQL on 2014 SP2 and they are using CPU consistently.
</blockquote>
Are all those instances in the same box or each machine has their own SQL Server instance?<br />
Can you provide the machine configuration (CPU &amp;&nbsp;RAM)?<br />
How the CPU usage looks like in the Task Manager?
</div>


<div>
<blockquote>
I have a few instances of SQL on 2014 SP2 and they are using CPU consistently.
</blockquote>
Are all the SQL Server instances in a single server or each machine has their own SQL Server instance?<br />
How the CPU usage looks like in the Task Manager?<br />
Can you provide the machine configuration (CPU &amp;&nbsp;RAM)?
</div>


<div>
<blockquote>
1. Restart SQL Server services first and then see the shoot up of memory and CPU. 
</blockquote>
This should be your last resort. First you have to check if you can identify the cause of this symptom and remove it. If it will still persist then you can try a SQL service restart.
</div>


<div>
<blockquote>
1. Restart SQL Server services first and then see the shoot up of memory and CPU. 
</blockquote>
This is the typical solution usually used by developers that aren't used to work in production and in a shared environment.
</div>


<div>
15 express instances, all on the same server. &nbsp;1 socket, 4 core- 2014 SP2. &nbsp;18GB RAM.<br />
<br />
The problem is that something triggers the resource monitor to start using CPU and it never stops. &nbsp;So each instance will use ~6% of the CPU until the server is restarted. &nbsp;Restarting the instance does not restart this behavior.<br />
<br />
We don't run AV on the SQL servers.<br />
<br />
If I restart the SQL service and no users connect to it, it still will use CPU continually. &nbsp;All instances target server memory match total server memory.
</div>


<div>
For reference, that CPU time (51,522,968) is over the course of 4 days. &nbsp;I only see this usage on SQL 2014 servers (we have 2).<br />
<br />
On a SQL 2012 R2 server after 7 days the max CPU time for resource monitor on any instance is 179,120.
</div>


<div>
<blockquote>
15 express instances, all on the same server. &nbsp;1 socket, 4 core- 2014 SP2. &nbsp;18GB RAM.<br />

</blockquote>
This is the same server where you got the issue last week with the Restore command? If so, I thought that you had increased the memory of the server.<br />
<br />
Anyway 15 Express Editions can only use a maximum of 15GB RAM so OS will still have 3GB for itself.<br />
Are any of those SQL Server instances facing heavy tasks?<br />
IMO you should provide more CPU to the server or better is to migrate at least half of the instances to a new server.
</div>


<div>
This is a different server-- &nbsp;but this is abnormal behavior. &nbsp;None of my other servers (there are about 160) use any CPU like this, even with more load. &nbsp;<br />
<br />
I attached 2 CPU graphs since June of servers that have 30 instances on them. &nbsp; I'd like to find out what is causing the problem and fix that, why is it only (seems to be) 2014 that does this? &nbsp;Is there a way to see what RESOURCE MONITOR is busy doing?<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/09_w38/1116614/sqlNormal1.png" target="_blank" class="file-inline" title="sqlNormal1.png (17 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>sqlNormal1.png</a><br />
<a href="https://filedb.experts-exchange.com/incoming/2016/09_w38/1116615/sqlNormal2.png" target="_blank" class="file-inline" title="sqlNormal2.png (18 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>sqlNormal2.png</a>
</div>


sqlNormal1.png

sqlNormal2.png

<div>
All 15 instances has user databases? If not then shutdown the ones that doesn't have databases to see if it helps.<br />
Or if you can, shutdown each instance at a time and give some minutes to check the CPU behavior. The one that you shutdown and release CPU time should be the one that has issues.
</div>


<div>
All 15 have user databases- &nbsp;I did try shutting them down one by one but the problem persisted. &nbsp;When I restart the instances one by one, they immediately resume using CPU and the CPU time for RESOURCE MONITOR is the only thing being used. &nbsp;If the instance has already started doing this, when the service is restarted the CPU resumes abnormal usage.<br />
<br />
Only a server reboot resolves the issue.
</div>


<div>
<blockquote>
Only a server reboot resolves the issue. 
</blockquote>
But temporary, right?<br />
What's the behavior if only one of the 15 instances is up and running?
</div>


<div>
Yes, the reboot clears the issue for anywhere from 12 hours - 36 hours.<br />
With only 1 instance using ~6-8% CPU constantly.
</div>


<div>
<blockquote>
With only 1 instance using ~6-8% CPU constantly. 
</blockquote>
Can we say that 2 instances uses 12-16% of CPU or isn't that linear?
</div>


<div>
Yeah it's fairly linear. &nbsp;With 2 instances it is about 10-12%.<br />
<br />
However, there are no connections on the database after restart while the CPU is being used.
</div>


<div>
<blockquote>
there are no connections on the database after restart while the CPU is being used. 
</blockquote>
This is the weird part. I guess you already tried to run a trace to capture the SQL Server instances activities after they restart, right?
</div>


<div>
Nothing on the trace after an instance restart, but CPU going. &nbsp;<br />
<br />
If I then log in and run my query to see CPU time, I can see it just continually going up into the millions.<br />
<br />
I'm using:<br />

<pre><code class="code-10 nolinks" id="code-20-41798223-1"><span>;with cte ([totalCPU]) as (select sum(cpu) from   master.dbo.sysprocesses)</span>
<span>select </span>
<span>	  tblSysprocess.spid</span>
<span>	, tblSysprocess.cpu</span>
<span>	, CONVERT(BIGINT,(tblSysprocess.cpu * CONVERT(BIGINT,100))) / CONVERT(BIGINT, cte.totalCPU) as [percentileCPU]</span>
<span>	, tblSysprocess.physical_io</span>
<span>	, tblSysprocess.memusage</span>
<span>	, tblSysprocess.cmd</span>
<span>	, tblSysProcess.lastwaittype</span>
<span>from   master.dbo.sysprocesses tblSysprocess</span>
<span>         cross apply cte</span>
<span>order by tblSysprocess.cpu desc</span>
</code></pre>
<br />
to generate that table I submitted in original post.
</div>


<div>
Only seemed to be an issue with the 2014 environment. &nbsp;DB's diff'd back to 2012 don't have the issue.
</div>


<div>
<div class="content wysiwyg-content">
I have a few instances of SQL on 2014 SP2 and they are using CPU consistently. &nbsp;There doesn't appear to be any memory pressure, and all instances have this same issue.<br />
<br />
Is there a known bug or reason why this CPU usage would be so high?<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/09_w38/1116416/sqlResourceManager.png" target="_blank" class="file-inline" title="sqlResourceManager.png (49 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>sqlResourceManager.png</a>
</div>
</div>


sqlResourceManager.png

I have a few instances of SQL on 2014 SP2 and they are using CPU consistently.  There doesn't appear to be any memory pressure, and all instances have this same issue.

Is there a known bug or reason why this CPU usage would be so high?

SQL Server CPU usage (Resource Monitor)

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.