Receive an improvement report of your SQL configuration and Exact databases.

In 2009, we start building the Exact System Informtion (ESI) Tool. This tool serves both Exact and the customers: Exact gets clear insight in how customers use our software and customers get targetted and personal advice on their use of our software. I'm happy to see that a lot of our customers have used the ESI tool. As of today the Exact System Information tool is extended with an option to receive an improvement report per e-mail.

If you specified your e-mail address and press on the Start Analysis button, the Exact System Information will analyze your SQL Server and Exact databases. When the analysis is completed you will receive within 10 minutes the improvement report. The report is divided in 2 sections:

1. Server improvements. Server improvements are related to your SQL server configurations like:
   Have you installed the latest Service packs?
   Possible changes in your SQL Server configuration to make use of all available memory.
   Etc....
    
2. Database improvements. Database improvements are related to the database itself like: 
   Available product updates.
   Clean up of historical journal records.
   Clean up voided entry records.
   Determine not configured  background jobs.
   Clean up of temporary tables.
   Big SQL log file in comparison to the SQL data file.
   Etc.....

If you're already using the Exact System Information tool, it will update itself when you start it again.
Enjoy using the Exact System Information tool. If you have suggestions for improvements please let me know.


Additional information about the Exact System Information tool:

• Download the Exact System Information tool 
• Information about the Exact System Information tool itself 
• What information is retrieved by the Exact System Information tool

Exact System Information application: Why should you use it?

This is my third blog post about the Exact System Information application. In the first 2 blogposts I introduced the reason of the Exact System Information application and what kind of information is retrieved by the Exact System Information application. In this blogpost I will explain why you as valuable customer should start this application on your SQL Server.
With the information we received from your Exact databases, we are able to improve our software. However improvements in the software based on this data will cost time and you will not directly benefit of it.

So the question is: What kind of improvements are directly possible for you to implement?

I will give some examples to:
SQL Server configuration improvements:

Example: Database configuration improvement scripts:

Example: Not used Exact functionality: Clean up historical journal records to save database size.

These are some examples. To experience all possible improvements, please start the application on your SQL server. The application is available on : ftp://ftp.exact.nl/Software/ESI/ExactSysInfo.zip. Extract the zip file on your SQL server and start the ExactSysInfo.exe

After we have received your data we will analyze the data. Via the support department you can request the improvement report. In the future we will distribute this improvement report via our portals.

Thank you already for your cooperation and trust in Exact Software.