ManageEngine® SQLDBManager Plus
An important aspect of all management tasks is that you can analyze the trend over time and evaluate the performance. The analysis is also useful in making calculated predictions and taking corrective actions as necessary. These calculated predictions allows you to plan for any future impact on performance for various services. To view these reports, you can follow either of the given steps:
Click the Reports module tab. This opens the index page that lists all the reports generated dynamically by SQLDBManager Plus
The reports generated by SQLDBManager Plus depicts the availability, health, response time and alarms of the database over a specified period of time. The reporting function enables you to analyze your databases even across months and all this even without having to make any additional configuration changes. The reports are generated dynamically, which means that you only see reports for monitors that you have created in SQLDBManager Plus. Before proceeding, please ensure that you have enabled reports for all the monitors. The generated reports has 7 / 30 report details which enables you to understand the behaviour of your applications under various business hours or during a particular period of the week/month. This feature allows you to make predictive calculations on future impact.
Some of the common functionalities of reports are as follows:
Options to view 10/20/50/All reports by choosing them from the Top N Reports field. They are enabled by default for all availability and health reports.
Note: This is not applicable to reports generated for Monitor Groups.
Options to schedule reports or enable reports can be done quickly by clicking on 'Schedule Reports | Enable Reports' link.
Option to view Custom Time Period reports for Availability and Attributes, i.e, the time period for which the reports are needed can be selected. Additionally, you have the option to set the Business Hours during which you want the reports.
Option to view Custom Attribute Reports and Downtime Summary Report configuration. Click here for detailed information.
Option to save the reports in CSV format by clicking on icon, PDF format by clicking on icon and also save in Excel format (available for Monitor - Availability & Health Snapshot - Current Snapshot, Critical Snapshot, History report, Outage Comparison Report, Availability Trend Report) for each individual report under reports tab. And also, you can mail these particular report to yourself by clicking on icon, fill out the email address and click Send.
Option to delete known Downtime reports. You can delete known downtime reports from the database by clicking the icon in the Availability Report. For eg, go to SQL Server and select Weblogic from the pull down menu in the top. Now click on Availability of Application Servers. Now click on the monitor's Total Downtime. Select the known downtime from the Monitor Downtime detail. This will delete this known downtime report from the database.
Downtime History: Gives the downtime/uptime chart for 'today''s period and also the downtime history for that particular monitor across all time periods. You can also assign Groups as well as Sub-Groups to downtime scheduler and generate reports. In Downtime history report, you can view the summary details of Scheduled Downtimes and Unmanaged time. This will give you more clarity in knowing the monitor's exact downtime. You can also add notes on why the monitor was down for that particular time period.
Summary Report of Monitor: Gives the summary of all the reports for that particular monitor.
Comparison Reports: You can compare the attribute reports of various monitors within a particular monitor. For eg., to view active connections of a DB server, click on Active Connections Reports attribute link. It displays the list of all DB server monitors, with maximum, minimum and average number of connections. You can also compare various DB server monitors by selecting the monitors and click on Compare link.
At a Glance Reports: The performance of top 10 monitors within the monitor group can be compared in a single view. By clicking on the bars in the report, you can see all the attributes of the monitor in a single view. Further, you can drill down to see the individual attribute reports.
Note: Scheduling of reports is possible by using ' Schedule Reports' under Admin tab.