SQL Prompt sooooo slow

• 
  Hi Eva,
  
  Thank you for your post.
  
  Is SQL Prompt still slow if it is the only tool installed? 
  
  Could you try to disable the auto-refresh experimental feature (SQL Prompt > Options > Labs > Experimental features).
  
  
  

  Ben_P June 23, 2021 11:23

  - 0 +
• 
  Hi Ben
  
  Thank for your answer
  
  The experimental features were disabled
  
  
  

  EvaE June 23, 2021 11:26

  - 0 +
• 
  Hi Eva,
  
  Do you mean that it was already disabled and so not the cause of the slowness or that you have now disabled it and SQL Prompt is no longer slow? 
  
  
  

  Ben_P June 23, 2021 11:32

  - 0 +
• 
  Hi Ben,
  
  Sorry. It was already disabled

  EvaE June 23, 2021 11:33

  - 0 +
• 
  In that case could you try disabling the built-in intellisense under Options > Text Editor > Transact-SQL > Intellisense
  
  When you right-click in Object Explore is it slow?

  Ben_P June 23, 2021 12:10

  - 0 +
• 

  Ben_P said:

  In that case could you try disabling the built-in intellisense under Options > Text Editor > Transact-SQL > Intellisense
  
  When you right-click in Object Explore is it slow?  

  
  1. Done
  2. No, it's not
  
  

  EvaE June 23, 2021 13:04

  - 0 +
• 
  After Disabling intellisense has there been any improvement?
  
  If it is still slow though it may be due to the version of SSMS you are running. If possible please update to the latest version of SSMS. SQL Prompt does not work that well with SSMS 16 so ideally the latest version would be best. Alternatively though it will also work with SSMS 17. 
  
  

  Ben_P June 24, 2021 08:48

  - 0 +
• 
  I am using SSMS 16. I'll update it
  
  thanks, Ben

  EvaE June 24, 2021 08:52

  - 0 +

Add comment

Please sign in to leave a comment.