SQL Database Export

In addition to various types of system monitoring reports, SysGauge Ultimate provides the ability to export system monitoring results to an SQL database allowing one to analyze monitoring results using external analysis tools such as Microsoft Excel. In order to enable the SQL database export capabilities, open the 'Options' button, select the 'Database' tab, select the 'Enable SQL Database' checkbox and specify an ODBC data source, user name and password to use to connect to the SQL database.

SysGauge SQL Database Options

Once finished specifying all the required parameters, press the 'Verify' option to test the SQL database connection. Now, press the 'Save' button located on the main toolbar, select the 'SQL Database' report format, specify the name of the SQL database table to export monitoring results to and press the 'Save' button.

SysGauge Save Database Report

If there is no such table in the SQL database, SysGauge will create a new database table and then export system monitoring results to the newly created database table. If the database table already exists, SysGauge will add monitoring results to the existing table. In order to import system monitoring results from the SQL database to Microsoft Excel, open the Microsoft Excel application select the menu 'Data - Import External Data - New Database Query'.

Excel Import External Data

On the 'Choose Data Source' dialog, select the SQL database to import the monitoring data from and press the 'Ok' button. It is important to note that in order to be able to connect to a 64-Bit version of the SQL database using the 32-Bit version of Microsoft Excel, the user needs to install the 32-Bit version of the ODBC database connector and properly configure the ODBC data source in the Windows control panel.

Excel Select SQL Database

On the 'Query Wizard' dialog, select a SysGauge database report to import data from and then add all the required database columns to be imported. Once finished selecting database columns press the 'Next' button, optionally filter and/or sort the imported data and finally press the 'Finish' button to import data to Microsoft Excel.

Excel Select SysGauge Report

For each system monitoring result, SysGauge exports to the SQL database the following columns: the date and time of the monitoring result, the counter type, the counter name, the counter instance name, the counter host name, the counter value and the counter units description.

Excel SysGauge Monitoring Data

In addition to the ability to export system monitoring results manually using the SysGauge GUI application, the SysGauge command line utility allows one to automate system monitoring and database export operation using batch files and shell scripts. For example, in order to perform a process monitoring operation and then export all process monitoring results for all running processes to the SQL database, type the following command:

sysgauge -process_monitor -time <Seconds> -save_to_database <Table Name>

The command will monitor all the running processes during the specified period of time and then export process monitoring results for all running processes to the specified SQL database table. In general, the '-save_to_database' command line option is supported by all types of SysGauge system monitors and it can be used with the CPU monitor, memory monitor, system status monitor, disk monitor, NAS monitor, network monitor and process monitor.