SSMS 18.0 redraw issues when switching between multiple query windows
SSMS 18.0 redraw issues when switching between multiple query windows
1. Open SSMS
2. Open a new query window and enter and execute a command, such as:
- 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.
Thanks everybody for providing the list. I’ve passed the info to the Visual Studio Team.
In the meanwhile, I have 2 more requests:
1) If you happen to have Visual Studio 2017 (version 15.9.11 or greater), could you check and see if it shows the same behavior?
2) If you happen to have SSMS 17.9.1 on the same machine, could you check and see if it shows the same behavior?
I’m hearing from folks here that “changing SSMS such that it disables h/w acceleration by default” is not a recommended thing to do… However, quite honestly, at this point, it may be the only option I can think about.. :-(
Tim Hunch commented
I was able to resolve this by changing the compatibility mode to Windows 8. Right-click on your shortcut, choose properties, then Compatibility and change the Compatibility Mode by selecting "Run this program in compatibility mode for:" and choosing "Windows 8". The next time you run the application it will be fine.
Andy Stringer commented
Still happening for me
SQL Server Management Studio 15.0.18206.0
Microsoft Analysis Services Client Tools 15.0.1567.0
Microsoft Data Access Components (MDAC) 10.0.18362.1
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.11.18362.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 10.0.18362
For anybody who stumbles on this issue:
*Go ahead and turn off "Use hardware graphics acceleration if available" immediately.*
No need to suffer - or execute the wrong code! Everybody who disables it seems to be fine, and it completely fixes the problem.
And with all due respect to Matteo's note that changing this default is not a recommended thing to do, I cannot for the life of me understand why a modern computer would need GPU hardware acceleration to render a text editor and object tree.
Elliott Oedewaldt commented
Confirming that 18.4 has the same issue and it frustrates me to no end. Not cool to have to brake my train of thought to manually refresh the window between switching panes.
Antoine Hernandez commented
Just confirming while using 18.4, the same issue is present with 4 tabs open. My workaround is to use the mouse scroll wheel up and down a couple times and now I get into the habit of doing that as soon as I switch tabs because I'm one of those that can have a million (more like tens) of tabs open at once.
Last update and the same issue...
Bill Voltmer's comments from November 15, 2019 20:28 are accurate
I'm using Intel UHD Graphics 620.
If you unpin Object Explorer then the problem goes away. This isn't ideal but it's safer and less frustrating.
Still the Issue SSMS v18.4 on windows 10
Michael Ruel commented
I have SSMS v17.9.1 and have seen this issue. I'm not sure what has triggered it. I will see data from another query on the query I just ran or vice versa. Changing tabs does nothing and I can no longer edit the original query I was working on. The only way I've been able to clear it is to close the tab and reload. It seems to happen when you have multiple tabs open for queries. It's also not consistent in occurring.
Bill Voltmer commented
In troubleshooting a couple of factors affected the presence or absence of this failure.
1. Object Explorer pinned. If pinned, redraw sometimes fails. If not pinned, redraw never failed.
2. SSMS window on display served by Intel HD Graphics 4600 with driver 184.108.40.20663. Fails on this display but not another served by NVIDIA Quadro K3100M with driver 220.127.116.113.
I’m using SSMS 18.4 on Windows 10 Enterprise 1809 Build 17763.864. Disabling hardware acceleration resolves problem.
SSMS 17.9.1 on the same machine does not exhibit this misbehavior, even with hardware acceleration.
I agree with the other posters: this is a very scary bug and started happening almost immediately. I had two CREATE TABLE definitions up and it kept showing the wrong data on the tabs! Hello, disaster. Turning off hardware acceleration worked instantly, which raises several critical questions:
1) Why hasn't this been patched in over 7 months and 4 point releases? If it's that hard to fix or replicate, the SSMS team needs to turn off hardware acceleration by default immediately.
2) Why do we need graphics hardware acceleration on what is essentially (from a visual point of view) a text editor?
SSMS 18.4 (15.0.18206.0)
VS 2019 (16.3.9)
Plug-ins: SSMSBoost (3.7.7170)
GPU: NVIDIA GeForce GTX 1070 (DisplayPort)
This never happened with SSMS 17.9.1. It started almost immediately on switching to 18.4.
mark d commented
Was still a problem for me using v18.4 until I disabled "Use hardware graphics acceleration if available" and it seems to work better (thanks!); note that this is a default setting. Also, I have two NVIDIA GeForce RTX 2080 Ti video cards (high performance stuff). Hope that helps.
It does not happen in SQL Server Management Studio 17.9.1 - 14.0.17289.0
It does happen in SQL Server Management Studio 18.3.1 - 15.0.18183.0
It never happens in VS 2019 (16.3.6) which I use heavily.
Turning off hardware acceleration isn't really an option. Is this going to be resolved?
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
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
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
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!