ManageEngine® SQLDBManager Plus
SQL Server Host Performance Metrics
Specifies the total CPU used by the system with its peak and current value, and current status.
Swap Memory Utilization: Specifies the swap space or the virtual memory utilized by the system with peak and current value, and current status of the parameter.
Physical Memory Utilization: Specifies the amount of physical memory utilized by the system with peak and current value, and current status of the parameter.
Free Memory Utilization: Specifies the amount of free physical memory available for the system.
Specifies the hard disk space utilized by the system and updates with the peak and current value, and current status of the Disk Partition parameter.(The parameter includes C, D, E, F drives, etc. in windows)
Apart from the above mentioned parameters, you can also monitor the following:
Monitor Network Interfaces
Note: Network Interface monitoring is possible only in SNMP and WMI mode of monitoring.
In the Server Monitor page, under Network Interfaces , all the network interfaces will be listed. The various attributes that can be monitored are
Interface Traffic - Input traffic (bits received), Output Traffic (bits transmitted). You can set alarm thresholds for these attributes.
Interface utilization - Input Utilization %, Output Utilization %. You can set alarm thresholds for these attributes.
Packets received - Packets received per second
Packets transmitted - Packets transmitted per second
Error packets - No.of packets in error per second after receiving the packets
Discarded packets - No.of packets discarded per second after receiving the packets
Health - the health of the interface based on the attributes
Status - whether the interface is up or down
Monitor Windows Processes
In the Server Monitor page under Process Details, click Add New Process.
All the processes that are running would be displayed along with CPU and Memory utilization statistics. (Only memory statistics is shown for Windows and SNMP mode of monitoring)
Select the processes that you want to monitor.
After configuring the processes, they are listed under the Process Details section of the Host tab page. By clicking on the process, you can view its availability graph. You can also configure alarms for a particular process.
You can edit the Display Name, Process Name, Commands and Arguments of the particular process by clicking on the Edit Process icon.
Monitor Windows Event Logs
For receiving windows events, you have to configure Event Log Rules. You can get notified by the events from the following Log Files.
Application (By default Event Log rule is configured for any Application Error)
Security (By default Event Log rule is configured for any Security Failure)
File Replication Service
Follow the steps given below, to add a new Event Log rule:
Under Admin tab, click on Event Log Rules
Click on 'Add New Rule'
Enter the Rule Name of your choice
Enter the Event ID associated with the Event Log File (not mandatory)
Choose the Event Type - Error, warning, Information. In case of Security Events, the types would vary between Success Audit and Failure Audit
At the outset, you can enable or disable the Rule Status
By clicking on Advanced Options, you can formulate the rule more specifically by associating the source, category, username, and description content of the incoming event to the alarm severity.
For Eg., select Log File as [System] and Event Type as [Error] , to get all events of type Error from System Log File.
Monitor Windows Services
Note: Windows Services monitoring is possible only in WMI mode of monitoring.
In the Host tab page, under Service Details, click Add New Service
All the services that are running would be displayed along with service name and status.
Select the services that you want to monitor.
After configuring the services, they are listed under the Service Details section of the Host tab page. By clicking on the service, you can view its availability graph. You can also configure alarms for the availability of that particular service. Apart from monitoring the availability of the service, you can manage the services by using the start, stop, restart options. When the service goes down, you can configure action "Restart the Service " along with other actions.