Ever since I installed the latest version of SQL Prompt (9.2.7.6282), after less than five minutes of working in SSMS, SSMS hangs, and I get a notice in the system tray that says, "Microsoft SQL Server Management Studio is waiting for an internal operation to complete." Eventually, I have to end the SSMS task and restart it. If I disable SQL Prompt, it seems OK, but as soon as I re-enable it, it will hang within a few minutes.
Comments
8 comments
-
Some developers at our office are experiencing exactly the same problem. There are no apparent differences between the configurations of those that are experiencing it and those who aren't, either. -
We're looking into this, but without much success. Without any way to reproduce it I suspect it may be difficult. Can you share any information about your environment?
-
-
Same here.
Problems started immediately after installing SQL Prompt 9.2.7.6282 on SSMS 17.8.1.Microsoft SQL Server Management Studio 14.0.17277.0Microsoft Analysis Services Client Tools 14.0.1016.262Microsoft Data Access Components (MDAC) 6.1.7601.17514Microsoft MSXML 3.0 4.0 6.0Microsoft Internet Explorer 9.11.9600.19080Microsoft .NET Framework 4.0.30319.42000Operating System 6.1.7601 -
In my particular instance, I'm running Windows 7 Experience N, SP 1, with 16 GB memory, 64-bit O/S.
SQL Server Management Studio is v17.8.1, with:Microsoft SQL Server Management Studio 14.0.17277.0Microsoft Analysis Services Client Tools 14.0.1016.262Microsoft Data Access Components (MDAC) 6.1.7601.17514Microsoft MSXML 3.0 4.0 6.0Microsoft Internet Explorer 9.11.9600.19080Microsoft .NET Framework 4.0.30319.42000Operating System 6.1.7601
-
Reverting to an earlier version of SQL Prompt solved the problem for me as well.TheoL said:Same problems - reverting to 9.1.16 "solved" the issues for me. I shall be waiting for 9.2.x release that fixes the issue, as this bug makes SSMS unusable for me.
Investigation with logs: last 5 lines show:
04 Sep 2018 11:25:24,736 [1] DEBUG RedGate.SqlPrompt.Engine.AutoCompletion.AutoCompleter - Inserted text : .
04 Sep 2018 11:25:24,736 [34] ERROR RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [12760] Abandoning current task 'Matching object names'.
04 Sep 2018 11:25:24,937 [8] INFO RedGate.SqlPrompt.Engine.AsyncExecution.WorkAsyncExecutor - [12776] Started task 'Code analysis task <a.sql - localhost.master (c\d (53))*>'.
04 Sep 2018 11:25:31,465 [1] DEBUG RedGate.SQLPrompt.CommonUI.Utils.UniversalAuthenticationAccessTokenCache - No access tokens in cache, returning empty collection
04 Sep 2018 11:25:31,465 [1] DEBUG RedGate.SQLPrompt.CommonVS.Editor.TextViewMonitor - OnKillFocus IVsTextView: 551067436
After this - the only action I can take is kill SSMS using Task Manager.
If I am not connected to the database, it does not crash.
-
I reverted to version 9.2.6.6145 and everything seems to be working again. We have been experiencing the same issues as above. Makes SSMS totallly unusable. Current environment info:Microsoft SQL Server Management Studio 14.0.17277.0Microsoft Analysis Services Client Tools 14.0.1016.262Microsoft Data Access Components (MDAC) 10.0.17134.1Microsoft MSXML 3.0 6.0Microsoft Internet Explorer 9.11.17134.0Microsoft .NET Framework 4.0.30319.42000Operating System 6.3.17134
-
Hi all,
We believe version 9.2.8 will correct this issue. Please download it from the ftp here. I had disabled my suggestions and had to re-enable them after updating, then restart SSMS once for it to all work properly.
Kind regards,
Alex
Add comment
Please sign in to leave a comment.