Getting Started with dbWatch Control Center

Open the download file and run the program. You will be greeted by the start screen of the Installation Wizard.

After you do so you will get the following window, where you set the directory where dbWatch will be installed.

Previous installation of the Control Center will be replaced by the newer version.

After clicking “Next”, you will be directed to the next page of the installation process. Here, you can tick the selection you need.

• Install Monitor – Install the latest file path for Control Center monitor.
• Create shortcut for all users – Short cut for monitor will be available in your desktop
• Terminal server settings – Define domain and port for Control Center. Skip this when you don’t need to define a port.

Select the installation options you want and click “Next”.

This is the window, where you specify the credentials who will run your dbwatch service.

If you just want to install the client software, Control Center Monitor, you can untick “Install Service” here. Its also possible to change the default port for ControlCenter, and configure the service for Control Center. By ticking “Advance”, two additional boxes and input fields show up. If you don’t need to specify the Service ID, you can skip that segment. If you don’t want to replace the old service running or start the Dbwatch Control Center, you can untick them.

Always remember to keep the previous version of the monitor closed, as it causes problems when installing the service.

If you do not choose to create a service the Server can still be started in console mode. Click “Next” to continue. You will be redirected to the installation summary.

You are now ready to install dbWatch. Check the information displayed and click “Next” if they are correct.

The installation should take less then a minute on a normal computer.

The installation has now been completed successfully.

What To Do Next

If you did not start the Monitor directly, you need to manually start it. This is located under “All Programs”->”dbWatch Control Center”->”Monitor ” in the start menu on Windows.

When you start your new dbWatch installation, you will be prompted with the “Add database” wizard. For information about how to add a new database, see the “Add or Remove Database” chapter in this guide.

Special setup steps

Instructions for setting up dbWatch on a multihomed system.

If you have problems during or after the installation, please look at our [[Fault-finding-guide|fault finding guide]]

After installation

After installation you might like to have a look at [[Initial configuration of dbWatch|initial configuration]] of dbWatch for furter details.

Quick Fixes

If you’re encountering services problems that relates to credential errors, here’s a quick way to deal with that. Open “Services” in your computer. You can type “Services” in the search bar.

Start running the service. Highlight the equivalent of “Dbwatch Control Center”. This was defined earlier in your installation process.

Right click and click “Start.

If this error above appears, the credentials you inputted were incorrect. To fix this, right click on the highlighted services again and select properties. A window of properties will show up. Select tab “Log On” then select Log on as: Local System account. This only works if CC is installed in your local.

Click “Apply” and re-run the services. You should be able to start your Dbwatch services without a problem.

PROMPT SCREEN FOR ADDING INSTANCE

There are two methods in opening the prompt.

First Method:

To add a SQLServer instance, click on the “Plus (+)” sign on the bottom left of the dbWatch dashboard.

This will bring up the “Add Instance” wizard, which will guide you through the following steps.

Second Method:

On the top left corner, hover to “Monitor” then click “Add Instance”

Select Instance Type and Input Connection Details

Specify the host and port number. Click “Detect” to identify the database platform of this instance.

Choose an authentication type whether Password Authentication or OS Authentication.
You need to specify a login with a sysadmin role that will be used during the installation.

Pro Tip:

Click “Next”.

Define Monitoring

Next specify the group and connection details for this instance.

Next specify the group and connection details for this instance.

Specify the group this instance will belong under, the default groups are Development, Test and Production.

You can easily create and customize your own groups based on your requirements.

Choose the service level depending on how you would like to monitor an instance depending on your dbWatch license.
The following options are:

• Connector – doesn’t require you to install dbWatch schema within the monitored instances. Limited jobs available just to check for your instance uptime
• Basic – doesn’t require you to install dbWatch schema within the monitored instances. Limited jobs available just to check if your instance is up and running
• Standard – usual way to monitor instances will require you to install dbWatch schema within the monitored instance, all jobs are available for installation.

Here’s guide to help you with each section:

Specify the database which you want to install the dbWatch schema/objects in, the installed packages will be used to monitor different performance counters within your instance.

Tick the jobs which you wish to install in this monitored instance.

Click “Next”.

Define Module authentications

Within this window you have an option to choose which credential to use for each module within dbWatch.
You can use the existing user or select a new user whether password or OS authentication.

Here’s guide to help you with each module:

If you’ve finished specifying a credential for each module. Click Next.

Instance Installation

Specify a display name for this instance.

Click Finish to start installing.

Underneath you will see the status of various jobs being installed.

We’ve now successfully added the SQL Server instance in our dbWatch monitor.

PROMPT SCREEN FOR ADDING INSTANCE

There are two methods in opening the prompt.

First Method:

To add an Oracle instance, click on the “Plus (+)” sign on the bottom left of the dbWatch dashboard.

This will bring up the “Add Instance” wizard, which will guide you through the following steps.

Second Method:

On the top left corner, hover to “Monitor” then click “Add Instance”

Select Instance Type and Input Connection Details

The Host info is the hostname or ip address of the database instance.
The Port is the port number where the listener process is listening on.
Click “Detect” to identify the database platform of this instance.

In the SID / Service name field allows you to specify the SID or Service name for the Oracle instance you are about to add.

*A good feature added in Control Center: When a default port is detected for Oracle, Postgres, MySQL or MSSQL, it automatically detects the instance type without the need of selecting it a specified Instance Type. Since the default authentication type will be Password Authentication, it sets the default LOGIN credential to system administrator.Click here for more information in Auto discover ports.

!This feature is only applicable once. If you decided to change the default port, you need to configure it manually or restart the installation wizard by clicking “Cancel”.

Choose an authentication type whether password or OS Authentication.
You need to specify a login with a sysadmin role that will be used during the installation.

Pro Tip:

Click “Next”.

Select Instance Type and Connection Details

Specify the group and connection details for this instance.

By default there are three groups to add instances into defined in dbWatch.
They are:

• Development
• Production
• Test

The Group selector lets you choose which group you want this instance to be added into.
You can easily create and customize your own groups based on your requirements.

Choose the service level depending on how you would like to monitor an instance depending on your dbWatch license.
The following options are:

• Connector – doesn’t require you to install dbWatch schema within the monitored instances. Limited jobs available just to check for your instance uptime
• Basic – doesn’t require you to install dbWatch schema within the monitored instances. Limited jobs available just to check if your instance is up and running
• Standard – usual way to monitor instances will require you to install dbWatch schema within the monitored instance, all jobs are available for installation.

Here’s guide to help you with each section:

Specify the database which you want to install the dbWatch schema/objects in, the installed packages will be used to monitor different performance counters within your instance.

*You can settle with the default settings or customize the jobs that you will be needing. However, it’s not recommended to untick the Local Database Schema since it will limit the availability of the number of jobs to be installed.

Tick the jobs which you wish to install in this monitored instance.

Click “Next”.

Define Module authentications

Within this window you have an option to choose which credential to use for each module within dbWatch.
You can use the existing user or select a new user whether password or OS authentication.

Here’s guide to help you with each module:

If you’ve finished specifying a credential for each module. Click Next.

Instance Installation

Specify a display name for this instance.

Click Finish to start installing.

Underneath you will see the status of various jobs being installed.

We’ve now successfully added the Oracle instance in our dbWatch monitor.

• 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 chown 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.
  

• 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