Welcome to the Exact Product Blog

On this blog we will cover stories from all around the Exact ecosystem.

Receive free advice on optimizing your Exact solution

Written by André van de Graaf on . Posted in Exact Globe, Exact Synergy

In 2009 we started developing the Exact System Information (ESI) Tool. With this free tool we can serve you, as one of our valued Exact Globe and Exact Synergy customers, with targeted and personal advice on how to make better use of our software solutions. By advizing you and thousands of other customers, we can also gain better insight in how our software is used; valueable information that enables us to keep improving our solutions. The Exact System Information Tool can be downloaded for free and the file ‘ExactSysInfo.exe’ can be installed by all organizations that use Exact Globe and/or Exact Synergy (Enterprise).  

It is important for you to know what kind of information is exchanged by the ESI Tool. When you use the ESI Tool no company sensitive information will be transferred. Only technical information like usage statistics, logged errors, numbers of records per table, database size and settings will be exchanged. When using the ESI Tool you can see exactly what information is send to us in the CSV file that is placed on your desktop or via menupath ‘Logs, View CSV file’.

Personally, I am very happy to see that a lot of our customers have already used the ESI tool. As of today, the Exact System Information Tool is even extended with the option to receive an automated improvement report per e-mail.

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

1. Server improvements.
The server improvements section is related to your SQL server configurations and answers questions like: Have you installed the latest Service packs? Can you make changes in your SQL Server configuration to make use of all available memory? Etcetera.
 
2. Database improvements.
The database improvements section is related to the database itself and gives advice about new available product updates, clean up of historical journal records, clean up of voided entry record, background jobs, clean up of temporary tables etcetera.

If you have already used the Exact System Information tool in the past, the tool will update itself when you start it up again.

Enjoy using the Exact System Information tool. If you have suggestions for improvements please let me know, as we do not only want to improve our software solutions but also the Exact System Information Tool itself.

Photo credit: cliff1066tm

Tags: , , , ,

Comments (3)

  • Andre Speek

    |

    Looks like a great tool (service included ! ) and an excellent way to improve customer satisfaction. I don’t think I’ll be using it a lot since I’m mostly involved with development and not consultancy anymore. But it looks to like a tool that should be standard included in any project plan from now on.

    Maybe you could attach an example of such a report that people can expect?

    p.s. I presume that the advice does not include anything on (SDK created) Custom tables and such? In particular; I don’t think the report will suggest to clean up any table that is not recognized as “used by Exact”. Right? 😉

    Reply

  • Exact User

    |

    “free advice”….umm I wonder what it could possibly lead to?? Not that I’m a sceptic!!!!!

    Reply

  • Danny Bonthuis

    |

    Perhaps it’s a good thing to share some experiences with this tool from the last years since we have been using this in controlled release fazes and at customer sites that indicated performance issues.

    1. With the data provided we were able to add additional indexes in the standard database set to improve performance. roled out to all customers!
    2. The tool can optimize certain MS SQL and database parameters.
    3. Uttilization of the hardware could be improved, one example showed us a customer using only 2GB of memory in their server instead of 4GB.

    Just 3 examples to what it can lead to.

    In other examples it was made clear the hardware was no longer a fit to the database size and software usage, so it can also lead up to an earlier than expected or hoped hardware upgrade.

    In either way, this tool was built to give an advice free of costs and it is up to the end user what to do with the advice.

    Reply

Leave a comment