How do I view, add, edit or remove databases?

To view databases

Database Management page

Dashboards and dashlets

To add a database

To edit a database

To remove a database

To view databases:

Database Management page:

The Database Management page enables you to view, add, edit, and remove databases for monitoring. Users require “Inventory Administration” permissions to access this page.

1. Click the Main Menu and then Database Management.

   

2. The Database Application Management page will open.

   

The Database page displays a table listing the databases that you have added. The table details the following information:

Dashboards and dashlets:

You can view database status information via the following dashboards:

• Database Monitoring dashboard:

  This dashboard is applicable to the View context:

At the View context level, this dashboard provides the following information:

• Database Status pie chart, showing the statuses of the databases in this View.
• Polling Status pie chart dashlet, showing the polling statuses of the databases in this View.
• Incidents Summary pie chart dashlet, displaying the open Database Incidents in this View.
• Databases table dashlet, listing the databases in the View.

• Database Instance Summary Dashboard:

  This dashboard is applicable to database objects:

You can access this dashboard by clicking the specific database display name from the Database Instances table, or by navigating to the database via the Explorer. At the database context level, this Summary dashboard provides the following information:

• Key Info dashlet summarizing details of the database
  • Name
  • Path
  • Recovery Model
  • System Version
  • Version
  • Collector Definition
  • Host
  • Polling Status
  • Type
  • Status
• Schema table dashlet listing the schemas of the database instance.
• Open Incidents dashlet displaying the incidents on this database instance.
• Lock Contention Rate dashlet displaying a line chart of the performance metric polled.
• Buffer Cache Hit Ratio dashlet displaying a line chart of the buffer cache hit ratio performance metric polled.
• Throughput dashlet displaying a stacked bar chart of the MBPS Received and Sent performance metrics polled.
• I/O Latency dashlet displaying an area spline chart of IO Latency Misc., IO Latency Read, and IO Latency Write performance metrics polled.
• Query Latency dashlet displaying an area spline chart of Query Latency Delete, Query Latency Fetch, Query Latency Insert, and Query Latency Update performance metrics polled.
• Allocated Memory Size Usage dashlet displaying a bar chart of the memory size used percentage performance metric polled.
• Space Allocation Usage dashlet displaying a stacked bar chart of the used space and remaining space performance metrics polled.

• Database Resources Dashboard:

  This dashboard is applicable to the context of a database instance:

• At the database instance level, this dashboard provides the following information:
  • Database Schema dashlet displaying the schema on this database in a table with the following information:
    • Name
    • Buffer Allocated
    • Buffer Data
    • Buffer Pages
    • Buffer Rows Cached
    • Indexes
    • Unused Indexes
    • Used Space
    • Space Allocated
  • Database Jobs dashlet displaying the jobs on this database with the following information:
    • Name
    • Host
    • Schema
    • Type
    • Last Executed
    • Status
  • Database Engines dashlet displaying the engines on this database with the following information:
    • Name
    • Description

• Schema Summary Dashboard:

  This dashboard is applicable to the context of a database instance:

  

• At the database schema level, this dashboard provides the following information:
  • Key Info dashlet summarizing details of the database
    • Name
    • Buffer Data
    • Buffer Rows Cached
  • Incidents Summary dashlet displaying the incidents on this database instance.
  • Average Query Time dashlet displaying an area spline chart of the average time for a query to execute for this schema milliseconds.
  • Query Rate dashlet displaying a bar chart of the query rate for this schema.
  • Space Allocation Usage dashlet displaying a bar chart of the used space performance metric on this schema.
  • I/O Latency dashlet displaying an area spline chart of IO Latency Misc., IO Latency Read, and IO Latency Write performance metrics on this schema.
  • Query Latency dashlet displaying an area spline chart of Query Latency Delete, Query Latency Fetch, Query Latency Insert, and Query Latency Update performance metrics on this schema.
  • IOPS dashlet displays a stacked bar chart of IOPS Read, IOPS Write, and IOPS Misc. performance metrics on this schema.

• Engine Summary Dashboard:

  This dashboard is applicable to the context of a database instance:

  

• At the database engine level, this dashboard provides the following information:
  • Key Info dashlet summarizing details of the database engine
    • Name
    • Description
  • Incident Summary pie chart dashlet, displaying the open Database Incidents in this view.
  • Events Over Time chart dashlet, displaying a bar chart of incidents by severity level over the previous 24 hours.

• Job Summary Dashboard:

  This dashboard is applicable to the context of a database instance:

  

• At the database job level, this dashboard provides the following information:
  • Database Jobs dashlet displaying the jobs on this database in a table with the following information:
    • Name
    • Host
    • Schema
    • Type
  • Database Job Events table dashlet displaying the events opened against database jobs detailing the job name, source, details and time of the incident.
  • Database Job States pie chart dashlet, showing a breakdown of the database job status for the jobs in the View.

To add a database:

1. Navigate to the Database Application Management page.

2. Click Add Database at the top of the page (or via the Overflow Menu).

   

3. The Add Database form will open on the right of the window.
4. Display Name - specify a display name for the database.
5. Host – specify the IP address or hostname of the database.
6. Connection Port – specify a connection port if desired, if left blank the default port will be used.
7. Type – The type of database being added such as MySQL, Oracle, or Microsoft SQL. This determines the connection methods available.
8. Connection Method – select the connection method that is to be used to communicate with the database.
9. Credential – specify the shared credential set to be used for the database connection.
10. Polling – specify whether to enable polling. If enabled, the database will be polled every 5 minutes by default.
11. Click Done in the top right to save your changes, otherwise click Cancel. When saved, the database will appear in the table list.

To edit a database:

1. Navigate to the Database Application Management page.

2. Select the database that you wish to edit and click Edit Database at the top of the page (or via the Overflow Menu or right-click Context Menu).

   

3. The Edit Database form will open on the right of the window, which contains the same fields as when adding a database (see above).
4. Make your desired changes and click Done in the top right to save, otherwise click Cancel.

To remove a database:

1. Navigate to the Database Application Management page.

2. Select the database that you wish to remove and click Remove Database at the top of the page (or via the Overflow Menu or right-click Context Menu).

   

3. A removal confirmation dialog will open. Confirm your choice.