SQL takes 100% of CPU despite low activity of the DB

The configuration is as follows: An EC2 machine in AWS with SQL 2012, with 16 cores & 122 GB RAM. The application layer consists of ~150 servers which hold a lot of connections (between 3 - 5 K during peak times).

At peak times for the application, my CPU constantly goes up to 100% (sql server engine process). Using the sys.dm_exec_* DMVs & sp_whoisactive I see that the DB actually is not doing much - usually about 20 - 50 very fast queries (under 2 ms each). The number of connections is indeed high, but even dropping most of the inactive ones has little to no effect on the matter. At this point in time I don't have the ability to setup the environment to use fewer connections.

It's driving me nuts ... any advise would be most welcome :)

avatar image By Liran.E 1 asked May 23, 2017 at 06:17 AM
more ▼
(comments are locked)
10|10000 characters needed characters left

2 answers: sort voted first
avatar image By JoshisOn 1 answered May 23, 2017 at 03:30 PM
more ▼
(comments are locked)
10|10000 characters needed characters left

Memory is not the issue at all , only CPU

avatar image By Liran.E 1 answered May 25, 2017 at 07:48 AM
more ▼
(comments are locked)
10|10000 characters needed characters left
Your answer
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

Follow this question

Topics:

x91

asked: May 23, 2017 at 06:17 AM

Seen: 61 times

Last Updated: May 25, 2017 at 07:48 AM