still painfully slow and locks up mgmnt studio

acrawfordacrawford Posts: 16 Bronze 1
Granted, I'm on VPN but this has never happened to me before. I'm using GIT and the database locks up for 5+ minutes after going into Object Explorer, selecting on the DB in source control (which then starts the scan) and trying to expand tables for instance. Lock up created. Management Studio shows busy and is unusable. I had this problem on and saw the recent posting about it....turned on frequent updates and installed hoping this would solve the problem but it is still really bad. Please help Red Gate!


  • Hi,

    We have identified the performance issue with expanding Object Explorer nodes (eg Tables) in versions 3.6.6 and 3.6.7 of SQL Source Control. A database request is unnecessarily made for every object in the list, so the performance hit will depend on the speed of connections to your SQL Server instance.

    A fix is in the pipeline, and we hope to make it available this week to frequent updates.
    Paul Stephenson
    Project Manager, Red Gate
  • acrawfordacrawford Posts: 16 Bronze 1
    Thank you Paul. Just installed and the problem is fixed! Thanks!
Sign In or Register to comment.