Create a Database Task

Problem
You don’t know if your databases (Oracle, mySQL, Informix, InterBase, Postgre SQL, are on or offline. Queries are failing, but you don’t know when.

Solution
Chroniker's Task Monitor will test exactly how long it takes to run an SQL query against your database.

Define a Database Task

Click on Tools > Add New Monitor > Database Task:

Required Parameters
1. Click on the Group drop down menu button and select a group from this list.
2. Enter a unique Task Name. Use whichever naming convention is most useful to you.
  Example: Oracle System Test
3. Monitor From: If Chorniker Remote Location is used. Select a location where the task will be executed.
4. Database Type: Select the Database type from the drop down menu.
  Example: Microsoft SQL Server
5. Host: Enter the host name or IP address for the database server in the Host field. Not needed for Oracle or ODBC.
6. Port: Enter the numerical port number for the database in the Port field. Not needed for oracle or ODBC.
7. Login and Password: Enter a valid user name and password for the database in the Login and Password fields.
  Example: This is for secure databases only. Also make sure that you already have the proper permissions from the machine Chroniker is installed on to the database you are trying to run queries on.
8. Timeout: Enter a number for the time it takes before the database is considered unavailable in the Time-out (seconds) field.
9. Database Name: Enter the instance name of the database in the database name field. For Oracle, it should be the TNS-Name. For ODBC, it should be the DNS.
  Example: "Northwind"
10. TNS Name: Enter the TNS name of the database in the TNS field. This is for Oracle.
  Example: "orcl"
11. Query: Enter a query to execute. Basic syntax is required. Do NOT enter a semi-colon at the end.
  Example: SELECT TOP 10 * FROM [dbo].[Orders]
12. Monitor Results: Monitor query results instead of response time. Check if you wish to monitor the return query result or uncheck if you wish to monitor the query response time.
13. Conn. Method: This is for Oracle. Use sqlplus or internal libraries.
  
  Note: Make sure when using oracle to have oracle client installed and all environment variables set correctly.
14. Enter the host/server where the Database server resides. This field is used for Host Outages configurations. Please click here to know more about Host Outages.
Events
1. Click on Add Event button to create a new Event or apply a predefined Event to this task.
2. Select Event Type from Type dropdown.
3. Select a predefined Event from the dropdown list or select [Add New Event ..] from the dropdown to create a new Event.
  
  When selecting [Add New Event ..], Events form opens to create the new Event.
  
  After creating the new Event, you need to click on Add Event button one more time in Add Task form to see the new Event in the Events dropdown list.
Description: Enter a meaningful description of the Task.
Click on Submit to save the form or Reset to clear the form.

Summary

You have created a Database Task that will send an email when the event threshold you’ve set is exceeded. It is recommended that you create as many reactions and events as you need to monitor your systems and networks efficiently.

If you find that you are receiving emails constantly, edit the event’s threshold accordingly. Or make changes to the Database so that it does operate under desired thresholds

Now that you have a basic Database test setup, you can graph, report and monitor the data you are collecting. You may also edit the appropriate scenario and or task to include profiles and other options.

Top

Load testing tools | Application Testing Software | NrgGlobal

Create a Database Task