Exact System Information Tool

The Exact System Information Tool

This System Info tool is developed to easily retrieve and adjust Windows, SQL and Database settings to get an optimum performance.
It will also automatically send statistical information about Exact tables and index usage to Exact.
For this tool to function proper, you need run this tool on the SQL Server using an administrator or equivalent Windows account.

Download the lastest version from the following FTP site:
ftp://ftp.exact.nl/Software/ESI/ExactSysInfo.zip

How to use the tool:

Step 1: Start and Connect
To start the application you need to execute the ExactSysInfo.EXE, see Installation and Uninstall information
Establish a connection to the local SQL server instance via Windows or SQL Authentication. See example:

You can sent the Improvement Report to the specified e-mail address.
(It can take about 10 minutes before the Improvement Report is sent to the provided e-mail address)

With the Options button you can select the appropriate options before starting the analyses or leave every setting to de the default.

Click on the button 'Start Analysis' to start the process. This can take several minutes depending on the number and sizes of the Exact databases.
During the analyze process the following information will be displayed, see example:

When the process is complete the following information will be displayed, see example:
In the Recommendation column, you can see optimized recommendations for the specific items.



Note - This tool cannot retrieve information about the disk system (RAID Level) and how many disks are stored in the disk system!

Step 2: Applying the Recommended Optimizations

After the process is complete the number of recommendations will be displayed in the 'Recommended Optimization' tab. See example:

Selected the optimizations that you want to apply to the system (or enable the Select All option) and click on the button: 'Apply Optimizations'.
The following window will popup:

Click on the button 'Yes' to apply the recommendations or 'No' ignore the recommendations.

After the recommendations are applied the following window might popup:

It's is advisable to perform the restart of the server of the SQL instance after working hours.

Step 3: Schedule a SQL Optimization Job

Select the an Exact database and set the time that the jobs will be executed (default 23:00 hours on Monday, Tuesday, Wednesday, Thursday and Friday) and click on the button: 'Create'. Now the SQL Job 'Optimize Rebuild Indexes [Select Database Name]' is created to optimize the index performance.

Note: If indexes are not rebuild periodically the performance will decrease!

The Delete button will remove the SQL job which is created with this tool.
The 'Overwrite existing [Rebuild Indexes/Update Statistics] job' option can be used to modify the start time of the job when the job already exists.

You are done optimizing your system for SQL.

<< Back

Tab: Database Information
The Information is shown in two data grids the first data grid shows important settings of all the databases.
The second data grid displays information about the size, growth and location of the database files.

<< Back

TAB: Exact Databases

The Exact Databases tab displays a result set of Exact specific related information about Error Logs, index information and statistical table information.

<< Back

The Menu

File Menu

• File: Save System Information tab to HTML or CSV format
• Print: Prints System Information and Database Information tabs to a selected printer
• E-Mail: Sends the System Information tab in HTML format to one entered e-mail address
• Options: Set the application options

Action Menu

• Connect: Displays the Connection window to make a connection to the local SQL instance
• Start Analysis: Starts the analyzing process

View Menu

• General Database Information: Show or hide the tab that contains information about database settings, location, sizes etc.
• Exact Database Information: Show or hide the tab that contains information about statistical table information, indexes usage etc.
• Toolbar: Show or Hide the toolbar containing buttons for Connect, Start Analyze, Options, Help and Exit.
  
• Logs: Shows the log file for Applied Optimizations applied by the tool, Error log and the created CSV file that is send to Exact.

Help Menu

• Help: Displays this document
• About: displays the version of the application

<< Back

Installation and Uninstall Information:
The Exact System Information Tool needs the Microsoft .NET Framework 2.0. If it is not installed you need to download this from the Microsoft website.
http://www.microsoft.com/downloads/details.aspx?FamilyID=0856EACB-4362-4B0D-8EDD-AAB15C5E04F5&displaylang=en

To install the application, unzip the ExactSysInfo.zip file to a folder on a hard drive. The zip contains 5 files, the ExactSysInfo.exe, ESI_Exact.SQL, ESI_AutoUpdater.exe, NTRights.exe and the ICSharpCode.SharpZipLib.dll.

Uninstall the application

To uninstall or remove the application you can remove the 5 files you’ve unzipped.

<< Back

How to Start the Exact System Information Tool (Exact System Info)
Execute the ExactSysInfo.exe file stored on your hard disk

<< Back

Supported en tested environments:  (both x86 and x64 platforms)
Windows XP, Windows Vista, Windows 7, Windows Server 2000, Windows Server 2003 (R2) and, Windows Server 2008 (R2)
Microsoft SQL Server 2000, 2005 and 2008 (R2).

When you want to apply optimizations via the application ExactSysInfo.exe on a Windows Server 2008, you need to right click on the application ExactSysInfo.exe and select ‘Run as administrator’ to be able to realize the changes on the system. See example:

<< 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.