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

Getting Started with dbWatch

dbWatch is a complete database monitoring and management solution for your database. Helping database administrators manage database farms, proactive monitoring helps you identify any issues before it becomes a serious threat to your system, helps tune your database infrastructure and optimize your database resource usage.

In this section you will learn the basics of dbWatch from installation, to adding of database instances and basic monitoring with dbWatch. This guide will show you how easy it is to operate dbWatch to monitor and manage your database farm.

dbWatch Checklist

dbWatch
dbWatch
dbWatch

Step By Step Installation Guide

  • Run the installer as admin
    1 Run the installer as admin

 

  • Set the directory for your dbWatch installation or just use the default path

 

  • Tick upgrade if you have an old or existing dbWatch version installed but if you don't. Just click Next.

 

  • Install the dbWatch server and the service, you can specify your own listener port or just use the default port.

 

  • Set a password for the default admin user

 

  • Enter license key

 

  • Accept the license agreement

 

  • dbWatch is now ready to install on your machine

 

  • Successfully installed dbWatch

 

  • Start the dbWatch monitor

 

  • Input the password you specified for the default admin user

 

  • We've succesfully installed dbWatch on our windows machine.

  • Create a new directory for dbWatch: sudo mkdir -p /usr/local/dbWatch
  • Then input the root or super user password
  • Change the owner of the directory to the user dbwatch: sudo chwn dbwatch.dbwatch /usr/local/dbWatch
  • Change the access mode of the directory by executing: sudo chmod 750 /usr/local/dbWatch


  • Download the installer file by running the command: wget https://download.dbwatch.com/download/Latest/dbWatch_unix_12_6_15.sh  --no-check-certificate


  • Grant permission to execute the installer by running: sudo chmod +x dbWatch_unix_12_6_15.sh


  • Run the installation file by typing: sudo ./dbWatch_unix_12_6_15.sh


  • A window will appear, specify your preferred destination directory for dbWatch.


  • In this window you can choose to upgrade to an existing dbWatch installation. Right now, we’re doing a fresh install so let’s continue by clicking next.


  • We will install a new dbWatch server and use the default port.


  • Input your preferred password for the default admin user.


  • Enter the license key


  • Accept the agreement


  • Everything’s set we can now install dbWatch on our machine.


  • And now we’ve completed installing dbWatch on Linux. Let’s start the dbWatch monitor.



  • We have successfully configured and started dbWatch in Ubuntu.

Learn how you can add database instances on dbWatch

In this section we will learn the basics such as adding database instances and basic configuration to get started with dbWatch.

  • Select MS SQL Server button and tick Add Database Instance


  • Pick whether the instance you will monitor is for Development, Test or Production. Specify your hostname, port number, authentication mode and credentials. Click Next.


  • Choose the display name for this instance you wish to monitor, Installing advanced monitoring means that a dbwatch database will be created with the monitoring framework installed on the instance. Input your login credentials it must have sa or sysadmin role.

  • Select the set of tasks you wish to install that will be used to monitor our SQL Server instance.
  • We're now ready to add the sql server instance on our dbWatch monitor.
  • We've succesfully added the SQL server instance 


  • Select PostgreSQL button and tick Add Database Instance

 

  • Specify the display name for this instance and the group it belongs to. Tick the monitoring checkbox then continue.

 

  • Specify the host, credentials and the port number for this instance.

 

  • Set a user and password for the dbWatch user

 

  • Select the tasks you wish to install that will be used to monitor the PostgreSQL instance.

 

  • We're now ready to add the PostgreSQL instance on dbWatch

 

  • Successfully added the PostgreSQL instance 

  • Select Oracle button and tick Add Database Instance

 

  • Specify the group where the instance belongs to, hostname, port number, SID, authentication mode and credentials for this instance.

 

  • Specify display name for this instance,  Installing advanced monitoring means that a dbwatch database will be created with the monitoring framework installed on the instance. Specify the schema owner and password.

 

  • Select the tasks you wish to install which is used to monitor the Oracle instance.

 

  • We're now ready to add the Oracle instance on dbWatch

 

  • Successfully added the Oracle instance

  • Select MySQL button and tick Add Database Instance

 

  • Specify given name for the MySQL instance and select a grouping which the instance belongs to. Tick Monitoring.

 

  • Specify the hostname, credentials and the port number

 

  • Specify the database to be used by dbWatch and set a username and password.

 

  • Select the tasks you wish to install which will be used to monitor the MySQL instance

 

  • We're now ready to add the MySQL instance in dbWatch

     
  • Successfully added the instance

  • Select the Sybase button and tick Add Database Instance

 

  • Specify given name for the Sybase instance and select a grouping which the instance belongs to. Tick Monitoring.

 

  • Specify the hostname, credentials and the port number

 

  • Specify the database to be used by dbWatch and set a username and password.

 

  • Select the tasks you wish to install which will be used to monitor the Sybase instance

 

  • We're now ready to add the Sybase instance in dbWatch

 

  • Succesfully added the Sybase instance

  • Select Azure button and tick Add Database Instance

 

  • In this window, specify the display name, set the group where the instance belongs to, input your hostname, port number, database name and credentials.
  • Select the tasks you wish to install which will be used to monitor the Azure instance

 

  • We're now ready to add the Azure instance in dbWatch

 

  • We've successfully added the instance


Performance Monitoring

  • Capable of checking disk and memory usage
  • Monitor CPU usage
  • Analyse performance and disk growth rate
  • Top level view of database farm

Basic Monitoring with dbWatch

In this episode you will learn the basics on how to monitor your cpu, memory usage and various charts that will help you stay on top of your database farm with the help of dbWatch.

 

Monitoring active query sessions

In this episode you will learn how you can track different query sessions running on your database instances.

 

Database Management

  • Full overview of all hardware resource 
  • Management of database performance reports
  • Management of tasks and alerts
  • Able to manage jobs on the management module

Managing database instances

 

Receive a license for 30 days for the full product for you to explore.

Submit the form to get started with your dbWatch free trial today!

See for yourself:

  • Pro-active monitor all your instances
  • Drill-down performance analysis
  • Automate routine tasks
  • Extensive reporting

Get my free dbWatch trial now: