SSMS 18.0 redraw issues when switching between multiple query windows
SSMS 18.0 redraw issues when switching between multiple query windows
Repro:
1. Open SSMS
2. Open a new query window and enter and execute a command, such as:
SELECT @@SPID;
- Open a second query window
- Using your mouse, switch back and forth between the two open query windows by clicking on their tabs.
- After several clicks (five to ten?), the content of the first window (query and result pane) may appear to be displayed in the second window, but you can't interact with any of the text.
- Switching back and forth a few more times may clear up the issue temporarily.
- The same issue may carry over to additional query windows which are opened, after switching between the various windows several times.
Glenn Burnett
shared this idea
This issue was fixed (or better, mitigated) in SSMS 18.5
As you can see, SSMS will automatically prevent the Visual Studio Shell from using the h/w acceleration.
While I hear that for some of you this workaround did not help, it seems that for the vast majority of the people here it was beneficial, so the workaround has been baked into SSMS 18.5.
Thanks,
-Matteo
119 comments
-
Derrick White
commented
I have just updated to SSMS version 18.3.1 from version 18.1
Both versions are displying the behaviour described in this bug.
I frequently need to close all tabs & restart what I am doing, because of the display corruption.
It is inconvenient & slows down productivity. -
Alveena Joyce
commented
It's true that this issue persists but this can be quickly rectified if the query window is reconnected . Just press the Change connection button and press connect (provided be sure to keep your save password button checked to reduce the number of times of entering password) . This is a method to reduce waiting time for the ssms to change tab (temporarily).
-
Matty Brown
commented
I didn't see this issue in 18.2 (15.0.18142.0), but within hours of using 18.3.1 (15.0.18183.0) I kept on experiencing this same issue and made SSMS very frustrating to work with.
Moving the window, minimising the window or any of the usual stuff that makes the window redraw temporarily fixes the the problem.
I've disabled hardware acceleration and haven't noticed the issue since. -
Matt Pugsley
commented
Have this issue with SSMS v18.2. Using multiple monitors and Windows 10.
Disabling HW acceleration cleared the issue. -
Anonymous
commented
This is happening to me in 18.2 and 18.3
Steps:
Connect object explorer
Open a recent .sql file from the File menu
Select a database
Execute the query
Click "New Query"
Toggle between the 2 tabs
You'll see the issue immediately -
Nathan Ernst
commented
I've SSMS v18.2 and v17.9.1 installed, and I'm only seeing this in v18.2. I've also VS 2019 (16.3) and VS 2017(15.9.13) and I don't see the issue in either of those. Disabling HW acceleration cleared up the issue.
-
Andrey Nekrash
commented
Hi,
I have this bug on 2 of my PCs, all of them with v18.2.
It's really confusing when you select one tab and it actually shows content from the another. If you need I can create even video with this.
It was no such issues before with v17. It was no such issues with VS 2013/17/19. -
Dean Jackson
commented
It doesn't seem like it would be a problem with the Visual Studio shell, so get with the shell team and have them look at how you open and close tabs. Maybe they can tell what you might be doing wrong. They made the shell...they know how tabs should be opened/closed.
-
Karol Sawicz
commented
had same issue on 18.2 win 10 pro
after switching HW acc off it is fine!! thanks for that tip -
Anonymous
commented
I have Visual Studio 2017 Version 15.9.15 and do not have the same behavior.
-
Russ Johnson
commented
I don't have the issue with 17.9.1
-
Adravil
commented
Unfortunately same here, on 18.2.
Downgrading version by version down to 17.9.1 didn't help.
Switching off HW acceleration -- thanks for the advice! -
Anonymous
commented
I have SSMS 17.9.1 on the same machine as 18.2 and I am only seeing the issue in the 18.2 version
-
Jeroen H
commented
Hmmm... 4 months and two point releases later this critical usability issue is still not fixed??? (Was using 17.9 before)
-
Scott
commented
Any updates on this? I just installed SSMS 18 (15.0.18142.0) and immediately began encountering this issue. It is unusable. I would rather not turn off HW accel.
I also have Visual Studio 2017 (15.9.28307.812), but I have never experienced this issue in VS.
For now I suppose I'll have to switch back to SSMS 17.
thanks! -
GCSCGJ
commented
18.2 Switching HW acceleration off solved the issue. Thank you
-
Anonymous
commented
It happened in 17.9, 18.0, 18.1 to me. Switching HW acceleration off solved the issue.
More details: https://social.msdn.microsoft.com/Forums/en-US/a94f20fd-e74e-474d-9b60-0b2ab05c94d3/ssms-display-problems?forum=sqltools -
Jeremiah
commented
I am seeing this as well
I do have VS2017 installed and up-to-date and do not see this issue. I do not have SSMS 2017 installed.
SQL Server Management Studio 15.0.18131.0
Microsoft Analysis Services Client Tools 15.0.1347.0
Microsoft Data Access Components (MDAC) 10.0.17134.1
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.11.17134.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 10.0.17134*** UPDATE ***
Disabling Hardware Excelleration solved this issue for me -
Dmitrii
commented
This happened to me with versions 18.2 and 17.9.1. When I Connected to SQL server, all of controls disappeared, and showed only when resizing the app. Redrawing also took place.
After unchecking "Use hardware graphics acceleration" problem was solved.
My video-system is AMD Radeon R7 200 Series -
Wilhelm
commented
This has been happening to me as well since installing 18.2, at first it was happening about once a day but now it happens every 2/3 times I change tab and its becoming rather a nightmare to manage. I will try disabling hardware acceleration.