Question
myQA runs slower as before, is there a way to improve database performance?
Answer
In order to improve myQA database performance:
Step 1
Backup your database first. How do I create a back-up of the SQL database?
Step 2
Run Database Configuration Tool as administrator in Windows Start Menu
Step 3
Select the active database you are using, click Edit
If you cannot see your database in the dashboard, please read this article: How to attach an existing database to Database Configuration Tool?
Step 4
Select Database Maintenance - Database maintenance tasks - Optimize Database Performances
Step 5
Click Execute.
When the process is completed, you will see below window:
Click OK