Slow scrolling in SQL Server Management Studio

Provides intelligent code completion for SQL Server editors.

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson

Slow scrolling in SQL Server Management Studio

Postby davidbarker » Tue Oct 13, 2009 7:51 pm

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
 
Posts: 3
Joined: Tue Apr 29, 2008 11:55 am
Location: London, UK

Postby Chris Auckland » Thu Oct 15, 2009 10:35 am

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
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Postby NightowlKY » Thu Feb 04, 2010 5:07 pm

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
 
Posts: 1
Joined: Thu Feb 04, 2010 5:04 pm

Slow scrolling in SQL Server Management Studio

Postby apop » Wed Oct 06, 2010 7:16 am

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
 
Posts: 2
Joined: Wed Oct 06, 2010 6:50 am

Postby Anu Deshpande » Wed Oct 06, 2010 12:38 pm

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?
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Broken Link

Postby apop » Wed Oct 06, 2010 10:18 pm

Sorry Anu but the link in you messasge is broken.
apop
 
Posts: 2
Joined: Wed Oct 06, 2010 6:50 am

Postby Linda Hawksworth » Wed Oct 13, 2010 8:50 am

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
 
Posts: 192
Joined: Mon Jun 25, 2007 11:32 am

Postby eromanel » Thu Oct 14, 2010 6:08 pm

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
 
Posts: 2
Joined: Wed Sep 19, 2007 8:50 pm

Postby Anu Deshpande » Fri Oct 15, 2010 9:12 am

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.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge


Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests