SQL Management Studio Sluggish

MikeONeill

Hi

I applied the Patch for VIEW formatting , and I am seeing VERY sluggish response from SSMS

Has there been any comments from elsewhere , I have just re built my PC and put 2008 on , but have had much time using it yet to gauge if this is due to that ?

I am seeing delays of 1 -2 seconds for characters typed to appear, which looks horribly like somethng parsing

I disable SQL Prompt and it goes to normal typing speed ?

XP sp3 , 2 Gb RAM , intel core Duo 2 Ghz, so it should be OK , it was on 2005

Anu D

Many thanks for your post Mike.

We haven't received any complaints like this.

Have you done any changes to the video drivers or your graphic card?

We have a knowledge base article which can be worth reading:

http://www.red-gate.com/supportcenter/C ... wledgebase\SQL_Prompt\KB200912000447.htm

Kindly let me know if this makes any difference.

MikeONeill

Hi I think I have cracked it ...

My works lap top was rebuilt so I installed 2008 first time as a clean install. I also installed SQL Prompt , Refactor and Search as it was before .

I hit the slow response , so I uninstalled 2008 reverted to 2005 as it was previously before the rebuild, plus the 3 add ins BUT no improvement , still type and wait 2-3 sec for the typing to show.

I now disabled SQL Prompt -- no joy

I uninstalled SQL Search and Voila ,all back to normal in 2005

I have now upgraded to 2008 and all is still well , so I hate to say it but it would seem that SQL Search was the culprit .

I do not have intalled and all is fine.

As an side I have all 3 add ins installed in 2008 on my other lap top with Win 7 and 4Gb Ram and do not see it , but the db sizes on my works Lap Top , the one that was suffering are much bigger.

Can SQL Search be affected by Db size even when its nominally "doing nothing"

It certainly looked like the sort of Parsing clashes I have seen with VS2008 addins trying to parse the same file at the same time.

Hope this helps, please can you pass on to the SQL Search team for comment

Mike

Anu D

Many thanks for your update that was helpful.

I have forwarded your feedback to SQL Search I will update this forum when I get reply from them.

Anu D

SQL Search team needs few details like:

1. database size,
2. system specifications and
3. if possible a snapshot of your database

Kindly let us know if it is fine to share these details with us.

DSON

I'm having the exact same problem Mike had with Sql Prompt 4 and usually end up disabling it.
My system is an Intel Core Duo 2.13Ghz with 4mb ram running Windows XP sp3. I'm using Sql Prompt with Management Studio 2005.
My video drivers are up to date and there is no option for acceleration. I am running dual monitors. I also tried uninstalling SQL Search and it had no effect.
I have found several references to SQL Prompt adversely affecting SQL performance in these forums.

MikeONeill

This is typical , I have a server with 3 "big" db , normally 8-10 gb

This is the sount of sys.objetcs

VIEW 68
SQL_TABLE_VALUED_FUNCTION 29
SQL_STORED_PROCEDURE 1770 362
FOREIGN_KEY_CONSTRAINT 142
USER_TABLE 293 313
SQL_SCALAR_FUNCTION 127
PRIMARY_KEY_CONSTRAINT 258 263
SQL_TRIGGER 19 1

of the 2 biggest .

It the LH column I was seeing the performance hit most

Some of the Sp's are quite lengthy , often 300 lines + for driving reports etc , but there is a mix of small & large

I think for confidentiality I can't attach schemas

I hope this helps


Mike

MikeONeill

Hi

any thoughts on this one , I really do want to play with SQL Search

Mike