sql prompt slowing ssms down to snail pace

dippies

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:

Paul Stephenson

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

dippies

Hi, thanks for the reply, it's pretty much from the start, i'll checknit
Out and confirm.

dippies

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.

atompkins

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.

dippies

reverted back to v5.0.1.7 and all seems ok now

Paul Stephenson

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

jdvorak

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

Paul Stephenson

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

jdvorak

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?

dippies

cool I'll test it out for you when it's available