|
|
This section is common to all the editions of IT360 - Professional Edition, Enterprise Edition (Probes only) and MSP Edition (Probes only).
Database servers are robust, enterprise-class database management system. IT360 provides Database Server monitoring that monitors database resources. This database server monitoring involves connecting to the database resource, collecting data, and representing its attribute details as graphs.
The following are the different Database servers supported by IT360;
Note: In the MySQL database (that you are trying to monitor), ensure that the Username, assigned to IT360, has the permission to access the MySQL database from the host, where the IT360 is running. Else, give a relevant user, who has the privileges to do the same. Minimum User Privileges : The user should have privileges to execute SELECT, SHOW DATABASES, REPLICATION commands in the MySQL server. Also, the IT360 machine should be allowed to access the MySQL database server. For enabling the privileges, execute the below commands in the remote MySQL Server; INSERT INTO user (Host,User) VALUES('<host>','<user>'); (Host -> IT360 machine) / |
To create a MySQL database server monitor, follow the below steps;
Go to 'Admin -> Servers & Applications' and click on New Monitor link.
From the drop down menu, select MySQL DB Server.
Enter the IP Address or Hostname of the host.
Enter the SubNetMask of the network.
Enter the Port number, in which MySQL is running.
Enter the Polling interval time in minutes.
Provide the Username and Password of user, who has permission to access the MySQL database.
Specify the Database name. Please note that the Database name must be valid. Also, the database name is associated with the Username. Hence, provide the database name corresponding to the Username, given in the above field.
Choose the Business Service Group from the combo box, with which you want to associate the MySQL database server Monitor;
In the case of Professional Edition, it is Business Service [optional].
In the case of Enterprise Edition - Probe, it is Business Service [optional]
In the case of MSP Edition - Probe, it is Customer and Site [mandatory]
Click Add Monitor(s). This discovers MySQL database server from the network and starts monitoring them.
|
Note: In the MySQL database (that you are trying to monitor), ensure that the Username assigned to IT360 has the permission to access the MySQL database from the host where IT360 is running. Else, give a relevant user who has the privileges to do the same. |
|
|
Troubleshoot: Having trouble in monitoring MySQL database server? Refer to the online Troubleshooting section. |
Follow the below steps to create an Oracle database server monitor;Note: 1. For you to create a new Oracle database monitor, you should have Admin privileges.
2. Minimum User Privileges = user with CONNECT and SELECT_CATALOG_ROLE roles.
Go to 'Admin -> Servers & Applications' and click on New Monitor link.
From the drop down menu, select Oracle DB Server.
Enter the IP Address or Hostname of the host.
Enter the SubNetMask of the network.
Enter the Port number in which the Oracle is running.
Enter the Polling interval time in minutes.
Provide the Username of the admin user ('system' is the default username) and its corresponding Password.
Provide the Instancec Name [Service Name].
Choose the Business Service Group from the combo box, with which you want to associate the Oracle database server Monitor;
In the case of Professional Edition, it is Business Service [optional].
In the case of Enterprise Edition - Probe, it is Business Service [optional]
In the case of MSP Edition - Probe, it is Customer and Site [mandatory]
Click Add Monitor(s). This discovers Oracle database server from the network and starts monitoring them.
To create a MS SQL database server Monitor, follow the below steps;
Go to 'Admin -> Servers & Applications' and click on New Monitor link.
From the drop down menu, select MS SQL DB Server.
Enter the IP Address or Hostname of the host.
Enter the SubNetMask of the network.
Enter the Port number, in which the MS SQL is running.
Enter the Polling interval time in minutes.
Provide the Username and Password of user, who has permission to access the MS SQL database [SQL DB Authentication]. The Username specified for collecting the data from MS SQL Server should have either System Administrator role, or the user should be the DB owner for Master database. Alternatively, you can provide the Windows Authentication details (give the Username like domainname\username) also.
Choose the Business Service Group from the combo box, with which you want to associate the MS SQL database server Monitor;
In the case of Professional Edition, it is Business Service [optional].
In the case of Enterprise Edition - Probe, it is Business Service [optional]
In the case of MSP Edition - Probe, it is Customer and Site [mandatory]
Click Add Monitor(s). This discovers MS SQL database server from the network and starts monitoring them.
Minimum User Privileges : User should be permitted to access MASTER database & In MASTER database. Roles : public + db_datareader should be selected. For MS SQL 2005 user role, To grant VIEW SERVER STATE, you can use any of the following methods: 1) Execute the following query,GRANT VIEW SERVER STATE TO username; 2) In SQL management studio for user choose, 'Properties -> Securables -> Click Add ( under securables ) -> choose "All objects of the Types..." -> choose Servers -> choose Grant for "View server state' permission. |
To create a IBM DB2 database server monitor, follow the below steps;Note: IBM DB2 ver.8 and ver.9 monitoring is supported. And also, you should be able to access the SYSPROC procedures.
Go to 'Admin -> Servers & Applications' and click on New Monitor link.
From the drop down menu, select DB2 DB Server.
Enter the IP Address or Hostname of the host.
Enter the SubNetMask of the network.
Enter the Port number, in which DB2 is running.
Enter the Polling interval time in minutes.
Provide the Username and Password of user, who has permission to access the DB2 database. The Username specified for collecting the data from DB2 Server should have either System Administrator role, or the user should be the DB owner for Master database.
Specify the Database Name.
Choose the Business Service Group from the combo box, with which you want to associate the DB2 database server Monitor;
In the case of Professional Edition, it is Business Service [optional].
In the case of Enterprise Edition - Probe, it is Business Service [optional]
In the case of MSP Edition - Probe, it is Customer and Site [mandatory]
Click Add Monitor(s). This discovers DB2 database server from the network and starts monitoring them.
To create a Sybase database server Monitor, follow the below steps;Note: Sybase ASE ver.12.5.3 and above monitoring is only supported.
Go to 'Admin -> Servers & Applications' and click on New Monitor link.
From the drop down menu, select Sybase.
Enter the IP Address or Host Name of the host.
Enter the SubNetMask of the network.
Enter the Port number, in which sybase is running.
Enter the Polling interval time in minutes.
Provide the Username and Password of user, who has permission to access the Sybase database. The Username specified, for collecting the data from Sybase, should have either System Administrator role, or the user should be the DB owner for Master database.
Specify the Database Name.
Choose the Business Service Group from the combo box, with which you want to associate the Sybase database server Monitor;
In the case of Professional Edition, it is Business Service [optional].
In the case of Enterprise Edition - Probe, it is Business Service [optional]
In the case of MSP Edition - Probe, it is Customer and Site [mandatory]
Click Add Monitor(s). This discovers Sybase database server from the network and starts monitoring them.
If you have added Monitors and not associated them with a Monitor Group, you can do this manually anytime. For information on associating a Monitor with a Monitor Group, refer to Associating Monitor with Business Service topic.
To create a PostgreSQL database server monitor, follow the steps given below;
Go to 'Admin -> Servers & Applications' and click on New Monitor link.
From the drop down menu, select PostgreSQL.
Enter the Display Name of the database server.
Enter the IP Address or Host Name of the host.
Enter the Port number, in which PostgreSQL is running.
Provide the Username and Password of user, who has permission to access the PostgreSQL database.
Specify the DBName.
Enter the Polling interval time in minutes.
Choose the Business Service Group from the combo box, with which you want to associate the PostgreSQL database server Monitor;
In the case of Professional Edition, it is Business Service [optional].
In the case of Enterprise Edition - Probe, it is Business Service [optional]
In the case of MSP Edition - Probe, it is Customer and Site [mandatory]
To create a Memcached database server monitor, follow the steps given below;
Go to 'Admin -> Servers & Applications' and click on New Monitor link.
From the drop down menu, select Memcached.
Specify the Display Name of the Memcached server.
Enter the Hostname or IP Address of the host, where the Memcached server runs.
Enter the Port, where the server is running.
If you want to enable Transaction test, select 'Yes' radio button, else select 'No' radio button.
Set the Polling Interval.
Choose the Business Service Group from the combo box, with which you want to associate the Memcached server Monitor;
In the case of Professional Edition, it is Business Service [optional].
In the case of Enterprise Edition - Probe, it is Business Service [optional]
In the case of MSP Edition - Probe, it is Customer and Site [mandatory]
If you have added Monitors and not associated them with a Monitor Group, you can do this manually anytime. For information on associating a Monitor with a Monitor Group, refer to Associating Monitor with Monitor Groups topic.
See Also:
Monitor Information - Database Server | Create Other New Monitors|
|
