Add new Database
Last updated
Last updated
Before start monitoring Database, you should create a new Database entry.
1. Click to Database on the left pane.
2. On Database Management screen, click Add (+) button on the right top section.
3. You will get the fields as follows.
Refer to the following table to understand the fields in the above screen.
Fields | Description |
---|---|
Database Type | Select proper type from dropdown. · Microsoft SQL: Relational database management system (RDBMS) developed by Microsoft, offering comprehensive data storage, retrieval, and management capabilities for various applications and industries. · SAP HANA: SAP HANA is an in-memory database platform that accelerates data processing and analytics, providing real-time insights and enabling rapid application development for businesses. |
Name | A label or name that is assigned to a Database. |
IP Address / Instance | The numerical label assigned to each device connected to a computer network is called an "IP address." An IP address is typically represented in the format XXX.XXX.XXX.XX, where each "XXX" is a number ranging from 0 to 255, and the "XX" is a similar two-digit number. IP addresses are used to uniquely identify and locate devices on a network. |
Database Name | Unique identifier for a collection of organized data within a database management system, distinguishing it from other databases within the same environment. |
Credential Type | Select a proper credential type and credential. · None: Select this type and add Username and Password · Basic: Selecting this option provides you with another Field called Credential from where you can select an appropriate option. · Cyberark: Selecting this option provides you with another Field called Credential from where you can select an appropriate option. |
Trigger | You may want to assign the servers to a custom Trigger if target server is in an Isolated network or if you want to setup a scalable infrastructure. You will only see available Triggers in this field. |
Port | A specific endpoint for data exchange between two devices or applications within a network. |
Inventory Interval | This option defines frequency of Inventory Collector. Inventory Collector is responsible for: · Collecting server inventory like pending updates, installed applications, local administrators etc. · Collecting module inventory like virtual machines, web sites, databases etc. · Hardware Health Monitoring · Windows Firewall Logs · Change Tracking |
Stats Interval | This option defines frequency of Monitoring Collector. Monitoring Collector is responsible for: · Collecting all performance counters results · Collecting Event Logs · Collecting TCP Connections |
Debug | To choose debug such as: · Off · Inventory: Only collects debug logs for Inventory Collector · Monitoring: Only collects debug logs for Monitoring Collector · On: Collects debug logs for Inventory and Monitoring Collector |
Status | To choose a server status such as: · Active: Enables monitoring for server · Maintenance: Enables maintenance mode for server and disables all notifications · Reconnect: Restarts all collectors for server · Disabled: Disables monitoring for server |
Logging Type | Logging Levels determine the frequency at which statistic queries occur, the length of time statistical data is stored in the database and the type of statistical data that is collected. |
4. After entering all the required info, click the button SUBMIT.