Free SQL Monitoring – Documents
The Free ManageEngine SQL Health Monitor tool helps an administrator to monitor MS SQL 2005 Server, MS SQL 2008 servers
This tool makes connection 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. Once server is added , Tool will populate server details view
Administrator can view following details in tree
- Server Details View
- MS SQL Details view
- Database details
Server Details View
Once server added , Tool will populate 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 tool 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 is configurable.
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
And Refresh Interval
