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

Slow scrolling in SQL Server Management Studio

I have a fairly complex script (approx 2,500 lines, with several table variables, using some wide tables & views, ie 400 columns plus, and with large sections commented out)

If I have SQL Prompt 4 enabled, then scrolling up and down (using the up & down arrow keys) slows considerably - down to maybe 2 lines per second. If I type anything, then nothing appears until I pause for about a second. Selecting any text using the arrow keys is very slow. Selecting using the mouse however works normally, as does PageUp and PageDown. If I look at the Task Manager, I notice that the SqlWb.exe process takes 50% of my CPU when scrolling up or down (on a dual CPU machine).

This makes editing the script very difficult.

If I disable SQLPrompt, then scrolling returns to about 15 lines per second and typing appears immediately. CPU usage drops to 40% when scrolling down, and 15% when scrolling up.

I am using SQL Prompt Pro v4.0.2.53, SQL Server 2005 and XP Pro.
davidbarker
0

Comments

8 comments

Sort by
  • Chris Auckland
    Thanks for your post.

    Unfortunately, this is a known issue when using SQL Prompt 4.0 with large scripts.

    We have a bug open for this, and should hopefully make some improvements in the next version.

    For your reference the bug tracking code for this is SP-2809.

    Sorry for the inconvenience.
    Chris Auckland
    0
  • NightowlKY
    Does "next version" mean version 5 or a 4.1?

    Any ETA on that?


    I see slowness on a script that's no more than 100 lines or so.
    NightowlKY
    0
  • apop
    Hi,

    Any luck with this bug...tracking code for this is SP-2809. Love the SQL Prompt concept and loved V3. V4 is a disaster for me.
    apop
    0
  • Anu D
    Apologies for the inconvenience caused.

    Can you try few settings specified in this article: http://www.red-gate.com/supportcenter/C ... aspx?p=SQL Prompt&c=knowledgebase%5cSQL_Prompt%5cKB200912000447.htm ?

    If that doesn't make any difference I will log a support call for you and we can investigate further?
    Anu D
    0
  • apop
    Sorry Anu but the link in you messasge is broken.
    apop
    0
  • Linda Hawksworth
    Try:

    <http://www.red-gate.com/supportcenter/Content.aspx?p=SQL Prompt&c=knowledgebase%5cSQL_Prompt%5cKB200912000447.htm>

    If this doesn't improve performance, let us know and we can send you instructions for editing the EngineOptions file.
    Linda Hawksworth
    0
  • eromanel
    i tried the suggestions in the link posted by anu (the link works if you copy and paste the whole thing), but it did not help, in fact i think it is slower. the only solution that works for me is to turn off sql prompt. is there another solution? i would like to use sql prompt since we did pay for it...
    eromanel
    0
  • Anu D
    Hello eromanel,

    Can you kindly email support@red-gate.com and I will send you few suggestions?

    Please mark it to my attention in the subject of the email.
    Anu D
    0

Add comment

Please sign in to leave a comment.