Manfred.Castro wrote:Can you check that your graphics card drivers are up to date? This has been known to affect the performance of SQL Prompt.
Manfred.Castro wrote:1.) There's a config option in %LOCALAPPDATA%\\Red Gate\\SQL Prompt 5\\RedGate_SqlPrompt_Engine_EngineOptions.xml called <MaxSupportedColumns> - you can use this to limit the size (in columns) of a database that SQL Prompt will load. If you set it, to, say, <MaxSupportedColumns>20000</MaxSupportedColumns>, SQL Prompt will give up on loading columns for databases with more than 20,000 columns.
This is really to stop individual giant databases crashing Prompt.
Manfred.Castro wrote:2.) Sometimes just clearing the cache helps. Restarting SSMS will clear SQL Prompt's cache. So when SQL Prompt becomes sluggish you can try restarting ssms before it runs out of memory.
Manfred.Castro wrote:3.) Another option that may help is disabling linked server support in SQL Prompt.
Users browsing this forum: No registered users and 0 guests