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

sql prompt slowing ssms down to snail pace

dippiesdippies Posts: 10
edited July 12, 2011 5:08PM in SQL Prompt Previous Versions
Hi all,
when I run sql prompt (5) ssms is as slow as a snail, even clicking on the menus is slow and not workable. when I tab back to ssms from a nother windows a it take like 2 seconds before I can do anything.

system:
windows 7 32bit
have installed latest nvidia 3100m drivers
targus docking station with dual display
4gb of ram, windows can uses 3gb

any ideas on how to improve sql prompt response?

thanks all :shock:

Comments

  • Options
    Hi dippies,

    Does the slowness start when you open a SQL script? It may be that some particular SQL constructs are making SQL Prompt struggle. If so, please send a copy of your script to support@red-gate.com so we can investigate.

    Regards,
    Paul
    Paul Stephenson
    Project Manager, Red Gate
  • Options
    Hi, thanks for the reply, it's pretty much from the start, i'll checknit
    Out and confirm.
  • Options
    Hi,
    Ok so with only one windows open sql prompt works ok, but not as quick as before on xp and different laptop configuration. with every sql script I open or write the performance goes slower and slower and the bigger the script.... to a state where there is no point using sql prompt.
  • Options
    atompkinsatompkins Posts: 22 Bronze 2
    I am also seeing this. In SPs with 5 or more temporary tables.
    I have gone back to 5.1.4 and find that the problem is far less pronounced. It still has high CPU activity but for much shorter periods making it workable.
  • Options
    reverted back to v5.0.1.7 and all seems ok now
  • Options
    Thanks to help from atompkins, the developers have traced the slowdown to a build setting that inadvertently changed between 5.1.4 and 5.1.6, and which slowed down some of the parsing code.

    Meanwhile, we've spotted some other optimisations that should speed things up as well. Subject to testing, we hope to get these out in the next bug-fix release.

    I appreciate everyone's patience in this matter.

    Regards,
    Paul
    Paul Stephenson
    Project Manager, Red Gate
  • Options
    Hi,

    I am experiencing same issue, where can I download 5.0 or different version which doesn't have this issue? I am using 5.1.6.


    Thanks
    Jakub

    http://www.sqltreeo.com - Free SSMS Productivity Add-In
  • Options
    You can get old versions of Red Gate products at http://www.red-gate.com/downgrade . You'll need to uninstall your current version from the Control Panel before installing an older SQL Prompt.

    I'll post back here when we have a new release that improves the situation, so that you can get back onto the latest version.

    Regards,
    Paul
    Paul Stephenson
    Project Manager, Red Gate
  • Options
    Thanks. It seems that my issues started when I was experimenting with thousands of SQL objects. I think that than it slowed down. I saw some manual "cache control" of SQL Prompt in previous version. Is it possible to delete cache for SQL Prompt 5?

    http://www.sqltreeo.com - Free SSMS Productivity Add-In
  • Options
    cool I'll test it out for you when it's available
Sign In or Register to comment.