Boosting your Exact Globe performance without upgrading

In the recent Exact Globe product update, system performance is improved by optimizing the database indices. On Batch 397 update, a new tool has been implemented to improve performance by adding indices to your database, because a good index structure enables the SQL Server database engine to retrieve requested data by the Globe application in an efficient way.

Note: you need to execute the tool then, but starting from batch 400, these indices are added automatically to the current standard index structure when you update the database to run on Exact Globe product 400.

However, for some reasons you can not update to this new release immediately. Like for instance, your have a customized solution that needs to be changed inorder to be compatible with the new Exact Globe release or you are already accustomed with the current installed version (I know one company in this situation) or you are just afraid to update because the data might get lost. But still you can make use of these new indexes in your current installation.

First of all, this is only available if your Exact Globe database runs on SQL 2005, SQL 2008 or SQL 2008 R2, because the deployment depends on the SQL Dynamic Management Views (DMVs), which is only available from SQL 2005 onwards.

To create these indexes with the tool: (EPTIndex.exe)

• Download the latest version of the EPTIndex.exe tool
• Copy EPTIndex.exe to the BIN Folder of your Exact Globe installation folder.
• Download the latest version of the PerformanceTuningIndices.xml file. Put your mouse on the filename:  PerformanceTuningIndices.xml and right click, Use Save Target As. Save the file in the XML folder of your Exact Globe installation folder. (If you double click on the filename, the XML will be opened instead of downloaded)
• Browse to the BIN folder of your Globe installation and double click on the EPTIndex.exe to start to the EPTIndex tool
• At the Connection section enter the correct name of the Server and Database name. (Make sure that you connect as a user with the System Role SysAdmin within SQL)
• Press the Preview button to get a list of possible indices which can be implemented
• Press the Generate all button to implement all suggested indices.

Scheduling the EPTIndex tool:

You can schedule this tool to run once a month via Windows Scheduler Task or SQL job to check if there are indices which need to be implemented. When you start the tool with parameters shown below, the Generate all process is automatically started to implement the suggested indices.

• Parameters: -r[DatabaseServerName] -D[DatabaseName]
• Example: "C:\Program Files\Exact Software\Bin\EPTIndex.exe" -rGlobeSVR -D111

Run Exact Globe, do some cards retrieval.  By this time you should encounter noticeable speed then. If you are not satisfied yet, read my other blog.
      * Boosting your Exact Globe / Synergy database server thru SQL Server Settings  
       http://anthonyexactglobe.blogspot.com/2011/06/boosting-your-exact-globe-synergy.html
      * Boosting your Exact Globe / Synergy database server thru Windows Server Settings
       http://anthonyexactglobe.blogspot.com/2011/06/boosting-your-exact-globe-synergy_28.html