Exact System Information

Help File: Exact System Information +

The System Info tool + (ESI+) is developed to easily retrieve and adjust Windows, SQL and Database settings to get an optimum performance out of your SQL system.
It will also automatically send statistical information to Exact.
For the best results it advised to execute the ESI+ tool on the SQL Server using an administrator or equivalent Windows account.


Menus within the Exact Information Tool (ESI+)

Connect
System Info
Database Info
Optimize
SQL Maintenance
Advanced Indexes
Advanced Checks
Traces
Performance
Security
Cleanup Logs
App Logs
Exact Script (only used to sending anonymous information to Exact)
Settings


Other information

Installation and Uninstall Information
Supported and tested environments

App Logs
Contains the current log information based on action performed within the ESI+ tool. 
You can also check (if they exists) the Debug.log, Adjustments.log and Error.log files located in the root folder of the ESI+ tool installation.


Settings

Application Settings
Auto Execute ESI_EXACT.SQL script, this option is enabled by default and exact the script and sent anonymous information to Exact.
The option Delete created CSV File automatically deletes the file. This file is sent to Exact and not needed afterwards.
Default Query Time out (default: 60 sec) set the query time out SQL waits for the SQL Query to completed.
With the link: 'Select Font' you can set your personal font.
With the link: 'Select Color' you can set personal color theme to the tool.
With the link: 'Reset Settings' you will reset all settings to their default values

Menu
This will show or hide menus from the menu bar.
The Show Tool tips will show the tooltips with every main function.
Option Compressed Menu will collapse or expand the left menu of the ESI+ tool.

Performance
DSKSPEED duration in second, default 10 seconds how long the tool measures the diskspeed.
CPU duration in minutes, default 60 minutes. Measures the average CPU performance for the last 60 minutes.
SQL Query / Subtree Costs > in Seconds, default 0.5 sec, default value how long a query must run to be shown in the list.
Minimal Disk Latency in ms, default 50, is used with the Performance option within the Performance menu to indicate if a disk is performing below the threshold.
SQL Jobs work time, default 07:00 hour and 18:00 hours, shows if there are SQL jobs running within the provided time frame

Exact Links
Opens the links about the Change Logs, System and Hardware requirements in your default browser.

Optimize
Backup Age (days), default 7, Will check if there are backups create within the last 7 days of all Exact databases.
Option: Use Current TempDB size, default enabled. When the SQL Service is restarted the size of the TempDB is based on the current size. If you disable this option, you can provide a percentage of the largest database for the initial size of the TempDB.

Advanced Checks
Show disabled triggers, default disabled. Will also show the disabled triggers in the overview.
Show disabled indexes, default disabled. Will also show the disabled indexes in the overview.
Filtered Indexes minimum # Rows, default 1.000. Only indexes with more than the provided number will be eligible for Filtered Indexes.
Fill Factor default value, default 90. Will set the default value for a couple of specific selected Exact indexes.

Advanced Indexes
Duplicate Indexes minimum # Rows, default 1.000. This option checks if the table contains at least the provided number of rows otherwise it will not be suggested for filtered indexes.
Missing Indexes minimum Score, default 100.000. This only show indexes with a minimum score 100.000. This value incorporates the number of records and improvement to be eligible for optimization.

Traces
Filter on Username, with this option you can filter Trace Queries (Extended Event) based on a specific username.
Maximum File Size (GB), default 5 GB, sets the maximum file size of Extended Event) file.
CSV Separator default a comma, you can select the separator used within the CSV file (, or ;)
Severity Level (default 17) to show only error containing the select value or higher within the Extended Events trace.

System Information 
Check SQL Error Log, enabled default. By default, this option will only check the current (active) SQL Log file for critical errors.
You can change to look in all SQL error logs.

Search
With this option you can search for functions within the ESI+ tool.

< Back


Installation and Uninstall Information
The Exact System Information Tool needs the Microsoft .NET Framework 4.7 to run.
To install the application, download the ESITool+.exe file to a folder on a hard drive.


Uninstall the application.
To uninstall just remove all files in the folder where you executed the ESITool+.exe.

To download the latest version from our FTP Site, do the following:  

• Open your Windows File Explorer
• Copy/Paste the following ftp://ftpesi.exact.com/ESI
• Download the ESITool+.EXE to your harddrive

Supported and tested environments (x64 platforms)
Windows 10, 11
Windows Server 2012 (R2), 2016, 2019 and 2022
Microsoft SQL Server 2014, 2016, 2017, 2019 and 2022
Microsoft Azure SQL

< Back


Disclaimer:
In article 4.5 of the Customer License Agreement states that the license-holder is responsible for the installation and configuration of the software on his system.
The license-holder is responsible for adjustments made to the system with the use of the Exact System Information Tool.