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

• 
  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.

  PDinCA December 06, 2017 18:43

  - 0 +
• 
  I also have this same issue.

  Jamesrs December 07, 2017 01:15

  - 0 +
• 
  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...

  torsten.strauss December 07, 2017 16:48

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

  PhilS December 08, 2017 09:21

  - 0 +
• 
  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

  Andrei R December 08, 2017 15:02

  - 0 +
• 
  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.

  PhilS December 08, 2017 15:10

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

  Andrei R December 08, 2017 15:13

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

  PhilS December 08, 2017 15:14

  - 0 +
• 
  Could you please tell us which version of Prompt (9.0.0 / 9.0.1 / 9.0.2 ) and SSMS you are using
  
  Thanks!

  Andrei R December 08, 2017 15:18

  - 0 +
• 
  Prompt: 9.0.2
  SSMS: 17.3

  PhilS December 08, 2017 15:20

  - 0 +
• 
  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.

  Andrei R December 08, 2017 15:24

  - 0 +
• 
  Hi!
  
  Same here! Time, code lines, tabs differs.
  Version
  SSMS 17.3
  VS 2015 latest update
  SQLPrompt 9.0.2.3223
  

  torsten.strauss December 08, 2017 15:29

  - 0 +
• 
  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.
  
  
  

  Anu D March 28, 2018 12:26

  - 0 +
• 
  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. 

  RichardL March 30, 2018 15:25

  - 0 +
• 
  Hi Richards!
  
  Thanks for your support, I will give it a try and report in a few weeks.
  
  Torsten
  

  torsten.strauss April 03, 2018 01:04

  - 0 +

Add comment

Please sign in to leave a comment.