How to Page?

 

Topic #1 : 8201

Applicable Ephesoft versions:

All Ephesoft versions using a MSSQL DB.

 

Instructions:
 
SQL Indexes were applied in order to solve the database deadlock problems.

1. User can verify if indexes have been applied on the application by checking the post-schema.sql file located at “Ephesoft\Application\WEB-INF\classes\META-INF\dcma-data-access\post-schema.sql ” file. User can find index word inside the file.

 

Windows Server 2012 R2 (2) 3128-2015-03-09-12-52-33

 

2. User can also go to SQL Server management studio and check if indexes are present or not by checking indexes under each of JBPM tables

 
Windows Server 2012 R2 (2) 3128-2015-03-09-12-45-35

 

3. Indexes are applied on following tables/fields:
 

Axosoft-

 
 
 


< Back | How To Main PageNext How To Article #? >

Was this article helpful to you?

Walter Lee

Comments are closed.