ManageEngine® SQLDBManager Plus
This section explains the report settings that can be configured in SQLDBManager Plus as well as data retention settings. To access this section, click the Report Settings link under Admin tab. The section consists of the following two inner tabs:
Treat SQL Groups as Database Cluster (Availability based on default calculation) : By default, the SQL Group availability will be shown as down (0%) if any one of the monitors in the SQL Group is down.
Treat SQL Groups as Services Group: By selecting this option, you can calculate SQL Group availability based on the services availability. For eg., if there are 5 monitors in a SQL Group and one monitor is down, SQL Group availability is calculated as 80% available (one monitor - 20%).
Do not include Scheduled Maintenance and Unmanaged state in availability reporting: If you select this option, you can exclude scheduled maintenance and unmanaged state data from availability reports.
Plot attributes report with Bar chart: If you select this option, you can view the attributes report in the form of bar charts.
Plot attributes report with Line Graph: If you select this option, you can view the attributes report in the form of line graphs.
Show Plot shape in graph: By selecting this option, you can see the dots / blobs in the line graphs.
Moving Average: A simple moving average is the unweighted mean of the previous n data points. For example, a 10-day simple moving average of attribute value like CPU utilization is the mean of the previous 10 days' CPU Utilization value. By selecting this option, you can add moving average graph in the 7, 30 graphs of the various monitors.
To plot graphs and generate reports, Applications Manager collects data from the monitors at regular intervals. By default, Applications Manager aggregates the performance data into hourly data at the end of each hour. The hourly data thus calculated will be aggregated into daily data at the end of each day. The aggregated data will be used in graphs and reports.
SQLDBManager Plus allows you to maintain the database with the required data. By default, the detailed data will be maintained for six hours max, the hourly data for 90 days and the daily data for 365 days. After the specified period, the database will be cleaned up automatically.
To configure your own settings for database retention, follow the steps given below:
Click on the Admin tab
Under 'Reports Settings' section, click Data Retention tab.
Enter the number of days for which hourly statistics should be maintained.
Enter the number of days for which daily statistics should be maintained.
Enter the number of recent alarms that should be maintained in the alarm database.
Save the changes