ManageEngine® SQLDBManager Plus


Host

<< Prev

Home

Next >>

 

SQL Server - Host Performance Metrics

Host Details

Parameters

Description

CPU Utilization

Specifies the total CPU used by the system with its peak and current value, and current status.

Memory Utilization

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.

Disk Utilization

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

 

Monitor Windows Processes

  1. In the Server Monitor page under Process Details, click Add New Process.

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

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

Follow the steps given below, to add a new Event Log rule:

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.


  1. In the Host tab page, under Service Details, click Add New Service

  2. All the services that are running would be displayed along with service name and status.

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

 

 

 


<< Prev

Home

Next >>

Overview

Memory