Red Gate forums :: View topic - Slow scrolling in SQL Server Management Studio
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt Previous Versions
SQL Prompt Previous Versions forum

Slow scrolling in SQL Server Management Studio

Search in SQL Prompt Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
davidbarker



Joined: 29 Apr 2008
Posts: 3
Location: London, UK

PostPosted: Tue Oct 13, 2009 7:51 pm    Post subject: Slow scrolling in SQL Server Management Studio Reply with quote

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.
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Thu Oct 15, 2009 10:35 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
NightowlKY



Joined: 04 Feb 2010
Posts: 1

PostPosted: Thu Feb 04, 2010 5:07 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
apop



Joined: 06 Oct 2010
Posts: 2

PostPosted: Wed Oct 06, 2010 7:16 am    Post subject: Slow scrolling in SQL Server Management Studio Reply with quote

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.
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 685
Location: Cambridge

PostPosted: Wed Oct 06, 2010 12:38 pm    Post subject: Reply with quote

Apologies for the inconvenience caused.

Can you try few settings specified in this article: http://www.red-gate.com/supportcenter/Content.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
Back to top
View user's profile Send private message Send e-mail
apop



Joined: 06 Oct 2010
Posts: 2

PostPosted: Wed Oct 06, 2010 10:18 pm    Post subject: Broken Link Reply with quote

Sorry Anu but the link in you messasge is broken.
Back to top
View user's profile Send private message
Linda Hawksworth



Joined: 25 Jun 2007
Posts: 192

PostPosted: Wed Oct 13, 2010 8:50 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
eromanel



Joined: 19 Sep 2007
Posts: 2

PostPosted: Thu Oct 14, 2010 6:08 pm    Post subject: Reply with quote

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...
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 685
Location: Cambridge

PostPosted: Fri Oct 15, 2010 9:12 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group