User profile for ATurner

Hi Carol Thank you for your patience on this. What version of SQL server is this you are monitoring? / comments

Hi CarolThank you for your patience on this. What version of SQL server is this you are monitoring?

0 votes

Hi Carol I have been attempting to replicate this but have been unable to do so thusfar. Does this only occur when the custom metric is gathering from this machine? / comments

Hi CarolI have been attempting to replicate this but have been unable to do so thusfar. Does this only occur when the custom metric is gathering from this machine?

0 votes

Hi Carol Is this a newly added server, or has it just occurred on this instance that has been monitored for a whilst? What is the collation of the system databases of this instance? SELECT name, collation_name FROM sys.databases / comments

Hi CarolIs this a newly added server, or has it just occurred on this instance that has been monitored for a whilst?What is the collation of the system databases of this instance?SELECT name, colla...

0 votes

Hi MOH1111 SQL Monitor is sampling the backup system tables every 5 minutes to get information on the database backups. Our sampler appears to be running at the same time as one of your log backups (in the case of the one shown in the image) and is chosen as victim. SQL Monitor is designed to handle deadlocks on the samplers, the backup sampler will be chosen as victim and collect the data the next collection. The sampler runs every 5 minutes by default so depending on your backup schedule it may deadlock at different times but there is a way to change this to be ever more off schedule, say every 7 minutes), which I will describe below. Or alternatively you can have set SQL Monitor to not raise alerts for those deadlocks as the system is designed to accommodate them occurring by editing the Configuration > Alert settings for the Deadlock (Extended events) alert. If your SQL Monitor uses a login specific to it, you can exclude based on that, which would be the most appropriate or possibly with "resources matching" backupmediaset OR backupset. This may not be appropriate if all of the currently sampler runs are being deadlocked and then changing the frequency to be and odd timing is the better option. To customize the sampler frequency you will use the ConfigurationFileEditor.exe tool included in the Tools subdirectory of the base monitor installation directory ( C:\Program Files\Red Gate\Redgate Monitor\BaseMonitor\Tools by default): Right click and run the tool as an Admin Click on the Load Configuration File option and then select the "RedGate.SqlMonitor.Engine.Alerting.Base.Service.exe.settings.config" which should be residing under the C:\ProgramData\Red Gate\redgate Monitor directory by defaultIt's recommended that you save a copy of the config file elsewhere before editing it further - the tool may also do this. Once you've loaded the config file, scroll down about 2/3-3/4 of the way and tick the box next to each [Cluster].[SqlServer].[Database].[Database] , [Cluster].[SqlServer].[Database].[Database].[BackupType] and [Cluster].[SqlServer].[Database].[Database][BackupType].[Backup] and then change the 5 in the "Minutes" section to 7 as seen below: [image] / comments

Hi MOH1111SQL Monitor is sampling the backup system tables every 5 minutes to get information on the database backups. Our sampler appears to be running at the same time as one of your log backups...

0 votes

Hi MOH1111 I will require more information to check that I will create a ticket here and email you. / comments

Hi MOH1111I will require more information to check that I will create a ticket here and email you.

0 votes

Hi MOH1111 Is this for a specific alert you are looking for? / comments

Hi MOH1111Is this for a specific alert you are looking for?

0 votes

Hi kenshine To get this working, you'll need to get the flyway-core dependency from the Redgate repository as described here: https://documentation.red-gate.com/fd/api-java-184127629.html / comments

Hi kenshineTo get this working, you'll need to get the flyway-core dependency from the Redgate repository as described here: https://documentation.red-gate.com/fd/api-java-184127629.html

0 votes

Hi kenshine Apologies, I may have worded my question poorly there. What maven repository is it you are getting flyway from? Is it the redgate one? https://download.red-gate.com/maven/release/com/redgate/flyway/ / comments

Hi kenshineApologies, I may have worded my question poorly there. What maven repository is it you are getting flyway from? Is it the redgate one? https://download.red-gate.com/maven/release/com/red...

0 votes

Hi kenshine Where are you pulling your community artifact from? / comments

Hi kenshineWhere are you pulling your community artifact from?

0 votes

Hi Louis If you have internal certificate authority, this should be able to create a self-signed certificate for you. If not you can create a self-signed one with something like openssl, however this will then need to be installed on machines accessing as it will not be trusted by default as it is self-signed. Or as you mentioned can use Let's Encrypt for an externally signed one but the DNS name will need to match with the certificate. For Redgate Monitor we would expect you to have the certificates to apply to the web server. / comments

Hi LouisIf you have internal certificate authority, this should be able to create a self-signed certificate for you.If not you can create a self-signed one with something like openssl, however this...

0 votes

How can we help you today?

ATurner

Comments