Activity overview
Latest activity by Higgins
I submitted a Red-Gate support request and attached my log files to it. / comments
I submitted a Red-Gate support request and attached my log files to it.
@ostandage I was able to have SSMS up long enough to enable enhanced logging on SQL Prompt and have a zip of log files from today if you would find them useful. Let me know where I can upload them if you'd like them. / comments
@ostandage I was able to have SSMS up long enough to enable enhanced logging on SQL Prompt and have a zip of log files from today if you would find them useful. Let me know where I can upload them ...
I too am experiencing SSMS restarting itself after upgrading to 10.11.8. SSMS isn't open long enough for me to even load a SQL script file before it dies and then re-opens itself. I too would like a download link for 10.11.7 or earlier, at least that was stable. / comments
I too am experiencing SSMS restarting itself after upgrading to 10.11.8. SSMS isn't open long enough for me to even load a SQL script file before it dies and then re-opens itself. I too would like ...
Between my last post on this thread (Feb 23) and now I had a support ticket open with Red Gate. The support people learned that an issue exists in 10.6+ if your snippets reside on a network share or UNC path with high latency between your computer and the network location (think working from home via VPN). If you set your snippets folder to a local path on your computer like C:\MyFolder\RedGateSnippets then there is no issue with performance. To @ogrishman's point, I have observed the conversion of snippets from XML to JSON and their software creates a backup for you in the Snippet path so your "old format" XML snippets should be in a subfolder called "backup" of your snippet folder's path but as always it is best to create your own backup. Quote from my support ticket... "I have spoken with our dev team about this. You have clearly highlighted a need for improvements around the performance of SQL Prompt v6 when referencing network shares, however unfortunately, given current workloads and overall impact of this issue, at this stage we cannot say when we will be able to address this. For the time being, as a workaround we suggest using a local folder for your snippets instead of a network drive with high latency when working from home over a VPN. Alternatively you could continue to use SQL Prompt 10.5 for now." / comments
Between my last post on this thread (Feb 23) and now I had a support ticket open with Red Gate. The support people learned that an issue exists in 10.6+ if your snippets reside on a network share o...
@ogrishman If memory serves the default location is within a windows user profile. Could you try moving it outside the C:\Users\MyProfile folder to something like C:\MyFolderOfChoice\Snippets? / comments
@ogrishman If memory serves the default location is within a windows user profile. Could you try moving it outside the C:\Users\MyProfile folder to something like C:\MyFolderOfChoice\Snippets?
I do not have a performance issue with a local path but I am also not running the latest version of SQL Prompt. I am on 10.6.5.18584. In a different forum post I saw someone mention an issue if SQL Prompt did not have write permissions on the folder. Do you have read and write permission on the folder where you store your snippets even though it is local? / comments
I do not have a performance issue with a local path but I am also not running the latest version of SQL Prompt. I am on 10.6.5.18584. In a different forum post I saw someone mention an issue if SQL...
Between my last post on this thread (Feb 22) and now I had a support ticket open with Red Gate. The support people learned that an issue exists in 10.6+ if your snippets reside on a network share or UNC path with high latency between your computer and the network location (think working from home via VPN). If you set your snippets folder to a local path on your computer like C:\MyFolder\RedGateSnippets then there is no issue with performance. To @ogrishman's point, I have observed the conversion of snippets from XML to JSON and their software creates a backup for you in the Snippet path so your "old format" XML snippets should be in a subfolder called "backup" of your snippet folder's path but as always it is best to create your own backup. Quote from my support ticket... "I have spoken with our dev team about this. You have clearly highlighted a need for improvements around the performance of SQL Prompt v6 when referencing network shares, however unfortunately, given current workloads and overall impact of this issue, at this stage we cannot say when we will be able to address this. For the time being, as a workaround we suggest using a local folder for your snippets instead of a network drive with high latency when working from home over a VPN. Alternatively you could continue to use SQL Prompt 10.5 for now." / comments
Between my last post on this thread (Feb 22) and now I had a support ticket open with Red Gate. The support people learned that an issue exists in 10.6+ if your snippets reside on a network share o...
I tried 10.6.3 this morning as a support tech told me it was available. 10.6.3 has the same performance issues. I've submitted verbose logs to the support request I have open. I can't say the experience is the same for everyone but I cannot recommend upgrading at this time. / comments
I tried 10.6.3 this morning as a support tech told me it was available. 10.6.3 has the same performance issues. I've submitted verbose logs to the support request I have open. I can't say the exper...
I will also mention I am running SSMS 18.8 on an HP Win 10 laptop with 32GB of RAM so performance of SQL Prompt shouldn't suck so bad. / comments
I will also mention I am running SSMS 18.8 on an HP Win 10 laptop with 32GB of RAM so performance of SQL Prompt shouldn't suck so bad.
SQL Prompt 10.6.2.X & 10.6.3.X performance issues
On Fri 2/19 I updated to the latest 10.6 version of SQL Prompt and typing was and is painfully slow, performance stinks. I can type two complete lines of SQL code before it finishes "typing" the wo...