Comments
Sort by recent activity
Good Morning Remko, Thanks for reaching out to Redgate Software, glad you are enjoying the new 'Show aggregate feature' feature, could I kindly have yo elaborate a bit further on what exactly you are attempting to do in this instance? / comments
Good Morning Remko,Thanks for reaching out to Redgate Software, glad you are enjoying the new 'Show aggregate feature' feature, could I kindly have yo elaborate a bit further on what exactly you ar...
Thanks Nocky, That is more of what I was expecting, so it seems that in your case, the improvement in the latest version of Prompt vs 10.15.3 is not as pronounced as we saw with other users, I will document these Logs you have included and I may have to send this up to be reviewed further and see if any additional optimization can be made using the findings. You can of course continue to use 10.14.21 if you so choose for the time being / comments
Thanks Nocky,That is more of what I was expecting, so it seems that in your case, the improvement in the latest version of Prompt vs 10.15.3 is not as pronounced as we saw with other users, I will...
Old Version without: 2024-12-13 12:18:16.007 -05:00 [Debug] [dev.sql.sis.jhu.edu].[dailydb] progress: Processing parameters...2024-12-13 12:21:40.501 -05:00 [Debug] Time taken for parameters [dailydb] = "00:03:24.4955451" [98463 rows] 2024-12-13 12:18:08.931 -05:00 [Debug] Time taken for parameters [master] = "00:00:04.1260636" [7679 rows] New Version: 2024-12-13 12:31:31.726 -05:00 [Debug] [dev.sql.sis.jhu.edu].[dailydb] progress: Processing parameters...
2024-12-13 12:34:13.859 -05:00 [Debug] Time taken for parameters [dailydb] = "00:02:42.1275867" [98463 rows] 2024-12-13 12:31:15.246 -05:00 [Debug] Time taken for parameters [master] = "00:00:01.3722779" [7679 rows] Will admit, I was expecting a bigger improvement from the new version than we saw here in this case, but the newer version is still faster. If you are still curious I would roll back two more versions, and then see if there is significant improvement, as this should be prior to the changes were made to Stored Procedures Adding 10.14, I am fairly certain this one should be before the changes were made. SQLPrompt_10.14.20.9646.exe
/ comments
Old Version without:2024-12-13 12:18:16.007 -05:00 [Debug] [dev.sql.sis.jhu.edu].[dailydb] progress: Processing parameters...2024-12-13 12:21:40.501 -05:00 [Debug] Time taken for parameters [da...
Could also use SQLPrompt_10.14.21.9884.exe, I have tested with this one previously with success. / comments
Could also use SQLPrompt_10.14.21.9884.exe, I have tested with this one previously with success.
Understood Nocky, In this case, if you indeed think it has gotten worse, what we would need to gather for confirmation are the following: Gather Debug logs from Prompt (Prompt > Help > Verbose Prompt > Help > Locate Log Files) now while you are on the latest version, in the logs we track how long it takes to load parameters. Then Fully uninstall SQL Prompt and downgrade to version 10.15.3.12768 and then repeat the test with Prompt in Debug. Then we can compare the logs from the latest version and version 10.15.3.12768 and see if there is a performance slowdown or speed up. / comments
Understood Nocky,In this case, if you indeed think it has gotten worse, what we would need to gather for confirmation are the following:Gather Debug logs from Prompt (Prompt > Help > Verbose Prompt...
Hi @nocky, Thanks for reaching out to Redgate Support with your feedback. I am actually surprised by your feedback as Prompt SQLPrompt_10.16.0.13262.exe was released specifically with Performance improvements for "Processing Parameters" that other users have already confirmed improvement for. (Almost 10X faster in my testing) These improvements were the result of a performance issue we were seeing on version 10.15 and 10.14 of Prompt which was rooted in some changes we had to make in how Stored Procedures were loaded in to the application, so if you dont mind me asking, what version of Prompt did you upgrade from? Its possible if you upgraded from a dated version prior to the changes made for loading Stored Procedures in Prompt that you still would see some slowdown. / comments
Hi @nocky,Thanks for reaching out to Redgate Support with your feedback. I am actually surprised by your feedback as Prompt SQLPrompt_10.16.0.13262.exe was released specifically with Performance im...
@jsreynolds1 Root Cause has been identified for this behavior and is currently being worked on for a fix. Will have more for you likely sometime next week. / comments
@jsreynolds1 Root Cause has been identified for this behavior and is currently being worked on for a fix. Will have more for you likely sometime next week.
@Jaragoth , @AdamGojdas , @jsreynolds1 Thanks all for your patience on this issue. Please upgrade Prompt to the latest version of 10.15.3 as this issue has been remediated in that version. https://download.red-gate.com/checkforupdates/SQLPrompt/ Cheers, Christian Perez / comments
@Jaragoth , @AdamGojdas , @jsreynolds1 Thanks all for your patience on this issue.Please upgrade Prompt to the latest version of 10.15.3 as this issue has been remediated in that version. https://d...
@jsreynolds1 & @AdamGojdas Thanks for reaching out to Redgate Support. Fortunately, the behavior you are describing is a known behavior already under investigation by the development team. As soon as they release some remediation steps or a patch fix for this issue I will circle back here and update you further. You can also keep an eye on the https://download.red-gate.com/checkforupdates/SQLPrompt/ for any subsequent releases. / comments
@jsreynolds1 & @AdamGojdas Thanks for reaching out to Redgate Support. Fortunately, the behavior you are describing is a known behavior already under investigation by the development team. As soon ...
Good Morning @Ivailo, Was able to replicate this issue while utilizing the latest version of SQL Compare. Going to shoot this up to development and will circle back here and let you know next steps. / comments
Good Morning @Ivailo,Was able to replicate this issue while utilizing the latest version of SQL Compare. Going to shoot this up to development and will circle back here and let you know next steps.