Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

← SQL Server

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;


  1. Open a second query window

  2. Using your mouse, switch back and forth between the two open query windows by clicking on their tabs.

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

  4. Switching back and forth a few more times may clear up the issue temporarily.

  5. The same issue may carry over to additional query windows which are opened, after switching between the various windows several times.

347 votes
Sign in
(thinking…)
Sign in with: Microsoft
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Glenn Burnett shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
completed  ·  AdminMicrosoft SQL Server (Product Manager, Microsoft Azure) responded  · 

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

Show previous admin responses (3)

118 comments

Sign in
(thinking…)
Sign in with: Microsoft
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Todd commented  ·   ·  Flag as inappropriate

    It's only happens to me in SSMS 18 and 18.1, not VS 2017, 2019 or SSMS 17.x

  • Mark Burns commented  ·   ·  Flag as inappropriate

    SSMS 18.1 Simple workaround: grab the scrollbar in the current tab/window and drag it - the window repaint the correct SQL and edits are enables properly.

  • Dean J. commented  ·   ·  Flag as inappropriate

    It happens for me on these graphics cards: Intel HD 4600, and NVidia GT 240. It has never happened for me on Visual Studio 2015 or 2017.

    It also happened in SSMS 16.x for me, but then got better in 17.x.

  • Robert Woods commented  ·   ·  Flag as inappropriate

    This was an issue in an old version of SSMS (maybe 13/14?), but has been fixed for a while for me. Suddenly in 18 it showed up again.

  • Glenn Burnett commented  ·   ·  Flag as inappropriate

    @Matteo: I do not experience this issue with any of the following:

    SSMS 17.9.1
    Visual Studio Version 15.9.9
    Visual Studio Version 15.9.14

    In testing all three of the above, the "Automatically adjust visual experience based on client performance" option was enabled, which auto-enables the "Enable rich client visual experience" and "Use hardware graphics acceleration if available" options.

    Tests performed on same machine which does experience the issue with SSMS 18.0 and SSMS 18.1.

  • pbradshaw commented  ·   ·  Flag as inappropriate

    I do NOT experience the problem in Visual Studio 2017, which I use every day. Version 15.9.14 with .NET 4.8.03752. I've never experienced this problem in any product other than SSMS 18.x

    SSMS 17.9.1 has never exhibited this problem for me. It's what I use on a daily basis, since I found SSMS 18.x just too buggy and problematic to work with.

    While I've seen reports from other people experiencing this problem with SSMS 16.x and up, I never have. This is all brand new to 18.x, and it happens so often it's impossible to use.

  • Lee commented  ·   ·  Flag as inappropriate

    I am using SSMS v17.9.1 and do NOT have the same issues

    Microsoft SQL Server Management Studio 14.0.17289.0
    Microsoft Analysis Services Client Tools 14.0.1016.283
    Microsoft Data Access Components (MDAC) 10.0.18362.1
    Microsoft MSXML 3.0 4.0 6.0
    Microsoft Internet Explorer 9.11.18362.0
    Microsoft .NET Framework 4.0.30319.42000
    Operating System 6.3.18362

  • Richard Kittrell commented  ·   ·  Flag as inappropriate

    I have never experienced this issue in either VS 2017 15.9.14 nor SSMS 17.9.1. I use both of these daily. I have stopped using SSMS 18.1 until 18.2 becomes available.

  • Rozenbaum Alexander commented  ·   ·  Flag as inappropriate

    SSMS 17.9.1 works fine on the same machine
    SSMS 18.1 glitches the same way as 18.0
    P.S. I am not sure, but may be you have to know. Most of time I am running SSMS uder the different account than desktop logon.

  • Graves Kilsgaard commented  ·   ·  Flag as inappropriate

    I am using an Lenovo T480 with
    - Intel UHD Graphics 620 & NVIDIA GeForce MX150

    I have to disable hardware acceleration in SSMS 18.0 else the system stalls and goes extremly slow.
    As soon i am disabling Acceleration the system works fine but then i get the redraw issues.

  • Glenn Burnett commented  ·   ·  Flag as inappropriate

    Intel UHD Graphics 620
    Intel Core i7-8650U
    Dell Latitude 7490
    Driver Provider: Intel Corporation
    Driver Date: 12/10/2018
    Driver Version: 25.20.100.6472

1 2 4 6

SQL Server: Bugs

Categories

Feedback and Knowledge Base

(thinking…)
Hosted by UserVoice