What are the challenges you face when working across database platforms? Take the survey
Options

SQL Management Studio Sluggish

MikeONeillMikeONeill Posts: 131
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

Comments

  • Options
    Anu DAnu D Posts: 876 Silver 3
    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.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • Options
    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
  • Options
    Anu DAnu D Posts: 876 Silver 3
    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.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • Options
    Anu DAnu D Posts: 876 Silver 3
    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.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • Options
    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.
  • Options
    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
  • Options
    Hi

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

    Mike
Sign In or Register to comment.