SQL Assistant Lag/Freeze ?

Hi there,
I am new here and really enjoy the handy tool.
But sometimes, I feel alittle lag or even freezed when I used SQL Assistant for querying.
(Ex: it might take 5 sec to respond....

Does it happen to anyone else ?

Please advise,

Thanks,

Frank

Hi,

Please provide a bit more information about your environment, database type, editor type, speed of your network connection, some idea about the size of your database (I mean approx. number of tables, columns, procedures), etc...

How often the background syntax checker is set to wakeup and check for errors?

Thanks.

Hi,
Here is some information that I can find,

* MS SQL Server 2005
* T1 Network(Intranet)
* Using MS Management Studio
* 104 Tables in Database
* # of Columns vary from 20~40.
* Client using XP and Win7

Also, some suggestion for diagnose,
it would be better if we can just click some button to submit system information for your trace/diagnose.

thanks,
FRank

Thanks for the info. That's a small database. Unless there is a significant problem with your server performance, retrieving database catalog data should not have a significant impact. The network connection doesn't seem to be constrained too. Therefore the remaining potential areas are: a slow system running MS Management Studio, issues with the database connection configuration - somehow having low bandwidth or speed, and coding of very large scripts (thousands of lines of code). All 3 of the issues can potentially affect the performance of SQL Assistant's background syntax checker and other behind the scenes SQL Assistant activities. I suggest to turn off this particular feature and check how it affects the performance. To turn off that, right-click on the syntax status bar in the right side of SQL editor window, select Auto-check-> Off from the context menu.

Please let us know if that helps. If that doesn't help much, it is likely you are having an issue with your database connection settings.

It seems working fine now.
We will keep monitoring it.

Thanks for the tip.

FRank

I'm glad it's working for you.

Just in case, you might be having an issue with your database connection. The connection is likely very slow. I've seen this issue when SSMS is configured to use an ODBC connection instead, of a native MS SQL client and/or ADO.NET. Because of some deficiency in SSMS, with ODBC connection the throughout is very limited which in turn affects .SQL Assistant's background processes and makes them very slow too.