Comments
Sort by recent activity
Hi Ashlyn, Thank you for your post. I've not seen this happen before, but it may be because the Base Monitor, once upgraded, cannot locate the Baselocation.config. Are you installing SQL Monitor to the default location, or are you changing it? Also, what changes in the config file? Is it the network location or the port number? Do you have your Web server and Base Monitor installed on different machines? / comments
Hi Ashlyn,Thank you for your post. I've not seen this happen before, but it may be because the Base Monitor, once upgraded, cannot locate the Baselocation.config. Are you installing SQL Monitor to ...
Hi @SEarle86 Thank you for your post. Query duration is the total time the query ran for according to a combination of dm_exec_ dmvs (largely sys.dm_exec_query_stats). I've also tried to reproduce the same behaviour using the example you provide for AdventureWorks, but the alert doesn't trigger, even if the first and second query in combination run over the threshold. If you were to simulate a LRQ using WAITFOR DELAY do you see the same result? / comments
Hi @SEarle86 Thank you for your post. Query duration is the total time the query ran for according to a combination of dm_exec_ dmvs (largely sys.dm_exec_query_stats).I've also tried to reproduce t...
For transactional replication, there is not much for them I'm afraid. We have a few options to deal with the objects and options that merge replication leaves in databases, but the problems with transactional replication are mostly that we can't modify tables that we need to modify, and we don't know which tables these are in advance because we don't read the replication settings from the server. For merge replication, we have 'Ignore Not For Replication' and 'Ignore Replication triggers' - which ignore the NOT FOR REPLICATION flag on constraints (which suppresses the checking of those constraints when rows are added by replication) and the triggers that are automatically added to tables on setting up merge replication, letting you compare databases with merge replication set up to databases that should be the same but don't have merge replication set up. / comments
For transactional replication, there is not much for them I'm afraid. We have a few options to deal with the objects and options that merge replication leaves in databases, but the problems with tr...
Hi Dan, Thank you for your post. The latest release contains a fix for this issue, you can download it here: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.13.12.1701.exe https://documentation.red-gate.com/sp/release-notes-and-other-versions/sql-prompt-10-13-release-notes: FixesFixed an issue where an unwanted space/tab was being added into the multi-part identifier in the WHERE clause.
Fixed an issue where OPENXML statement wasn't recognized in Azure SQL Database.
Fixed an issue that prevented exact match searches in SQL History. Fixed an issue that prevented Smart Rename to rename column with same name but different case on case-sensitive database. / comments
Hi Dan, Thank you for your post. The latest release contains a fix for this issue, you can download it here:https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.13.12.1701.exehttps:...
In case there are others with similar issues, please see the below: To uninstall: You can uninstall the tools from command line by calling on either the msi or the uninstall string for the tool and making sure to include the /quiet switch. To use the uninstall string:
Open your registry with regedit and go to the HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall key
From there, please search through under that key for the tool in question and locate the subkey that contains the DisplayName value and take note of the UninstallString value.
If you take that value and change /I to /X and add the quiet switch, that will uninstall the tool. For example:
MsiExec.exe /X{89962ADB-329F-45B7-95FE-821A72851664} /quiet Alternatively, you can uninstall by specifying the .msi file. This would just be something like: msiexec /x "C:\ProgramData\Downloaded Installations\6155E9E6FDC349B67D42984114AD7AAB\DLM Automation_2.0.35.1605_x86.msi" /quiet You can find the path to the msi file in the InstallSource registry key. To Install: We are unable to assist with InTune but to install via the msi and mst files please see: https://productsupport.red-gate.com/hc/en-us/articles/360007207454-Installing-from-the-msi-file-silent-install- / comments
In case there are others with similar issues, please see the below:To uninstall:You can uninstall the tools from command line by calling on either the msi or the uninstall string for the tool and ...
Hi @CaptainNemo, thank you for your post. If you have a database highlighted in Object Explorer or if you have an open query linked to a DB then SQL Search will default to the linked/highlighted DB. If you collapse the Object Explorer and have the SQL Server level highlighted then when you open SQL Search it will default to "All Databases". / comments
Hi @CaptainNemo, thank you for your post. If you have a database highlighted in Object Explorer or if you have an open query linked to a DB then SQL Search will default to the linked/highlighted DB...
Hi @brenttempleton, thank you for your post. You may be able to modify existing alerts for custom metrics, but you wouldn't be able to set up the custom metric itself. To modify the Custom metric alert you can use the Custom Types: https://documentation.red-gate.com/sm/api/powershell-api/custom-types Also see https://documentation.red-gate.com/sm/api/powershell-api/powershell-cmdlet-reference/update-sqlmonitoralertspecificsettings for the syntax / comments
Hi @brenttempleton, thank you for your post. You may be able to modify existing alerts for custom metrics, but you wouldn't be able to set up the custom metric itself. To modify the Custom metric a...
Hi @Ante_T, just to let you know the Dev team have reproduced the issue as well (thank you for providing those reproduction steps!) They raised the issue on they github board and they will be updating me with their progress so I'll let you know as well. / comments
Hi @Ante_T, just to let you know the Dev team have reproduced the issue as well (thank you for providing those reproduction steps!) They raised the issue on they github board and they will be updat...
Hi @Ante_T thank you for your post. Using your scripts, I've been able to reproduce the issue and I do see that the script is generated in the wrong order. So I will raise the issue with the Dev team and then get back to you with their feedback. / comments
Hi @Ante_T thank you for your post. Using your scripts, I've been able to reproduce the issue and I do see that the script is generated in the wrong order. So I will raise the issue with the Dev te...
For others who may be seeing a similar issue, our recommendation is to run SSMS 19.1 (or the latest) and the latest version of SQL Prompt which at the time of this post is https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.13.11.1536.exe / comments
For others who may be seeing a similar issue, our recommendation is to run SSMS 19.1 (or the latest) and the latest version of SQL Prompt which at the time of this post is https://download.red-gate...