How can we help you today? How can we help you today?

SQL Prompt causes SSMS to hang

Hi
On a daily basis SQL Prompt causes SSMS to hang when looking for a suggestion.
I am typing a command and the SQL Prompt dialog appears to aid typing but then the SSMS hangs. I haven't found anything consistent as to why that is or happens so its hard to give you more info.

The command today was

SELECT TOP 10 * FROM myDB..myTable AS MT WHERE index (and at this point the popup comes up and hangs)

I was in master DB in the query window

I have about 8 windows open and 2 management studios.

Version info

Microsoft SQL Server Management Studio 13.0.16106.4
Microsoft Analysis Services Client Tools 13.0.1700.441
Microsoft Data Access Components (MDAC) 6.1.7601.17514
Microsoft MSXML 3.0 4.0 6.0
Microsoft Internet Explorer 9.11.9600.18893
Microsoft .NET Framework 4.0.30319.42000
Operating System 6.1.7601

SQL Prompt 9.0.7.3692
wonderbison
0

Comments

33 comments

Sort by
  • mbrooks
    Toggling 'Enable Suggestions' off does stop the hangs. I must have hit it twice by mistake. It's a workaround, but this is not a good situation.
    mbrooks
    0
  • gcomstock
    mbrooks, I toggled this feature on/off and it didn't help.  Redgate sent me a test installer with a test build that didn't help either.  At this point they have some logging files I sent them when this was occurring so I guess it's a waiting game now.
    gcomstock
    0
  • mbrooks
    I'm at a loss as why turning off prompts didn't help the first time but did after that.

    I was working on a rather messy debug script when this started, and I wonder if there was a pattern to the script that clashed with a problem in SQL Prompt. I was making changes to columns in table variables when most if not all of the hangs occurred, especially adding new ones and then referencing them in queries. I was working locally with SQL Server 2017. Both SQL Prompt and SSMS had updated recently.

    When the hangs started, my VPN was down and I brought it up in case "something" was trying to access the remote (Azure) DBs, a pattern I have seen before (not necessarily involving SQL Prompt). It didn't help.

    The hangs were long, running a minute or more each, but not permanent for the most part. There was one that left the UI dead (no updating) and I had to restart SSMS. Eventually I restarted WIndows -- it didn't help. After that I just killed and restarted SSMS each time it hung, because it was faster than waiting for the hangs to resolve.

    I saw flickering in the user interface during the hangs. This is not too unusual, because I run Windows in a VMWare Fusion VM on my MacBook Pro and the display can be a little strange sometimes. The flickering suggests that something was repainting constantly.
    mbrooks
    0

Add comment

Please sign in to leave a comment.