How to troubleshoot "Out of Memory" errors in SSMS + SQL Prompt

ncbaras

I've recently started seeing a lot of instability with SSMS. I have not proven this , but believe it is due to SQL Prompt, and specifically a couple of databases I'm using that have a couple hundred thousand synonyms each (vendor-created, unfortunately they have to have these objects). Read: this is a database design problem, not SQL Prompt, but I'm hoping to work around it via SQL Prompt settings.

Is there a way to prevent SQL prompt from looking at synonyms at all? I've tried disabling the "Load suggestions for synonyms" checkbox in Options > Connections > Linked servers and synonyms, but that hasn't seemed to help. I'm now explicitly excluding the problem databases from Options > Connections > Databases, but that is obviously not ideal.

Any other suggestions? Anything else I should be considering in my troubleshooting?

ncbaras

Screenshot of settings and memory error for reference. Disabling connection to those specific databases appeared to have no effect. In that case, maybe I should change my question to "how to troubleshoot out of memory exception errors when using SQL Prompt"....

kalo

post removed as i misread the original question so comment was redundant

Tianjiao_Li

Hi @ncbaras

Thanks for posting.

You may find this page useful?

Also as SSMS is a 32 bit program, so it may help if you make it Large Address Aware to increase the memory max. You can download the following utility to do this: https://www.techpowerup.com/forums/threads/large-address-aware.112556/