Free SQL Health Monitor — Documents

ManageEngine SQL Health Monitor helps administrators to monitor MS SQL server versions including MS SQL 2012 and 2014.

The tool connects with MS SQL servers and generates easy to visualize desktop reports and graphs. Using the tool, Administrator can monitor up to 2 MS SQL server simultaneously.

Getting Started

ManageEngine SQL Health Monitor helps an administrator to view server resources and SQL database performance parameter.

Discovery of MS SQL server

Start the tool, Discovery feature of tool, automatically discovers MS SQL servers across the network and populates in the discovery wizard. To monitor the performance counters of discovered SQL server, select the particular sql server shown in the wizard and click "select" button, then give the username, password to make connection to the server. or you can skip the discovery, by clicking skip button, this will take you to setting window, from there, administrator can make connection.

Server Setting

To add the server details, click the 'setting' icon and enter the following information :

  • System Name/IP
  • Domain/Workgroup
  • User Name
  • Password

We can use the domain user name/password. The SQL server performance parameters are classified into 3 categories:

  • Server Details View
  • MS SQL Details view
  • Database details

Server Details View

Administrator can see server resources details like CPU Utilization ,Memory Utilization ,Storage Details and status of the application running on the server, network status information, MS SQL version.

MS SQL server Details

MS SQL database performance parameters are shown

DBA can see parameter like Buffer details, Memory details, Lock and latches information and SQL statistics such as login, logout, active database connection status

Database details

DBA can also see the individual database parameters like Active transaction,Database size of log file used ,cache hit ratio status.

DashBoard View

The SQL Health Monitor has a Dashboard view to show the important parameter indicators of the server such as Memory utilization, CPU usage, Disk utilization. Important performance parameter of the MS SQL database such as page write, page read ,buffer cache hit ratio and also tool will show the status of the performance indicators.

Delete Server

To delete the server, choose the "delete server" icon in the tree view of the corresponding server.

Refresh Server

To know the current status of the server, choose the 'Refresh Server' icon

Threshold Settings

Using this tool, administrator can edit the warning and critical threshold values for Memory, Disk Space and CPU usage and for important SQL parameter such as Pages, Cache, Memory details

Click on the "Settings" icon to edit the threshold values for warning and Critical thresholds

For Host server

  • CPU Threshold
  • Memory Threshold
  • Disk Space Threshold

For sql database thresholds

  • Page reads
  • Page write
  • Free pages
  • SQL cache memory
  • Buffer cache hit ratio

Refresh Interval

The added Windows servers will be refreshed at regular interval (Refresh Interval) which can be configured as required.

Click the "submit" button to save the settings and to start the SQL performance monitoring.

Retaining Settings

The following details are saved in the disk so that the parameters can be reused when the tool is restarted. During the restart of the tool, tool will automatically connects to server and will populate performance counters.

Following configurations are stored internally

  • Connection information
  • Server Name
  • Domain Name
  • User Name
  • Password [ Encrypted using Triple DES ] encryption standard used.
  • Warning and Critical Threshold values for SQL paramters
  • CPU threshold values
  • Memory threshold values
  • Disk Usage threshold
  • Page write threshold
  • Page read threshold
  • Free pages
  • SQL cache memory
  • Buffer cache hit ratio
  • Refresh Interval