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
On top choose Configure > Extensions
In this window you will enable E-Mail extension for this demonstration
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 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:
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
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:
