VERIFIED SOLUTION i

Refresh indexes in Portrait Dialogue database


 
Portrait Dialogue requires a smooth running database to avoid performance issues, because Dialogue is a database driven solution.
When using Dialogue a lot of records get written, updated, transferred and/or deleted in several database tables.
Records relating to messages, questionnaires, domains, dialogs, participants, users, tasks, system, and more, change a lot, and over time, this results in a lot of fragmentation of files and indexes.  
Routine maintenance, rebuilding indexes, compressing tables and updating statistics can all help the database performance which affects the performance of Dialogue.

Database maintenance alone is not the entire solution to performance issues.
Where maintenance has been done and performance issues persist, we need to look at memory dumps from the Dialogue server, and analyze the database for blocking and blocked SQL statements.

 
UPDATED:  October 8, 2018