Hello and welcome to this video on how to create actionable responses in SQL Diagnostic Manager. Actionable responses allows you to react when an alert threshold is reached. You can execute the following responses to an alert: Send an email notification, write an event to the Windows event log, send the alert message to the ID on newsfeed action provider, run a program or batch file, execute a SQL script, execute an agent job or a specific step within the job, send an SNMP [simple network management protocol] trap message, or run a prescriptive analysis. The first step is to configure the alerts by adjusting the thresholds to the specific needs. This is done by right-clicking on your instance name. Going to configure alerts. And in this case, I am going to choose log full percent. And I am going to be adjusting the thresholds. The second step is to go on there tools select alert action and responses. You can add a new rule and provide a name. The conditions and the actions to run the conditions will define what instances to alert, when to alert, what type of status to alert etc. In this example, I will select a specific instance out of my five instances that I have only from 8:00 to 5:00 p.m. Monday through Friday and only to alert me if the log full person is critical. One important tip is to always check where metric severity has changed. Otherwise, you will get an alert for every collection period. The third step is to define the actions to take. In this example, we will use two actions. One sent an email notification. And the other one to run a SQL script. First, you need to enable the action called sent an email. In this case, we will assume that you already have entered the SMTP [simple mail transfer protocol] information to be able to send emails. Otherwise it will prompt you to enter that information. Next you need to enter your email address and customize your email template. You can pass different variables. By clicking the arrow on the right-hand side. And this example I will add the database name to my template. Now I will also enable the option that is called run the following SQL script. I will enter the description. The instance variable. So he knows which instance to use. And my script to truncate the transaction log file. I will pass the variable of the data into my script. So he knows which database to use. To do the transactional log truncation. That is it. You have created an alert and also an automation response in SQL Diagnostic Manager. You could also run other actions like run a program by adding the path of your executable. Or run an agent job by loading the job from the instance. And optionally selecting the step that you want to run from that job. Thank you. For more information visit idera.com. Thank you.
Topics : Database Monitoring,Database Performance,
Products : SQL Diagnostic Manager for SQL Server,