Refresh Suggestions Keyboard Shortcut Stops Working

coneillconeill Posts: 2 New member
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.
Tagged:

Answers

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

     

    Kind regards,

    Kurt McCormick
    Product Support Engineer, Redgate

    Need help? Take a look at our Help Center

  • coneillconeill Posts: 2 New member
    Thank you, I'll give these suggestions a shot.
Sign In or Register to comment.