Any tips for tuning SQL Complete with large databases? I work with ~100 similar databases across multiple servers. Each database has ~65k tables, ~100k stored procedures, 15k functions etc. I've read that SQL Complete shouldn't cause SSMS to freeze - but it seems to. I often have several SSMS tabs open. SSMS's performance varies - sometimes it is just fine, sometimes it gets brief delays, and sometimes freezes and eventually crashes. Disabling SQL Complete code completion causes the problem to go away. Latest versions of SSMS and SQL Complete on a pretty beefy machine.

Thanks!