Red Gate forums :: View topic - SQL Prompt lag for suggestions with SSMS2012
Return to www.red-gate.com RSS Feed Available

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

SQL Prompt lag for suggestions with SSMS2012

Search in SQL Prompt 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
kondrich



Joined: 10 Jun 2010
Posts: 59
Location: Vienna, Austria

PostPosted: Mon Jun 10, 2013 9:14 am    Post subject: SQL Prompt lag for suggestions with SSMS2012 Reply with quote

Hi,

we are using SQL Prompt 5.3.8.2 with SSMS 2012 to SQL Servers 2012 SP1 and we are experiencing lags with suggestion lists.
This lags occur since migrating to SSMS 2012 on the clients and SQL Server 2012 on the server boxes. I have used SSMS 2012 with our old SQL Server 2005/2008 R2 environment as well, but I did not notice any lags then.

To reproduce:
Open a new query window
Type a query e.g. "select * from " and wait for the auto-list to show (that is still very fast).
Now, if you continue typing for list matches or press the cursor for going down the list, there is a lag of several seconds before the list member is chosen.

I already tried to lower those two parameters to 500 and 300, resp.
<ParserLookBackDistance>500</ParserLookBackDistance>
<ParserLookAheadDistance>300</ParserLookAheadDistance>
This did not make any difference. My guess is, because the lags also occur if the query windows just contains such a short query like "select * from ".

This is also remarkable since the new servers are much more powerful. The network environment did not change the way that the servers are "farther away" from the clients. In fact, they are connected via 10Gigabit to one another and are connected via Gigabit to our client network that is a switched Fast Ethernet network.
I doubt that the network connection was the problem, since the suggestion list members should already be cached on the clients, right?

Do you have any idea what causes this suggestion list selection lags? All of my colleagues including myself are complaining about this.
We would greatly appreciate any help on this!
_________________
Regards, Klaus
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 663
Location: Cambridge

PostPosted: Tue Jun 11, 2013 10:08 am    Post subject: Reply with quote

Thanks for your post Klaus.

I have logged a support call for you, reference number for this call is F0073819.
_________________
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