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 lets you view, add, edit, and remove databases for monitoring. Users require 'Inventory Administration' permissions to access this page. For information about user permissions and how to grant user permissions, see this article.

Click Administration from the Main Menu, and then click Database Management.

The Database Application Management page is displayed.

The Database Application Management page provides the following information about the databases that you have added to Entuity.

Dashboards and dashlets:

You can view database status information from the following dashboards:

• Database Monitoring dashboard:

  This dashboard is applicable to the View context:
  
  
  
  At the View context level, the dashboard provides the following information:

  • Database Status - this is a Pie Chart dashlet. This dashlet shows the statuses of the databases in this View.
  • Database Type - this is a Pie Chart dashlet. This dashlet shows the types of databases in this View.
  • Incidents Summary - this is a Pie Chart dashlet. This dashlet displays the open Database Incidents in this View.
  • Databases Instances - this is a Table dashlet. This dashlet lists the databases in the View, including the system version of each database.

• 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 from the Explorer. The dashlets on this Summary dashboard dynamically change, based on the type of database instance that you've selected (as shown in the following examples).
  
  Example 1:
  
  
  
  At the database context level, this Summary dashboard applies to the MongoDB and MS SQL database instance types, and provides the following information:

  • Key Info - this is a Key Info dashlet. This dashlet summarizes the details of the database: 
    • Status
    • Name
    • Replication Enabled  
    • Path
    • System Version
    • Recovery Model
    • Version
    • Collector Definition
    • Polling Status
    • Host
    • Type
  • Schemas - this is a Table dashlet. This dashlet lists the schemas of the database instance.
  • Open Incidents - this is a Pie Chart dashlet. This dashlet displays the incidents on this database instance.
  • Lock Contention Rate - this is a Chart dashlet. This dashlet displays a line chart of the performance metric polled.
  • Buffer Cache Hit Ratio - this is a Chart dashlet. This dashlet charts the buffer cache hit ratio performance metric polled.
  • Throughput - this is a Chart dashlet. This dashlet displays a stacked bar chart of the MBPS Received and Sent performance metrics polled.
  • I/O Latency - this is a Chart dashlet. This dashlet displays an area spline chart of IO Latency Misc., IO Latency Read, and IO Latency Write performance metrics polled.
  • Query Rate - this is a Chart dashlet. This dashlet displays an area spline chart of Query Rate performance metrics polled.
  • Allocated Memory Size Usage - this is a Chart dashlet. This dashlet displays a bar chart of the memory size used percentage performance metric polled.
  • Space Allocation Usage - this is a Chart dashlet. This dashlet displays a stacked bar chart of the used space and remaining space performance metrics polled.
    
    
    Example 2:
    
    
    
    At the database context level, this Summary dashboard applies to the PostgreSQL database instance type, and provides the following information:
    • Key Info - this is a Key Info dashlet. This dashlet summarizes the details of the database: 
      • Status
      • Name
      • Replication Enabled 
      • Path
      • System Version
      • Recovery Model
      • Version
      • Collector Definition
      • Polling Status
      • Host
      • Type
    • Schemas - this is a Table dashlet. This dashlet lists the schemas of the database instance.
    • Open Incidents - this is a Pie Chart dashlet. This dashlet displays the incidents on this database instance.
    • Lock Contention Rate - this is a Chart dashlet. This dashlet displays a line chart of the performance metric polled.
    • Buffer Cache Hit Ratio - this is a Chart dashlet. This dashlet charts the buffer cache hit ratio performance metric polled.
    • Average Query Time  - this is a Chart dashlet. This dashlet charts the Average Query Time performance metric polled.
    • I/O Latency - this is a Chart dashlet. This dashlet displays an area spline chart of IO Latency Misc., IO Latency Read, and IO Latency Write performance metrics polled.
    • Query Latency - this is a Chart dashlet. This dashlet displays 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 - this is a Chart dashlet. This dashlet displays a bar chart of the memory size used percentage performance metric polled.
    • Space Allocation Usage - this is a Chart dashlet. This dashlet displays a stacked bar chart of the used space and remaining space performance metrics polled.
      
      
      Example 3:
      
      
      
      At the database context level, this Summary dashboard applies to the Azure SQL, MariaDB, MySQL, Oracle, and SAP HANA database instance types, and provides the following information:
      • Key Info - this is a Key Info dashlet. This dashlet summarizes the details of the database: 
        • Status
        • Name
        • Replication Enabled 
        • Path
        • System Version
        • Recovery Model
        • Version
        • Collector Definition
        • Polling Status
        • Host
        • Type
      • Schemas - this is a Table dashlet. This dashlet lists the schemas of the database instance.
      • Open Incidents - this is a Pie Chart dashlet. This dashlet displays the incidents on this database instance.
      • Lock Contention Rate - this is a Chart dashlet. This dashlet displays a line chart of the performance metric polled.
      • Buffer Cache Hit Ratio - this is a Chart dashlet. This dashlet charts the buffer cache hit ratio performance metric polled.
      • Throughput - this is a Chart dashlet. This dashlet displays a stacked bar chart of the MBPS Received and Sent performance metrics polled.
      • I/O Latency - this is a Chart dashlet. This dashlet displays an area spline chart of IO Latency Misc., IO Latency Read, and IO Latency Write performance metrics polled.
      • Query Latency - this is a Chart dashlet. This dashlet displays 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 - this is a Chart dashlet. This dashlet displays a bar chart of the memory size used percentage performance metric polled.
      • Space Allocation Usage - this is a Chart dashlet. This dashlet displays 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 - this is a Table dashlet. This dashlet displays the schema on this database with the following information:
  • Display Name
  • Buffer Allocated
  • Buffer Data
  • Buffer Pages
  • Buffer Rows Cached
  • Indexes
  • Unused Indexes
  • Used Space
  • Space Allocated
  • Database Engines - this is a Table dashlet. This dashlet displays the engines on this database with the following information:
    • Display Name
    • Description
  • Database Nodes - this is a Table dashlet. This dashlet displays the nodes in this clustered database with the following information:
    • Status
    • Display Name
    • Mode
    • Role
  • Database Tables - this is a Table dashlet. This dashlet displays the database tables that you specified when you added the database to Entuity, with the following information:
    • Display Name
    • Schema
    • Total Space
    • Used Space

• Schema Summary Dashboard:

  This dashboard is applicable to the context of a database instance. The dashlets on this Summary dashboard dynamically change, based on the type of database instance that you've selected (as shown in the following examples).

  Example 1:
  
  
  
  At the database schema level, this Summary dashboard is applicable to the MongoDB and MS SQL schemas, and provides the following information:

  • Key Info - this is a Key Info dashlet. This dashlet summarizes details of the database schema:
  • Name
  • Indexes
  • Unused Indexes
  • Incidents Summary - this is a Pie Chart dashlet. This dashlet displays the incidents on this database instance.
  • Average Query Time - this is a Chart dashlet. This dashlet displays an area spline chart of the average time for a query to execute for this schema milliseconds.
  • Query Rate - this is a Chart dashlet. This dashlet displays a bar chart of the query rate for this schema.
  • Space Allocation Usage - this is a Chart dashlet. This dashlet displays a bar chart of the used space performance metric on this schema.
  • I/O Latency - this is a Table dashlet. This dashlet displays an area spline chart of IO Latency Misc., IO Latency Read, and IO Latency Write performance metrics on this schema.
  • IOPS Read/Write/Misc/Total - this is a Chart dashlet. This dashlet displays a stacked bar chart of IOPS Read, IOPS Write, and IOPS Misc. performance metrics on this schema.

  
  
  Example 2:
  
  
  
  At the database schema level, this Summary dashboard is applicable to the PostgreSQL and SAP HANA schemas, and provides the following information:

  • Key Info - this is a Key Info dashlet. This dashlet summarizes details of the database schema:
    • Name
    • Buffer Data
    • Buffer Pages
    • Indexes
    • Unused Indexes
  • Incidents Summary - this is a Pie Chart dashlet. This dashlet displays the incidents on this database instance.
  • Average Query Time - this is a Chart dashlet. This dashlet displays an area spline chart of the average time for a query to execute for this schema milliseconds.
  • Query Rate - this is a Chart dashlet. This dashlet displays a bar chart of the query rate for this schema.
  • Query Latency - this is a Chart dashlet. This dashlet displays an area spline chart of Query Latency Delete, Query Latency Fetch, Query Latency Insert, and Query Latency Update performance metrics on this schema.

  • IOPS  Read/Write/Misc/Total - this is a Chart dashlet. This dashlet displays a stacked bar chart of IOPS Read, IOPS Write, and IOPS Misc. performance metrics on this schema.

    
    
    Example 3:
    
    
    
    At the database schema level, this Summary dashboard is applicable to the Azure SQL, MariaDB, Oracle, and MySQL schemas, and provides the following information:

    • Key Info - this is a Key Info dashlet. This dashlet summarizes details of the database schema:
      • Name
      • Indexes
    • Incidents Summary - this is a Pie Chart dashlet. This dashlet displays the incidents on this database instance.
    • Average Query Time - this is a Chart dashlet. This dashlet displays an area spline chart of the average time for a query to execute for this schema milliseconds.
    • Query Rate - this is a Chart dashlet. This dashlet displays a bar chart of the query rate for this schema.
    • Space Allocation Usage - this is a Chart dashlet. This dashlet displays a bar chart of the used space performance metric on this schema.
    • I/O Latency - this is a Table dashlet. This dashlet displays an area spline chart of IO Latency Misc., IO Latency Read, and IO Latency Write performance metrics on this schema.
    • Query Latency - this is a Chart dashlet. This dashlet displays an area spline chart of Query Latency Delete, Query Latency Fetch, Query Latency Insert, and Query Latency Update performance metrics on this schema.
    • IOPS  Read/Write/Misc/Total - this is a Chart dashlet. This 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 - this is a Key Info dashlet. This dashlet summarizes details of the database engine:
    • Description
    • Name
  • Incidents Summary - this is a Pie Chart dashlet. This dashlet displays the open Database Incidents in this view.
  • Events Over Time - this is a Chart dashlet. This dashlet displays a bar chart of incidents by severity level over the previous 24 hours.

   

• Database Nodes Summary Dashboard:
  
  This dashboard is applicable to the context of a clustered database instance:
  
  
  
  At the database node level, this dashboard provides the following information: 
  • Key Info - this is a Key Info dashlet. This dashlet summarizes the details of the database node:
    • Mode
    • Role
    • Name
  • Incident Summary - this is a Pie Chart dashlet. This dashlet displays the incidents on this node.
  • Events Over Time - this is a Chart dashlet. This dashlet displays a bar chart of incidents by severity level over the selected time period.

• 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 - this is a Table dashlet. This dashlet displays the jobs on this database in a table with the following information:
    • Display Name
    • Host
    • Schema
    • Type
  • Database Job Events - this is a Table dashlet. This dashlet displays the events opened against database jobs detailing the job name, source, details and time of the incident.
  • Database Job States - this is a Pie Chart dashlet. This dashlet shows a breakdown of the database job status for the jobs in the View.
     

• Database Tables Summary Dashboard:
  
  This dashboard is applicable to the context of a database instance:
  
  
   

  At the database instance level, this dashboard provides the following information:

  • Database Tables - this is a Table dashlet. This dashlet lists the database tables in the database instance, and provides the following details about each database table:
    • Display Name
    • Schema
    • Total Space
    • Used Space
    • Used Space Percent
  • Table Space Used - this is a Chart dashlet. Select a database table listed in the Database Tables dashlet to populate this dashlet. The dashlet displays a stacked bar chart of the total space of, and the used space on, the database table.
  • Table Space Allocation Usage - this is a Chart dashlet. Select a database table listed in the Database Tables dashlet to populate this dashlet. The dashlet displays a bar chart of the percentage of allocated storage space used by the database table.
    
     
• Table Summary Dashboard:
  
  This dashboard is applicable to the context of a database instance:
  
  
  
  You can access this dashboard by clicking the specific database table name from the Database Tables table.
  At the database table level, this dashboard provides the following information:
  • Key Info - this is a Key Info dashlet. This dashlet summarizes details of the selected database table:
    • Name
    • Schema
  • Table Space Used - this is a Chart dashlet. This dashlet displays a stacked bar chart of the total space of, and the used space on, the database table.
  • Table Space Allocation Usage - this is a Chart dashlet. This dashlet displays a bar chart of the percentage of allocated storage space used by the database table.

To add a database:

1. Navigate to the Database Application Management page.
2. Click Add Database at the top of the page (or from the Overflow Menu).
   
   
   
   The Add Database form is displayed.
    
3. Fill in the Add Database form, which consists of the following sections:
   • Database Details
   • Agent Monitoring
   • Monitoring Settings
     
     
     
     
     Database Details
     1. In the Display Name field, specify a display name for the database.
     2. In the Host field, specify the IP address or hostname of the database.
     3. In the Connection Port field, optionally specify a connection port. If left blank, the default port is used.

     4. In the Type field, choose the type of database you want to add:

        • Azure SQL 
        • MS SQL
        • MongoDB
        • MySQL
        • Oracle
        • PostgreSQL
        • SAP HANA

        Your selection determines the connection methods available.

     5. From the Connection Method dropdown field, select the connection method to be used for communicating with the database.
     6. Click the Credential field to go through to the Credential form, where you can either search from a list of shared credential sets, or create a local credential to be used for the database connection.
   • 
     
     Agent Monitoring
     This section is for monitoring Server/Storage devices, including databases, using an Entuity Agent. For more information on agent monitoring, see this section. 
     1. Click the Agent field to go to the Agent form.
        
         
     2. From the Agent form, select the Entuity Agent that you want to monitor the database. 
        The selected agent's name and ID are then displayed in the Agent field.
     3. Once you have selected the Entuity Agent that will monitor the database, click Done to save your changes. Otherwise, click Cancel. 

• 
  
  
  Monitoring Settings

  1. Set the Polling Enabled switch to specify whether to enable polling. 
     If enabled, the database is polled every 5 minutes, by default.
  2. Set the Table Monitoring switch to specify whether you want Entuity to monitor specific tables of the database. If yes, do the following:
     1. Click the Add Table field.
        The Add Table form is displayed. 
         
        
     2. In the Name field, enter the name of the database table that you want to monitor.
     3. Click Done to return to the Add Database form. Otherwise, click Cancel to close the form without saving your changes.
     4. Repeat Steps a-c for each database table that you want to monitor.
  3. Click Done on the Add Database form to save your changes. Otherwise, click Cancel. 
     When saved, the newly added database is displayed in the table on the Database Application Management page.

   

To edit a database:

1. Navigate to the Database Application Management page.
2. Select the database that you want to edit and click Edit Database at the top of the page (or from the Overflow Menu or right-click Context Menu).
   
   
   
   The Edit Database form is displayed.
3. Make changes to the fields on the Edit Database form.
   The Edit Database form has the same fields as when adding a database (see To add a database).
4. Click Done to save your changes. Otherwise, click Cancel.

To remove a database:

1. Navigate to the Database Application Management page.
2. Select the database(s) that you want to remove and click Remove Database at the top of the page (or from the Overflow Menu or right-click Context Menu).
   
   
   
   A removal confirmation window is displayed. 
3. Click Yes to confirm the removal or Cancel to close the confirmation window without removing the database(s).