Slow scrolling in SQL Server Management Studio

davidbarker

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.

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.

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.

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.

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?

apop

Sorry Anu but the link in you messasge is broken.

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.

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

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.