<img height="1" width="1" style="display:none;" alt="" src="https://dc.ads.linkedin.com/collect/?pid=204641&amp;fmt=gif">

Performance alerts configuration with dbWatch

Posted by Chad Pabalan on Mar 18, 2020 2:02:16 AM
In an enterprise with multiple systems across various departments, database administrators find not only multiple database platforms such as Oracle and SQL Server, MySQL, PostgreSQL but also different versions of each platform. DBA's usually manage tens to hundreds up to thousands of database instances of different platforms and versions within the company.

 

Each database platform and sometimes each version come with their own set of tools, it is a waste of time switching through multiple applications just to monitor and manage hundreds of database instances.

 

dbWatch is the perfect solution to monitor and track all your instances for you. The dbWatch alert module is powerful and flexible, so you can configure precisely how you receive alerts, what alerts you receive, who receives them and at what time of the day or week. In this way you can create alert rules to match work schedules with different alert schemes for office hours, nighttime and weekends.

See the example below.

 
Problem

I want to stay on top of our database farm and receive performance alerts like blocking transactions, deadlocks, failed database backups, high cpu and memory usage thru email or SMS. So that I could easily respond when an issue on our database farm arises especially during off work hours.

 
Solution
 
dbWatch can easily monitor and track the health and performance of your database systems. dbWatch has an alert module which you can configure based on your business requirements so for example you want to monitor the status of your weekly DBCC CheckDB maintenance job for SQL Server. You can configure it by following the step by step procedure below.
 
  • On top choose Configure > Extensions
dbWatch_Extensions
  • In this window you will enable E-Mail extension for this demonstration
dbWatch_Extensions_config

Within this window you will see various server extensions which you can use to send signals across different enterprise monitoring solutions, such as email, Nagios, SMS, OpenView etc.

Right click on E-mail extension and click enable.



  • After enabling the email extension, On top choose Configure
  •  

  • A window will appear specify the following:
  • SMTP Host - input your mail server/smtp settings
  • SMTP Port - input your smtp port number
  • Username/Password - input the email credential which you will use to send the alert
  • From address - this field is the same with  username as this email will be the one sending the alerts
  • Subject - input the subject for the alert

  • After filling up the properties > Click Add Rule.
  •  

Below will appear a box, specify the following information:

Rule name - input the name of this rule

    • Type - select whether you want to send it thru email or SMS
    • Receivers - specify the receivers of this notification
    • Schedules - click Edit to set a schedule for the frequency check

Statuses - click Edit to choose from the following status

    • Type - select whether you want to send it thru email or SMS
    • Receivers - specify the receivers of this notification
    • Schedules - click Edit to set a schedule for the frequency check
    • Statuses - click Edit to choose from the following statusserver_status
    • Group filter - click Edit, you can either include or exclude the selected server groups
    • DBMS type filter - click Edit, you can either include or exclude the selected dbms types (ex. oracle, sqlserver, mysql)
    • Instance filter - click Edit, you can either include or exclude the selected instances
    • Package filter - click Edit, you can either include or exclude the selected packages (ex. AlwaysOn, Capacity, Cluster, Replication, Maintenance, Performance)
    • Check filter - click Edit, you can either include or exclude the selected performance checks (ex. DBCC CheckDB, High Activity, Blocking alerts, etc..)
  •  

    • Group filter - click Edit, you can either include or exclude the selected server groups
    • DBMS type filter - click Edit, you can either include or exclude the selected dbms types (ex. oracle, sqlserver, mysql)
    • Instance filter - click Edit, you can either include or exclude the selected instances
    • Package filter - click Edit, you can either include or exclude the selected packages (ex. AlwaysOn, Capacity, Cluster, Replication, Maintenance, Performance)
    • Check filter - click Edit, you can either include or exclude the selected performance checks (ex. DBCC CheckDB, High Activity, Blocking alerts, etc..)

  • After filling up the all the necessary information for this rule, click Save.

Here is a sample email alert of a failed check execution in Oracle which I've received from the dbWatch monitor.

 

We have successfully configured an alert notification, you can easily customize and create your own rules based on your requirements.

 

For more information visit:

wiki.dbWatch.com 

http://wiki.dbwatch.com/12.7/en/topic/email-and-sms1

 

Follow us on Facebook, Twitter, Youtube, LinkedIn

 

 

Topics: database monitoring, sqlmonitor, sqlperformance, sqlserver, sqlmonitoring