CPU allocation of 100% after a while in SSMS and VS after upgrade to version 9

torsten.strauss

Hi Redgate Team,

since the last SQL Prompt update to version 9 I experience a massive CPU utilization after a while.
I encountered the problem on two different machines.
The CPU consumption of SSMS and VS becomes 100% and forces me to restart my machine.
My personal observation is, that this seems to be caused by the new code rule analysis and this it true in SSMS as well as VS.

Can you please check what the reason is, but do not concentrate on the code rules only cause this is just my guess.

Thanks a lot!

Torsten

PDinCA

One of my co-developers has this, too.

I'm about to post ANOTHER big bug re the new SMELLY CODE SMELLS feature...

SQL Prompt Log File for typical day available - no ERROR Messages or Exceptions are associated with this 100% CPU eating behavior.

Jamesrs

I also have this same issue.

torsten.strauss

I switched off Code Analysis Rules for 1.5 days and I do not see the high CPU utilization anymore.
I guess there is a dependeny between setting the CPU on fire and enabling Code Rules...

PhilS

I've got the same issue here - CPU shoots up to 100% and locks up and I have to kill management studio

Andrei R

Hello! Thank you for reporting this issue.

Do you recall how long it was before the CPU usage became a problem ?
Also, anything else you can say about what you were doing would be very helpful (approx size of open script, constant script changes, etc).

Thank you

PhilS

For me - the scripts don't have to be particularly large, the one I was working last time was about 650 lines. I did have quite a few tabs open in management studio thought if that makes a difference? Like others though - once I've disabled code analysis i've not had any problems.

Andrei R

When you had Code Analysis on, how long did it take, after starting SSMS, before the CPU usage was a problem ?

PhilS

it seemed to vary - from minutes to hours. there wasn't really any set pattern.

Andrei R

Could you please tell us which version of Prompt (9.0.0 / 9.0.1 / 9.0.2 ) and SSMS you are using

Thanks!

PhilS

Prompt: 9.0.2
SSMS: 17.3

Andrei R

Thank you. We'll try to find the cause of the issue.

If you notice any exceptions, or anything in the log files, please upload them here as well.

I've created SP-6734 to track this internally and we'll let you know when we find a fix for the issue.

torsten.strauss

Hi!

Same here! Time, code lines, tabs differs.
Version
SSMS 17.3
VS 2015 latest update
SQLPrompt 9.0.2.3223

Anu D

Hi  there,

We have done improvements with regards to performance of SQL Prompt. Please try the latest version and let us know if you have any issues with it.

RichardL

Hi @torsten.strauss

The latest version is available for download below. 

ftp://support.red-gate.com/patches/SQLPrompt/28Mar2018/SQLPrompt_9.1.5.4619.exe

Kind regards

Richard Lynch. 

torsten.strauss

Hi Richards!

Thanks for your support, I will give it a try and report in a few weeks.

Torsten