Activity overview
Latest activity by JonasEckerman
Jon_Kirkwood said:
Thank you for providing your logs, there are a few warnings and errors connected to network availability. Are you connecting to any databases via VPN or other external network pipeline? Are you able to confirm the database types you have in SSMS? Local, Azure etc. If you are using Azure, can you confirm your connection/authentication type.
Hello! I'm having the same problem. SQL Prompt is very slow when refreshing suggestions, but both SSMS and SQL Prompt are fine other wise. The problem started one or two SQL Prompt updates ago (with no SSMS upgrades in between IIRC). It seems that most of the time is from "Processing parameters", and made worse because information is fetched twice for the same database. I see the problem for the same two sets of dabases in dev, test and prod environments. Both databases have a lot of stored procedures, and quite a few functions. and has been deveiped continuously since 2009 or so (so some legacy code may refer to objects or columns that no longer exists). The servers are: - on-premise SQL Server 2016 Standard, over VPN, using SQL Server autentication. - on-premise SQL Server 2019 Developer, without VPN, using Windows authentication. The attached log file is for a database in a remote location, so the connection is through a VPN. The effect is noticable on for databases on local network as well, but is much worse for the remote databases. I hope the attached log file helps. Regards /Jonas / comments
Jon_Kirkwood said:
Thank you for providing your logs, there are a few warnings and errors connected to network availability. Are you connecting to any databases via VPN or other external net...
This is happening for me as well. SSMS and SqlPrompt are not slow in general, but SqlPrompt is very slow when refreshing suggestions. Before the last two updates the refresh used to be much faster. (I hope I will have time to gest some verbose logs later today.) / comments
This is happening for me as well.SSMS and SqlPrompt are not slow in general, but SqlPrompt is very slow when refreshing suggestions.Before the last two updates the refresh used to be much faster.(I...