How can we help you today? How can we help you today?

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

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?
Nick Baras
0

Comments

3 comments

Sort by
  • 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"....

    1s9754cibqz1.png

    3u11anp68wr1.png



    ncbaras
    0
  • kalo
    post removed as i misread the original question so comment was redundant
    kalo
    0
  • 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/
    Tianjiao_Li
    0

Add comment

Please sign in to leave a comment.