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.
ManageEngine SQL Health Monitor helps an administrator to view server resources and SQL database performance parameter.
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.
To add the server details, click the 'setting' icon and enter the following information :
We can use the domain user name/password. The SQL server performance parameters are classified into 3 categories:
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 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
DBA can also see the individual database parameters like Active transaction,Database size of log file used ,cache hit ratio status.
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.
To delete the server, choose the "delete server" icon in the tree view of the corresponding server.
To know the current status of the server, choose the 'Refresh Server' icon
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
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.
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