Refresh Suggestions Keyboard Shortcut Stops Working

coneill

Has anyone experienced this?  When I first open SSMS, for some period of time (usually 5-10 minutes) Ctrl+Shift+D refreshes the suggestions.  Then it stops working, I have to manually go to the SQL Prompt menu and click refresh.  If I close SSMS and re-open, it'll work for a little while again, then stop.

Kurt_M

Hi @coneill

It's possible that SSMS itself could be causing the issue. As a 32-bit application, SSMS can only access up to 4GB of memory on a 64-bit system. If SSMS is maxing out memory wise, then this might be one of the causes of your issue. To help resolve this, you could consider managing the size of your query windows, the number of open tabs and windows and closing any of them you aren't currently using. 

Additionally, you can try using the Connections tab under SQL Prompt > Options to limit the number of servers that SQL Prompt loads suggestions for. This may help prevent SQL Prompt from slowing down by loading too many suggestions at once.

 

coneill

Thank you, I'll give these suggestions a shot.

Joelg

Since a couple of weeks (or months back: I don't remember) the action to refresh using keyboard shortcut Ctrl+Shift+D stopped working.

• The menu says this command is assigned. 
• Clicking the menu item with the mouse still works.

I solved it by assigning the command to Ctrl+Shift+R in Tools/Options instead and it started working again.



Joel Greijer

Joelg

Found the root cause. It was Techsmith Snagit that stole the ctrl+shift+D shortcut for me. I had to disable it and all started working!