Using SQL to monitor applications, processes, networks, and servers with HEYMon and HEYMonSQL.
HEYMonSQL Application components
There are two components to HEYMonSQL, a client and the HMSQL Server.
The client is used to send SQL requests to the HEYMonSQL (HMSQL) Server.
The HMSQL Server receives requests from clients and converts SQL into a HEYMon job request. The HEYMon job is executed immediately and the results of the job are returned to the client.
By supporting a client/server connection, HEYMonSQL allows you to place the HEYMon engine on one system and execute queries from the same system, or any other system on the network.
Before installing the HEYMonSQL files, determine where you want to host the HMSQL Server and the
You can setup everything on the same system, and do not have to use two separate systems for HEYMonSQL. HEYMon and HEYMonSQL will run on just about any operating system, including Linux, Windows (all versions), and UNIX.
HEYMonSQL and its clients can be setup on any operating system, and do not need to both be on the same operating system.
Installing HMSQL Server and the HEYMon engine
The HMSQL Server is comprised of the
HEYMonSQL.jar file, a lib directory with some other JAR files,
and a script to start the HMSQL Server process.
HMSQL is delivered in a single TAR.GZ or ZIP file. The TAR/ZIP file should be decompressed with the directory/folder names included.
To install HMSQL Server you should create a directory/folder to hold the files. The directory/folder and its contents should allow process execution and should allow read and write by its owner. On the Windows platform, a directory/folder should be created by an Administrator user on the C: drive, such as
C:\HEYMonSQL. The directory/folder name can be any value.
Also on Windows, DO NOT create or use a directory/folder which is in the
Program Files or
Once the directory/folder is created, extract the contents of the TAR/ZIP file into the directory/folder and the 'installation process' is complete.
When the files are extracted on a non-Windows platform, the file
HMSQLServer.sh should be setup for
When the files are extracted on the Windows platform, select the file
HMSQLServer.bat and configure
it to 'Run as Administrator'.
The files, and HMSQL Server are ready to run! No other setup or configuration is needed!
Startup HEYMonSQL and the HEYMon engine
To use HEYMonSQL, the server process should be started first. To start HEYMonSQL, just execute the
HMSQLServer script on your favorite computer (any platform will run HEYMonSQL).
On Windows, double-click on the file HMSQLServer.bat to start HEYMonSQL.
On platforms other than Windows, execute the HMSQLServer.sh script to start HEYMonSQL.
When HEYMonSQL is started you will see a message indicating the server has started:
Starting HEYMon HMSQL Server v.3.7
HMSQL server listening on port 7164
Note that HEYMonSQL listens for connections on port
7164. If there is a firewall or malware program
on the same system as HEYMonSQL, then TCP-IP port
7164 may need to be configured to allow traffic to
and from remote systems.
In the next release of HEYMon we will allow ways to configure the port number to a different value.
How to interact with HMSQL Server
To communicate with HMSQL Server you will need to use one of the HMSQL clients.
In version 3.7 there are two clients for the HMSQL Server, which can be described as follows:
- - Command-line: HEYMonSQL comes with a client directory that contains a command-line program which
can send SQL requests to the HMSQL server. Execute the script
client/HMSQLClientand a usage message will appear, describing how to send a SQL request.
Some examples are available in a following section
- JDBC Client: HEYMonSQL comes with a JDBC database driver. The driver can be loaded into SQL management applications like Squirrel, RazorSQL, DBeaver, and Embarcadero and used to send SQL commands to the HMSQL Server.