how to get redgate monitor default alert tsql
MOH1111
Posts: 4 New member
I use redgate monitoring service, I want to know how to see alert type tsql, I want to know what is the script of each alert?
Tagged:
Answers
Is this for a specific alert you are looking for?
I will require more information to check that I will create a ticket here and email you.
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):C:\ProgramData\Red Gate\redgate Monitor
directory by default[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: