Kendra_Little said:
Hi all, Apologies for the lack of resolution and /or recent updates on this issue. I'd like to do a quick recap of current existing options for lightning the impact of SQL Source Control on SSMS, then share some additional thoughts. First up, performance tweaks that may help readers
As mentioned above, one option is to disable automatic refreshing in SQL Source Control.
We also have two additional options which can be toggled that specifically may help speed up Object Explorer with some environments. You can either lessen the frequency or disable the rate at which changed objects are updated in Object Explorer. You can also test if the object locking feature may be what is causing the latency by disabling that feature.
Finally, we have some tips for diagnosing/avoiding general latency here .
Gathering more info I am curious to know if your use case specifically includes any of these, and if it might be related to the poor experience:
Connecting to databases over a slow connection (whether cloud or not)
Large static data tables
Many encrypted objects
Schemas with a large number of objects (this wouldn't just show in object explorer but would also cause a slow refresh time)
We are looking to improve the experience with all of these, but it always helps to understand specific use cases. Plans and some background SQL Source Control is currently implemented as an x86 plugin in SQL Server Management Studio. This means that performance and functionality is always a balance -- and also that we don't have a simple way to resolve performance issues for every use case. But while this isn't a quick fix for us, this is definitely an area where we would like to improve. We are working on some new functionality which we plan to have available soon for a private preview for customer feedback. If you think you might be a good fit for the private preview, I'd love for you to get in touch with me at Kendra.Little@red-gate.com. It would help if you could share a bit about your use case / any info related to the "gathering more info" section that you think might be suitable. Thanks very much for your feedback in this area. Cheers, Kendra ------ Kendra Little Redgate
Hi Kendra, I appreciate your reply here, but this problem still exists here for me, and I've tried every single one of the workarounds mentioned here and throughout RedGate's website, i.e.:
Disable automatic refreshing
Set the snippets folder to a local path (it already was)
Disable Code Analysis
Disable the built-in intellisense
Disable the auto-refresh (the GUI way)
Upgrading to the latest version of SQL Source Control, and
Disabling object locking
...each one followed by a restart of SQL Server for the change to take effect. Ultimately, the only troubleshooting step that finally brought responsiveness back to my SQL Server was to uninstall RedGate tools altogether. (And I trust I don't need to explain to anyone here why that's not a real solution!) Given how many people in this thread are experiencing the issue (and add to that number 3 more at my company, including myself), then I think it's pretty clear that there is some bug in RedGate's software. It should be fairly straight-forward for someone at RedGate to reproduce this issue on their end. Regarding your specific questions about how many static tables or encrypted objects I have, I'm afraid you'll just have to tell your engineers to do their own research and get the answers to those questions themselves. I work at a medium-to-large-sized company. Our database is a medium-to-large-sized database. I don't know what else to tell you. It's a real world workplace, with real-world databases. And RedGate's software should work in the real world. What I do know for sure though, is that when I install a piece of third party software it shouldn't make my mouse clicks freeze for 3–5 seconds. / comments
- Community
- SQL Source Control
- SSMS Object Explorer Right Click Menu Very Slow
Kendra_Little said:
Hi all,Apologies for the lack of resolution and /or recent updates on this issue. I'd like to do a quick recap of current existing options for lightning the impact of SQL ...
0 votes
