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.
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.