SQL Prompt lag for suggestions with SSMS2012

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

SQL Prompt lag for suggestions with SSMS2012

Postby kondrich » Mon Jun 10, 2013 9:14 am

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
kondrich
 
Posts: 60
Joined: Thu Jun 10, 2010 10:44 am
Location: Vienna, Austria

Postby Anu Deshpande » Tue Jun 11, 2013 10:08 am

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
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge


Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 1 guest