Introduction

In every Exact Globe product update, system performance is improved by optimizing the database indices in Exact Globe. In this product update, a tool is implemented to optimize your database instead of the standard indices in Exact Globe. With this method, the indices will be deployed only when it is required by your SQL server. This method also reduces deployment risk because you can easily add or remove the indices if you are not satisfied with the performance result. There will also be performance improvement for functions that use the new index.

Menu path

Not applicable.

What has been changed

A new tool has been implemented to improve performance by optimizing your database indices in your SQL server. This tool is called EPTIndex.exe located in the BIN folder. The xml file called PerformanceTuningIndices.xml is located in the XML folder.

For every product update, reports with indices will be extracted from Exact Software Internal SSRS and put into an XML file. The performance tuning indices tool allows support personnels and consultants to deploy indices to your SQL server. When the tool is started, it will read the XML file and check against the SQL Dynamic Management Views (DMV) in your database and deploy the indices dynamically to your SQL server. The screen of the tool is as follows:

However, there is some impact for every new index that is deployed such as:

• Slight performance degradation on every insert, update, or delete operation into the database tables because the SQL server has to perform additional steps to update to the new index.
• Size of database will grow because indexes are database tables that will consume hard disk space.

Note: Only Microsoft SQL Server 2005 and above is supported because the deployment depends on the SQL Dynamic Management Views (DMVs), which is only available from SQL 2005 onwards.

Related document

There is no related document.